Wayne D. Roesner

Home

Recommendations

PDF Resume

Word DOC Resume

LinkedIn

STAR
 

Wayne D. Roesner


15331 W 49th Ave    ◆    Golden, CO 80403    ◆    (563) 505-3489    ◆    wayne@wayneroesner.com

 
 

Technical Knowledge/Skills
For example, Using Word for Windows Software, operating a Macintosh computer, or performing CPR.


SQL Daily Procedures


Situation:

Usage of Microsoft SQL or MS-SQL to perform daily procedures

Task:

Validation of jobs ran, backups, reporting, etc. completed and accurate. Although rare the jobs complete, but have errors from data, this does not always trigger an email alert.

Action:

I verify the jobs did complete and the major jobs actually did what they were suppose to. Backups are validated for date and time. Excel Daily Management Report, used by upper management is validated for accuracy by downloading the report and checking dates. In the rare case of an error, I email the appropriate affected personnel about the issue, fix any discrepancies, rerun the job, and validate the information again. I then send an email to the appropriate affected personnel on what caused the issue, what I did to fix it, what I did so it does not happen again.

Result:

All jobs complete accurately 99.9% of the time. Full Backups are completed Daily. Management receives a valid Daily Management Report everyday by 8:00am. I have since trained and delegated this to one of my employees.