Position Title: Senior DBA

Position Id: #428

Agency: State of Michigan- Department of State

Duration: 12 Months

Work Location: 425 W. Ottawa Ave, Lansing. MI



Please fill the skill matrix:




Requirement

Description

Min Requirement/Field of Study

Candidate Experience

Last Used


Skills

Oracle PL/SQL

3 Years



Years


Skills

0racle SQL

3 Years



Years


Skills

Oracle Spatial Programming

4 Years



Years


Skills

Oracle spatial models and algorithms

4 Years



Years


Skills

Oracle 11g, 12 c

2 Years



Years


Skills

Oracle on Solaris exp

3 Years



Years


Skills

Oracle performance tuning, DB backup & recovery

3 Years



Years


Skills

Installation and configuration

5 Years



Years




Position Description SOM DTMB supporting MDOT, is recruiting a Senior Oracle DBA for its Enterprise Customer Service Department that will provide enterprise-wide technical expertise in ORACLE database administration to the database team, application development teams, data architects, and business data stewards. This position is to serve as an Oracle Database Administrator responsible for supporting Oracle database environments for the Department of Transportation. The person in this position will plan, coordinate and implement a full range of professional database administration tasks and duties: Database installation, patching and configuration: Database performance monitoring, tuning and troubleshooting; Database backup and recovery; and Data migrations and management.



Skills Required :

*Experience with Oracle Spatial

*Provide support for growing Oracle Spatial needs, including installation, tuning and troubleshooting

*Assist in the implementation of Oracle Statewide Standards

*Experience with Oracle 11g , 12c

*Working knowledge of DDL, DML, PL/SQL, stored procedures, triggers, views, constraints and cursors

*Proficiency with Oracle performance tuning

*Proficiency with database backup and recovery using Oracle RMAN…..

*Ability to analyze and design physical databases and their definitions

*Experience with disaster recovery planning and testing

*Experience with installation, configuration and upgrades of vendor-supplied software, including contacting vendor on enhancements and problems. *Strong problem solving and conceptual thinking abilities

*Excellent written/verbal communication and documentation skills

*Able to work independently and deliver high quality results when given a set of requirements

*Experience with Oracle on Solaris



Skills Preferred :

*Experience managing databases up to 10+ TB

*Knowledge of Shell Scripting

*Knowledge of EMC and NetApp SAN hardware

*Knowledge/Experience with database appliances

*data guard, compression, backup tools.



Experience Required

Bachelor’s Degree in Computer Information Systems, Computer Science or Computer Systems Engineering; or a Bachelor’s degree in a related field appropriate for the assignment plus five years of experience.

*1+ years’ experience with spatial models and algorithms

*2-4 years Oracle Spatial programming experience

*3-7 years Oracle SQL and PL/SQL programming experience



Experience Preferred 3 years of professional experience equivalent to an Information technology Infrastructure or Programmer/Analyst P11.



Education Required Possession of a bachelor's degree with 21 semester (32 term) credits in computer science, data processing, computer information, data communications, networking, systems analysis, computer programming, or mathematics.



Thanks & Regards