The Applications Development Senior 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.
Responsibilities:
Design, develop, and maintain high-quality, scalable, and efficient database objects including PL/SQL stored procedures, functions, triggers, and packages.
Write and optimize complex SQL queries to support application requirements and data analysis.
Perform extensive database performance tuning and optimization of queries, indexes, and database structures.
Collaborate with application developers, business analysts, and other stakeholders to understand requirements and implement effective database solutions.
Develop and implement data models and database designs to ensure data integrity, security, and scalability.
Troubleshoot and resolve database-related issues, including data discrepancies, performance bottlenecks, and access problems.
Participate in code reviews to ensure adherence to coding standards and best practices.
Create and maintain comprehensive documentation for database schemas, processes, and objects.
Recommended Qualifications:
7+ years of professional experience focused on SQL development with Oracle databases.
Expert proficiency in SQL and PL/SQL, with extensive experience in creating complex stored procedures, functions, and packages.
Demonstrated expertise in database performance tuning and optimization techniques for large-scale enterprise systems.
Strong understanding of Oracle database architecture, data modeling, and relational database design principles.
Experience with query optimization tools and techniques, such as Explain Plan and AWR reports.
Solid understanding of indexing strategies, partitioning, and other Oracle performance features.
Bachelor’s degree in Computer Science, Information Technology, or a related field.
Strong analytical and problem-solving skills.
Excellent communication and interpersonal skills, with the
ability to collaborate effectively in a team environment.
Education:
This job description provides a high-level review of the types of work performed. Other job-related duties may be assigned as required.
------------------------------------------------------
------------------------------------------------------
------------------------------------------------------
------------------------------------------------------
------------------------------------------------------
------------------------------------------------------
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.
Job details are sourced from the employer's original posting.
Open job postingAbout the company
Citicorp Services India Private Limited is a subsidiary of Citigroup, providing technology and operations support for the global financial services company.