[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-reputed company 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