Database Developer

Discover your future at Citi

Working at Citi is far more than just a job. A career with us means joining a team of more than 230,000 dedicated people from around the globe. At Citi, you’ll have the opportunity to grow your career, give back to your community and make a real impact.

Job Overview

Job Summary: We are seeking a talented and experienced Database Developer to join our growing team. The ideal candidate will have 2-4 years of experience in designing, developing, and maintaining high-performance and scalable database solutions. This role involves working closely with software engineers, architects, and business analysts to translate business requirements into efficient database designs, implement data models, and optimize database performance.

Key Responsibilities:

• Design, develop, and implement robust, scalable, and secure database solutions (e.g., schemas, tables, views, stored procedures, functions, triggers, indexes, complex PLSQL codes) primarily using [e.g., MSSQL Server, Oracle].
• Collaborate with application developers to define data structures, enforce data integrity, and ensure efficient data access.
• Write and optimize complex SQL queries and ETL processes for data extraction, transformation, and loading.
• Develop and maintain scripts for database automation, routine tasks, monitoring, and data manipulation using shell and/or batch scripting.
• Experience with data loading and extraction using tools like SQL*Loader and Oracle-supplied packages (UTL_FILE, DBMS_JOB, DBMS_SCHEDULER, DBMS_SQL).
• Monitor database performance, identify bottlenecks, and implement solutions for performance tuning and optimization (e.g., query optimization, indexing strategies).
• Perform database capacity planning and contribute to architectural decisions related to database infrastructure.
• Develop and maintain documentation for database designs, configurations, and operational procedures.
• Ensure data security, integrity, and availability through best practices, including backup and recovery strategies.
• Troubleshoot and resolve database-related issues in development, testing, and production environments.
• Participate in code reviews and contribute to the continuous improvement of database development standards and processes.
• Stay up to date with emerging database technologies and trends.

Required Skills and Qualifications:

• 2-5 years of professional experience as a Database Developer, SQL Developer, or similar role.
• Strong proficiency in SQL and experience with at least one major relational database system (e.g., MSSQL Server, Oracle).
• Solid understanding of database design principles, data modeling (conceptual, logical, physical), and normalization.
• Good experience with shell scripting (Linux/Unix) and/or batch scripting (Windows) for automation and task execution.
• Experience with performance tuning and optimization techniques, including query analysis and indexing.
• Familiarity with ETL processes and tools.
• Experience with version control systems (e.g., GitHub, Light Speed Enterprise).
• Excellent problem-solving and analytical skills.
• Strong communication and interpersonal skills, with the ability to work effectively in a team environment.

Preferred Skills (Nice to Have):

• Basic Knowledge of data warehousing concepts and Business Intelligence (BI) tools.
• Understanding of Agile/Scrum methodologies.