Hybrid Oracle / Postgres Database Developer

at Mogul

• Job title: Oracle / Postgres Database Developer
• Job type: Full Time
• Experience level: Mid level, Senior
• Salary: Not specified
• Degree requirement: Bachelor's Degree
• Tech skills: Oracle, Postgres, Shell Scripting, SQL, Unix
• Location requirements: Hybrid, Hyderabad, India

About the role

• PostgreSQL / Oracle Developer at Vitech designing and implementing complex database solutions. Join a dynamic team focused on innovative software for insurance and retirement industries.

Responsibilities

• Develop Complex Database Solutions: Design, develop, test, and implement stored procedures, functions, packages, views, cursors, triggers, and complex SQL queries.
• Ensure Database Compliance: Ensure that database programs adhere to company standards and best practices.
• Optimize Performance: Tune queries for optimal performance and provide recommendations to improve efficiency.
• Business Requirement Translation: Translate business requirements into technical specifications for database solutions.
• Technical Assistance: Provide technical support, troubleshoot issues, and resolve problems efficiently.
• Explore New Technologies: Stay updated on new and emerging database technologies to enhance system performance and capabilities.
• Collaborate and Communicate: Work closely with team members, demonstrating strong communication and interpersonal skills to meet project deadlines.

Requirements

• 4 to 6 years of experience in PostgreSQL / Oracle development
• Strong command of PostgreSQL and Oracle SQL/PLSQL, including stored procedures, functions, triggers, and complex SQL statements.
• Proficiency in Unix shell scripting is a plus.
• Excellent debugging and problem-analysis skills, able to resolve complex technical issues efficiently.
• Hands-on experience in tuning SQL queries for performance improvement.
• Ability to analyze and translate business requirements into technical specifications.
• Ability to work independently and deliver high-quality results within tight deadlines.

Benefits

• Work on Complex Projects: Develop and implement complex database solutions that directly impact business operations.
• Learning Opportunities: Stay at the forefront of database technologies and continuously expand your technical expertise.
• Collaborative Environment: Be part of a dynamic team that values communication, innovation, and knowledge sharing.
• Competitive Compensation: Enjoy a competitive salary and a robust benefits package.
• Impactful Role: You will have the autonomy to take on new challenges and see the direct impact of your work on the company's success.
• Health insurance
• 401(k) matching
• Flexible work hours
• Paid time off
• Remote work options