Job Description

Database Administrator
Job Number: 21-16104
 
Want to be part of the Energy Industry? Eclaro is looking for a Database Administrator for our client in New York, NY.
 
Eclaro's client operates one of the world's largest energy delivery systems, constantly at the forefront of innovations in developing technology. If you’re up to the challenge, then take a chance at this rewarding opportunity!
 
Position Overview:
  • DBA will work on the following projects:
    • 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.
    • Migration of on-premise SQL Server Employee Data Warehouse and reporting system to Oracle Autonomous Data Warehouse (ADW) and Oracle Analytics Cloud (OAC).


Responsibilities:
  • 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 onprem 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.
  • This DB will replace current Employee Data Warehouse SQL server data and will store employee history.
  • Perform configuration and support of database and will assist in database design with Systems Implementer & Solutions Architect.
  • 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

Required Qualifications:
  • 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)


Experience:
  • The following would be considered as a valuable asset:
    • 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
 
If hired, you will enjoy the following Eclaro Benefits:
  • 401k Retirement Savings Plan administered by Merrill Lynch
  • Commuter Check Pretax Commuter Benefits
  • Eligibility to purchase Medical, Dental & Vision Insurance through Eclaro
 
If interested, you may contact: 
Al Roper    
Al.Roper@eclaro.com   
646-695-2953
Al Roper | LinkedIn
 

Equal Opportunity Employer: Eclaro values diversity and does not discriminate based on Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.

Application Instructions

Please click on the link below to apply for this position. A new window will open and direct you to apply at our corporate careers page. We look forward to hearing from you!

Apply Online