Senior Technical Specialist
Senior Technical Specialist
Job Summary
Senior PostgreSQL DBA / Database Architect (12+ Years Experience)
Job Title
Senior PostgreSQL DBA / Database Architect
Experience
12+ Years
Location
[Client Location / Hybrid / Remote]
Role Summary
We are seeking a highly experienced Senior PostgreSQL DBA / Database Architect with 12+ years of overall database administration experience and strong expertise in PostgreSQL, AWS RDS, database modernization, migration automation, and DevOps practices. The ideal candidate will lead database architecture initiatives, define database standards, optimize enterprise-scale workloads, and drive cloud database transformation programs.
Key Responsibilities
Database Administration & Architecture
- Design, implement, and manage large-scale PostgreSQL database environments.
- Define database architecture, scalability, high availability, and disaster recovery strategies.
- Lead database lifecycle management including upgrades, migrations, patching, and capacity planning.
- Establish enterprise database standards, governance, and best practices.
- Conduct database health assessments and optimization initiatives.
AWS Cloud Database Management
- Architect and administer PostgreSQL databases on AWS RDS and Aurora PostgreSQL.
- Design Multi-AZ and cross-region disaster recovery solutions.
- Configure Read Replicas, automated backups, and performance monitoring.
- Implement AWS security controls including IAM, KMS encryption, Security Groups, and VPC networking.
- Optimize cloud database costs, storage utilization, and performance.
Database DevOps & Release Management
- Implement and manage database CI/CD pipelines.
- Automate schema deployment using Flyway and Liquibase.
- Integrate database releases with Git, Jenkins, GitHub Actions, Azure DevOps, or similar tools.
- Define database versioning, rollback, and release strategies.
- Collaborate with DevOps teams to support Infrastructure as Code (IaC) practices.
Performance Engineering
- Analyze complex database workloads and tune SQL queries.
- Optimize indexes, partitioning, vacuum operations, and database configurations.
- Troubleshoot locking, deadlocks, replication lag, and performance bottlenecks.
- Lead proactive database monitoring and performance management initiatives.
Database Development
- Design and optimize PL/pgSQL stored procedures, functions, triggers, and packages.
- Develop data models and database design standards.
- Support application teams in query optimization and schema design.
Leadership & Stakeholder Management
- Provide technical leadership to DBA and application teams.
- Mentor junior DBAs and database developers.
- Participate in architecture reviews and technology roadmap discussions.
- Coordinate with business stakeholders, solution architects, and infrastructure teams.
Key Responsibilities
Key Responsibilities
Database Administration & Architecture
- Design, implement, and manage large-scale PostgreSQL database environments.
- Define database architecture, scalability, high availability, and disaster recovery strategies.
- Lead database lifecycle management including upgrades, migrations, patching, and capacity planning.
- Establish enterprise database standards, governance, and best practices.
- Conduct database health assessments and optimization initiatives.
AWS Cloud Database Management
- Architect and administer PostgreSQL databases on AWS RDS and Aurora PostgreSQL.
- Design Multi-AZ and cross-region disaster recovery solutions.
- Configure Read Replicas, automated backups, and performance monitoring.
- Implement AWS security controls including IAM, KMS encryption, Security Groups, and VPC networking.
- Optimize cloud database costs, storage utilization, and performance.
Database DevOps & Release Management
- Implement and manage database CI/CD pipelines.
- Automate schema deployment using Flyway and Liquibase.
- Integrate database releases with Git, Jenkins, GitHub Actions, Azure DevOps, or similar tools.
- Define database versioning, rollback, and release strategies.
- Collaborate with DevOps teams to support Infrastructure as Code (IaC) practices.
Performance Engineering
- Analyze complex database workloads and tune SQL queries.
- Optimize indexes, partitioning, vacuum operations, and database configurations.
- Troubleshoot locking, deadlocks, replication lag, and performance bottlenecks.
- Lead proactive database monitoring and performance management initiatives.
Database Development
- Design and optimize PL/pgSQL stored procedures, functions, triggers, and packages.
- Develop data models and database design standards.
- Support application teams in query optimization and schema design.
Leadership & Stakeholder Management
- Provide technical leadership to DBA and application teams.
- Mentor junior DBAs and database developers.
- Participate in architecture reviews and technology roadmap discussions.
- Coordinate with business stakeholders, solution architects, and infrastructure teams.
Skill Requirements
Mandatory Technical Skills
Preferred Skills
- AWS RDS
- AWS Lambda
- Terraform
- Kubernetes
- Docker
Required Experience
- 12+ years of overall Database Administration experience.
- 8+ years of PostgreSQL Administration experience.
- 5+ years of AWS RDS/Aurora PostgreSQL experience.
- Experience managing mission-critical production databases with multi-terabyte datasets.
- Hands-on experience implementing Flyway or Liquibase in enterprise environments.
- Experience leading database migration and modernization projects.
- Experience with database governance, auditing, and compliance requirements.
| Mandatory Technical Skills | ||
| Skill | Mandatory | Proficiency |
| PostgreSQL DBA Administration | Yes | Expert (5/5) |
| AWS RDS PostgreSQL | Yes | Expert (5/5) |
| Database Architecture & Design | Yes | Expert (5/5) |
| Flyway | Yes | Advanced (4-5/5) |
| Liquibase | Yes | Advanced (4-5/5) |
| PL/pgSQL | Yes | Expert (5/5) |
| Stored Procedures & Functions | Yes | Expert (5/5) |
| Query Performance Tuning | Yes | Expert (5/5) |
| High Availability & Disaster Recovery | Yes | Expert (5/5) |
| Linux Administration | Yes | Advanced (4/5) |
| Database Security & Compliance | Yes | Advanced (4-5/5) |
| CI/CD Implementation | Yes | Advanced (4/5) |