Database Developer- Oracle PLSQL

Job description

Database Developer Our people make all the difference in our success. Citi FX Technology would like to hire a senior Java developer to work on strategic initiatives on our FX trade processing platform. The successful candidate will also support the improvement of our software development, build and deploy practices, and will champion the use of best practices across our global development teams. Citi has the largest FX presence of any bank globally. Our physical presence in 83 countries gives us unrivalled insight into global FX markets. Our clients benefit from this as well as unparalleled liquidity. We trade over 140 different currencies out of our 83 centres, so it's no surprise that Citi FX has the broadest range of clients out of all the major FX banks. Our network is our strength. We would be nothing without our people. We value their skills, motivation and experience. Increasing investment in technology has seen us roll out award winning applications. The successful candidate will be ready to dive into running projects and contribute, hands-on, to integration, modernisation, cloud-enablement, and working with SMEs in FX Technology to create practical standards of best practice. Responsibilities Design, develop, and maintain database solutions using Oracle and Sybase. Develop and optimize SQL queries, stored procedures, PL/SQL packages, functions, and triggers. Write performance-optimized PL/SQL code using Collections, Pipelined Functions, GTTs, and other advanced features. Monitor, analyze, and improve database performance through query tuning and optimization. Review and analyze Explain Plans and other performance diagnostic tools. Design and maintain logical and physical data models. Ensure data integrity, consistency, and security across databases. Develop and support ETL processes and data integration solutions. Collaborate with application developers, business analysts, and other stakeholders. Participate in code reviews and promote database development best practices. Support production deployments and troubleshoot database-related issues. Qualifications / Experience 4+ years of experience in database development. Strong hands-on experience with Oracle and Sybase databases. Experience supporting enterprise-scale applications and databases. Technical Skills Strong expertise in SQL and PL/SQL development. Strong experience writing and optimizing complex SQL queries in Oracle. Hands-on experience with Oracle SQL Developer and other database development tools. Strong knowledge of: Query Performance Tuning Explain Plan and performance analysis tools Indexes and Index Access Methods Index Organized Tables (IOT) Partitioning Joins and Query Optimization Stored Procedures, Functions, Packages, and Triggers Basic understanding of Data Modeling concepts. Experience with ETL processes and data integration tools is preferred. Exposure to MongoDB or other NoSQL databases is an advantage. Knowledge of CI/CD pipelines and tools such as Jenkins, TeamCity, UDeploy, and SonarQube. Familiarity with Design Patterns, Code Reviews, Coding Standards, and Unit Testing. Soft Skills Strong analytical and problem-solving skills. Excellent written and verbal communication skills. Ability to work independently and take ownership of deliverables. Strong attention to detail and commitment to data quality. Ability to work under pressure and manage changing priorities and deadlines. ------------------------------------------------------ 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.