Information Technology

Employment TYPE

Contract

LOCATION

Blythewood, South Carolina

DATE POSTED

June 3, 2020

INDUSTRY

Information Technology

POSITION(S)

1

SALARY

Negotiable

Job# J677

CL - Database Administrator - Project Lead

About The Opportunity

    SCOPE OF THE PROJECT:
  • SCDMV SUPPORTS IN THE NEIGHBORHOOD OF 250 PLUS ORACLE DATABASES. SENIOR ORACLE DATABASE POSITION WILL BE RESPONSIBLE FOR PRODUCTION DATABASE ENVIRONMENTS RELATED TO SCDMV PHOENIX APPLICATION. THIS POSITION WILL SUPPLEMENT OUR CURRENT SQL DBA FORCE WITH PRODUCTION SUPPORT ACTIVITIES SUCH AS OS UPDATES, SECURITY UPDATES, ETC. AND WILL REQUIRE BEYOND NORMAL HOURS ACTIVITIES.
  • THIS IS EXPECTED TO BE A LONG TERM, ONGOING ASSIGNMENT. ON-SITE PRESENCE IS REQUIRED THEREFORE REGIONAL CANDIDATES (SC, GA, NC) WILL BE GIVEN PREFERRED PRIORITY. CANDIDATE WILL BE WORKING IN A TEAM ENVIRONMENT CONSISTING OF 5 DATABASE ENGINEERS AND ADMINISTRATORS AND WORKING DIRECTLY WITH APPLICATION DEVELOPERS, BUSINEE ANALYSTS, AND SERVER SUPPORT TEAM.

Job Description

    DAILY DUTIES / RESPONSIBILITIES:
  • Install and configure Oracle Database 11g and 12.2 on Windows and Oracle Red Hat Enterprise Linux
  • Install and configure Oracle ASM (Automatic Storage Management) 11g and 12.2 on Windows and Oracle Red Hat Enterprise Linux
  • Install and configure Oracle Grid Infrastructure 11g and 12.2 on Windows platform.
  • Install and configure Oracle Gateway for SQL-Server 11g and 12.2
  • Install and configure Oracle Grid Control version 12c and 13c on Windows and Oracle Red Hat Enterprise Linux
  • Configure HAS (High Availability Services) 11g and 12.2 on Windows platform
  • Configure and maintain Oracle Active Data Guard for Standby databases
  • Configure multiple Oracle listeners for TCPIP filtering, for Oracle Gateway and for security purposes
  • Configure and perform Oracle backups using RMAN and DDBoost
  • Configure and maintain Data Domain servers
  • Schedule and perform Oracle database software upgrades, both in-place and out-of-place
  • Schedule and perform Windows server upgrades
  • Apply Oracle critical patches in a timely fashion via OPatch
  • Work in conjunction with Oracle support to find solutions to Oracle software problems
  • Work with the server team to assign LUN\'s to the server, partition them, and add them to ASM as necessary
  • Plan storage requirements for future database storage needs based on growth analysis
  • Perform backups of Oracle Standby databases
  • Restore databases across versions of Oracle from Production AND Standby databases - from version 11g to 12.2
  • Create and modify shell scripts
  • Create user accounts for Windows Domain based users
  • Manage multiple Oracle Homes for different Oracle products and different Oracle versions
  • Performance tuning of SQL on a live database using ASH, AWR reports and Grid Control
  • Develop SQL scripts and PL/SQL applications to supervise the database performance
  • Develop SQL scripts and PL/SQL applications to supervise the database storage usage
  • Actively monitor and tune Oracle database statistics to ensure maximum performance
  • Proactively monitor the database\'s health and take preventive or corrective action as required
  • Design and update the database data model using Toad Data Modeler
  • Develop table and index partition methods for large tables
  • Control migration of programs, database changes, reference data changes through the development life cycle using Version Manager/PVCS or TFS
  • Implement and enforce security for the Oracle Databases
  • Perform datapump exports and imports as required
  • Create and schedule SQL-Loader scripts for nightly imports
  • Use Grid control to create and submit jobs in the scheduler
  • Write ad-hoc reports as requested by developers/business analysts
  • Provide standards to ensure that all application design and code is produced with proper integrity, security and performance
  • Provide technical support to application development teams
  • Perform the impact analysis of any changes made to the database objects
  • Provide SQL guidance to business analysts and developers to ensure integrity and performance

Required Skills

    REQUIRED SKILLS (RANK IN ORDER OF IMPORTANCE):
  • ORACLE 11G, 12C
  • 10 YEARS SENIOR ORACLE DBA EXPERIENCE
  • ORACLE RED HAT ENTERPRISE LINUX
  • ORACLE ASM
  • ORACLE GRID CONTROL
  • SQL SERVER 2012 2014
  • SC DEPARTMENT OF MOTOR VEHICLE DATA BASE MANAGEMENT EXPERIENCE
  • PREFERRED SKILLS (RANK IN ORDER OF IMPORTANCE):
  • DD BOOST TO SUPPORT BACKUP AND RESTORE OPERATIONS FOR ORACLE DATABASE
  • REQUIRED EDUCATION:
  • 10 YEARS OF EXPERIENCE
  • REQUIRED CERTIFICATIONS:
  • ORACLE CERTIFIED PROFESSIONAL 10G/11G/12CDD BOOST TO SUPPORT BACKUP AND RESTORE OPERATIONS FOR ORACLE DATABASEORACLE CERTIFIED PROFESSIONAL 10G/11G/12C is required

Duration

12 + Months

Please Contact me to discuss the hiring process!

Sushil Singh

Sr. Executive Recruiter
Contact: (310) 929-8421 Ext: 107
Email: sushil.singh@staffactory.com

Hi! My name is Sushil Singh. Helping consultants with getting their desired job is what makes me feel alive. I build a unique relationship with each of my consultants and work on their profile as per their needs. I believe that my consultants are my assets and this motivates me to serve them in an even better manner. Hence, I work towards the success of every consultant I work with.