Job Title : Database Engineer
Job Location : NYC, NY (Remote Position)
Duration : 12 Months Contract Job Description :
Position Duties :
- Install, configure, customize, create, implement, and support Oracle databases in Non-RAC and RAC environments, and software and related tools / products for the database systems
- Implement Grid Infrastructure release 19c on an OS Unix / Linux platform support databases
- Implement Oracle Automatic Storage Management (ASM) cluster Filesystem and maintain it; Add new disks to an ASM disk group
- Patching grid infrastructure and Oracle RDBMS
- Set up Oracle database security environment
- Carry out DB Performance Tuning and RMAN backups
- Working with Oracle, implement best-of-class solutions
- Utilize Linux Administration skills as needed; develop UNIX shell scripts; Automation using ansible; work with the Database team and teams of Unix engineers and administrators to design, build, upgrade, and support the necessary Oracle infrastructure to meet the needs
- Work hands-on on more extensive projects such as migration, implementing new features, architectures, and validation
- Configure Golden gate replication; both integrated and microservices-based configuration
- Configure Oracle RAC and ASM technologies on Redhat Linux
- Configure Oracle Data Guard with Active and Standby database modes
- Assist developers and end users in implementing best practices and addressing performance issues in implementation
- Ensure all databases are backed up and meet the business’s Recovery Point Objectives (RPO) and Recovery Time Objectives (RTO)
- Lead team efforts in adopting modernized architecture such as hybrid cloud and database ready for hybrid cloud
- Perform RCA; manage different database encryption technologies; and implement DR by design and validate
- Perform special projects and initiatives as assigned
- Experience with the latest Oracle versions and their features, including Multi-tenant Architecture, Oracle Partitioning, Real Application Testing (RAT), and Oracle Database Vault
Mandatory Skills / Experience :
- Minimum 12 years of hands-on experience in database engineering
- Ability to work independently
- Experience implementing / managing Oracle Databases in an RAC environment with at least two years of production support
- Experience Implementing Grid Infrastructure release 19 or higher on a Redhat Linux environment
- Experience implementing ASM cluster Filesystem with knowledge of how to maintain it for successful operational delivery
- Knowledge of Best Practices for adding a new disk to an ASM disk group
- Experience patching grid infrastructure software
- Familiarity with Oracle database resource manager
- Familiar with Ansible / automation / scripting
- Familiarity with huge pages on Linux
- Experience supporting a high-availability production database
- Experience in configuring / supporting Oracle Active Data Guard required
- Experience in database architecture and design, Oracle Advanced Security Option, and Golden Gate for Oracle Replication
- Knowledge of working on cloud environments, preferably AWS & AZURE
- Participate in application / DB outage incidents during troubleshooting and provide solutions and RCA
Desirable Skills / Experience :
- Experience with Oracle Advanced Security Option is highly desirable
30+ days ago