About the Role :
We are seeking a highly experienced Principal Software Engineer (Database) to architect, optimize, and scale our enterprise-grade data platforms. This senior engineering role requires deep expertise in Oracle and PostgreSQL databases, AWS Cloud database services, and DevOps-driven automation. The ideal candidate will drive data modernization, implement high-performance architectures, and lead critical initiatives involving database migrations, replication, and performance engineering, while ensuring security, compliance, and resilience at scale.
Key Responsibilities :
Database Architecture & Engineering :
- Architect and design scalable, secure, and highly available database platforms leveraging Oracle and PostgreSQL.
- Define and enforce best practices for data modeling, schema design, and database lifecycle management.
- Implement replication and high-availability strategies using Oracle GoldenGate (OGG) and related tools.
- Drive adoption of modern database engineering practices including Liquibase-based schema versioning and CI / CD integration.
Migration, Optimization & Automation :
Lead database migration and upgrade programs across heterogeneous environments (on-premises to AWS, Oracle to PostgreSQL).Develop automation scripts in Shell and Python to streamline database operations, deployment pipelines, and self-healing processes.Proactively monitor and optimize performance using AWR, ADDM, SAR, and advanced monitoring frameworks.Champion database observability and telemetry through modern DevOps toolchains.Cloud & DevOps Integration :
Manage AWS-native database services including Aurora, RDS, and related infrastructure.Define and implement disaster recovery (DR) strategies, backup automation, and failover mechanisms in hybrid cloud environments.Collaborate with DevOps teams to integrate database systems into CI / CD pipelines, containerized environments (Docker / Kubernetes), and Infrastructure as Code (IaC) frameworks.Governance, Security & Compliance :
Ensure database security hardening, encryption, auditing, and compliance with regulatory standards.Implement automated change management and approval workflows for schema and data operations.Lead DR drills, compliance checks, and audit readiness for mission-critical systems.Leadership & Collaboration :
Serve as a technical authority and escalation point for complex database challenges and incidents.Mentor and guide database engineers, developers, and DevOps teams on advanced database architecture and performance tuning.Partner with enterprise architects, business stakeholders, and product teams to align data engineering with organizational goals.Required Skills & Qualifications :
12+ years of proven experience in enterprise database engineering and leadership.Expert-level proficiency in Oracle and PostgreSQL : installation, configuration, performance tuning, replication, and upgrades.Hands-on expertise with Oracle GoldenGate (OGG) and Liquibase for replication and schema change automation.Strong background in AWS database services (Aurora, RDS, Backup, Monitoring, Failover).Proficiency in Shell scripting and experience with Python automation for DevOps-driven operations.Proven experience in performance optimization, data security, compliance frameworks, and backup / recovery strategies at enterprise scale.Strong communication, stakeholder engagement, and cross-functional leadership skills.(ref : hirist.tech)
