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

Summary

Responsibilities

• 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

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

• 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

• 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