Job Description

Job Overview:

The Senior Oracle Database Administrator with Ansible/Python/PERL is responsible for assisting with Database administration activities, including Service management, technical guidance, and support coordination with the Technology Infrastructure team. This role requires expertise and experience in High Availability (RAC), Partitioning, Replication technologies, VLDB, Ansible, PERL and Python. The overall objective is to use infrastructure technology knowledge and identified policies to process data, resolve issues and execute administrative tasks.

Responsibilities:
Review and Oversee Critical Changes in Production DB environment
Ensure DB standards and tools are implemented as per global standards
Build strong clients relationships with Application Managers and Production support
Performance and capacity review of Production DB environments
Analytical & Problem solving skills
Database automation & Service Improvement
Project / Program management and implementation experience
Create complex project plans, perform impact analyses, solve/work high impact problems/projects, and provide resolution to restore services
Provide Root Cause Analysis (RCA) post restoration of service
Design testing approaches, complex processes, reporting streams, and assist with the automation of repetitive tasks
Provide technical/strategic direction to application teams
Review requirement documents, define hardware requirements and update processes and procedures as necessary
Ensure ongoing compliance with regulatory requirements
Responsible for applications dealing with the overall operating system
Conduct project related research
Has the ability to operate with a limited level of direct supervision.
Can exercise independence of judgement and autonomy.
Acts as SME to senior stakeholders and /or other team members.
Appropriately assess risk when business decisions are made, demonstrating particular consideration for the firm's reputation and safeguarding Citigroup, its clients and assets, by driving compliance with applicable laws, rules and regulations, adhering to Policy, applying sound ethical judgment regarding personal behavior, conduct and business practices, and escalating, managing and reporting control issues with transparency.

Qualifications:

* 6+ years of experience in Oracle Database Management

* Experience with Oracle 12c or 19c.

* RAC and high availability

* Advanced backup, restore, and recovery strategies

* Experience in upgrading, patching and migrating databases

* Database performance and tuning experience

* Experience in database contingency planning, configurations and support

* Experience running SQLT Explain plans and other Advisors

* Application SQL tuning experience is a plus

* Experience in and Golden Gate replication.

* Experience in KSH shell scripting.

* Strong development & scripting background (Python, Perl a must; Power shell & Java script a plus)

* Experience with Ansible and Ansible playbook development

* Experience in automation/integration tools like Jenkins.

* Good understanding of Infrastructure as a code as well as provide solutions using tools like Chef, Puppet etc.

* Required to provide off-hours support as and when needed

* General IT Audit experience is a plus

* Ability to communicate technical concepts to non-technical audience

* Ability to work with virtual and in-person teams, and work under pressure or to a deadline

* Experience in a Financial Services or large complex and/or global environment preferred

* Effective written and verbal communication skills

* Effective analytic/diagnostic skills

Education:

Bachelors/University degree or equivalent work experience

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

Job Family Group:

Technology

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

Job Family:

Infrastructure

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

Time Type:

Full time

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

Citi is an equal opportunity and affirmative action employer.

Qualified applicants will receive consideration without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.

Citigroup Inc. and its subsidiaries (Citi) invite all qualified interested applicants to apply for career opportunities. 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 the EEO is the Law poster. View the EEO is the Law Supplement.

View the EEO Policy Statement.

View the Pay Transparency Posting