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