Database Administrator (1440) - Advanced

Zencon Group

Tallahassee, FL

Apply

JOB DETAILS

SKILLS

Administrative Policies, Administrative Skills, Analysis Skills, Communication Skills, Computer Programming, Computer Servers, Computer Systems, Criminal Justice, Customer Support/Service, Data Administration, Data Analysis, Data Migration, Data Modeling, Data Recovery, Data Structures, Database Administration, Database Backup, Database Design, Database Management Software/Systems (DBMS), Database Programming, Database Recovery, Database Technology, Debugging Skills, Distributed Applications, Distributed Computing, Documentation, Federal Government, Identify Issues, Information Technology & Information Systems, Information/Data Security (InfoSec), JDBC (Java Database Connectivity), Law Enforcement, Linux Operating System, Memory Management, Microsoft .NET, Microsoft OLE DB (Object Linking and Embedding Database), Microsoft Product Family, Microsoft SQL Server, Microsoft Windows Operating System, Microsoft Windows Server, MySQL, Network Connectivity, Network Support, ODBC (Open Database Connectivity), Operating Systems, Oracle, Oracle Applications, Oracle DBA (Database Administrator), Oracle Database, Oracle PL-SQL, Performance Tuning/Optimization, Problem Solving Skills, Production Systems, Project Planning, Protective Services, Public Safety, Quality Control, RMAN, Red Hat Linux Operating System, Relational Databases (RDBMS), Requirements Management, SQL (Structured Query Language), Scripting (Scripting Languages), Seminars, Software Administration, Software Patches, Stored Procedures, System Migration, Systems Administration/Management, Systems Analysis, Team Player, Technical Presentation, Test Plan/Schedule, Testing, Unix Operating Systems, Unix Shell Programming, Writing Skills

LOCATION

Tallahassee, FL

POSTED

28 days ago

Background
The mission of the Florida Department of Law Enforcement (FDLE) is to "promote public safety and strengthen domestic security by providing services in partnership with local, state, and federal criminal justice agencies to prevent, investigate, and solve crime while protecting Florida's citizens and visitors.
In support of this mission, FDLE operates and maintains many Relational Database Systems. To provide services to help protect the safety of all Floridians and visitors. Both public and officer safety are the core of FDLE's mission. In order to provide the highest level of services possible, FDLE requires the services of one Database Administrator related to Relational Database Systems.
FDLE also has many other systems needing additional resources to continue the level of support required.
FDLE requires the services of a full-time contract position to enhance the Database Administration for Production System Services and provide support to other FDLE Information Systems.

Description of Services & Deliverables
Database Administrator responsibilities include but may not be limited to the following:
" Management and administration of Oracle, Microsoft SQL Server and MySQL database software and databases;
" Installing, configuring, patching and maintaining Oracle, Microsoft SQL Server and MySQL database software and databases;
" Ensuring the availability, integrity and security of database data;
" Providing database backup and recovery services;
" Developing and maintaining utility programs, scripts and routines for management of database systems on Red Hat LINUX and Windows server systems;
" Providing network support services for database-related network technologies and adapters such as TNS, ODBC, JDBC, OLEDB and .Net; and
" Assisting in the establishment and enforcement of database administration policies, standards and procedures.
" Collaborating with business experts to develop and document database infrastructure or design requirements;
" Performing database design, data modeling and data administration;
" Developing and documenting data standards
" Maintaining the enterprise data dictionary and model repository;
" Utilizing data administration tools to construct data profiles, perform data analysis and provide data cleansing recommendations;
" Providing support, diagnostic, troubleshooting and resolution of web-based and client server software applications in a distributed computer systems environment;
" Project planning related to maintenance and lifecycle management for multiple distributed systems;
" Administration and support for multiple statewide applications; and
" Assisting in the establishment and enforcement of database administration policies, standards and procedures.

KNOWLEDGE, SKILLS & ABILITIES
" Knowledge of Oracle and MySQL data base management technologies in UNIX/LINUX operating system environment;
" Knowledge of Microsoft SQL Server in a Windows operating system environment;
" Knowledge of Oracle, Microsoft SQL Server and MySQL internals, data structures, and memory management;
" Knowledge of Oracle network connectivity;
" Knowledge of SQL and PL/SQL languages;
" Knowledge of UNIX/LINUX operating system and commands;
" Knowledge of Microsoft Server operating system and commands;
" Knowledge of computer programming, systems analysis and systems design principles and practices;
" Experience installing and maintaining Oracle, Microsoft SQL Server and MySQL software and databases;
" Experience designing, developing, testing, documenting and implementing database backup and recovery procedures;
" Experience performing database backup and recovery processes for Oracle using RMAN;
" Experience performing database backup and recovery processes for Microsoft SQL Server;
" Experience configuring data base parameters for performance tuning;
" Experience developing, testing, documenting and implementing SQL, Oracle PL/SQL, UNIX/LINUX shell scripts and Windows operating system BAT orCMD shell scripts;
" Ability to use critical thinking skills and problem solve;
" Ability to work independently;
" Ability to create logical, well-written standards and procedures related to database design and database administration;
" Ability to write, code, test, debug, and review computer programs and stored procedures;
" Ability to process information logically and solve problems;
" Ability to identify and define user requirements;
" Ability to communicate effectively verbally and in writing;
" Ability to establish and maintain effective working relationships with others;

Preferred Experience
" 8 years of experience working with Oracle RDBMS software and databases (version 11g or more recent)
" 8 years of experience developing SQL, PL/SQL scripts, procedures, functions and packages
" 5 years of experience planning, developing and executing data conversion/migration plans, processes and programs
" Experience facilitating analysis sessions with business clients
" Experience presenting technical subject matter reviews or seminars to business clients
" Experience designing and executing quality control and test procedures

The Database Administrator will report to the designated FDLE supervisor, and is expected to perform the tasks and specific assignments given by the FDLE supervisor.

About the Company

Zencon Group

Resume Resources

Free Resume Templates Free Resume Builder