Database Administrator Analyst

Pluxee India; Mumbai; Hybrid; INR 1,200,000 - 2,400,000; Full time

Job summary

Pluxee India in Mumbai is seeking an experienced Oracle Database Developer to design, develop, and maintain PL/SQL procedures, packages, functions, and triggers for business applications.

You will manage Oracle Database technologies, optimize complex SQL queries, implement indexing and partitioning, and analyze execution plans to remove bottlenecks while ensuring high availability and performance. Collaboration with application teams is essential.

Qualifications

• Hands-on PL/SQL development with Oracle Database
• Expertise in SQL tuning and execution plan analysis
• Experience in database troubleshooting and performance optimization
• Bachelor's degree in CS/IT/Engineering or related field

Responsibilities

• Design, develop, and maintain PL/SQL objects (procedures, packages, functions, triggers)
• Manage Oracle Database technologies for availability and performance
• Write, optimize, and troubleshoot complex SQL queries
• Implement indexing, partitioning, and other optimization techniques
• Analyze execution plans to identify bottlenecks and improve performance
• Monitor and tune memory, CPU, and storage usage for databases
• Collaborate with application development and business teams to deliver scalable database solutions

Skills

Oracle PL/SQL

Oracle Database

SQL tuning

Execution plan analysis

Database troubleshooting

Performance tuning

Education

Bachelor's degree in CS/IT/Engineering

Job description

Role & responsibilities

• Design, develop, and maintain PL/SQL procedures, packages, functions, and triggers to support business applications and database operations.
• Manage and support Oracle Database technologies, ensuring database availability, reliability, and optimal performance.
• Write, optimize, and troubleshoot complex SQL queries to ensure high performance and reliability.
• Implement and maintain indexing, partitioning, and other database optimization techniques.
• Analyze execution plans, identify bottlenecks, and recommend performance improvements.
• Monitor and tune database performance, including memory, CPU, and storage utilization.
• Collaborate with application development and business teams to deliver scalable and efficient database solutions.

Preferred candidate profile

• A skilled Oracle professional with strong hands-on experience in PL/SQL development and Oracle Database technologies.
• An analytical thinker with expertise in SQL tuning, execution plan analysis, and database troubleshooting.
• A proactive team player who can work effectively with cross-functional stakeholders and deliver high-quality solutions.
• Bachelor's degree in Computer Science, Information Technology, Engineering, or a related discipline.
• 4-6 years of experience in Oracle Database Development and PL/SQL programming.
• Strong experience in developing and maintaining PL/SQL objects, SQL query optimization, indexing, partitioning, and performance tuning.
• Experience working with enterprise-scale databases and business-critical applications will be an added advantage.