What are the responsibilities and job description for the Database Engineer - Foundational Infrastructure Modernization position at Current Openings?
A NYC agency is looking for a Database Engineer for a 12 month contract. This role will be 100% remote based in NYC.
Pay Rate Range : $70.00 - $98.00
Job Description :
Serve as a Database Engineer reporting to the Infrastructure Management division. This position is responsible for delivering and overseeing the Agency's multi-tenant databases and service offering as part of Foundational Infrastructure Modernization Project. The Database Engineer will be responsible for leading projects and initiatives and making significant contribution to the technical design and implementation of the Agency's database platforms. This role offers the opportunity to work across teams and contribute to the database services while leading the charge for database solution across service delivery; and involves critical thinking and problem solving in concert with the utilization of industry standard best practices.
RESPONSIBILITIES :
- 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 at OTI.
- Implement Grid Infrastructure release 19c on a 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.
- Setup 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 of the office and office hosted supported agencies.
- Work hands on more extensive projects such as migration, implementing of new features, architectures and validation and assisting the office.
- 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 meets the business's Recovery Point Objectives (RPO) and Recovery Time Objectives (RTO)
- Lead team efforts in adopting in 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 by the agency.
- Experience with latest Oracle versions and their features but not limited to Multi-tenant Architecture, Oracle Partitioning, Real Application Testing (RAT), Oracle Database Vault.
MANDATORY SKILLS / EXPERIENCE
Note : Candidates who do not have the mandatory skills will not be considered
Salary : $70 - $98
