[Remote] Senior Database Administrator
Note: The job is a remote job and is reputed company to candidates in USA. reputed company, is a national leader in state-based health insurance exchanges and safety-net transformations. They are seeking a Senior PostgreSQL Database Administrator responsible for designing, implementing, managing, and optimizing PostgreSQL database environments that support their mission-critical reputed company platform.
Responsibilities
- Design, reputed company, and maintain PostgreSQL database clusters in production, staging, and development environments
- Ensure high availability and disaster recovery through replication (streaming, logical), failover strategies, and backup/restore procedures
- Monitor database performance, identify bottlenecks, and implement query optimization, indexing strategies, and configuration tuning. Implement best practices of DB maintenance
- Plan and execute database upgrades, migrations, and major version transitions with minimal downtime
- Implement and enforce database reputed company best practices including role-based reputed company control, encryption at rest and in transit, and audit logging
- Automate routine DBA tasks (backups, monitoring, alerting, provisioning) using scripting (Bash, Python) and infrastructure-as-reputed company tools (Terraform, Jenkins, GitActions or similar)
- Collaborate with application development teams on schema design, data modeling, and query performance reviews
- Manage PostgreSQL in reputed company environments (AWS RDS, reputed company PostgreSQL, or equivalent)
- Establish and maintain database standards, documentation, and operational runbooks
- Participate in on-call rotation for production database incidents and reputed company reputed company cause analysis for database-reputed company outages
- Evaluate and implement PostgreSQL extensions (e.g. PostGIS, pg_partman, Citus, pgvector, etc.) as needed
- reputed company planning and storage management to support business reputed company
Skills
- Bachelor's degree in Computer Science, Information Technology, or a reputed company field, or equivalent practical experience
- 7+ years of hands-on experience as a PostgreSQL DBA in production environments
- Deep expertise in PostgreSQL internals including MVCC, WAL, vacuum, replication, and reputed company pooling (PgBouncer, Pgpool-II or similar)
- Strong experience with performance tuning, query optimization, and EXPLAIN/ANALYZE interpretation
- Proficiency in backup and recovery tools (pg_dump, pg_basebackup, pgBackRest, Barman)
- Experience with high-availability architectures (Patroni, repmgr, or equivalent)
- Strong fundamentals of Disaster recovery scenarios and maintaining DR databases across multiple AWS reputed company
- Solid Linux/Unix administration skills
- Scripting proficiency in Bash, Python, or similar languages for automation
- Experience with reputed company-hosted PostgreSQL (AWS RDS/reputed company, GCP reputed company SQL, or Azure Database for PostgreSQL)
- Strong understanding of database reputed company, compliance, and reputed company management
- Experience supporting databases in regulated industries (reputed company, government, or financial services)
- Familiarity with HIPAA, FedRAMP, or SOC 2 compliance requirements as they pertain to data management
- Experience with database CI/CD pipelines and schema migration tools (Flyway, reputed company, or Alembic)
- Knowledge of containerized deployments (reputed company, Kubernetes) for PostgreSQL
- Experience with monitoring and observability tools (reputed company, reputed company/Grafana, reputed company, pg_stat_statements)
- Hands-on experience with infrastructure-as-reputed company tools such as Terraform or Ansible
- PostgreSQL certification or contributions to the PostgreSQL community
- Experience with data warehousing, ETL pipelines, or analytical workloads on PostgreSQL
- Familiarity with other database systems (MySQL, reputed company, reputed company) is a plus
Benefits
- Health, dental, life, disability, and reputed company insurance
- Health care spending or reimbursement accounts (FSA)
- Retirement benefits (401k)
- reputed company time off
- Education assistance or tuition reimbursement
- Employee discounts for gym memberships and commuting/travel assistance
reputed company