About This Position

Job Description:

IT Database Administrator Senior

Purpose:

Duties, Functions and Responsibilities:

Essential duties and functions, pursuant to the Americans with Disabilities Act, may include the following. Other related duties may be assigned.

• Designs, analyzes, troubleshoots, and resolves advanced operational and performance-related database issues; coordinates changes; maintains database structures; and assists in developing policies and procedures designed to ensure the integrity of the database environment.

• Designs, coordinates, implements, and determines procedures necessary to save and recover production databases and databases from hardware and software failure.

• Performs database performance monitoring and auditing, implements efficiency improvements, and modifies existing databases and database management systems.

• Designs, configures, and implements database network connectivity working with required technical teams.

• Monitors capacity versus utilization and recommends appropriate action on a timely basis to avoid performance degradation.

• Creates databases and database objects, such as tables, indexes, views, triggers, and stored procedures.

• Tracks database assets and critical information about those assets.

• Assists in development of data security standards to ensure data integrity data security.

• Maintains data standards and prepares and develops database documentation, procedures, and definitions for data dictionaries.

• Creates test database environment for applications section, including the creation of necessary libraries and procedures.

• Installs new software releases and/or upgrades including researching, testing, and implementing new technology.

Responsibilities - Supervisor and/or Leadership Exercised:

May provide leadership, work assignments, evaluation, training, and guidance to others.

Knowledge, Skills, and Abilities:

Must possess required knowledge, skills, abilities, and experience and be able to explain and demonstrate, with or without reasonable accommodations, that the essential functions of the job can be performed.

• Knowledge of industry and department best practices, requirements and policies and procedures.

• Knowledge of the advanced principles, practices and techniques of secure computer programming, system design, computer operations, systems and procedures.

• Knowledge of advanced database structures and theories.

• Knowledge of current database technologies.

• Knowledge of Oracle and SQL Server database tools, environments and query languages (SQL, TSQL).

• Knowledge of statistical analysis processes.

• Skill in developing reports and cross references from the data dictionary.

• Skill in performing data modeling and prototyping to implement efficiency improvements.

• Skill database debugging, testing and troubleshooting techniques.

• Skill in selecting and using training/instructional methods and procedures appropriate for the situation when learning or teaching new concepts

• Ability to write Extraction, Transform and Load (ETL) or SSIS tasks for the Extraction, Transformation or Loading (ETL) process.

• Ability to gather, assemble, correlate, and analyze facts.

• Ability to perform a root cause analysis.

• Ability to assess future information needs so that the databases can evolve in an appropriate manner.

• Ability to accurately identify/determine customer needs and take appropriate actions and/or steps to address identified needs.

• Ability to recognize, value, and include different perspectives, experiences, approaches, and cultures in achieving organizational goals.

• Ability to gain and maintain the trust and confidence of others and the organization through consistency and reliability.

• Ability to give, receive, or share thoughts, ideas, perspective, and data to create shared understanding.

• Ability to define, analyze, and find solutions for difficult or complex problems.

• Ability to view the big picture.

• Ability to quickly become familiar with emerging technologies.

• Ability to identify trends as well as isolated events.

Minimum Qualifications:

• Graduation with a Bachelor’s degree from an accredited college or univers