Database Administrator I
Share
Job Location:
Monthly Salary:
Posted on:
Yesterday
Vacancies:
1 Vacancy
Job Summary
Summary Statement
This position is responsible for the management of theDivision-wide Forensic Laboratory Information Management System (FLIMS). Work includes installing configuring andupgrading database system software developing physical database designsdatabase performance and tuning security backup version control andintegrity of the database.
Essential Functions
Essential functions are fundamental core functions common to all positions in the class series and are not intended to be an exhaustive list of all job duties for any one position in the class. Since class specifications are descriptive and not restrictive incumbents can complete job duties of similar kind not specifically listed here.
- Monitors coordinates and manages the selection physical design development security operation processing performance and maintenance of relational and/or other database data storage and retrieval systems.
- Coordinates and ensures database management systems interface with other information technology for sharing of data. Meets with customers to determine database requirements.
- Develops database standards documentation security and authorization procedures.
- Develops physical database and data warehouse/data mart designs and ensures appropriate modifications to databases; establishes databases; creates primary database storage structures (tablespaces/files views and indices) based on estimated storage requirements. Modifies physical database objects/structures to reflect changes to the data model.
- Establishes backup and recovery or replication plans to minimize data loss and system downtime.
- Monitors and troubleshoots databases for potential or existing performance or security problems capacity requirements and makes modifications/adjustments to ensure availability of data.
- Installs monitors diagnoses and debugs the database system software. Plans for projected software requirements and increased computer capacity relating to database requirements. Prepares plans for feasibility of conversion to database management systems from existing file structures.
- Keeps current on new developments and techniques in data storage and database management. Identifies and evaluates the use of new and emerging tools methods and technologies to improve database management and data storage. Establishes and maintains contact with vendors and recommends database software and services.
- May plan assign review and evaluate the work of two or more merit and/or contractual staff involved in database implementation and management.
Job Requirements
Applicants must have education training and/or experience demonstrating competence in each of the following areas:
- Six months experience in designing maintaining analyzing and implementing database management systems which includes systems performance tuning maintaining backup/recovery systems using system tools to identify correct or refer system issues such as system space management and database integrity.
- Six months experience in applying database query languages such as using MS SQL Server Sybase DB2 Informix Oracle ADABAS PL/SQL and other Oracle Based Tools.
- Six months experience in database security which includes developing internal database security mechanisms and defining user requirements.
- Knowledge of data resource management which includes systems analysis design and implementation.
Additional Posting Information
This is a Casual/Seasonal position which is a non-pension eligible position without healthcare and/or other benefits.
Conditions of Hire
Selection Process
The application and supplemental questionnaire are evaluated based upon a rating of your education training and experience as they relate to the job requirements of the position. It is essential that you provide complete and accurate information on your application and the supplemental questionnaire to include dates of employment job title and job duties. For education and training list name of educational provider training course titles and summary of course content. Narrative information supplied in response to the questions must be supported by the information supplied on the application including your employment education and training history as it relates to the job requirements.
Once you have submitted your application on-line all future correspondence related to your application will be sent via email. Please keep your contact information current. You may also view all correspondence sent to you by the State of Delaware in the My Applications tab .
Accommodations
Accommodations are available for applicants with disabilities in all phases of the application and employment process. TDD users may request an auxiliary aid or service by calling or by visiting . You may also call or email for additional applicant services support.
The State of Delaware is an Equal Opportunity employer and values a diverse workforce. We strongly encourage and seek out a workforce representative of Delaware including race color religion age sex national origin disability status genetics protected veteran status sexual orientation gender identity or expression.
Required Experience:
Unclear Seniority
Key Skills
- Databases
- Disaster Recovery
- SQL
- High Availability
- Microsoft SQL Server
- ssrs
- Database Design
- Performance Tuning
- SSIS
- Database Administration
- Sybase
- Oracle
About Company
The official website of the State of Delaware. Find information about state government, programs, and services. The First State is located in the Northeast U.S.
