|Department||Office of Management and Enterprise Services|
|Date Opened||7/30/2014 8:00:00 AM|
|Filing Deadline||7/7/2015 11:59:00 PM|
|Salary||Up to $68,200/year|
|Full or Part Time||
A resume and cover letter must be submitted along with your application.
The Office of Management and Enterprise Services (OMES) is a government agency providing services to other Oklahoma government agencies. We work toward the goals of capitalizing on available resources, continuing to seek cost saving opportunities and elevating our level of service. Our mission is to be a “FAST” agency: Flatter, Agile, Streamlined, and Technology-enabled.
The Information Services Division (ISD) is seeking a full-time Data Base Administrator for our Oklahoma City location. This is an unclassified position within Oklahoma state government. Click here to view our comprehensive Benefits Packet.
The primary purpose of this position is to monitor and maintain on-line data bases related to the storage, maintenance and recovery of data in a computer data base system. This includes designing, implementing and maintaining on-line data bases, security access systems, data sets and jobs, defining file or space utilization parameters, supporting data dictionary activities, installing vendor software products, and similar activities. Individual will complete projects following established standards while maintaining a high level of user trust, satisfaction and confidence. Also, proven experience working with different operating systems and data base environments including AIX, UNIX, Windows, Oracle. A general understanding of technical principles, theories, concepts and technologies is required.
•Design and assist with the implementation of on-line data bases, security access systems, data sets and jobs; recommend specifications for file or space utilization; establish direct access files or other file configurations as required; monitor space utilization and recommend modifications as needed.
•Provide applications development and other division personnel with data base and security information required to support application design and development; support repository/data base dictionary requirements and activities. Includes identifying SQL tuning and indexing to improve performance.
•Assist with the installation, configuration and upgrade of vendor database software products; conduct appropriate tests to insure compatibility of new or modified programs with operating system, data security, and performance requirements.
•Confer with computer operations, technical support, user and vendor representatives concerning data base requirements, system performance, software maintenance, and capacity planning and data security requirements. Maintain database systems at 99% uptime and reliability.
•Review systems specifications for compliance with departmental, division and data base administration standards.
•Respond to data base operational emergencies as required including data base recoveries involving the use of data base log files which provide for the recovery of data bases with no loss of data and which do not require the users to reenter data into the data base.
•Manage processes archiving older data in operational databases to archive databases.
•Perform ongoing review of applications systems and programs; identify problems ad develop appropriate solutions.
•Research and stay current on the latest database concepts and technologies.
•Prepare status reports as defined by management.
•Other assigned duties.
This position will not have direct supervisory responsibilities.
This position may require some in-state and out-of-state travel on an as needed basis
Ability to read, analyze, and interpret general business periodicals, professional journals, technical procedures, and governmental regulations. Ability to write reports, business correspondence, and procedure manuals. Ability to effectively present information and respond to questions from managers and customers.
Ability to work effectively with customers, agency staff and other state agency staffs. Must be able to demonstrate a high degree of interpersonal skills in both verbal and written communications.
Ability to define problems, collect data, establish facts, and draw valid conclusions.
Ability to work with mathematical concepts and perform basic mathematic calculations.
Proficiency in desk top applications and specialized analytical, monitoring, data base and operating system software.
The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
While performing the duties of this job, the employee is regularly required to use hands to finger, handle or feel. The employee frequently is required to stand, walk, sit, and reach with hands and arms. The employee is occasionally required to climb or balance. The employee must be capable of lifting and/or moving up to 25 pounds. Specific vision abilities required by this job include close vision, distance vision, color vision, peripheral vision, depth perception and ability to adjust focus.
Bachelor’s Degree (B.A.) in Computer Sciences, Business, Engineering or related discipline (with an information technology focus is preferred); and at least two years professional-level experience in implementation, operation and maintenance of large-scale relational databases, preferably across multiple hardware and software platforms. Experience and knowledge in new computing architectures and implementation of complex database structures. An equivalent combination of education and experience substituting one year of experience in Computer Science, Information Technology, Database implementation, Disaster Recovery and Continuity Planning or closely related field for each required year of education.
•At least four years professional-level database administration experience, preferably across multiple database and systems software platforms including AIX, UNIX, Windows, Oracle, SQL.
•Experience and knowledge in new application architectures including ERP systems.
OMES is an Equal Opportunity Employer. Reasonable accommodation to individuals with disabilities may be provided upon request.