Rate:$55/Hour
The Secretary of State is an agency that oversees two major functions. The
Secretary serves as Chief Election Officer for Texas, assisting county
election officials and ensuring the uniform application and interpretation
of election laws throughout Texas. Additionally, the Office of the Secretary
of State also provides a repository for official business and commercial
records required to be filed with the Office. We will be adding data bases
to support new production and existing back-up/dev environments.
SOS is looking to hire an Oracle DBA to join the SOS team. The worker will
work with the existing SOS team to maintain and support the application and
systems. This is a small environment so employees are asked to wear
multiple hats and work as a team on the operations side. They will be
troubleshooting and maintaining databases. There are 35 plus databases in
the environments, primarily Oracle 9i and 10g (one in development is 11).
The candidate will primarily be dealing with one large database (1.4
terabytes, 240 tables, OLTP and back-up OLTP, data warehouse).
WORKER SKILLS AND QUALIFICATIONS (Required)
-Database Administration (Oracle required and MS SQL preferred) -Performs
data modeling and prototyping, and implements efficiency improvements
-Responsible for ensuring availability and performance of the databases that
support the system -Work with the team to ensure that the associated
hardware resources allocated to the databases and to ensure high
availability and optimum performance -To proactively monitor the database
systems to ensure secure services with minimum downtime -Responsible for
providing trend analysis to the service management team to enable them to
make informed decisions regarding resource management -Responsible for
problem escalation to Oracle Development team and third parties as
appropriate -Responsible for improvement and maintenance of the databases to
include rollout and upgrades -Responsible for implementation and release of
database changes as submitted by the development team -Loads databases,
reorganizes as necessary, and assists in monitoring database performance
-Executes the procedures necessary to save, retrieve, and recover databases
from hardware and software failures -Maintains data standards; prepares and
develops database documentation, procedures, and definitions for data
dictionaries -Creates test database environment for applications section,
including the creation of necessary libraries and procedures -Installation
of database software and with analyzing, designing, and implementing
databases -Designing and maintaining database structures -Establishing and
implementing necessary database security controls.
-Other duties as assigned.
WORKER SKILLS AND QUALIFICATIONS
Minimum Requirements:
Years Skills/Experience
4 Oracle 9i/10g database administration
4 Experience with Stored Procedures
4 Experience monitoring and maintaining databases
4 Installation of database software and with analyzing,
designing, and implementing databases
4 Designing and maintaining database structures
4 Establishing and implementing necessary database security
controls
4 Knowledge of the principles, practices, and techniques of
computer programming and systems design of computer operations, systems, and
procedures; of computer programming languages; of data
processing flowcharting techniques; of database structures and theories; of
current
database technologies; and of data analysis techniques.
Preferences:
Years Skills/Experience
2 Experience with Shareplex, BI Publisher and Oracle optimizer
is preferred
2 Experience of managing multiple RDBMS on large systems,
working in a team that delivers a high availability service and practical
experience in
monitoring and tuning a database to provide a high
availability service is preferred
2 Experience of other database systems, preferably SQL Server,
practical experience in managing the internal and external MS SQL database
security is preferred
--
Thanks & Regards
Kevin
Maripax Solutions | [email protected]
www.Maripax.com
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"OracleAppsDba" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/oracleappsdba?hl=en
-~----------~----~----~----~------~----~------~--~---
