Job Description :
Oracle Database Administrator in NEW YORK..

Requirements and skills

  • 6+ years of experience in Oracle Database
  • Extensive experience with Data Warehouse
  • Extensive experience with Oracle RAC
  • Extensive expertise in installing, administering and managing Oracle databases, both on prem and cloud.
  • Extensive expertise in database performance tuning
  • Strong understanding of database monitoring, especially with OEM and SQL monitoring tools.
  • Strong Experience with Shell and SQL scripting.
  • Experience with Microsoft SQL Server.
  • Experience administering SQL Server on Windows Platform or Oracle Real Application Cluster on Linux Platform
  • Ability to quickly diagnose problem areas and come up with solutions and/or workarounds
  • Strong time management skills with willingness and ability to handle multiple projects/initiatives at the same time
  • Self-motivated with strong team, interpersonal and communication skills
  • Experience with full Software Development Life Cycle (SDLC)

Desired Skills

  • Experience with Oracle Automated Data Warehouse and Oracle Exadata Service
  • Experience with OCI
  • Experience with Oracle Cloud applications
  • Experience with Azure DevOps
  • Experience with EBS
  • Experience with Oracle Business Intelligence,
  • Experience with PeopleSoft

Responsibilities

  • Implementation of cloud OBIA/OAC on cloud Exadata Service. This will be a replacement of on-premise OBIA / Oracle 12c database.
  • Implementation of Oracle HCM Cloud to replace on-prem Peoplesoft HRMS.
  • 3 Migration of on-premise SQL Server Employee Data Warehouse and reporting system to Oracle Autonomous Data Warehouse (ADW) and Oracle Analytics Cloud (OAC).
  • The DBA will create, configure, and administer databases to support implementation of OBIA/ODI/OAC cloud platform.
  • DBA will perform configuration and support of database and will assist in database design with Systems Implementer & Solutions Architect. This database will replace an on prem Oracle 12c database.
  • The DBA will create, configure, and administer databases to support the implementation of ADW for HCM analytics platform (ODI/OAC) and will advise on tools and technologies for data integration.
  • DBA will perform configuration and support of database and will assist in database design with Systems Implementer & Solutions Architect. This db will replace current Employee Data Warehouse SQL server data and will store 35+ years of employee history.
  • Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.
  • Perform database administration functions such as database installation, configuration, upgrades, patching, capacity planning, backup, restore, disaster recovery, SQL code review, performance analysis, query tuning.
  • Document Runbook for database support specific to the BI, HCM, and OAC applications
  • Document and test Disaster Recovery procedures
  • Help investigate, identify and document existing integrations and active users to current Employee Data Warehouse
  • Help with migration of historic information from On-prem SQL Server databases to Oracle's Autonomous Cloud (ADW).
  • Work closely with other DBAs, Infrastructure team, application development team, business analysts and IT vendors to ensure high availability and proper functioning of databases
  • Advise on and adhere to best practices related to monitoring, security, and performance tuning (Operating System, SQL Server, Disk Utilization, TSQL queries
  • Perform knowledge transfer to other team members.
  • Assist development and reporting groups in optimizing SQL statements in applications, batch jobs, and reports
  • Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations
             

Similar Jobs you may be interested in ..