Senior Technical Specialist (IN)

HCL TechnologiesIN

Senior

Posted 8 hours agoStill open, checked 11m ago

About the job

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)

Other Requirements