Senior Database Administrator – Postgres, MySQL
Employment Information
Report this job
Job expired or something wrong with this job?
Job Description
Senior DBA managing Experity’s Aurora PostgreSQL and MySQL SaaS databases on AWS. Improving reliability, performance, scalability, security, and operational resilience.
Responsibilities:
- Design, implement, optimize, and support Experity’s cloud-native database platforms, focusing on Aurora PostgreSQL and MySQL running on AWS RDS
- Deploy, configure, and manage PostgreSQL and MySQL databases in AWS RDS and Aurora environments
- Configure and manage MySQL parameter groups, option groups, automated backups, snapshots, and maintenance windows
- Architect and support high-availability solutions using clusters, read replicas, Multi-AZ deployments, writer/reader endpoint strategies, and read scaling
- Monitor and mitigate replication lag across replicas
- Tune database-specific parameters and optimize Aurora storage architecture, I/O patterns, autovacuum behavior, and checkpoint tuning
- Optimize database indexing, query execution plans, and MySQL InnoDB configuration for production workloads
- Monitor and troubleshoot database performance using AWS CloudWatch, DataDog, and database-native tools such as pg_stat_statements and EXPLAIN
- Analyze and optimize query performance, indexing strategies, and resource utilization
- Investigate and resolve complex production issues, including locking, blocking, replication lag, and connection saturation
- Implement and manage backup and recovery strategies, including point-in-time recovery, automated snapshots, and cross-region resilience
- Partner with engineering teams to improve schema design, query patterns, and database access efficiency
- Drive observability best practices across database environments, including alerting, logging, and performance metrics
- Optimize cloud database cost and performance, including instance sizing, storage utilization, and workload tuning
- Support database migrations and modernization efforts
- Automate database provisioning and operations using Infrastructure-as-Code and scripting
- Participate in incident response, root cause analysis, and continuous improvement processes
- Support MySQL version upgrades, patching, and database migrations with minimal downtime
- Act as a technical leader in database reliability and performance, influence architecture decisions, mentor team members, and drive operational excellence across multiple database platforms
- Perform other duties as assigned
Requirements:
- Bachelor’s degree in Computer Science or related field, or equivalent experience
- Minimum 5 years of database administration experience, with 3+ years focused on PostgreSQL in high-volume OLTP production environments
- 2+ years administering MySQL in production, preferably on AWS RDS
- Strong hands-on experience with AWS Aurora PostgreSQL and AWS RDS MySQL
- Deep understanding of PostgreSQL internals, including query planner, indexing, vacuuming, WAL, and replication
- Strong understanding of MySQL architecture, including InnoDB storage engine, replication, indexing, and query optimization
- Proven expertise in database performance tuning and troubleshooting in high-availability, high-throughput environments
- Experience supporting systems with significant transaction volume (e.g., 100–200+ TPS) and scaling for continued growth
- Experience troubleshooting contention scenarios, including locking, blocking, connection saturation, and long-running transactions
- Experience with AWS services including RDS, Aurora, EC2, IAM, VPC, CloudWatch, and S3
- Experience with monitoring and observability platforms such as DataDog and CloudWatch
- Experience designing and supporting High Availability and Disaster Recovery solutions
- Strong understanding of relational database design and data modeling
- Experience with automation (Terraform, CloudFormation, or similar) and scripting (Python, Bash, etc.)
- Experience operating in a production SaaS or high-transaction environment
- Demonstrates ownership and accountability for production systems
- Strong problem-solving skills with a proactive approach to identifying and resolving issues
- Ability to work cross-functionally with engineering and operations teams
- Communicates clearly and effectively in both technical and non-technical contexts
- Continuously seeks to improve processes, performance, and reliability
Similar Jobs
Senior DBA, Database Architect
Senior DBA / Database Architect designing scalable, high-performance data systems for Lateral, a global design and technology company. Leading database architecture, delivery, and engineering mentorship.
SPMO PPM Database Administrator
Primavera P6 database administrator managing Oracle EPPM systems for Westinghouse’s clean nuclear energy solutions. Supporting performance, security, recovery, integrations, and users.
Database Administrator
Database Administrator supporting Oracle databases, Exadata, and OCI deployments. Maintaining secure technology systems for Accenture Federal Services’ US federal government clients.
Database Administrator
Database Administrator supporting Koniag's federal government customer with SQL Server and Oracle administration. Contributing to AWS migration, data modernization, incident response, and database operations.
Database Administrator
Database Administrator maintaining PostgreSQL on AWS RDS and Aurora for a global B2B platform. Ensuring performance, security, backups, disaster recovery, and 24/7 reliability.
Database Administrator – DBA
Database Administrator managing MSSQL, PostgreSQL, and MySQL databases for Escalent’s data analytics and advisory business. Optimizing performance, security, backups, and cloud or on-premises deployments.
Database Administrator, DBA
Database Administrator managing MSSQL, PostgreSQL, and MySQL environments for Escalent, a data analytics and advisory firm. Optimizing performance, security, backups, and cloud or on-premises deployments.
MySQL Database Administrator
MySQL Database Administrator designing, optimizing, and automating mission-critical databases for Miratech’s global IT services clients. Supporting MySQL replication, performance, availability, and cloud modernization.
Database Administrator
Epic database administrator optimizing SQL, Healthy Planet, and analytics systems for healthcare organizations. Supporting population health, value-based care, quality performance, and clinical outcomes.
Database Administrator
Database Administrator managing PostgreSQL, MongoDB, and Redis databases for RecruityTalent’s Bulgarian IT clients. Ensuring performance, security, backups, recovery, and scalability.
Senior Database Administrator
Senior Database Administrator maintaining MySQL, Oracle, and SQL Server platforms for Main Digital’s high-traffic digital environments. Supporting performance, security, backups, and disaster recovery.
Database Administrator
Database Administrator maintaining SQL Server and Oracle environments for Koniag’s federal government customers. Supporting cloud migrations, incident response, backups, security, and performance optimization.
Senior Database Administrator
Senior database administrator supporting Oracle, Postgres, and MS SQL systems for US federal government missions. Maintaining enterprise databases, resolving issues, and deploying infrastructure improvements.
Database Administrator
Database Administrator managing Oracle databases, GoldenGate, RAC, backups, and performance. Supporting European Dynamics’ enterprise software and government IT projects.
Database Administrator – SQL
Azure SQL Database Administrator operating high-volume production databases for SHI, a global IT solutions provider. Managing Azure data services, performance, availability, security, and customer incident response.
Database Administrator III
Database Administrator III maintaining and tuning Oracle databases for ONEOK, a leading midstream energy infrastructure company. Designing schemas, troubleshooting SQL issues, and producing operational reports.
Database Administrator IV
Database Administrator IV managing secure, scalable enterprise databases for Modivcare, a healthcare access and transportation company. Modernizing platforms, advancing cloud adoption, and automating reliable data operations.
Database Administrator
Database Administrator ensuring the performance, reliability, and scalability of data systems for a financial data provider. Collaborating with engineering teams in a remote role.
SAP HANA Database Administrator – Part-time
Database Administrator for SAP HANA, providing database administration and optimization. Working flexible hours with a focus on performance and security of SAP HANA environments.
Cloud Database Manager
Cloud Database Manager overseeing cloud database platform administration and team development at Fiserv. Focused on Azure environments and driving database modernization and automation.