
Senior Database Administrator
Posted 1 day ago

Posted 1 day ago
This is a fully remote position, open to applicants in India.
• Take charge of the reliability, availability, performance, security, and disaster recovery of Azure PostgreSQL Flexible Server within a PaaS-first SRE setting.
• Lead the response to incidents, conduct root-cause analyses, and implement preventive measures.
• Oversee patching and maintenance schedules.
• Enhance query performance, indexing, and schema design.
• Manage data partitioning and lifecycle processes.
• Take responsibility for backup, restoration, retention, and RTO/RPO; address any backup failures.
• Ensure readiness for failover and its execution.
• Oversee disaster recovery workflows, conduct drills, and validate regional failover, switch-back, and rollback processes.
• Facilitate customer onboarding, deconversions, and tenant migrations.
• Execute and validate engineering database scripts.
• Carry out data integrity checks, including schema validation, constraints, foreign key verification, and orphan detection; provide release sign-off.
• Monitor performance using New Relic, Grafana, and observability pipelines.
• Manage RBAC, compliance, audit support, and secure handling of backups.
• Oversee weekly release and change management across Development, QA, UAT, and Production environments.
• Automate maintenance tasks, backup/restore processes, monitoring, and SRE practices, including SLIs, SLOs, and error budgets.
• Ensure high uptime and reliability, conduct zero-disruption maintenance, achieve rapid incident resolution, validate disaster recovery readiness and failover execution, and improve database performance and cost-effectiveness.
• Proficient in PostgreSQL administration.
• Experience with Azure PostgreSQL Flexible Server.
• Skill in performance tuning.
• Knowledge of backup and restoration processes.
• Experience with failover, disaster recovery, and schema optimization.
• Proficient in Linux/Unix troubleshooting across database, operating system, and platform layers.
• Familiarity with Bash/Shell scripting.
• Python skills are preferred.
• Experience with New Relic, Grafana, and Azure Monitor.
• Competence in log analysis.
• Ability to tune alerts.
• Exposure to CI/CD practices.
• Experience in incident and change management.
• Strong skills in cross-functional collaboration.
• Excellent communication abilities.
• Commitment to documentation discipline.
• Possess an ownership mindset.
• Ability to thrive in high-pressure production settings.
• Familiarity with PgBouncer, large-scale partitioning, regulated/fintech environments, and multi-region Azure disaster recovery is a plus.
• Scheduled weekly hours: 40.
• Regular worker type.
TriSphere Apps
Alphabria
Jonas Software
LouisianaNOW.Jobs
Get handpicked remote jobs straight to your inbox weekly.