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
Similar Jobs
The Associate Solutions Consultant will develop and deliver customer presentations, create multichannel marketing playbooks, and act as a strategic advisor to clients by leveraging Zeta's marketing services and technology. Responsibilities include managing client proposals, collaborating with various internal teams, and providing guidance on digital and social media campaigns. The role involves utilizing analytics tools to formulate effective marketing strategies and ensuring timely delivery of campaign-related materials.
Be an Early Applicant
As a Senior Site Reliability Engineer, you will ensure platform stability and responsiveness, enhance software solutions, resolve incidents, implement automation tools, and analyze system performance. You will collaborate with cross-functional teams to promote best practices in reliability and efficiency, and maintain scripts with a focus on Python while participating in on-call rotations.
As an Associate Solutions Consultant, you will create and deliver client presentations, develop marketing playbooks, act as a strategic advisor, and manage proposal delivery. Essential skills include a strong background in digital media, analytics, and collaboration across various internal teams. You will also support the sales team by addressing customer requests and recommending suitable audience segments based on campaign goals.
What you need to know about the Hyderabad Tech Scene
Because of its proximity to leading research institutions and a government committed to the city's growth, Hyderabad's tech scene is booming. With plans to establish India's first "AI city," the city is on track to become one of the world's most anticipated tech hubs, with companies like TransUnion, Schrödinger and Freshworks, among others, already calling the city home.
