REMOTEFULLTIME
Lead Engineer
Majesco
Remote · remote · Posted 4d ago
Sourced from
Undisclosed5–10 yrsfulltimeRemote
Your match
?
Sign in to see your match score, skill gaps & tailored resume.
Section · 01
About this role
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.
Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.
Sourced from naukri
Let the agent run this one for you.
Tailored resume, auto-apply, and referral lookup — in under 2 minutes.
Section · 02
Skills
AutomationAgilecloud databaseagile software developmentAutomatingComplex QueriesApplication Production SupportData MigrationcloudData ConversionCommunication SkillsApplication DevelopmentData ProcessingData Validation
Section · Company
About Majesco
Majesco
IT Services & Consulting
1.4k+
employees
1982
44 years old
Morristown, NJ
United States
About
Majesco is the partner P&C and L&AH insurers choose to create and deliver outstanding experiences for customers.
Industries
IT Services & Consulting
Employee ratings
449 reviews
2.9/ 5
Culture
2.9
Career growth
2.5
Work-life
2.9
Employees rate it well for
Work Life Balance85Work Culture59Senior Management45Work From Home43Salary40
Find them on