SUMMARY:

An accomplished Senior Database Administrator (DBA) with extensive experience designing, coding, testing, documenting and supporting mission critical, enterprise level database solutions in MS SQL Server environments. Proficient in an assortment of technologies, including MS SQL Server, Access, Visio, VSTF, IIS Web Server, C#, VB Script, ASP.NET, XML, SSIS, SSRS, SSAS, Windows.

DBA SKILLS INCLUDE:

• MS SQL 6.5 - 2012 Database Administration
• Performance Tuning & Capacity Monitoring
• Data Security, Backup & Recovery
• Standby/Failover Administration
• SQL 2012 AWO Administration/Installation
• SSIS Package Development
• Database-Backed Web Solutions
• SQL Tuning in an MS SQL Environment

EXPERIENCE:

Confidential, Kent, WA

Senior Database Administrator & SQL Developer

Responsibilities:

• Worked with business and IT to create applications to increase productivity though process change.
• Architected and wrote monitoring and automated management software to better support and anticipate issues across the MSSQL back end of Confidential corporate and manufacturing systems.
• Sr. Database Administrator for Confidential corporate and manufacturing systems.
• Worked across teams to architect and implement best practices across the platform.
• Created and implemented best practices and associated automation jobs for DBCC Consistency checking, indexing and stats rebuilding.
• Troubleshot performance bottlenecks.
• Monitored and maintained SQL servers and associated health parameters.
• Troubleshot and resolved production issue including but not limited to SQL Jobs, backups, SSIS Packages, code and data issues.

Confidential, Portland, OR

Senior Database Administrator & SQL Developer

Responsibilities:

• Architected and wrote monitoring and automated management software to better support and anticipate issues across the MSSQL back end of XO Cloud Voice and High Volume Out-Dial.
• Sr. Database Administrator for XO Cloud Voice and High Volume Out-Dial.
• Worked across teams to architect and implement best practices across the platform.
• Created and implemented best practices and associated automation jobs for DBCC Consistency checking, indexing and stats rebuilding.
• Troubleshot performance bottlenecks.
• Monitored and maintained SQL servers and associated health parameters.
• Troubleshot and resolved production issue including but not limited to SQL Jobs, backups, SSIS Packages.

Confidential, Seattle, WA

Senior Database Administrator & SQL Developer

Responsibilities:

• Architected and wrote automation scripts and SSIS packages for data archive and legacy reporting.
• Architected and wrote meta-data driven ETL for security reporting.
• Sr. Database Administrator for Physical Security / Lenel.
• Worked with development teams to architect proper solutions and verified code for best practices and minimal impact.
• Created and implemented best practices and associated automation jobs for DBCC Consistency checking, indexing and stats rebuilding.
• Troubleshot performance bottlenecks.
• Monitored and maintained SQL servers and associated health parameters.
• Troubleshot and resolved production issue including but not limited to SQL Jobs, backups, SSIS Packages.

Confidential, Redmond, WA

Senior Database Administrator

Responsibilities:

• Created and implemented best practices and associated automation jobs for DBCC consistency checking, indexing and stats rebuilding.
• Worked with development teams to architect proper solutions and verify code for best practices.
• Provided escalation support for Tier 1 and 2 support personnel.
• Assisted with development of best practices and created documentation.
• Troubleshot and resolved performance bottlenecks.
• Monitored and maintained SQL servers and associated health parameters.
• Troubleshot and resolved production issue including but not limited to SQL Jobs, backups, SSIS Packages.
• Created troubleshooting guides for Tier 1 & 2 to reduce impact of issues to tier 3.
• Performed problem management on issues to discover trends and provide root cause resolution in code bugs.
• Assisted with management, training and oversight of vendors.

Confidential, Redmond, WA

Senior Database Administrator

Responsibilities:

• Developed and deployed business continuity plan for geo-redundancy.
• Provided escalation support for application related issues.
• Developed best standards of work practices and implemented across multiple teams.
• Authored process and system configuration documentation.
• Assisted with activities to design, develop and maintain database applications.
• Performed and automated database backup and recovery, database migration and archiving systems and procedures.
• Assisted with design and implementation of database security infrastructure including the creation and maintenance of user access accounts.
• Participated in hardware and software deployments.
• Monitored database performance trends to identify anomalies and errors, assess and determine resolution and execute corrective actions, work with engineering to implement permanent fix.
• Captured business requirements for SharePoint, created search criteria and author data mining scripts.
• Taught TSQL classes across organizations for Confidential staff and personnel.

Confidential, Redmond, WA

Systems Engineer

Responsibilities:

• Architected and Developed Essence - SQL application that automates the process of gathering job failure statics across entire BI resulting in an estimated cost savings of 1040 hours annually.
• Designed and Developed Automatic Incident Coordinator - Automates incident ticket audit process to better ensure consistent audits and compliance within BI. This resulted in a time savings of 2080 hours across the Business Intelligence and Services organizations annually.
• Created, reviewed and presented standards documents, KB articles, operation guides and training materials for tier 1 & 2 to offload troubleshooting and request fulfillment in order to focus on more complex issues.
• Developed and maintained basic database objects and databases.
• Assisted with hardware and software implementations
• Assisted with activities to design, develop and maintain database applications.
• Performed and automated database backup and recovery, database migration and archiving systems and procedures.
• Assisted with design and implementation of database security infrastructure including the creation and maintenance user access accounts.
• Participated in hardware and software implementations.
• Installed and tested software upgrades and patches.
• Monitored database performance trends to identify anomalies or errors.
• Led project to enhance the versatility and functionality of Confidential Communicator / Lync..