Senior Database Engineer

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.

---