Principle DB Engineer is a senior level position responsible for establishing and implementing new or revised application systems and programs in coordination with the Technology team.
Responsibilities:
- Design, implement and maintain database system to meet business requirements.
- Data Modeling
- Convert the Business need into Technical complex queries/procedures.
- Ability to write complex SQL queries/PL SQL Code for reporting purpose.
- Monitor Database performance and troubleshoot issues
- Support all day to day activities related to database like data consolidation, data migration scripting, performance tuning etc.
- Partner with multiple teams to ensure appropriate integration of functions to meet goals as well as identify and define necessary system enhancements to deploy new products and process improvements
- Resolve variety of high impact problems/projects through in-depth evaluation of complex business processes, system processes, and industry standards
- Provide expertise in area and advanced knowledge of Oracle DB and ensure Database design adheres to the overall architecture blueprint
- Utilize advanced knowledge of system flow and develop standards for coding, testing, debugging, and implementation
- Develop comprehensive knowledge of how areas of business, such as architecture and infrastructure, integrate to accomplish business goals
- Provide in-depth analysis with interpretive thinking to define issues and develop innovative solutions
- Appropriately assess risk when business decisions are made, demonstrating particular consideration for the firm's reputation and safeguarding Citigroup, its clients and assets, by driving compliance with applicable laws, rules and regulations, adhering to Policy, applying sound ethical judgment regarding personal behavior, conduct and business practices, and escalating, managing and reporting control issues with transparency.
Skill/Experience:
- Having 10+ Years of IT experience and strong expertise in PL/SQL programming , Oracle Database Management , DB Design/Architecture & Normalization
- Strong experience with Oracle 18c/19c and knowledge of Oracle database features
- Proficient in DB performance tuning & optimization Techniques
- Experience with Datawarehouse & ETL process is preferred
- Expertise in Data Modeling
- Expertise in Unix Shell Scripting
- Solid Experience of creating PL/SQL Packages, Procedures, Functions, Triggers, Views and Exception handling for retrieving, manipulating, checking and migrating complex data sets in Oracle.
- Experience in data migration/conversation using SQL*Loader.
- Experience in Data migration using import and export.
- Expertise in creating the indexes on tables and partitioning the table for SQL tuning purpose.
- Expertise in writing procedures, functions, views, materialized views as required.
- Responsible for performance tuning activities in the project.
- Having good experience on Client Interaction and Presentation Skills.
- Oracle DB certifications are desirables
- Knowledge of Big Data is plus
Qualifications:
- 10+ years of relevant experience in Apps Development or systems analysis role
- Extensive experience system analysis and in programming of software applications
- Experience in managing and implementing successful projects
- Subject Matter Expert (SME) in at least one area of Applications Development
- Ability to adjust priorities quickly as circumstances dictate
- Demonstrated leadership and project management skills
- Consistently demonstrates clear and concise written and verbal communication
Education:
- Bachelor’s degree/University degree or equivalent experience
- Master’s degree preferred
Competencies:
- Ability to work in a team environment
- Flexible and able to manage time effectively
- Ability to learn new skills quickly with little supervision and ensuring the detail is of high priority
- Excellent communication (verbal and written) and interpersonal skills with the ability to communicate well at all levels
- Efficiently and effectively manage work, time, and resources
- Ability to handle high stress and pressure situations
- Strong problem solving and program execution skills while being process orientated
- Self-motivating and delivery focused individual
------------------------------------------------------
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
What We Do
Citi's mission is to serve as a trusted partner to our clients by responsibly providing financial services that enable growth and economic progress. Our core activities are safeguarding assets, lending money, making payments and accessing the capital markets on behalf of our clients. We have 200 years of experience helping our clients meet the world's toughest challenges and embrace its greatest opportunities. We are Citi, the global bank – an institution connecting millions of people across hundreds of countries and cities.
