Lead Database Developer

Majesco; India; On-site; INR 1,200,000 - 2,400,000; Full time

Job summary

Majesco in India is seeking an experienced Database Engineer to design, develop, and optimize enterprise database solutions primarily using Oracle and PostgreSQL. The role requires strong SQL/PL/SQL skills, shell scripting, and hands-on performance tuning to support large-scale applications.

You will work across development, QA, and operations, contribute to migrations and data validation, and build automation to reduce manual effort.

Qualifications

• Minimum 5+ years of relevant experience in database development.
• Hands-on Oracle Database development and programming.
• Hands-on PostgreSQL development and programming.
• Strong SQL/PLSQL knowledge including complex queries, stored procedures, functions, and triggers.
• Linux Shell scripting a big plus.
• Experience with data migration/conversion and data validation.

Responsibilities

• Design, develop, and maintain scalable database solutions using Oracle and PostgreSQL.
• Develop and optimize complex SQL queries, procedures, and triggers.
• Analyze relational database concepts and performance tuning.
• Develop Linux Shell scripts for processing, automation, deployments, and operational activities.
• Perform database performance analysis and tuning.
• Participate in migrations, upgrades, data validation, and reconciliation.
• Troubleshoot database issues across development, testing, and production environments.
• Collaborate with cross-functional teams to deliver database solutions on schedule.
• Identify opportunities for automation and reusable solutions.

Skills

SQL

PL/SQL

Database programming

Performance tuning

Shell scripting

Agile

Analytical thinking

Communication

Education

Bachelor's degree in Engineering/CS/IT

Tools

Oracle

PostgreSQL

Job description

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.