Vacancy expired!
This is C2H on IntelliSavvy W2 or a direct fulltime with our client, please do not apply if you are looking for C2C or only contract opportunity. ROLES & RESPONSIBILITIES: Provide Oracle Database Admin services to production, in-house testing, proof of concept. Install, configure and maintain Oracle Enterprise Manager 12c/13c Cloud control Installation, DB Planning, Database Design and Development using ORACLE database versions 12c/11g Setup database high availability by installing / upgrading Oracle Clusterware 11g/12c. Plan, document and execution of Disaster Recovery procedures. Setup Backup methods for High availability of database and minimal Downtime and complete recovery of data Clone / Refresh non-production databases from production. Setup automation to refresh data between PROD and UAT Configure and maintain Active Dataguard Lead the DBA team to support on 24x7 basis Identify and resolve performance issues in RAC, Non-RAC databases. Analyze AWR, trace files to resolve performance issues. Index maintenance by creating, re-building them. Detecting Row Chaining and resolving using segment space advisor. Evaluating Performance of SQL statements and PL/SQL modules by EXPLAIN PLAN, SQL TRACE, TKPROF OS utility, SQL PLUS AUTOTRACE. Applying CPU / PSU / interim patches Partition management like splitting, adding, moving, converting non-partitioned tables to partitioned tables, setup automate jobs to archive data from LIVE to ARCHIVE Migration of databases from on-premise to cloud platform SQL, PL/SQL scripting to creating Database Triggers, Stored Procedures, Stored Functions, packages Create and maintain Unix shell scripts for day-to-day activities Setting of scheduled jobs in the database, on the server and in Oracle Enterprise Manger Install, upgrade and support Oracle APEX Install and configure Weblogic Server, BI Publisher cluster Support Mid-tier tools like Oracle HTTP Server, Oracle WebCache, Weblogic and BI Publisher Handle Data Center migration by migrating / moving the databases, applications. Setup cloud infrastructure like EC2 Servers, S3 buckets, Oracle RDS databases for applications Design, develop and implement database, ETL related modules to setup data warehouse. Setup and maintain Database Migration Service on cloud platform like Amazon Web Services Handle heterogenous database migration involving databases like Oracle, SQL Server, Postgres etc. Work with vendors like Oracle, Rackspace, Amazon on getting resolutions to the day-to-day issues Provide support to developers in code migration and releases. Train and guidance for Junior Database Administrators and Database Administrators REQUIRED KNOWLEDGE/SKILLS/ABILITIES: Knowledge of database implementation in cloud and interfacing with applications in cloud. Experience and knowledge in migrating code, database changes, data and menus through the various stages of the development life cycle. Sound knowledge of both database and program code performance tuning. A good knowledge of the operating system(s). A good knowledge of physical database design. A good knowledge of Oracle backup and recovery scenarios. Skills involving all Oracle tools and processes. QUALIFICATIONS: Bachelor's degree in Computer Science or Computer Information Systems, preferred. Oracle certification, preferred.
- ID: #43351230
-
State: Texas
Dallas / fort worth
75201
Dallas / fort worth
USA
- City: Dallas / fort worth
- Salary:
USD
TBD
TBD
- Job type: Contract
- Showed: 2022-06-20
- Deadline: 2022-08-18
- Category: Et cetera