Oracle DBA

Derex Technologies - Jersey City, NJ

Full-time - Mid Level

Jersey City, NJ

Professional, Scientific, and Technical Services

About the position

The Oracle DBA position at Derex Technologies Inc is a full-time role focused on providing database administrative support across various environments, including Development, QA, and critical production systems. The role requires extensive knowledge of Oracle database administration and the ability to support other database platforms. The DBA will play a crucial role in creating new processes and solutions while ensuring the stability and performance of databases in a 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
• Implement new releases and complete maintenance requirements
• Evaluate computer operating systems and hardware products
• Provide 2nd and 3rd level support for DTCC critical production environments
• Participate in root cause analysis for database issues
• Support database functions by crafting and coding utilities
• Prepare users by conducting training and resolving problems
• Maintain quality service by establishing and enforcing organizational standards
• Maintain professional and technical knowledge by attending educational workshops and reviewing professional publications
• Shared responsibility for off-hour support
• Recommend and implement database backup, recovery, and redundancy strategies
• Align risk and control processes into day-to-day responsibilities to monitor and mitigate risk

Requirements

• Bachelor's degree or equivalent experience
• Minimum of 4 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
• Hands-on experience with Oracle RAC and OEM Grid Control/Cloud Control
• Hands-on experience in Python, Ansible and other scripting languages to automate tasks
• Ability to work with a high degree of latitude while adhering to established processes and procedures
• Strong understanding of how databases fit into systems and how application changes will influence database performance

Nice-to-haves

• Theoretical knowledge of Goldengate
• Basic knowledge in Python