Freelancer Opportunity!!!
Senior PostgreSQL Database Administrator (Azure)µ
About the Role:
We are seeking a highly skilled and experienced PostgreSQL Database Administrator (DBA) with deep expertise in managing, optimizing, and securing PostgreSQL databases hosted on Microsoft Azure. This role is critical to ensuring the performance, availability, and scalability of our database infrastructure in a cloud-native environment.
Key Responsibilities:
Database Administration:
Install, configure, and maintain PostgreSQL databases on Azure (Azure Database for PostgreSQL ? Flexible Server).
Perform routine database maintenance tasks including backups, restores, patching, and upgrades.
Monitor database performance and proactively tune queries, indexes, and configurations to ensure optimal performance.
Implement and manage high availability (HA) and disaster recovery (DR) strategies using Azure-native tools and PostgreSQL replication.
Security & Compliance:
Enforce database security policies, including user access controls, encryption, and auditing.
Ensure compliance with data governance and regulatory requirements (e.g., GDPR, HIPAA).
Manage role-based access control (RBAC) and integration with Azure Active Directory (AAD).
Automation & Scripting:
Develop and maintain automation scripts using tools like PowerShell, Bash, or Python for routine DBA tasks.
Leverage Infrastructure as Code (IaC) tools such as Terraform or ARM templates for provisioning and managing database resources.
Monitoring & Troubleshooting:
Use Azure Monitor, Log Analytics, and third-party tools (e.g., pgAdmin, Datadog, New Relic) to monitor database health and performance.
Troubleshoot and resolve database-related issues including deadlocks, slow queries, and connection problems.
Collaboration & Support:
Work closely with development, DevOps, and infrastructure teams to support application development and deployment.
Provide guidance on database design, indexing strategies, and query optimization.
Participate in on-call rotations and provide 24/7 support for critical production systems.
Required Qualifications:
5+ years of experience as a PostgreSQL DBA, with at least 2 years on Azure.
Strong understanding of PostgreSQL internals, performance tuning, and replication.
Hands-on experience with Azure Database for PostgreSQL and related services.
Proficiency in SQL, PL/pgSQL, and scripting languages (e.g., Bash, Python).
Familiarity with CI/CD pipelines and DevOps practices.
Excellent problem-solving and communication skills.
Preferred Qualifications:
Azure certifications (e.g., Azure Database Administrator Associate, Azure Solutions Architect).
Experience with containerized PostgreSQL deployments (e.g., Kubernetes, Docker).
Knowledge of other database systems (e.g., Oracle, MySQL, SQL Server) is a plus.