Provide design, maintenance, and system support for company Microsoft SQL DB applications.
Perform traditional database administration duties including, but not limited to, software installation, database creation, database maintenance, capacity planning, tuning, backup, and business continuity planning for multiple high-availability databases.
Support, prioritize, and troubleshoot database, operating system, application and hardware issues.
Diagnose problems and implement corrective actions related to database management and associated applications.
Advanced technical and hands-on experience performing the following procedures: joining local and remote tables, developing stored procedures, handling errors in a stored procedure, processing data using cursors, writing triggers to carry out advanced validation, improving performance with indexes and views.
Create, maintain and modify simple to complex reports.
Review, analyze and modify programming systems including encoding, testing, debugging and documenting programs as stipulated by company requirements.
Maintain familiarity with a variety of the field’s concepts, practices and procedures.
Create, test and maintain documentation, including diagrams and schemas, of applications, including standards and procedures for operational and technical purposes.
Familiar with storage area networks (SAN) and designing configuration of production class database servers and database disk requirements.
Ability to create database implementation project plans and identify critical path and resolved issues related to such.
Provide progress reports to senior IT management as required.