Compensation Overview

Overview

Principal Database Administrators (DBAs) play a vital role in addressing the challenges associated with a shared platform environment where multiple applications and tools use the same databases, ETL processes, and reporting tools. Principal DBAs contribute significantly to the reliability, performance, stability, and observability of the shared platform. Their proactive monitoring, optimization efforts, and collaboration with various stakeholders help create a robust and well-maintained data infrastructure, facilitating smooth operations for all applications and tools sharing the mission critical platform.

This is a remote role in the eastern time zone of the US.

Responsibilities

• Performance Monitoring and Tuning: DBAs continuously monitor database performance, identifying bottlenecks, and proactively optimizing query execution plans, indexes, and database configurations. This ensures efficient use of resources and enhances overall system performance.
• Resource Allocation and Management: DBAs manage database resources, such as CPU, memory, and storage, to prevent resource contention and ensure fair distribution among applications and tools.
• Backup and Recovery: DBAs implement robust backup and recovery strategies to safeguard data integrity and provide rapid data recovery in case of failures or disasters. This ensures the reliability and stability of the shared platform.
• Security and Access Controls: DBAs enforce security measures, access controls, and encryption to protect sensitive data from unauthorized access and ensure data privacy and compliance with regulations.
• Database Provisioning and Scaling: DBAs handle the provisioning of new databases and scaling existing databases to meet the evolving demands of applications and tools on the shared platform. This ensures scalability and flexibility in data storage.
• Data Replication and High Availability: DBAs configure database replication and high availability mechanisms to minimize downtime and provide continuous access to critical data for applications and users.
• Query Optimization and Troubleshooting: DBAs optimize complex queries, identifying and resolving performance issues. They collaborate with application developers to troubleshoot and resolve database-related problems.
• Monitoring and Alerting: DBAs set up monitoring and alerting systems to proactively detect issues and promptly respond to potential problems in the shared platform, ensuring observability and quick incident resolution.
• Capacity Planning: DBAs conduct capacity planning to forecast future resource requirements and ensure that the shared platform can meet growing demands while maintaining optimal performance.
• Collaboration with Data Architects and Developers: DBAs collaborate with data architects and application developers to understand data requirements and recommend database design improvements, data modeling enhancements, and best practices.
• Database Security Audits: DBAs conduct regular security audits and vulnerability assessments to maintain a secure database environment and address potential security risks.
• Continuous Improvement: Stay updated on industry trends and advancements in database technologies. Continuously evaluate and recommend improvements to existing database systems and processes. Actively participate in disaster recovery planning and testing.
• Standardization of SQL Artifacts: Develop and enforce SQL standards for various HER applications. Conduct regular audit reviews to ensure compliance with SQL standards and best practices.

Qualifications

Academic and Professional Qualifications:

• Bachelor’s degree in Computer Science, Information Technology, or related field or equivalent/years of experience required.
• Master’s degree is a plus.

Experience:

• 10+ years of experience as a senior DBA
• Proven experience as a Database Administrator, with a focus on managing cloud based databases in Azure cloud environments.
• Extensive knowledge of Azure cloud services such as Networking, Security, and Alerts and Monitoring.
• Highly proficient in AlwaysOn, Distribute AG, Replication and Disaster Recovery
• Working knowledge on DevOps
• Strong understanding of data modeling principles, governance, and security practices.
• Demonstrated expertise in designing data integration solutions and optimizing data processing performance.
• Strong communication and presentation skills to effectively convey complex technical concepts to non-technical stakeholders.
• Experience working on HealthCare domain is a plus.

Travel Requirements:

• Up to 10% travel may be required.

Working Arrangements:

• Work is performed in a remote office environment with minimal exposure to health or safety hazards.