SQL Database Administrator III

SUMMARY:

This position is responsible for providing mid level DBA duties and for routine and repeatable DBA duties utilizing SQL on multiple platforms.

 

POSITION DESCRIPTION:

? DBA support for multiple customer environments using SQL.

? Monitor storage and performance statistics.

? Monitor backups and audit security.

? Identify tasks, which require automation and automate them.

? Writes control sheets, incident reports and change notices.

? Plan, implement, and document backup and recovery strategies and testing

? Restore and recover production databases.

? Plan and perform database upgrades.

? Conduct security audit and maintenance.

? Assist in triage and troubleshooting of backup errors.

? Assist in install of RDBMS from media.

? Assist in testing new RDBMS features and functionalities.

? Assist in database creation including file system setup and installation of scripts.

? Assures timely resolution to user issues.

? Provides support to entry level DBA Administrators

? Develops and maintains strong working relationships across departments.

? Participates in customer team meetings.

? Available to provide 24X7 system support and participate in on call rotation.

? Proactively seeks to improve upon the system or processes.

? Maintains/edits existing T-SQL scripts and assists in writing new ones.

 

SKILLS REQUIRED:

? Strong inter-personal and communication skills.  Capable of explaining simple procedures in writing or verbally. Good phone skills.

? Solid understanding of all versions of SQL.

? Basic understanding of database architecture including processes, structures and memory.

? Basic understanding of SQL Client Tools

? Basic understanding of database security including users and roles.

? Basic understanding of backup and restore, performance tuning and monitoring.

? Must possess the ability to work in a highly diverse and integrated hardware/software environment.

? Proficiency in usage of T-SQL.

? General understanding of database level programming such as triggers and stored procedures.

? General understanding of advanced features such as replication and disaster recovery.

? Ability to set and meet deadlines.

? Ability to solve problems quickly and completely.

? Ability to understand and follow instructions.

? Ability to complete assigned work without close supervision.

 

EDUCATION:  4 year degree in MIS/CS or Engineering preferred

 

YEARS OF RELATED EXPERIENCE:

? Experience in database administration or experience in a help desk environment preferred.

? Minimum 3 years experience in database administration.

? MCDBA Certification preferred