**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 (https://www.citigroup.com/citi/accessibility/application-accessibility.htm)_ _._ _View Citi’s_ _EEO Policy Statement (https://www.citigroup.com/global/eeo-aa-policy)_ _and the_ _Know Your Rights (https://www.eeoc.gov/sites/default/files/2023-06/22-088\_EEOC\_KnowYourRights6.12ScreenRdr.pdf)_ _poster._ Citi is an equal opportunity and affirmative action employer. Minority/Female/Veteran/Individuals with Disabilities/Sexual Orientation/Gender Identity.