Citi Group Oracle PL/SQL Developer Lead - VP 

India, Maharashtra, Pune 

801765122

Responsibilities

• Database Development: Design, develop, and maintain Oracle databases using PL/SQL.
• PL/SQL Programming: Write complex queries, stored procedures, functions, packages, triggers, and scripts.
• Performance Tuning: Analyze and optimize queries for maximum performance. Identify bottlenecks and provide solutions for slow-performing queries.
• Data Modeling: Work closely with data architects and business analysts to design logical and physical data models to meet project requirements.
• Database Security: Implement and maintain database security policies and procedures to ensure data integrity and availability.
• Code Review: Conduct code reviews to ensure best practices and standards are followed.
• System Integration: Work with other developers to integrate Oracle databases with other systems and applications, ensuring smooth data flow.
• Troubleshooting & Issue Resolution: Diagnose and resolve database-related issues, including performance bottlenecks, data integrity problems, and other technical challenges.
• Documentation: Maintain detailed documentation of database designs, technical specifications, and development processes.
• Mentorship: Work in an agile environment following through the best practices of agile Scrum. Provide technical guidance and mentorship to junior developers. Bring agility to application development through DevOps practices - automated builds, unit/functional tests, static/dynamic scans, regression tests etc.

Required Qualifications

• Education: Bachelor’s degree in Computer Science, Information Technology, or a related field.
• Experience: 10+ years of experience working as an Oracle Developer, with a strong focus on PL/SQL.
• Technical Skills:
  • Proficiency in Oracle Database (11g, 12c, 19c).
  • Advanced PL/SQL programming skills, including the creation of stored procedures, functions, packages, and triggers.
  • Strong knowledge of SQL query optimization and database performance tuning.
  • Expertise in logical and physical data models, maintenance of DDLs.
  • Experience with Oracle tools such as SQL*Plus, SQL Developer, and TOAD.
  • Knowledge of database design principles, data modeling, and normalization.
    
• Soft Skills:
  • Excellent problem-solving skills with a strong attention to detail.
  • Strong communication skills and the ability to collaborate effectively with cross-functional teams.
  • Ability to work independently and manage multiple tasks simultaneously.
  • Strong analytical skills and ability to think critically about data and system interactions.

Preferred Qualifications

• Certifications: Oracle Database Administrator (DBA) certification (e.g., Oracle Certified Professional) is preferred.
• Experience with Cloud: Experience working with Oracle databases in a cloud environment (such as Oracle Cloud, AWS RDS for Oracle, or Azure) is a plus.
• Project Management: Experience with Agile/Scrum methodologies and project management tools like Jira is advantageous. Exposure to agile and iterative software delivery

Education:

• Bachelor’s degree/University degree or equivalent experience
• Master’s degree preferred

This job description provides a high-level review of the types of work performed. Other job-related duties may be assigned as required.

Time Type:

View the " " poster. View the .

View the .

View the