Job description
ob Description:
This Oracle DBA position is to provide Database support for Citi’s Oracle Databases with an emphasis on problem solving, troubleshooting Production issues, provide guidance to App teams on database performance tuning items and ensure database stability, availability and also provide support to upgrade, migrate and patch systems. This position requires to work in a fast-paced, large scale and very diverse 24x7 environment. DBA team member will work with multiple support teams located in NAM, EMEA, APAC regions working together adopting follow-the-sun support model. Additional responsibilities include managing and documenting projects and executing process and delivering improvements.
Responsibilities:
- Oracle databases support for critical Oracle database systems.
- Monitor and address database alerts/issues, capacity constraints, and performance related items.
- Knowledge of Oracle DataGuard replication and physical standby for Disaster recovery.
- Fully analyze performance issues, identify tuning opportunities and advise developers on SQL tuning options.
- Interact and communicate with application developers and support teams to understand and articulate.
- Drive Root Cause Analysis (RCA) post restoration of service
- Design testing approaches, complex processes, reporting streams, and create automation of repetitive tasks
- Be a part of DBRE’s (database reliability engineers) team to meet targets and SLA objectives.
- Review requirement documents, define hardware requirements and examine and update processes and procedures as necessary
Qualifications:
- Ability to communicate technical concepts to non-technical audience
- Knowledge of UNIX scripting and automation experience preferred.
- Knowledge of automation tools like ANSIBLE and automation scripting / fixing is preferred.
- Knowledge of Oracle database installation / configuration best practices and Database upgrade/migration approaches.
- Extensive experience with of Oracle Data Guard replication setup, maintenance, and troubleshooting
- Experience with various Oracle Database high availability solutions and Oracle Golden Gate replication
- Knowledge of database internals/views to help troubleshoot issues.
- Skills to identify tuning opportunities, implement improvements and advise developers on SQL tuning options.
- Ability to develop projects required for design of metrics, analytical tools, benchmarking activities and best practices
- Ability to work with virtual / in-person teams, and work under pressure / 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
- Ability to communicate technical concepts to non-technical audience
Education:
- Bachelor’s/University degree, Master’s degree preferred
-
Job Family Group:
Technology-
Job Family:
Systems & Engineering-
Time Type:
Full time-
Primary Location:
Irving Texas United States-
Primary Location Salary Range:
$116,880.00 - $175,320.00-
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
-
Effective November 1, 2021, Citi requires that all successful applicants for positions located in the United States or Puerto Rico be fully vaccinated against COVID-19 as a condition of employment and provide proof of such vaccination prior to commencement of employment.
learninglandscape.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, learninglandscape.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, learninglandscape.com is the ideal place to find your next job.