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.
Skills Required
- Bachelor's degree in Engineering, Computer Science, Information Technology, or a related technical discipline
- Minimum 5+ years of relevant database development or programming experience
- 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
- Experience with database deployment, data processing, data migration or conversion, and data validation activities
- Ability to troubleshoot databases and application-related issues and perform root cause analysis
- Strong knowledge of Linux Shell scripting
- Experience in database or application production support and troubleshooting
- Experience with Oracle and PostgreSQL performance tuning, query optimization, and execution plan analysis
- Experience with large-scale database migration, data conversion, or application upgrade projects
- Experience developing automation utilities or scripts for database operations
- 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
Majesco Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Majesco and has not been reviewed or approved by Majesco.
-
Leave & Time Off Breadth — Flexible or unlimited PTO, paid holidays, and strong support for remote work are widely highlighted. Time-off policies feel generous and practical for work-life balance.
-
Healthcare Strength — Health insurance is considered solid and comparable to larger tech firms, with a global EAP also emphasized. Core medical coverage appears to be a dependable part of the package.
-
Career-Linked Recognition & Rewards — An employee recognition program and structured development paths (iLearn, CLIMB) are prominently featured. These elements add non-cash value alongside base pay.
Majesco Insights
What We Do
Majesco is the partner P&C and L&A insurers choose to create and deliver outstanding experiences for customers. We combine our technology and insurance experience to anticipate what’s next, without losing sight of what’s important now. Over 350 insurers, reinsurers, brokers, MGAs, and greenfields/startups rely on Majesco’s SaaS platform solutions of core, digital, data & analytics, distribution, and a rich ecosystem of partners to create their next now. As an industry leader, we don’t believe in managing risk by avoiding change. We embrace change, even cause it, to get and stay ahead of risk. With 900+ successful implementations we are uniquely qualified to bridge the gap between a traditional insurance industry approach and a pure digital mindset. We give customers the confidence to decide, the products to perform, and the follow-through to execute. For more information, please visit www.majesco.com.
