Job Description

Key Responsibilities:

=========================

Database Design & Development:

Design, model, and implement robust and scalable database solutions for both Oracle and Big Data platforms.

Performance Tuning & Optimization:

Proactively monitor, analyze, and optimize database performance for Oracle (SQL, PL/SQL, views, packages, stored procedures) and Big Data (Hive, Impala) environments. Identify and resolve bottlenecks, ensuring efficient query execution and data retrieval.

Data Ingestion & ETL:

Develop and manage efficient data ingestion pipelines using tools like Sqoop for moving data between relational databases and Hadoop.

Big Data Management:

Administer, maintain, and optimize Hadoop ecosystem components, including Hive and Impala, ensuring data availability and integrity.

Data Modeling:

Create and maintain logical and physical data models for both OLTP and analytical systems.

Troubleshooting & Support:

Provide expert-level troubleshooting and support for database-related issues, ensuring minimal downtime and business continuity.

Collaboration:

Work closely with data scientists, data analysts, developers, and other stakeholders to understand data requirements and deliver effective database solutions.

Documentation:

Create and maintain comprehensive documentation for database designs, configurations, and operational procedures.

Best Practices:

Advocate and implement database best practices, including security, backup, recovery, and disaster recovery strategies.

Reporting & Analytics Support:

Collaborate with BI teams and analysts, providing expertise on data structures and potentially supporting reporting tools like Tableau.

Required Skills & Experience:

==================================

Minimum 5+ years of hands-on professional experience

in database administration, development, or engineering roles.

Proficiency in Oracle Database:

+ Extensive experience with Oracle SQL, PL/SQL, views, packages, and stored procedures.
+ Proven ability in Oracle query tuning, performance optimization, and index management.
+ Familiarity with Oracle database architecture, backup/recovery, and security concepts.

Strong Big Data Ecosystem Knowledge:

+ Demonstrable experience with Hadoop and its core components.
+ Expertise in Hive for data warehousing and query processing.
+ Experience with Impala for real-time querying of data in Hadoop.
+ Solid understanding of data ingestion tools like Sqoop for RDBMS-to-Hadoop data transfer.

Data Warehousing & ETL Concepts:

Strong understanding of data warehousing principles, dimensional modeling, and ETL processes.

Analytical & Problem-Solving Skills:

Excellent analytical, problem-solving, and debugging skills with a keen eye for detail.

Communication:

Strong verbal and written communication skills, with the ability to explain complex technical concepts to non-technical stakeholders.

Desired (Good to Have) Skills:

==================================

Tableau or other BI Tools:

Experience working with Tableau (dashboard development, data source connectivity, performance optimization) or similar business intelligence tools is a significant plus.

Other NoSQL Databases:

Exposure to other NoSQL databases (e.g., Cassandra, MongoDB) is beneficial.

Cloud Platforms:

Experience with database services on cloud platforms (AWS, Azure, GCP).

Scripting Languages:

Proficiency in scripting languages such as Python or Shell scripting for automation and data manipulation.

Version Control:

Familiarity with version control systems (e.g., Git).

Agile Methodologies:

Experience working in an Agile/Scrum development environment.

Education:

==============

Bachelor's or Master's degree in Computer Science, Information Technology, or a related field, or equivalent practical 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.