This role is seeking a highly skilled Oracle PL/SQL Developer to join our team for a global enterprise application. The role involves working with Oracle Autonomous Relational Database (ORAAS), integrating with multiple applications, performance tuning, and extensive database activities. The ideal candidate will have deep expertise in PL/SQL development, database optimization, and data integration techniques.
________________________________________
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.
________________________________________
Location: PUNE, MH, India
Employment Type: Full-time
If you have a passion for database engineering, optimizing large-scale applications, and working on global solutions, we invite you to apply and be part of our innovative team!
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.
------------------------------------------------------
Job Family Group:
Technology
------------------------------------------------------
Job Family:
Applications Development
------------------------------------------------------
Time Type:
Full time
------------------------------------------------------
Citi is an equal opportunity and affirmative action employer.
Qualified applicants will receive consideration without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.
Citigroup Inc. and its subsidiaries ("Citi”) invite all qualified interested applicants to apply for career opportunities. If you are a person with a disability and need a reasonable accommodation to use our search tools and/or apply for a career opportunity review Accessibility at Citi.
View the "EEO is the Law" poster. View the EEO is the Law Supplement.
View the EEO Policy Statement.
View the Pay Transparency Posting
Top Skills
Citi Chennai, Tamil Nadu, IND Office
C P Ramaswamy Road, Chennai, Tamil Nadu, India, 600018
