Database Engineering Senior Analyst - Asst. Vice President
Role Overview
The Database Engineering Senior Analyst is responsible for enterprise database availability, performance optimization, administration, modern development, and intelligent automation.
The role centers on Oracle, with additional platforms including PostgreSQL, SQL Server, and MongoDB, and uses AI tools for diagnostics, optimization, monitoring, and support.
The position applies subject matter expertise, leads root cause analyses, drives automation, and mentors team members while following firm risk and control standards.
Key Skills for This Role
Full Job Posting
Job overview
The Database Engineering Senior Analyst is responsible for enterprise database availability, performance optimization, administration, modern development, and intelligent automation.
The role centers on Oracle, with additional platforms including PostgreSQL, SQL Server, and MongoDB, and uses AI tools for diagnostics, optimization, monitoring, and support.
The position applies subject matter expertise, leads root cause analyses, drives automation, and mentors team members while following firm risk and control standards.
Database performance and support
- Monitor database health, availability, and performance; analyze AWR, ADDM, and OEM reports.
- Tune SQL queries, indexes, memory, and storage, and proactively troubleshoot bottlenecks using traditional and AI-powered tools.
- Resolve production issues, Oracle errors, and critical incidents; coordinate with Oracle Support on complex cases.
- Use AI-based tools for incident triage, root cause analysis, and preventive action planning to support 24x7 availability.
Administration, lifecycle, and automation
- Create and manage instances, schemas, tablespaces, users, roles, and privileges; manage storage and capacity.
- Monitor tablespace usage, archive logs, jobs, and alerts.
- Plan and execute upgrades and migrations across environments and platforms; validate backups and conduct disaster recovery tests.
- Develop and maintain complex SQL, PL/SQL, and Shell scripts; use AI developer tools for code generation, refactoring, and code review.
- Automate monitoring, health checks, maintenance tasks, and operational workflows.
Governance and team contribution
- Assess risk in technical and business decisions and comply with policies, regulatory standards, and control requirements.
- Lead root cause analyses and mentor team members.
Experience and technical qualifications
- 10+ years of overall IT experience, including 8+ years of specialized Oracle DBA and database development experience.
- Expertise in Oracle administration and development, RAC, Data Guard, performance tuning, 19c upgrades, SQL, PL/SQL, and Data Pump.
- Proficiency using AI tools for database development and for operational support, such as incident diagnosis, anomaly detection, and predictive maintenance.
- Hands-on expertise in PostgreSQL; working knowledge of SQL Server and MongoDB.
- Proficiency in Shell scripting, DevOps practices, and infrastructure automation.
Professional and education qualifications
- Strong analytical, problem-solving, communication, and diplomacy skills; demonstrated incident leadership and cross-functional collaboration.
- Bachelor's/university degree or equivalent experience.
Salary
- The stated full-time salary range is $96,400 to $144,600 per year.
- Eligible employees may also receive discretionary or formulaic incentive and retention awards.
Benefits
- Benefits may include medical, dental, and vision coverage; 401(k); life, accident, and disability insurance; wellness programs; and paid time off and holidays.
Apply for this job in 1 click
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career
More from this employer
More jobs at Citi
Principal Engineer – Vice President
Irving, USA
Applications Development - Assistant Vice President
Pune, IND
Data Engineer
Pune, IND
AVP Productivity CitiLean Reengineering
Gurugram, IND
Vice President - Business Analytics
Bengaluru, IND
Market Sales and Service Analyst - Central California /Nevada
, USA
Data Analyst with SQL, Python, Data visualization
Gurugram, IND
Java Developer
Pune, IND