IT Database Administrator or IT Database Administrator Senior

This position will be filled at the IT Database Administrator or IT Database Administrator Senior level, depending upon qualifications.


IT Database Administrator level:

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.


  1. Create databases and database objects, such as tables, indexes, views, triggers, and stored procedures
  2. Load databases, reorganize as necessary, and assist in monitoring, troubleshooting and resolving operational and performance related database issues
  3. Execute the procedures necessary to save, retrieve, and recover databases from hardware and software failures
  4. Configure and implement database network connectivity working with the required technical teams 
  5. Ensure data integrity, and data security 
  6. Maintain data standards, prepare and develop database documentation, procedures, and definitions for data dictionaries
  7. Create test database environment for applications section, including the creation of necessary libraries and procedures
  8. Assist with the installation of database software and with analyzing, designing, and implementing databases
  9. Assist with designing and maintaining database structures
  10. Assist in developing and implementing standards

 

Responsibilities - Supervisor and/or Leadership Exercised: None


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 principles, practices and techniques of computer programming, system design, computer operations, systems and procedures
  • Knowledge of database structures and theories
  • Knowledge of current database technologies
  • Knowledge of Oracle and SQLServer database tools, environments and query languages (SQL, TSQL)
  • Skill in developing reports and cross references from the data dictionary
  • Skill in data modeling
  • Skill database debugging, testing and troubleshooting techniques
  • 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
  • Skill in selecting and using training/instructional methods and procedures appropriate for the situation when learning or teaching new concepts
  • 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 university with major course work in a field related to the job, plus two (2) years of experience in a related field. Experience may substitute for education for up to four (4) years


IT Database Administrator Senior level:

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.


  1. Design, analyze, troubleshoot and resolve advanced operational and performance related database issues, coordinate changes, and maintain database structures, and assist in developing policies and procedures designed to ensure the integrity of the database environment
  2. Design, coordinate, implement, and determine procedures necessary to save and recover production databases, and to recover databases from hardware and software failure
  3. Perform database performance monitoring and auditing, implement efficiency improvements, and modify existing databases and database management systems
  4. Design, configure and implement database network connectivity working with required technical teams.
  5. Monitor capacity versus utilization and recommends appropriate action on a timely basis to avoid performance degradation
  6. Create databases and database objects, such as tables, indexes, views, triggers, and stored procedures
  7. Track database assets and critical information about those assets
  8. Assist in development of data security standards to ensure data integrity data security 
  9. Maintain data standards, prepare and develop database documentation, procedures, and definitions for data dictionaries
  10. Create test database environment for applications section, including the creation of necessary libraries and procedures
  11. Install 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
  • 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
  • Skill in selecting and using training/instructional methods and procedures appropriate for the situation when learning or teaching new concepts
  • 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 university with major course work in a field related to the job, plus four (4) years of experience in a related field. Experience may substitute for education for up to four (4) years


Preferred Qualifications - Both Levels:


  • Demonstrated Experience supporting and administering Windows Servers, Active Directory, Web Servers IIS and Apache, Systems integrations 
  • Administration and support of MS SQL server and Oracle administration
  • Experience using VM Ware, using backup software like Rubrik or comparable and performing restore tasks.
  • Demonstrated experience with .Net (C#, VB.Net)
  • Ability to write Extraction, Transform and Load (ETL) or SSIS tasks for the Extraction, Transformation or Loading (ETL) process
  • Experience supporting reporting solutions such as Actuate, Cognos, Power BI.
  • Ability to travel to more than one work location.


Subscribe to Job Alerts