Senior Application Dba - Remote Az

Awarded a Healthiest Employer, Blue Cross Blue Shield of Arizona aims to fulfill its mission to inspire health and make it easy. BCBSAZ offers a variety of health insurance products and services to meet the diverse needs of individuals, families, and small and large businesses as well as providing information and tools to help individuals make better health decisions.

This remote work opportunity requires residency, and work to be performed, within the State of Arizona

Responsibilities:

1. Application Database Management: Manage and administer application databases, including installation, configuration, and maintenance of database software in both on-premises SQL environments and Azure.

2. Environment Optimization: Collaborate with application owners to understand their specific requirements and optimize databases across various environments, ensuring optimal performance, scalability, and cost-efficiency.

3. Database and Application Integration: Establish check-points and maintain effective communication between the application owners and the database, ensuring alignment and adherence to specific database guidelines and requirements across different environments.

4. Testing and Performance Tuning: Conduct thorough testing of database configurations in collaboration with application owners, identifying and resolving any issues or bottlenecks to ensure optimal performance.

5. Legacy Application Support: Provide support for legacy applications running on traditional on-premises SQL environments, including versions 2005, 2008, 2012, 2016, and 2019.

6. Framework Modeling: Understand and work with application framework models, ensuring their compatibility and effectiveness across different database environments.

7. Reporting and Analytics Support: Collaborate with reporting teams, including Tableau, SSRS (SQL Server Reporting Services), SSIS (SQL Server Integration Services), and SAS reporting, to ensure efficient and accurate data retrieval for reporting and analytics purposes.

8. Database Security: Implement and maintain security measures to protect the confidentiality, integrity, and availability of application databases across various environments.

9. Backup and Recovery: Develop and implement backup and recovery strategies specific to each environment, ensuring data integrity and availability in case of system failures or disasters.

10. Data Integration: Collaborate with data integration teams to design and implement efficient data exchange processes between different systems, leveraging integration methods and APIs suitable for the respective environments.

11. Database Documentation: Maintain thorough documentation of database configurations, processes, and procedures across different environments.

12. Troubleshooting and Issue Resolution: Investigate and resolve database-related issues, working closely with application owners, system administrators, and other stakeholders.

13. Continuous Improvement: Identify areas for improvement in database management processes, optimization, and cost-effectiveness, and make recommendations for enhancements.

Requirements:

1. Bachelor's degree in Computer Science, Information Technology, or a related field (or equivalent work experience).

2. Proven experience as an Application DBA, working with complex application databases in both on-premises SQL environments and Azure.

3. Strong knowledge and hands-on experience with database optimization and management in various environments.

4. Experience collaborating with application owners to meet specific database guidelines and requirements.

5. Proficiency in database management systems, such as Microsoft SQL Server, Oracle, or MySQL.

6. Experience in framework modeling, understanding the relationship between databases and applications.

7. Familiarity with database performance tuning and optimization techniques.

8. Knowledge of API integration and optimization.

9. Solid understanding of database security principles and best practices.

10. Excellent analytical and problem-solving skills.

11. Strong communication and collaboration skills, with the ability to work effectively in a team environment.

Our Commitment

BCBSAZ does not discriminate in hiring or employment on the basis of race, ethnicity, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, protected veteran status or any other protected group.

Thank you for your interest in Blue Cross Blue Shield of Arizona. For more information on our company, see azblue.com. If interested in this position, please apply.