{bc}
indeed

Database Engineering Senior Analyst - Asst. Vice President

Citi
Irving, USA
Full-time
Onsite
USD 96400-144600 yearly
Discovered 2 weeks ago
Oracle Database administrationOracle RACOracle Data GuardOracle 19c upgradesSQLPL/SQL

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.

Sarah M.James T.Maya R.

Trusted by over 500,000 job seekers on Base Career

Start Free Today

More from this employer

More jobs at Citi