Senior Application DBA- Assistant Vice President

Posted 21 Days Ago
Be an Early Applicant
Pune, Mahārāshtra, IND
In-Office
Senior level
Fintech • Financial Services
The Role
Leads application database administration for OTC applications, including database design, development, performance tuning, patching, maintenance, backup, archival, monitoring, standards, and automation. Works across Oracle and SQL Server platforms, performs data modeling, migration, integration, and query optimization, and uses Unix/Python scripting for DBA automation. Partners with infrastructure teams, analyzes complex issues, and supports secure, maintainable data platforms.
Summary Generated by Built In

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.
Key Responsibilities:

Senior Application DBA member AVP for OTC suite of applications, responsible for design , development and performance tuning of large scale data solutions.

Partner with CTI DBA / Windows SA domain experts to ensure DB patching and other DB maintenance activities.

Define needs around maintainability, performance, security, quality and usability for data platform including data platform backup, archival and DBA routine work

Tune existing applications on SQL Server and Oracle platforms for optimal performance.

Define and publish database standards to adopt by others to operate.

Produces detailed analysis of issues where the best course of action is not evident from the information available, but actions must be recommended/ taken.


Skills Required.

Oracle 19c , SQL Server 2016 and above, Unix, GitHub and Autosys

Highly motivated, Needs minimal hand holding, Ability to multitask and work under pressure

Strong Analytical and Problem solving skills; ability to analyze data for trends and quality checking

Must have basic Python/Unix scripting and ETL Knowledge.


Nice to Have.

Knowledge on BigData technologies like Hadoop, Spark, Snowflake, AWS S3 etc.


Knowledge/Experience:

10+ yrs. of overall IT experience

Strong exposure into routine basic DBA tasks and house keeping activities.

Expertise in database monitoring and server level performance tuning.

Strong knowledge of database fundamentals and advanced concepts, ability to write efficient SQL and tune existing queries.

Data Modeling experience (OLAP, OLTP, Logical/Physical Modeling, Normalization, knowledge on performance tuning)

Strong experience in automating routine DBA tasks via Unix/Python scripting.

Experience with AI tools like Co-Pilot, Devin or Stylus.

Data Migration, Data integration experience

Comprehensive knowledge of the principles of software engineering

Knowledge of agile (scrum , kanban) development methodology is a plus

System level understanding - Data structures, algorithms, distributed storage & compute

Can-do attitude on solving complex business problems, good interpersonal and teamwork skills.

Experience with a ETL tool is a plus

Experience with a job scheduling tool (e.g. Autosys)

Experience in Finance Industry is must.

Experience with all phases of Software Development Life Cycle


Qualifications:

Bachelor’s degree in Computer Science or equivalent


This job description provides a high-level review of the types of work performed. Other job-related duties may be assigned as required.


------------------------------------------------------

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 Required

  • 10+ years of overall IT experience
  • Bachelor's degree in Computer Science or equivalent
  • Experience in the finance industry
  • Strong experience with Oracle 19c
  • Strong experience with SQL Server 2016 or above
  • Experience with routine DBA tasks and database housekeeping
  • Expertise in database monitoring and server-level performance tuning
  • Strong knowledge of database fundamentals and advanced concepts
  • Ability to write efficient SQL and tune existing queries
  • Data modeling experience, including OLAP, OLTP, logical and physical modeling, and normalization
  • Experience automating DBA tasks with Unix or Python scripting
  • Basic Python and Unix scripting knowledge
  • ETL knowledge
  • Data migration and data integration experience
  • Experience across the software development lifecycle
  • Knowledge of software engineering principles
  • Experience with GitHub and Autosys
  • Strong analytical and problem-solving skills
  • Experience with an ETL tool
  • Experience with a job scheduling tool such as Autosys
  • Knowledge of Hadoop, Spark, Snowflake, or AWS S3
  • Experience with AI tools such as Copilot, Devin, or Stylus
  • Knowledge of Agile, Scrum, or Kanban methodologies

Citi Compensation & Benefits Highlights

The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Citi and has not been reviewed or approved by Citi.

  • Healthcare Strength — Health coverage is described as comprehensive and reliable, with multiple medical, dental, vision, prescription, and mental-health options. Wellness programs, counseling, and preventive resources further reinforce health support.
  • Retirement Support — Retirement planning is viewed as a standout, with dollar-for-dollar matching up to 6% and, in some cases, an additional fixed contribution. These elements are positioned as competitive features of the total rewards package.
  • Parental & Family Support — Family-support programs include parental leave, childcare and eldercare resources, backup-care assistance, and educational support. Part-time employees in some areas also access standard health and wellness benefits.

Citi Insights

Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Kwun Tong, Kowloon
223,850 Employees

What We Do

Citi's mission is to serve as a trusted partner to our clients by responsibly providing financial services that enable growth and economic progress. Our core activities are safeguarding assets, lending money, making payments and accessing the capital markets on behalf of our clients. We have 200 years of experience helping our clients meet the world's toughest challenges and embrace its greatest opportunities. We are Citi, the global bank – an institution connecting millions of people across hundreds of countries and cities.

Similar Jobs

Hybrid
Pune, Mahārāshtra, IND
226610 Employees

Optum Logo Optum

Senior Data Engineering Lead

Artificial Intelligence • Big Data • Healthtech • Information Technology • Machine Learning • Software • Analytics
In-Office
Pune, Mahārāshtra, IND
160000 Employees

The Aerospace Corporation Logo The Aerospace Corporation

Advanced Systems Engr

Aerospace • Artificial Intelligence • Cloud • Machine Learning • Software • Cybersecurity • Defense
Remote or Hybrid
2 Locations
4600 Employees

Capco Logo Capco

CRI/CRE Analyst

Fintech • Professional Services • Consulting • Energy • Financial Services • Cybersecurity • Generative AI
Remote or Hybrid
India
6000 Employees

Similar Companies Hiring

Hanover Park Thumbnail
Artificial Intelligence • Fintech • Software • Financial Services
New York, New York
42 Employees
Kepler  Thumbnail
Artificial Intelligence • Fintech • Software
New York, New York
9 Employees
Onshore Thumbnail
Artificial Intelligence • Fintech • Software • Financial Services
New York, New York
85 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account