SUMMARY:

• Over 20 years Database Engineering, Development, and Administration experience, including 3 years current Software as a Service (SaaS) Cloud application database administration experience
• 11 years Software Engineering experience in the systems development lifecycle (SDLC)
• Microsoft Certified Professional (MCP) in SQL Server and Windows
• Experience in the financial, insurance, software, retail, health, legal, cellular, and energy industries
• Operations management, project management, and technical team leader experience
• Strong technical, communication, customer service, process improvement, and problem solving skills
• A strong team player and individual contributor who creates high quality value added solutions

TECHNICAL SKILLS:

Database: MS SQL Server (2016, 2014, 2012, 2008, 2005, 2000, 7, 6.5), MS Cluster Server (2012, 2008, 2003, 2000), SSRS, SSIS/DTS, ETL, OLTP, OLAP, ODBC, Oracle, DB2

Operating Systems: MS Windows (2012, 2008, 2003, 2000, NT, 7, XP), IBM MVS, OS/2

Languages: T - SQL, VB, VBS, PowerShell, Windows Command Shell, C, ASP, HTML, XML

Other: VMWare, MS SQL Management Studio, Idera SQL Server Tools, Redgate SQL Toolbelt, SQL Sentry, SQL Litespeed, Quest Foglight and Spotlight, Erwin, SharePoint, Windows Administration, IIS Administration, MS Office

PROFESSIONAL EXPERIENCE:

Personal Computer Consultant

Confidential, Lynnwood, WA

• Supported and administered Microsoft Windows workstations and laptops for various clients. Installed anti-virus software and other application software and software upgrades.

Senior SQL Server Database Administrator

Confidential, Mountlake Terrace, WA

• Consulted software developers on best practices for developing efficient database create, read, update, and delete (CRUD) procedures.
• Administered all aspects of production, test, and development databases, including initial installation, applying patches, upgrading or migrating the DBMS, performance tuning, database maintenance and backups, disaster recovery, managing security, and planning for appropriate storage capacity.
• Planned and executed proactive measures to achieve stability and availability of the SQL Server systems.
• Researched and resolved system problems and performance issues on production systems.

Senior SQL Server Database Developer/Administrator

Confidential, Seattle, WA

• Designed and developed SQL Server Integration Services (SSIS) applications to perform Extract, Transform, and Load (ETL) operations from input and transfer databases to production processing databases.
• Developed Microsoft SQL Server Reporting Services (SSRS) reports and ad-hoc data queries.
• Created and performed database administration tasks for development, test and production SQL environments following the systems development lifecycle (SDLC) and industry and security best practices.
• Proactively managed database server resources using performance monitor, scripts, and 3rd party tools.
• Deployed and maintained a database security framework supporting role based group access.
• Developed, implemented and maintained a backup and disaster recovery strategy for all SQL server databases.
• Resolved connectivity and performance issues relating to SQL Servers and data enabled applications.
• Provided production database escalation support and database preventative maintenance.

Senior SQL Server Database Engineer/Developer/Administrator

Confidential, Bothell, WA

• Provided Enterprise level SQL Server Database Engineering, Development, and Administration services.
• Engineered, developed, and implemented the Corporate SQL Server Inventory database. This included writing complex database CRUD SQL stored procedures; designing and developing ETL process to import data from servers and databases; and designing and developing database tables, procedures, and reports.
• Designed, developed, and implemented standardized complete Database Maintenance/Repair SQL Agent jobs and a deployment system.
• Engineered and developed a standard customizable SQL Server monitoring and alerting database and scripts.
• Wrote and maintained corporate SQL database procedures and standards.
• Managed, administered, and supported 90+ SaaS cloud application MS SQL Server 2012/2008/2005/2000 Instances containing 10,500+ databases totaling over 185 terabytes.

Confidential, Seattle, WA

Senior SQL Server Database Administrator

• Provided application database support by developing and performing database operations processes and procedures, such as maintaining and synchronizing development/test database environments with production. Monitored and recommended database application changes for optimal performance. Provided third-level production operations support on a rotating on-call basis, to ensure data integrity and quick recovery of databases. Installed database software products and resolved software problems.
• Participated in the definition and implementation of database architecture and standards.

Senior SQL Server Database Engineer/Administrator

Confidential, Seattle, WA

• Following the acquisition of WaMu by Confidential, I was one of only 8 IT individuals retained as a key Technical Lead Database Administrator and Subject Matter Expert on the Confidential (WaMu) to Chase Database Conversion project.
• Created database transition procedures, migrated and transitioned support of over 200 WaMu SQL databases into the Chase SQL Server infrastructure. Decommissioned several SQL instances and databases, resulting in an annual savings of $260,000 in licensing and maintenance costs.

Senior SQL Server Database Engineer/Administrator

Confidential, Seattle, WA

• Served as Technical Lead Database Administrator/Engineer for the Shared Database Utility Computing (DBU) environment (multiple 64 bit SQL 2005 instances on Windows 2003 PolyServe clusters) and the Shared SQL environment (multiple 32 bit SQL 2000 instances on Windows 2003 clusters). Responsible for the design, implementation, technical evolution, management, support, and monitoring of DBU and Shared SQL.
• Designed and implemented the DBU SSIS infrastructure and SSIS procedures. Developed new enterprise DBU and SQL standards, procedures, guidelines, security standards, database maintenance plan standards, and disaster recovery processes using SQL Server database mirroring, log shipping, replication, and SAN SRDF replication. Installed and certified SQL Server 2008.
• Migrated and consolidated over 1000 application databases and 66 database servers into DBU/Shared SQL environments, resulting in an annual savings of $1.5 million.
• Designed, developed, and implemented in-house software to administer, manage, and track the complex multiple-instance DBU/Shared SQL environments, saving over $50,000 in software costs.
• Developed and implemented a T-SQL solution for the QRM Servicing application which eliminated 12 weeks worth of work every year, saving of over $50,000 annually.
• Rewrote the QRM Servicing ED Oracle database import process, reducing total processing time by 60%.
• Served as Technical Lead DBA for Production Support DBAs, provided Tier 4 Support, and performed Operations Manager duties on a rotating basis. Interviewed several DBA candidates.
• Served as a Project Manager on the IBM Global Services to Wipro DBA Vendor conversion project.