- 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.
- 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.
- 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.
- 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.
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.
