| Oracle DBA position in New York Metro Area at York, New York, USA |
| Email: [email protected] |
| From: Mani, THEMESOFT [email protected] Reply to: [email protected] Hi, Good Day!!! Im Mani with Theme Soft. I came across your profile wanted to reach out to discuss this exciting opportunity I have with my client for Oracle DBA role. Your profile looks to be a great match for the requirement and would appreciate your thoughts once review the below requirement. Job Title: Oracle DBA Client: Mindtree Location: New York Metro Area Duration: Contract Job Description: Required Skills/Experience (Skills that the successful candidate(s) must have) Enter the skills that the successful candidate(s) is/are required to have: o6+ years of experience in Oracle Database oExtensive experience with Oracle Autonomous Data Warehouse (ADW) and Oracle Analytics Cloud (OAC) oExperience with supporting an Oracle Data Integrator (ODI) cloud platform. oExtensive experience with Oracle RAC and Oracle Exadata Service oExtensive expertise in installing, administering, and managing Oracle databases, both on-premises and cloud. oExtensive expertise in database performance tuning oStrong understanding of database monitoring, especially with OEM and SQL monitoring tools. oStrong Experience with Shell and SQL scripting. oExperience with Microsoft SQL Server. oExperience administering SQL Server on Windows Platform or Oracle Real Application Cluster on Linux Platform oAbility to quickly diagnose problem areas and come up with solutions and/or workarounds. oStrong time management skills with willingness and ability to handle multiple projects/initiatives at the same time oSelf-motivated with strong team, interpersonal and communication skills oExperience with full Software Development Life Cycle (SDLC) Additional Skills (Skills that are a plus, but not required) Enter additional skills that are not required but would be helpful if the successful candidate(s) possess: oExperience with OCI oExperience with Oracle Cloud applications oExperience with Azure DevOps oExperience with EBS oExperience with Oracle Business Intelligence oExperience with PeopleSoft Assignment Prefer local candidate to NYC with ability to be onsite as-needed (pre-scheduled), but open to remote resource with expectation to join meetings on camera and work EST daytime hours. oDBA will work on the following 3 projects: 1. Implementation of Oracle HCM Cloud to replace on-prem Peoplesoft HRMS. 2. Migration of on-premises SQL Server Employee Data Warehouse and reporting system to Oracle Autonomous Data Warehouse (ADW) and Oracle Analytics Cloud (OAC). 3. Implementation of cloud OBIA/OAC on cloud Exadata Service. This will be a replacement of on-premises OBIA / Oracle 12c database. oThe DBA will create, configure, and administer databases to support implementation of OBIA/ODI/OAC cloud platform. oDBA will perform configuration and support of database and will assist in database design with Systems Implementer & Solutions Architect. This database will replace an on-premises Oracle 12c database. oThe 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. oConfigure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security. oPerform database administration functions such as database installation, configuration, upgrades, patching, capacity planning, backup, restore, disaster recovery, SQL code review, performance analysis, query tuning. oDocument Runbook for database support specific to the BI, HCM, and OAC applications oDocument and test Disaster Recovery procedures oHelp investigate, identify, and document existing integrations and active users to current Employee Datawarehouse oHelp with migration of historic information from On-prem SQL Server databases to Oracle's Autonomous Cloud (ADW). oWork closely with other DBAs, Infrastructure team, application development team, business analysts and IT vendors to ensure high availability and proper functioning of databases. oAdvise on and adhere to best practices related to monitoring, security, and performance tuning (Operating System, SQL Server, Disk Utilization, TSQL queries oPerform knowledge transfer to other team members. oAssist development and reporting groups in optimizing SQL statements in applications, batch jobs, and reports. oApply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations. Thanks & Regards Mani _______________________ Email: [email protected] || www.themesoft.com Keywords: business intelligence database information technology |
| [email protected] View all |
| Wed Feb 07 02:12:00 UTC 2024 |