Role OverviewThe PostgreSQL DBA is responsible for the performance, integrity, and security of PostgreSQL databases hosted on Azure.
This role also involves leveraging Azure DevOps for continuous integration and continuous deployment (CI/CD) processes. Key Responsibilities:Database Management: Install, configure, and maintain PostgreSQL databases on Azure.Performance Tuning: Optimize database performance and ensure high availability.Security: Implement and manage database security measures.Backup and Recovery: Develop and manage backup and recovery plans.Monitoring: Use Azure tools to monitor database health and performance.Troubleshooting: Diagnose and resolve database-related issues.CI/CD Pipelines: Design and manage CI/CD pipelines using Azure DevOps for database updates and deployments.Automation: Automate routine database tasks using Azure DevOps and other tools.Advanced: Configure, troubleshooting and optimize triggers, replication, data imports and exports etc. Required Skills and QualificationsTechnical Skills: Proficiency in PostgreSQL database management.Experience with Azure Database for PostgreSQL.Knowledge of SQL and database scripting.Familiarity with Azure tools and services (e.g., Azure Monitor, Azure Backup).Experience with Azure DevOps, including pipeline creation and management.Understanding of CI/CD principles and practices. Soft Skills: Strong problem-solving abilities.Excellent communication skills.Ability to work independently and as part of a team. Tools and TechnologiesPrimary Tools: PostgreSQLAzure Database for PostgreSQLAzure MonitorAzure BackupAzure DevOpsRed-Hat LinuxAdditional Tools: pgAdminpsqlAzure CLIGit Training and DevelopmentOnboarding: Initial training on company policies and Azure environment.Ongoing Training: Regular updates on new Azure features, PostgreSQL updates, and DevOps practices.Certifications: Encouraged to obtain relevant certifications (e.g., Microsoft Certified: Azure Database Administrator Associate, Microsoft Certified: DevOps Engineer Expert). Performance MetricsDatabase Uptime: Maintain a high level of database availability.Response Time: Quick resolution of database issues.CI/CD Efficiency: Effective implementation and management of CI/CD pipelines.Security Compliance: Adherence to security protocols and policies. Career PathOpportunities for advancement to Senior DBA, Database Manager, or other IT leadership