Job Summary
The Postgres DBA with Azure Cosmos role is responsible for managing, optimizing, and maintaining Azure SQL and Azure Database for PostgreSQL environments while ensuring performance, security, availability, and reliability. The role requires expertise in cloud database administration, performance tuning, high availability, disaster recovery, and Azure infrastructure services.
Key Responsibilities
• Manage and optimize Azure SQL (MSSQL) and Azure Database for PostgreSQL environments, ensuring performance, security, and availability.
• Provision, configure, and maintain Azure SQL and Azure PostgreSQL databases.
• Identify and resolve performance bottlenecks, optimize queries, and tune database configurations.
• Implement and maintain security measures, including user access control, encryption, and network security.
• Develop and execute backup and recovery plans to ensure data integrity and business continuity.
• Monitor database performance and availability, troubleshoot issues, and implement solutions.
• Perform performance tuning and query optimization using Performance Monitor, SQL Profiler, and related monitoring and troubleshooting tools.
• Support clustering, replication, virtualization, and high transactional enterprise systems.
• Manage SQL Server replication, high availability (HA), and disaster recovery (DR) solutions.
• Provide written and verbal recommendations regarding indexing, code modifications, process improvements, and logical and physical data structures.
• Provide technical assistance to developers, perform code reviews, identify inefficient code, and recommend query optimization techniques.
• Administer, maintain, monitor, and ensure availability of enterprise production SQL Server environments.
• Support Azure infrastructure and cloud computing initiatives.
• Design and implement secure Azure environments.
• Support automation initiatives using Infrastructure as Code (IaC) tools.
Required Qualifications
• Experience managing and optimizing Azure SQL (MSSQL) and Azure Database for PostgreSQL databases.
• Experience provisioning, configuring, and maintaining Azure SQL and Azure PostgreSQL databases.
• Strong experience with database performance tuning and query optimization.
• Experience using Performance Monitor, SQL Profiler, and related database monitoring tools.
• Experience with clustering, replication, virtualization, and high transactional enterprise systems.
• Experience with SQL Server replication, High Availability (HA), and Disaster Recovery (DR) techniques.
• Strong aptitude for T-SQL tuning and optimization.
• Experience administering enterprise production SQL Server environments.
• Strong understanding of cloud computing fundamentals.
• Proficiency with Azure services including Virtual Machines, Functions, and Active Directory.
• Strong networking knowledge.
• Understanding of security best practices.
• Experience with Infrastructure as Code (IaC) and automation tools.
• Ability to design secure Azure environments.
• Strong communication, analytical, and problem-solving skills.
