Database Engineer

Title: Database Engineer

Duration: 12 Months

Client: Department of Information Technology and Telecommunication New York City

Location: New York NY

Note: This position is a remote position.

"The applicant is the center of our universe."

Job Description:

• Install configure customize create implement and support Oracle databases in NonRAC and RAC environments and software and related tools/products for the database systems atOTI.
  
• Implement Grid Infrastructure release 19c on a OS Unix/Linux platform support databases;
  
• Implement Oracle Automatic Storage Management (ASM) cluster File system 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 sensible; 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 OTI and OTI hosted supported agencies.
  
• Work hands on more extensive projects such as migration implementing of new features architecture and validation and assisting OTI.
  
• 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 OTI.
  
• Experience with the latest Oracle versions and their features but not limited to Multitenant Architecture Oracle Partitioning Real Application Testing (RAT) Oracle Database Vault.
  

Required Skills:

• Minimum 12 years of hands o n 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 File system 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 highavailability 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 preferable AWS & AZURE. Participate in application/DB outage incidents during trouble shooting and provides solution and RCA.
  

DESIRABLE SKILLS/EXPERIENCE

• Experience with Oracle Advanced Security Option is highly desirable
  

"If you are: bright motivated skilled a differencemaker able to get things done work with minimum direction enthusiastic a thinker able to juggle and multitask communicate effectively and lead then we would like to hear from you. We need exceptionally capable people for this role for our client so get back to us and tell us why you think you are a fit."

About Us:

TriForce is one of the fastest growing companies in Philadelphia region by receiving the award 5 times and 3 times(Ranked #) on Inc. 5000 fastest growing companies in the USA. TriForce Consulting Services Inc. is an established consulting services firm offering innovative solutions to Government and Commercial sectors. We specialize in building customized software applications solutions such as knowledge management systems business intelligence data analysis database support and maintenance data warehouse implementation and support systems architecture and systems integration for our clients. Our technical competencies are in Java .NET SharePoint PHP Business Intelligence (Cognos Data Warehouse) mobile applications platforms (iPhone iPad Android Blackberry) and various other technologies. We also specialize in providing resources to manage infrastructure projects. TriForce is one of the fastest growing companies in Philadelphia region by receiving the award 5 times and 2 times on Inc. 5000 fastest growing companies in the USA.

Minimum 12 years of hands- o n 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. 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 preferable AWS & AZURE. Participate in application/DB outage incidents during trouble shooting and provides solution and RCA. DESIRABLE SKILLS/EXPERIENCE Experience with Oracle Advanced Security Option is highly desirable