DATABASE ADMINISTRATOR-INTERMEDIATE* - 03262024-56261

Job Information

LOCATION OF (1) POSITION TO BE FILLED: DEPARTMENT OF FINANCE & ADMINISTRATION, BUSINESS SOLUTIONS DELIVERY DIVISION, DAVIDSON COUNTY

This position requires CJIS & FTI fingerprints. This position requires a criminal background check. Therefore, you may be required to provide information about your criminal history in order to be considered for this position.

This position is designed as Hybrid.

Qualifications

Education and Experience: Graduation from an accredited college or university with a bachelor's degree and one year of professional level experience in the analysis, design, or programming of business information systems utilizing database management systems (e.g., IMS/DB, SQL Server, DB2, Oracle).

Substitution of Graduate Coursework for the Required Experience: Any additional graduate coursework in data modeling, database design, or performance monitoring and tuning of database management systems may substitute for the required experience on a year-for-year basis to a maximum substitution of one year.

Substitution of Experience for Education: Professional level experience in the analysis, design, or programming of business information systems utilizing database management systems (e.g., IMS/DB, SQL Server, DB2 and Oracle) may substitute for the required bachelor's degree on a year-for-year basis to a maximum of four years.

OR

Education and Experience: Graduation from an accredited college or university with an associate degree in business data processing, management information systems, computer and information systems, computer science, or other directly related field and one year of professional level experience in the analysis, design, or programming of business information systems utilizing database management systems (i.e., IMS/DB, SQL Server, DB2, Oracle).

Substitution of Experience for the Specialized associate degree: Experience in data modeling, database design or performance monitoring and tuning of database management systems may substitute for the specialized associate degree on a year-for-year basis to a maximum of two years.

OR

One year of experience as an Information Systems Associate, in training for Database Administrator with the State of Tennessee.
Necessary Special Qualifications: None.

Examination Method: Education and Experience,100%, for Preferred Service positions.

Summary

Summary: Under general supervision, is responsible for implementing and revising database structures of average difficulty and is responsible for ensuring accuracy of data.

Distinguishing Features: This is the entry/working level of the Database Administrator classification. An employee in this class assists database developers or other database administrators in designing, implementing or revising data structures and database systems following defined standards and procedures. This class is flexibly staffed with Information Systems Associate and differs in that an incumbent of the latter learns to implement or revise databases. This class differs from Database Administrator-Advanced in that an incumbent of the latter is responsible for implementing methods, techniques, and standards for data and database management.

,An applicant appointed to this flexibly staffed class will be reclassified to the next higher class in the series after successful completion of a mandatory one-year training period; inadequate or marginal performance during the training period will result in automatic demotion or termination.

Responsibilities

Interacting With Computers:

• Assist senior DBAs in installations, upgrades and patching of database software and migrations.
• Provide administration of database to ensure stated uptime goals as provided by management.
• Uses database documentation and knowledge of the system to assist in the recovery from problems or failures.
• Creates and schedules database specific jobs and backup/recovery jobs and designed strategies.
• Assist senior DBAs in executing or documenting Disaster Recovery (DR) solutions, testing or documentation.
• Perform daily maintenance processes and procedures.
• Monitors and administers basic RDBMS security i.e. adding and removing users, changing passwords, administering quotas, reviewing security logs.

Provide Consultation and Advice to Others:

• Provide technical assistance to database consumers, development and support teams including troubleshooting and diagnostics.
• Assist other database administrators in development and enforcement of standards, procedures and guidelines.

Monitoring and Controlling Resources:

• Implements database monitoring solutions under guidance of senior DBA.
• Monitors database system for availability. Track and report database performance and usage metrics and confirm all databases are operational.

Communicating with Supervisors, Peers, or Subordinates:

• Reviews logs for RDBMS systems and report all system issues to supervisor.
• Assist other database administrators in implementing and reviewing database systems to ensure accuracy and efficiency.

Analyzing Data or Information:

• Assist in troubleshooting database issues by using all available resources.
• Reviews database growth and provide reports to senior DBA.
• Evaluates database software to enhance database system usage, facilitate problem resolution, and maximize customer service.
• Assist other database administrators in monitoring database system performance.

Processing Information:

• Implements physical database changes on appropriate system platforms.
• Develop and create basic SQL, SQL Packages/languages.
• Implements change scripts as provided by senior DBAs.
• Implements designs and revises data structure under supervision.

Evaluating Information to Determine Compliance with Standards:

• Evaluates information gathered from users, other staff and historical data to ensure optimal performance and productivity of database systems.
• Assist other database administrators in identification, selection and use of database software.

Documenting/Recording Information:

• Provide support/assistance to development/application teams to ensure that applications and related services are documented and kept current.
• Documents processes and procedures for database operations and maintenance.
• Documents anomalies from daily maintenance procedures.
• Documents area of poor response and turnaround times by reviewing historical data and information from users.

Competencies

Competencies:

• Dealing with Ambiguity
• Functional/Technical Competency
• Problem Solving
• Technical Learning
• Time Management
• Perseverance
• Presentation Skills
• Written Communications
• Customer Focus
• Approachability
• Listening
• Composure

Knowledge:

• Knowledge of basic backup/recovery methodology including Cold backups, file system backups, import/exports, etc.
• Computers and Electronics
• Knowledge of Database Architecture - database design and scripted DML changes
• Knowledge of basic networking such as TCP/IP, DNS, etc.
• Knowledge of basic SQL, inserts, updates, deletes, joins, selects, etc.
• Knowledge of basic RDBMS database systems such as data normalization, primary/foreign key constraints, indexes, relationship model, etc.
• Knowledge of basic OS architecture such as file system layouts, directory structures, users, groups, basic O/S parameters, etc.
• Knowledge of basic monitoring software and the ability to interpret and understand alerts, thresholds and notifications
• Knowledge of Basic Mathematics
• Knowledge of basic RDBMS administration such as adding/removing users, changing passwords, adding roles, start/stop database, reviewing log files, etc.
• Customer and Personal Service
• Knowledge in basic documentation or technical writing using word processing
• Knowledge of basic O/S scripting such as korn shell, bash shell, windows, etc.
• Knowledge of basic database development lifecycle

Skills:

• Skill in basic database backup and recovery and deployment including Cold Backups, Hot backups, and basic database dumps, implementing, and scheduling and basic troubleshooting
• Dependability
• Adaptability/Flexibility
• Stress Tolerance
• Persistence
• Achievement/Effort
• Active Learning
• Active Listening
• Skills in understanding/reading and writing basic SQL, SQL Packages/languages
• Skills in basic understanding of database design, including physical data models and scripted DML changes
• Skills in basic understanding of database parameters
• Skills in basic understanding of operating system, networking and storage
• Skills in basic database security, including password changes, creating/deleting users, granting privileges
• Skills in reading and verifying log files and monitoring alerts
• Skills in basic documentation or technical writing
• Attention to Detail
• Integrity
• Analytical Thinking
• Initiative
• Judgment and Decision Making
• Operations Analysis
• Speaking
• Systems Analysis
• Skill in basic O/S scripting

Abilities:

• Ability to work under direct supervision
• Ability to read and understand ideas and information presented in writing
• Attention to Detail
• Integrity

Tools & Equipment

• Computer
• Telephone
• Fax Machine
• Printer