Database Engineer - PostgreSQL/PL-SQL

<p><p><b>Job Purpose :</b><br/><br/>We are seeking a Lead / Senior Oracle/PostgreSQL Developer with deep expertise in backend database engineering and AWS.

You will be responsible for designing, developing, and optimizing high-performance Oracle/PostgreSQL database systems, ensuring scalability, security, and reliability in enterprise environments.<br/><br/><b>Key Responsibilities :</b><br/><br/>- Design, develop, and optimize Oracle/PostgreSQL database solutions.<br/><br/>- Write efficient SQL, PL/SQL, and PL/pgSQL procedures, functions, triggers, and packages.<br/><br/>- Perform data modeling, schema design, and database configuration.<br/><br/>- Develop and manage ETL/data migration processes.<br/><br/>- Optimize queries, indexing, and execution plans for performance.<br/><br/>- Troubleshoot and resolve complex database issues in production environments.<br/><br/>- Collaborate with cross-functional teams to translate business requirements into technical solutions.<br/><br/>- Work with AWS services (Lambda, Step Functions, Kinesis, Kafka, etc.).<br/><br/>- Implement monitoring, governance, and database security best practices.<br/><br/><b>Skills & Competencies</b><br/><br/>- Strong SQL programming & query optimization expertise<br/><br/>- Hands-on with Oracle/PostgreSQL internals & performance tuning<br/><br/>- Exposure to ETL tools (Oracle Data Pump, ODI, etc.)<br/><br/>- Knowledge of AWS cloud ecosystem (Aurora, Lambda, Step Functions, etc.)<br/><br/>- Strong problem-solving and communication skills<br/><br/></p><br/></p> (ref:hirist.tech)