Principal Database Administrator - Remote

Altera, a new member of the N. Harris Computer Corporation family, delivers health IT solutions that support caregivers around the world. These include the Sunrise™, Paragon®, Altera TouchWorks®, Altera Opal, STAR™, HealthQuest™ and dbMotion™ solutions. At the intersection of technology and the human experience, Altera Digital Health is driving a new era of healthcare, in which innovation and expertise can elevate care delivery and inspire healthier communities across the globe. A new age in healthcare technology has just begun.

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 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 envir