Principal Software Engineer

#Hiring #DB #Oracle #PostgreSQL #AWS #Cloud #DevOps #architecture #Python #OGG

Principal Software Engineer for DB

Location: Hyderabad

Role Overview

As Principal Software Engineer (DB), this senior role leads the design, optimization, automation, and management of enterprise-grade database solutions and architectures, working extensively across Oracle and PostgreSQL environments, AWS Cloud, and advanced DevOps tools.

Key Responsibilities

• Architect, design, and optimize relational database systems (Oracle, PostgreSQL) for scalability, availability, and robust performance.
• Lead database upgrades, migrations, replication, change management via Oracle GoldenGate (OGG), Liquibase, and automation scripting.
• Design data models, schema management, data movement and pipelines, ensuring best practices in DDL, DML, security, backup, and recovery.
• Implement and monitor database performance, perform tuning and troubleshooting utilizing monitoring tools/reports (such as AWR, ADDM, SAR).
• Manage AWS database services (Aurora, RDS), including setup, configuration, performance optimization, and high availability.
• Write and maintain Shell scripts to automate database management, DevOps deployment, and routine operational tasks.
• Collaborate with architects, development teams, and business stakeholders to define database requirements, deliver technical specifications, and drive modernization strategies.
• Lead process improvements across database services, driving automation, compliance, and operational excellence (including self-service, DR drills, disaster recovery, audit).
• Mentor and guide technical teams, sharing expertise on advanced database engineering topics and engaging in critical incident response as needed.

Required Skills & Qualifications

• 12+ years hands-on experience in enterprise database engineering and technical leadership.
• Advanced proficiency in Oracle and PostgreSQL database architecture, installation, configuration, tuning, migrations, and replication.
• Deep experience with Oracle GoldenGate (OGG) and Liquibase for data replication and schema change management.
• Strong AWS background—Aurora/RDS setup, management, monitoring, and disaster recovery planning.
• Expertise in Shell scripting for automation (and familiarity with Python scripting is a plus).
• Experience in performance tuning, data security, compliance, and backup strategies for large-scale database environments.
• Excellent written and verbal communication, stakeholder management, and leadership skills