SENIOR DATA BASE ANALYST - 71001847 1

Requisition No: 838048 

Agency: Department of Law Enforcement

Working Title: SENIOR DATA BASE ANALYST - 71001847 1

 Pay Plan: Career Service

Position Number: 71001847 

Salary:  $56,650.00 

Posting Closing Date: 10/08/2024 

Total Compensation Estimator Tool

SENIOR DATABASE ANALYST

INFORMATION TECHNOLOGY SERVICES

PRODUCTION SYSTEM SERVICES/DATABASE ADMINISTRATION

**Open-Competitive Opportunity**

 

POSITION SUMMARY:

This position is in the Production Systems Services bureau, reporting to the Database Administration section. This is a full-time position that requires knowledge of data administration, data/process modeling concepts and techniques, relational database design, systems development methodology, and database administration. The position requires skill and experience in the highly technical database administration functions of Oracle database management system; SQL Server database management system; MySQL database management system; and, the numerous application databases that are maintained within them.

 

DUTIES & RESPONSIBILITIES:

Specific duties include:

• Testing and implementation of database systems;
• Planning, coordinating, and implementing security measures to safeguard computer databases;

• 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;
• Acting as a custodian of data integrity, efficiency, availability, and security within the organizations 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;
• 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; and
• Administration and support for multiple statewide applications.

 

KNOWLEDGE, SKILLS & ABILITIES:

• Experience designing, developing, testing, documenting, and implementing databases, as well as implementing backup and recovery procedures;
• Experience installing and maintaining Oracle, Microsoft SQL Server and MySQL software and databases, as well as performing backup and recovery processes;