FIM Database Engineer -FIMDE24-06523

Position: FIM Database Engineer
Location: Brooklyn, NY
Duration: 1 Year
Type: Remote

Job Description:

A successful candidate will serve as a Database Engineer reporting to the Infrastructure Management division. This position is integral to the delivery and oversight of the Agency's multi-tenant databases and service offerings as part of the Foundational Infrastructure Modernization Project. The Database Engineer will lead projects and initiatives, making significant contributions to the technical design and implementation of the Agency's database platforms under client direction. This role offers the opportunity to collaborate across teams, contribute to database services, and spearhead database solutions across service delivery. It requires critical thinking, problem-solving skills, and adherence to industry-standard best practices.

Tasks:

• Install, configure, customize, create, implement, and support Oracle databases in Non-RAC and RAC environments, including software and related tools/products.
• Implement Grid Infrastructure release 19c on OS Unix/Linux platforms to support databases.
• Implement Oracle Automatic Storage Management (ASM) cluster Filesystem and maintain it; Add new disks to an ASM disk group.
• Perform patching of grid infrastructure and Oracle rdbms.
• Setup Oracle database security environment.
• Conduct DB Performance Tuning and RMAN backups.
• Utilize Linux Administration skills; develop UNIX shell scripts; Automation using Ansible.
• 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.
• 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 readiness for hybrid cloud.
• Perform Root Cause Analysis (RCA), manage different database encryption technologies, and implement Disaster Recovery (DR) by design and validate.
• Perform special projects and initiatives as assigned by OTI.
• Experience with the latest Oracle versions and their features, including but not limited to Multi-tenant Architecture, Oracle Partitioning, Real Application Testing (RAT), Oracle Database Vault.

Mandatory Skills/Experience: (Note: Candidates without these mandatory skills will not be considered)

• Minimum 12 years of hands-on experience in database engineering.
• Ability to work independently.
• Experience in implementing/managing Oracle Databases in a RAC environment with at least 2 years of production support.
• Experience in 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.
• Familiarity 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.
• 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.