Database Engineering Senior Analyst - Asst. Vice President

Citigroup; Irving (TX); Sur place; USD 96 000 - 145 000; Plein temps

Résumé du poste

Citigroup in Irving, Texas is seeking a Database Engineering Senior Analyst to ensure 24x7 availability and optimize performance across enterprise database platforms, including Oracle RAC/Data Guard and multi-database systems like PostgreSQL, SQL Server, and MongoDB.

The role emphasizes AI-driven diagnostics, automation of monitoring and maintenance, and mentoring team members while upholding risk and control standards. Strong Oracle expertise and DevOps mindset are required.

Qualifications

• 10+ years of IT experience with 8+ years in Oracle DBA and Database Development.
• Oracle DB development and administration including RAC, Data Guard, 19c, SQL, PL/SQL, and Data Pump.
• AI-driven tools for Oracle/Database development and AI-assisted incident diagnosis.

Responsabilités

• Ensure 24x7 availability, performance optimization, and intelligent diagnostics across database platforms.
• Lead incident management with AI-assisted support and RCA.
• Administer databases: instances, schemas, tablespaces, users, roles, and privileges; monitor storage and alerts.
• Plan and execute upgrades (19c) and migrations; conduct DR testing.
• Develop SQL/PL/SQL, automate monitoring and maintenance tasks with AI tools.
• Maintain governance and risk controls aligned with firm policies.

Connaissances

Oracle DBA

SQL/PLSQL development

AI-assisted tooling

Incident leadership

Shell scripting

Cross-functional collaboration

Formation

Bachelor's degree

Outils

Oracle RAC

Oracle Data Guard

Oracle 19c

PostgreSQL

SQL Server

MongoDB

AWR/ADDM/OEM

Description du poste

The Database Engineering Senior Analyst is a seasoned professional responsible for ensuring 24x7 availability, performance optimization, administration, modern development, and intelligent automation across enterprise database platforms. The role combines deep expertise in Oracle (RAC, Data Guard, 19c, PL/SQL development) and multi-database platforms (OraaS, PostgreSQL, SQL Server, MongoDB) with the application of AI-driven tools and automation for smart diagnostics, intelligent query/code optimization, automated monitoring, and predictive support. Applies subject matter expertise, leads root cause analyses, drives automation, and mentors team members while adhering to firm-wide risk and control standards.

Responsibilities

• Performance, Monitoring & Intelligent Diagnostics: Monitor database health, availability, and performance; analyze AWR, ADDM, and OEM reports; optimize SQL queries, indexes, memory allocation, and storage utilization; troubleshoot and resolve performance bottlenecks proactively using traditional and AI-powered diagnostic/tuning tools.
• Incident Management & AI-Assisted Support: Analyze and resolve production database issues; troubleshoot ORA errors and critical incidents; coordinate with Oracle Support for complex issues; leverage AI-based support tools and knowledge assistants for accelerated incident triage, root cause analysis (RCA), and preventive action planning to guarantee 24x7 availability.
• Database Administration & Lifecycle Management: Create and manage database instances, schemas, tablespaces, users, roles, and privileges; manage database storage structures and capacity planning; monitor tablespace usage, archive logs, jobs, and alerts.
• Upgrades, Migrations & Disaster Recovery: Plan and execute database upgrades (19c, etc.); perform migrations across environments and platforms; conduct backup validation and disaster recovery (DR) testing.
• AI-Powered Development & Automation: Develop, optimize, and maintain complex SQL, PL/SQL, and Shell scripts; leverage AI developer assistance tools for code generation, SQL refactoring, and code review; automate database monitoring, health checks, maintenance tasks, and operational workflows to improve efficiency.
• Governance & Risk: Appropriately assess risk in technical and business decisions, safeguarding the firm's assets and reputation by adhering to policies, regulatory standards, and transparent control management.

Qualifications & Skills

• Experience: 10+ years of overall IT experience with 8+ years of specialized Oracle DBA and Database Development experience.
• Core Oracle Expertise: Oracle DB developer and administration, RAC, Data Guard, Performance Tuning, Database Upgrades (19c), SQL, PL/SQL, and Data Pump (expdp/impdp).
• AI-Driven Database Engineering & Support: Proficiency in utilizing AI tools for Oracle/Database development (e.g., AI-assisted SQL/PL/SQL coding, refactoring, unit testing, query optimization).
• Experience leveraging AI tools for database support and operations (e.g., AI-assisted incident diagnosis, log/telemetry pattern analysis, automated anomaly detection, and predictive maintenance).
• Multi-Database Knowledge: Hands-on experience and expertise in PostgreSQL ; working knowledge of SQL Server and MongoDB .
• Automation & DevOps: Proficient in Shell scripting, DevOps practices, and Infrastructure Automation tools.
• Professional Skills: Strong analytical, problem-solving, communication, and diplomacy skills; demonstrated capability in incident leadership and cross-functional collaboration.

Education

Bachelor's/University degree or equivalent experience.

Job Family Group

Technology

Job Family

Data Science

Time Type

Full time

Primary Location

Irving Texas United States

Primary Location Full Time Salary Range:

$96,400.00 - $144,600.00

In addition to salary, Citi's offerings may also include, for eligible employees, discretionary and formulaic incentive and retention awards.

Benefits

• Citi offers competitive employee benefits, including: medical, dental & vision coverage; 401(k); life, accident, and disability insurance; and wellness programs.
• Citi also offers paid time off packages, including planned time off (vacation), unplanned time off (sick leave), and paid holidays.
• For additional information regarding Citi employee benefits, please visit citibenefits.com. Available offerings may vary by jurisdiction, job level, and date of hire.