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 engineeringAbility to work independentlyExperience implementing / managing Oracle Databases in an RAC environment with at least two years of production supportExperience Implementing Grid Infrastructure release 19 or higher on a Redhat Linux environmentExperience implementing ASM cluster Filesystem with knowledge of how to maintain it for successful operational deliveryKnowledge of Best Practices for adding a new disk to an ASM disk groupExperience patching grid infrastructure softwareFamiliarity with Oracle database resource managerFamiliar with Ansible / automation / scriptingFamiliarity with huge pages on LinuxExperience supporting a high-availability production databaseExperience in configuring / supporting Oracle Active Data Guard requiredExperience in database architecture and design, Oracle Advanced Security Option, and Golden Gate for Oracle ReplicationKnowledge of working on cloud environments, preferably AWS & AZUREParticipate in application / DB outage incidents during troubleshooting and provide solutions and RCADesirable Skills / Experience :
Experience with Oracle Advanced Security Option is highly desirable