18 Aug
|
TRIGENT SOFTWARE PRIVATE
|
India
18 Aug
TRIGENT SOFTWARE PRIVATE
India
5+ years of hands-on experience as a PostgreSQL DBA also have good understanding on Azure Dev Ops with Terraform
Strong understanding of PostgreSQL internals, query planner, indexing, and performance tuning.
Experience with logical & physical replication, failover, and HA architectures.
Expertise in backup/restore, PITR, WAL management, and DR planning.
Strong SQL skills and experience optimizing complex queries.
Hands on experience with Azure Database for PostgreSQL Flexible Server.
Experience with monitoring tools (pg Badger, Prometheus, Grafana, Azure Monitor).
Scripting experience (Bash, Python) for automation
Desired skills
Hands on experience with Azure Database for PostgreSQL Flexible Server provisioning, scaling, storage tuning, and maintenance windows.
Strong understanding of Azure PaaS architecture, including compute tiers, IOPS, storage auto grow, and zone redundant HA.
Experience with Azure Monitor, Log Analytics, Query Performance Insight, and alerting for PostgreSQL performance troubleshooting.
Expertise in tuning Azure PostgreSQL parameters:
autovacuum settings, work_mem, shared_buffers, WAL settings, and connection pooling.
Experience with Azure PostgreSQL backup/restore, PITR, retention policies, and cross region restore.
Knowledge of Azure networking: Private Endpoints, VNet integration, firewall rules, and secure connectivity.
Experience building CI/CD pipelines in Azure Dev Ops for schema deployments, migration scripts, and automated validation.
Solid Git Hub experience: Git Hub Actions, branching strategies, code reviews, and DB version control.
Experience with Infrastructure as Code (Terraform, ARM/Bicep) for PostgreSQL deployments.
Understanding of connection pooling and scaling using PgBouncer or Azure connection pooling.
Knowledge of Azure security: RBAC, managed identities, encryption, auditing, and compliance.
Experience supporting production workloads on Azure PaaS PostgreSQL with performance tuning and incident resolution.
📌 Azure Devops PostgreSQL DBA (India)
🏢 TRIGENT SOFTWARE PRIVATE
📍 India