The Applications Development Programmer Analyst is an intermediate level position responsible for participation in the establishment and implementation of new or revised application systems and programs in coordination with the Technology team. The overall objective of this role is to contribute to applications systems analysis and programming activities.

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. Proficiency in using advanced features like cursors (including REF CURSORS), collections (NESTED TABLES, VARRAYS, INDEX BY TABLES), bulk binding (BULK COLLECT, FORALL), autonomous transactions, and dynamic SQL.
• 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-4 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):

• Experience with NoSQL databases (e.g., Redis) is a plus.
• Familiarity with cloud database services (e.g., AWS RDS, Google Cloud SQL).
• 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.