About the position
In this role you will lead and organize day-to-day database administration and management activities for mission critical Oracle databases relied on by SWIFTNet and FIN messaging services. This includes health data collection and analysis, database performance analysis and tuning, proactive database administration activities and others. You will drive automation initiatives of various reoccurring administration activities: log scanning, metrics collection, performance report analytics, capacity growth. Additionally, you will develop strategies to proactively identify production database issues, monitor and coordinate increases in capacity based on trend analysis and new project requirements, and resolve complex database health and performance problems by investigating and devising solutions for database operations. Interaction with database/software systems engineering, applications development and support teams will be necessary to restore availability of services and determine the root cause of complex problems. You will maintain and exercise a set of recovery procedures to restore databases in the most reliable way and define and implement recommendations for complex issues in the area of database management systems. This position is mission critical and requires mostly on-site support with a flexibility of remote on demand basis. You will be willing to perform weekend migration and change activities on a rotational basis with other team members and participate in on-call rotation to support critical production databases.
Responsibilities
- Lead and organize day-to-day database administration and management activities for Oracle databases.
- Drive automation initiatives of various reoccurring administration activities.
- Develop strategies to proactively identify production database issues.
- Monitor and coordinate increases in capacity based on trend analysis and new project requirements.
- Resolve complex database health and performance problems.
- Interact with database/software systems engineering, applications development and support teams.
- Maintain and exercise a set of recovery procedures to restore databases.
- Define and implement recommendations for complex issues in database management systems.
- Develop yourself and others in a highly collaborative environment.
- Participate in weekend migration and change activities on a rotational basis.
- Participate in on-call rotation to support critical production databases.
Requirements
- Bachelor's Degree in computer science or related discipline.
- 6+ years of work experience managing Oracle databases.
- Worked on Oracle Database Enterprise Edition 11.2, 12.1, 12.2 and 19c.
- Worked with Oracle Cloud Control (OCC).
- Deep understanding of AWR and ASH reports.
- Scripting in shell, python or perl.
- Transparent Data Encryption (TDE).
- Database Vault for stricter access control.
- Strong knowledge of IT security, mainly in the DBA area.
Nice-to-haves
- Certifications: Oracle Database 19c/12c Administrator Certified Associate (OCA) or (OCP).
- Oracle GoldenGate for data replication.
- Oracle DataGuard for Disaster Recovery (DR).
- Recovery manager (RMAN) for database backup/restore.
- Knowledge of CI/CD tools: Jenkins, Ansible, Nexus repository.
- Experience with distributed systems with high availability requirements.
Benefits
- Medical, dental, vision and life insurance with no premium costs for employees and their families.
- Retirement plan plus matching 401k.
- Competitive base salary and bonus opportunity contingent on personal and company performance.
