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.