Oracle DBA

Job Description

• DBA II - Coordinate changes to computer databases, test and implement the database applying knowledge of database management systems.
• May plan, coordinate, and implement security measures to safeguard computer databases.

Specified Duties:

Server Platform: - hardware; system and utility software Oracle/Apex:

• This position will configure and maintain Oracle database instances on Unix or Oracle servers, including disk space allocation, security, synchronization of multiple database instances, performance monitoring, and performance tuning. This position will be responsible for performing database backups and data recovery, configuring database user accounts, and will manage Unix files involved with database exports and imports.
• This position will perform database modeling, development and testing with desktop computers. Incumbent will produce routine documents that detail server status reports (percentage of uptime), maintenance downtime announcements and reports describing activities of the past week. These reports, and others, will be generated using e-mail, word processing, and or spreadsheets on office automation software (Microsoft Office).
• Information: data capture, processing and delivery; application software, web services, architecture, project management:
• This position will determine and document requirements for processing and storing business data in client's information systems. The position will use automated tools to model databases and generate program code, integrate software products with the database system, and test and document application software using the database. This position will correct errors in data values and assist users with the use and interpretation of stored data. Position will work with application development team to review project requests describing database user needs in an effort to estimate the time and costs required to accomplish project goals.

Server Platform: Hardware; system and utility software SQL/ASP:

• This position will configure and maintain Structured Query Language (SQL) database instances on Windows servers, including disk space allocation, security, synchronization of multiple database instances, performance monitoring, and performance tuning. This position will be responsible for performing database backups and data recovery, configuring database user accounts, and will manage SQL files involved with database exports and imports.
• This position will produce routine documents that detail server status reports (percentage of uptime), maintenance downtime announcements and reports describing activities of the past week. These reports, and others, will be generated using e-mail, word processing, and or spreadsheets on office automation software (Microsoft Office).

Performance Tuning:

• This position will assist developers in the development and performance tuning of database objects, scripts, and other performance related areas

Skills Required:

• Designing/Analyzing
• Coding
• Testing
• Debugging database programs or system software
• Performance analysis.

Knowledge and ability to utilize the current version of the following products:

• Oracle Server environment (Windows)
• Oracle Application Server installation, maintenance, tuning, with cross-database integration
• Oracle Data Base administration from 10g through current Oracle data base release configuration
• SQL Server DBMS experience
• Extensive knowledge of SQL, SOA services, Java, JavaScript, XML, and HTML.

Experience Required:

• 3 or more years experience designing/analyzing, coding, testing, debugging database programs or system software programming and analysis.

Education Required:

• Successful completion of AA degree in computer science or certification. Education may be substituted for experience as determined relevant by the agency.