Lead Engineer

JOB OVERVIEW:

Responsible for designing, developing, optimizing, and supporting enterprise database solutions primarily using Oracle and PostgreSQL. The role requires strong database programming and Shell scripting skills, with experience in database support, troubleshooting, migration, and performance optimization considered an advantage.

CORE DELIVERABLES:

• Design, develop, and maintain scalable and reliable database solutions using Oracle and PostgreSQL.
• Develop and optimize complex SQL queries, stored procedures, functions, triggers, and other database components.
• Good understanding of relational database concepts, database design, indexing, query optimization, and performance tuning.
• Develop and maintain Linux Shell scripts for database processing, automation, deployments, and operational activities.
• Perform database performance analysis and tuning to ensure efficient and reliable application performance.
• Participate in database migrations, data conversions, upgrades, deployments, and data validation/reconciliation activities.
• Troubleshoot and resolve database-related issues across development, testing, and production environments.
• Collaborate effectively with application development, QA, infrastructure, migration, and support teams to deliver database solutions on schedule.
• Identify opportunities for automation, standardization, and reusable solutions to improve productivity and reduce manual effort.

Responsibilities may evolve over time, and other duties may be assigned to support team and business objectives.

ESSENTIAL ATTRIBUTES AND CAPABILITIES:

• Strong analytical, troubleshooting, and problem-solving skills.
• Strong database programming and development mindset with attention to performance, scalability, and maintainability.
• Excellent communication skills with the ability to collaborate effectively with technical and non-technical stakeholders.
• Effectively demonstrates a commitment to quality and a “do it right the first time” mindset.
• Strong preference for automating repetitive database and operational activities.
• Ability to analyze complex technical problems and develop effective and sustainable solutions.
• Experience and ability to collaborate with multiple teams across development, QA, infrastructure, and support functions.
• Ability to work independently, remotely, and as part of a team.
• Knowledge and working experience with Agile software development methodologies.

REQUIRED QUALIFICATIONS AND TECHNICAL EXPERTISE:

• Bachelor’s degree in Engineering, Computer Science, Information Technology, or a related technical discipline.
• Minimum 5+ years of relevant experience in database development/programming.
• Strong hands-on experience with Oracle Database development and programming.
• Strong hands-on experience with PostgreSQL development and programming.
• Strong knowledge of SQL and PL/SQL, including complex queries, stored procedures, functions, triggers, and database objects.
• Strong knowledge of Linux Shell scripting will be a big plus.
• Experience with database deployment, data processing, data migration/conversion, and data validation activities.
• Ability to troubleshoot databases and application-related issues and perform root cause analysis.

PREFERRED QUALIFICATIONS AND EXPERIENCE:

• Experience in database/application production support and troubleshooting is an advantage.
• Experience with Oracle and PostgreSQL performance tuning, including query optimization and execution plan analysis.
• Experience with large-scale database migration, data conversion, or application upgrade projects.
• Experience developing automation utilities/scripts for database operations and repetitive activities.
• Exposure to enterprise applications involving high-volume data processing and complex database environments.
• Experience working with cross-functional and geographically distributed teams.
• Exposure to cloud database environments and database migration technologies is an added advantage.