About the role
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.
------------------------------------------------------
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.
Skills & Tags
Aplyr's read
Citigroup is a global financial services leader offering diverse roles, attracting professionals in finance, technology, and operations seeking international exposure and advancement.
What's promising
- •Citigroup's global presence offers employees opportunities for international career advancement.
- •The company invests heavily in technology, providing roles for tech-savvy professionals.
- •Citigroup's diverse services allow for career growth across multiple financial sectors.
What to watch
- •Citigroup has faced regulatory challenges impacting its operations and reputation.
- •The company's size can lead to bureaucratic processes that slow decision-making.
- •Citigroup's restructuring efforts may create uncertainty in job stability.
Why Citigroup
- •Citigroup's extensive global network differentiates it from many competitors.
- •The firm's commitment to innovation is evident in its technology-driven roles.
- •Citigroup offers specialized roles requiring language skills, such as Japanese-speaking positions.
Aplyr’s read is generated by AI from public sources. Was it useful?
About Citigroup
Citi, also known as Citigroup Inc., is a global financial services corporation that provides a wide range of financial products and services to consumers, corporations, governments, and institutions.
