Design, administer, maintain, secure, and improve performance of databases

 

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

 

• 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

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