Skills: Database Engineer, Oracle, 19c, 21c, 22c, MSSQL Server, MSSQL, Aurora Postgres database, Aurora Postgres, Python, Angular, Golden Gate Replication technology, Golden Gate Replication, Disk Management, SQL, RAC, OEM, OEM Grid Control/Cloud Control, Ansible, Scripting Languages

JOB DESCRIPTION:

• Being a member of Database Engineering team, the Lead Database Engineer is a DBA role and will provide database administrative support for all DTCC environments including Development, QA, client test, and our critical high availability production environment and DR Data Centers.
• Extensive knowledge on all aspects of Oracle database administration and the ability to support other database platforms including both Aurora PostgreSQL and MSSQL-Server.
• This DBA will have a high level of impact in the creation of new processes and solutions, while operating under established procedures and processes in a mission critical Financial Services infrastructure environment.

RESPONSIBILITIES:

• Software installation and patching
• Database creation and configuration
• Support development, QA, PSE and Production environments using ServiceNow ticketing system
• Review production performance reports for variances from normal operation
• Maintain database performance by calculating optimum values for database parameters; implementing new releases; completing maintenance requirements; evaluating computer operating systems and hardware products.
• Provide 3rd level support for DTCC critical production environments.
• Participate in root cause analysis for database issues.
• Supports database functions by designing and coding utilities.
• Prepare users by conducting training; providing information; and resolving problems.
• Maintain quality service by establishing and enforcing organizational standards.
• Maintain professional and technical knowledge by attending educational workshops; reviewing professional publications; establishing personal networks; benchmarking state-of-the-art practices; participating in professional societies.
• Shared responsibility for off-hour support.
• Aligns risk and control processes into day-to-day responsibilities to monitor and mitigate risk; escalates appropriately.

QUALIFICATIONS:

• Bachelor's degree or equivalent experience
• Minimum of 6 years of related experience
• Strong Oracle knowledge of 19c, 21c and 22c.
• Strong knowledge in MSSQL Server and Aurora Postgres database
• Strong knowledge in Python and Angular.
• Working knowledge of Oracles GoldenGate Replication technology
• Working knowledge of O/S and Disk Management, working knowledge with SQL
• Hands on experience with Oracle RAC and OEM Grid Control/Cloud Control
• Hands on experience in python, Ansible and other scripting languages to automate the tasks.
• Ability to work with a high degree of latitude while adhering to established process and procedures.
• Strong understanding in both how databases fit into systems and how application changes will influence database performance.