Design and implement database solutions, optimize performance, manage ETL processes, ensure data integrity, and support analytics and reporting requirements.
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.
- 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
Hadoop
Hive
Impala
Oracle
Pl/Sql
Python
Shell Scripting
SQL
Sqoop
Tableau
Citi Chennai, Tamil Nadu, IND Office
C P Ramaswamy Road, Chennai, Tamil Nadu, India, 600018
Similar Jobs
Logistics • Transportation
The Senior Database Engineer designs and develops scalable data platforms, manages migrations, optimizes data performance, and ensures data governance while mentoring junior members.
Top Skills:
AWSAws RdsAzureAzure SqlCi/CdData ModelingDevOpsETLGithub ActionsGrafanaMongoDBPostgresSQL ServerTerraform
Big Data • Information Technology • Software • Database • Business Intelligence
The DevOps Engineer will manage cloud operations, design CI/CD pipelines, implement monitoring systems, ensure security and compliance, and optimize costs for performance.
Top Skills:
BashCi/CdDockerElasticsearchGithub ActionsGCPHelmKubernetesMongoDBPostgresPrometheusPythonRedisTerraform
Information Technology • Security • Cybersecurity
Responsible for maintaining production systems, optimizing databases, troubleshooting performance issues, and collaborating with various teams for support and improvements.
Top Skills:
AnsibleCassandraCephElasticsearchGitGrafanaJenkinsKafkaOciOracleRedis
What you need to know about the Chennai Tech Scene
To locals, it's no secret that South India is leading the charge in big data infrastructure. While the environmental impact of data centers has long been a concern, emerging hubs like Chennai are favored by companies seeking ready access to renewable energy resources, which provide more sustainable and cost-effective solutions. As a result, Chennai, along with neighboring Bengaluru and Hyderabad, is poised for significant growth, with a projected 65 percent increase in data center capacity over the next decade.
