Citi Group PL/SQL Developer – Global Application 

India, Maharashtra, Pune 

977224638

Key Responsibilities:

• Develop, optimize, and maintain PL/SQL stored procedures, functions, triggers, and packages.
• Design and implement robust database structures to support business requirements.
• Perform performance tuning and query optimization for high-volume transactional databases. Very good understanding in reading and analyzing explain plan and fixing performance issues.
• Deep experience and "Hands- On" experience in architecting, designing, and building enterprise-class relational and dimensional data models for large scale OLTP and data warehouse
• Extensive experience in advanced database skills such as oracle in-memory, data partitioning, stat gather, data purging, materialized views, star and snowflake design, index and stored procedures.
• Advanced knowledge of SQL and related programming languages such as PL/SQL, Python and Unix Shell scripting
• Collaborate with cross-functional teams to integrate Oracle database solutions with various applications.
• Implement data security and backup strategies in compliance with enterprise policies.
• Troubleshoot and resolve database issues to ensure system reliability and performance.
• Maintain documentation and best practices for database development and deployment processes.

Required Skills & Experience:

• 10+ years of hands-on experience in PL/SQL development.
• Strong knowledge of Oracle databases, including ORAAS.
• Expertise in query optimization, indexing, and performance tuning techniques.
• Experience with ETL tools and processes for data migration and transformation.
• Knowledge of database connectivity with external applications (APIs, web services, etc.).
• Understanding of data warehousing concepts and best practices.
• Proficiency in database security, backup, and recovery procedures.
• Strong analytical and problem-solving skills.
• Excellent communication and collaboration abilities.

Preferred Qualifications:

• Experience in large-scale, enterprise-level applications.
• Familiarity with DevOps tools and CI/CD pipelines for database deployment.
• Exposure to cloud-based Oracle solutions and data integration frameworks.
• Knowledge of scripting languages such as Python or Shell Scripting for automation.

Employment Type: Full-time

Education:

• Bachelor’s degree/University degree or equivalent experience

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