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 Oracle’s 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.