Employment Opportunity

Job Description:

Oracle DBA

As the Database Analyst Senior, you will support Oracle databases to ensure data 
integrity, security, and stability.
This position is needed to maintain minimum staffing needs of the Oracle Database Services 
team.
The IOT Oracle team manages the data for the majority of the State’s agency applications.
DOR, DWD and DOT are just some of the agencies that have systems which are dependent upon 
this team for the maintenance of their back-end data.
Agency applications are dependent upon timely response to accurate and secure data.
Successful candidates will have extensive experience with the latest releases of Oracle 
RDBMS and be proficient with Oracle - both in Standalone and RAC clustered environments.
The candidate should be a self-starter, have excellent communication skills and work 
seamlessly in a team environment as well as independently.

As the Database Analyst Senior, you will support Oracle databases to ensure data 
integrity, security, and stability.
In this position, you will be responsible to provide adequate computer resources and up-
to-date software environment to our various customers.
This position will be responsible for monitoring and tuning database performance. It 
ensures that data is appropriately protected via database backup and related strategies.
The position loads, or assists in loading of, database software, upgrade and patching.
This position will assist with the evaluation and selection of infrastructure components 
and provide operational support for the database, ensuring data integrity, database 
availability, and performance.
The Senior Database Analyst is needed to provide the degree of support that our agency 
customers currently expect and to meet their future needs.
The essential elements of the job duties:
Develop and advise on standards, guidelines, policies, and procedures designed to ensure 
the integrity of the database environment.

Evaluate technology and products to determine the feasibility of adding to agency 
standards.
Develop work plans for assigned projects and manage the execution.
Design and implement logical and physical databases of a moderately to large complex 
nature.
Determine aggregation, partitioning and indexing strategies for physical data.
Monitor and tune database performance, including SQL scripts, hints, execution plans, and 
materialized views.
Administer end-user access and security at the database level.
Ensure that data is appropriately protected via database backup and related strategies.