Senior Database Developer

At Citi we’re not just building technology, we’re building the future of banking. Encompassing a broad range of specialties, roles, and cultures, our teams are creating innovations used across the globe. Citi is constantly growing and progressing through our technology, with laser focused on evolving the ways of doing things. As one of the world’s most global banks we’re changing how the world does business Shape your Career with Citi We’re currently looking for a high caliber professional to join our team as based in Pune/Chennai, India. Being part of our team means that we’ll provide you with the resources to meet your unique needs, empower you to make healthy decision and manage your financial well-being to help plan for your future. For instance: * We provide programs and services for your physical and mental well-being including access to telehealth options, health advocates, confidential counseling and more. Coverage varies by country. * We empower our employees to manage their financial well-being and help them plan for the future. * We provide access to an array of learning and development resources to help broaden and deepen your skills and knowledge as your career progresses. Responsibilities & Qualifications: * 2-4 years of relevant Strong experience in SQL and new technologioes * DataBridge (UAL) Application: Expected to Develop/Modify/Test/Migrate Subscriptions using DataBridge (UAL) Application. * SDLC: Contribute to full development life cycle, including requirements analysis, functional design, technical design, programming, testing, documentation, implementation, and on-going technical support * Analyze and Optimize SQL: Identify high-impact, suboptimal UAL Subscription SQL statements and PL/SQL code, generate and interpret execution plans, and rewrite queries to ensure optimal performance. * Ability and willingness to learn newer tools and technologies in cloud-based data analytics/Artificial intelligence arena and successfully deliver projects utilizing the same. * Performance Monitoring: Proactively monitor database performance using tools such as Oracle Enterprise Manager (OEM), AWR (Automatic Workload Repository), and ASH (Active Session History) reports to diagnose and resolve bottlenecks. * Required Skills and Qualifications * 5+ year of Industry experience working in Finance reporting applications/warehouses. * Technical Expertise: Deep understanding of Oracle Database architecture, RDBMS concepts, memory usage, wait events, and the Cost-Based Optimizer (CBO). * SQL and PL/SQL Proficiency: Expert-level skills in writing, optimizing, and debugging complex SQL queries and PL/SQL code (procedures, functions, packages, triggers). * Tools Experience: Hands-on experience with performance monitoring and tuning tools, including SQL*Plus, SQL Developer, AWR/ASH reports, and the SQL Tuning Advisor. Strong knowledge of Oracle Database, SQL tuning, understanding of the Relational Data Modal. * Operating Systems and Scripting: Proficiency in Linux/Unix environments and strong shell scripting skills are often required. * Problem-Solving: Strong analytical thinking and problem-solving abilities to identify the root causes of performance degradation. * Communication: Excellent verbal and written communication skills to collaborate with cross-functional teams and non-technical stakeholders. * Education/Experience: A Bachelor's degree in Computer Science or a related field, plus significant relevant work experience (typically 5+ years) in database performance analysis and SQL tuning. * Certifications: Relevant Oracle certifications (e.g., Oracle Certified Professional DBA) are often a plus. * DevOps Tools knowledge/Experience : git/bitbucket , Jenkins, Lightspeed/RLM and service now. * Prior experience with Citi tool – DataBridge (UAL) is a big PLUS * Prior working experience with Citi Financial system (Specially General Ledgers) is a Big PLUS * * Implement Tuning Recommendations: Utilize the Oracle SQL Tuning Advisor and other utilities to implement corrective actions such as gathering statistics, creating new indexes, or generating SQL profiles. * Database Design Collaboration: Work closely with application developers and data architects to ensure efficient database design, data modeling, and the use of appropriate indexing and partitioning strategies. * Troubleshooting: Diagnose and resolve complex, mission-critical performance problems in various environments (development, testing, production). * Documentation and Standards: Create and maintain technical documentation, including data standards, procedures, and definitions for the data dictionary, and ensure coding guidelines are followed. * Capacity Planning: Assist in capacity planning and growth management to ensure the database environment can handle future workloads. Education: * Bachelor’s degree/University degree or equivalent experience \------------------------------------------------------ ## Job Family Group: Technology \------------------------------------------------------ ## Job Family: Applications Development \------------------------------------------------------ ## Time Type: Full time \------------------------------------------------------ ## Most Relevant Skills Please see the requirements listed above. \------------------------------------------------------ ## Other Relevant Skills For complementary skills, please see above and/or contact the recruiter. \------------------------------------------------------ Citi is an equal opportunity employer, and qualified candidates will receive consideration without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, status as a protected veteran, or any other characteristic protected by law. 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 Citi’s EEO Policy Statement and the Know Your Rights poster.