SQL DBA

Job Purpose: Work as a member of the Information Technology department, providing:  1) Database Administration functions, and Systems Development Life Cycle planning, and 2) Reporting services.

 

Essential Duties and Responsibilities: other duties may be assigned.

 

·          Database Administration Duties: (80%)

o         Manages all enterprise databases, providing for their maintenance, stability and upgrades.

o         Responsible for database logical design, in coordination with the IT Systems Analysis team.

o         Assists in the development of secure data backup and restore strategies, processes and policies.

o         Responsible for ensuring that a proper System Development Life Cycle methodology is followed for all production systems under the IT Charter.

o         Assists in the definition and deployment of data security policies, data backup strategies, and business continuity planning.

·          Development Duties:  (20%)

o         Writes and edits SQL for stored procedures and reporting services.

 

 



Essential Skill Requirements:

 

·          Experience in managing Microsoft SQL databases, including:  physical data space planning, database monitoring, database performance tuning, and database upgrades.

·          Experience in database design, including:  logical database design, stored procedure design, ERD design and documentation.

·          Strong skills in database security and data synchronization, with an understanding of proper distribution methodologies.

·          Experience in managing databases and systems within a System Development Life Cycle methodology.

·          Ability to read, write and edit Structured Query Language (SQL) code.

·          Good communication and teamwork skills.