Role: Application DBA
Location: Onsite 4 days a week in either Plano TX; San Antonio TX; Phoenix AZ; Charlotte NC
Project Initiative: modernization from guidewire to cloud
Must haves: Erwin (or similar UML tools) would be critical to consume modeled content. Will be standing up new sources consuming or modifying content. May be asked to model a source
Skills Required:
- Proficient in using data modeling tools like Erwin for creating and maintaining logical and physical data models.
- Proficiency in working with large tables and complex joins ensuring data integrity and optimal query performance.
- Extensive experience with AWS RDS (Relational Database Service) including managing and optimizing relational database systems in the cloud environment.
- Strong experience in SQL tuning with a proven ability to analyze and improve query performance to meet business needs.
- Essential knowledge and experience with NoSQL databases particularly DynamoDB to support a variety of data storage requirements.
- Excellent communication and interpersonal skills to effectively collaborate with both business stakeholders and IT teams.
- Ability to guide developers providing recommendations and best practices for database design performance optimization and data management.
- Familiarity with database security best practices ensuring compliance with relevant data protection regulations and standards.
- Experience in planning and implementing robust disaster recovery and backup strategies to protect critical data assets.
- Proficient in automating routine database administration tasks using scripting languages like Python or Bash improving efficiency and reducing manual work.
- Experience with version control systems like Git for managing database schema changes and maintaining version history.
- Ability to plan and manage database capacity ensuring scalability and availability as data volumes and transaction loads grow.
- Strong analytical and problemsolving skills with the ability to troubleshoot complex database issues and implement effective solutions.
- Proficiency with database monitoring tools and techniques to ensure optimal performance and quickly identify potential issues.
- Experience managing databases across multiple platforms (e.g. Oracle SQL Server MySQL) and integrating them into a unified data architecture.