Senior Database Administrator
Job Description
Role: Senior Database Administrator (PostgreSQL / AWS RDS)
Experience: 7+ years
Location: Remote
Job Summary
We are seeking a highly experienced Senior Database Administrator (DBA) to manage, monitor, optimize, and evolve our PostgreSQL database environments. This role is responsible for supporting highload onpremises PostgreSQL systems as well as AWS RDS PostgreSQL deployments.
Key Responsibilities
- PostgreSQL Administration (OnPremise & Cloud)
- Monitor, analyze, and tune heavy and longrunning SQL queries across PostgreSQL environments
- Identify and resolve performance bottlenecks using PostgreSQL statistics, logs, and system metrics
- Optimize database performance through:
- Index design and optimization
- Query analysis and rewriting
- PostgreSQL configuration tuning (memory, vacuum, autovacuum, checkpoints)
- Database Version Upgrades & Compatibility Testing
- Lead and execute PostgreSQL database version upgrades in onpremises and AWS RDS environments
- Perform preupgrade assessments
- AWS RDS PostgreSQL & Cloud Operations
- Design, provision, and manage AWS RDS PostgreSQL instances
- Monitor RDS performance using AWS and PostgreSQL monitoring tools
- Partner with DevOps and infrastructure teams on cloud database architecture
- Database Migration & Modernization
- DevOps & Automation
Required Qualifications
- Minimum 7 years of experience as a Database Administrator, with strong focus on PostgreSQL
- Deep handson knowledge of PostgreSQL internals, performance tuning, and query optimization
- Proven experience planning and executing PostgreSQL version upgrades
- Strong experience managing AWS RDS PostgreSQL environments
- Solid understanding of Linux/Unix operating systems
- Experience working with DevOps tools, automation, and modern infrastructure practices
- Excellent troubleshooting, analytical, and problemsolving skills
- Experience supporting largescale or hightraffic PostgreSQL environments
- Familiarity with PostgreSQL monitoring and diagnostic tools
- Knowledge of highavailability, replication, and failover strategies
- Experience with AWS services such as VPC, IAM, EC2, and S3
- Scripting skills (Bash, Python, or similar)
Interested candidates can reach out at [Confidential Information]
More Info
About Company
Skills:
Cloud AWS, Github, PostgreSQL, Bash, Jira, Terraform, Helm, Kubernetes, Python, GitOPS CI, Argo Workflows, MSSQL Server management, Scripting PERL, Containers Docker, OS Tooling Linux, ArgoCD, Databases RDS, Git Actions, IaC CloudFormation
Skills:
Scripting, T-sql, Database Security, PowerShell, Bash, Automation, Performance Tuning, SQL Server 2016–2022, Index Maintenance
Skills:
T-sql, MS-SQL, PostgreSQL, PowerShell, Prometheus, Grafana, Terraform, MySQL, Azure PaaS SQL, Bicep, Azure Monitor, Azure CLI
Skills:
Backup And Recovery, Networking, Database Security, Microsoft Sql Server, High Availability, MySQL, PostgreSQL, Query Optimization, Database Monitoring, Liquibase, Datadog, Amazon Rds, Microsoft Azure, observability platforms, Disaster Recovery, query execution plans, SQL database architecture, deadlocks, AWS database technologies, Transactions, Capacity Planning, Indexing, locking and blocking, Statistics, cloud database security
Skills:
Performance Tuning, Configuration, Backup, Cassandra, PostgreSQL, Clustering, Upgrades, Sql, Nosql, RDBMS, Replication, Security, Troubleshooting, Recovery, Partitioning, Database installation, Database deployment, Indexing, Monitoring