CAREER SUMMARY:

• Over 25 Years of experiences working with all versions of Microsoft SQL Server Databases, now including 2016 Enterprise , SSRS, SSIS, and as a Backup/ Recovery Solutions administrator. Experience with Amazon’s AWS, EC2, S3, RDS, LIGHTSAIL.
• Currently working with SQL 2016 and Azure, MariaDB and ZappySys tools.
• Some of my responsibilities included: database monitoring, backup/recovery plans and solutions, developing and implementing disaster recovery plans, building and managing High Availability and Always On solutions, indexing, optimizing, query optimization, database status, and health reporting and future planning needs.
• Worked with a Microsoft IT team of Network Engineers to build and implement a load - balanced solution for Microsoft.com domain, a client who processes several thousand transactions a second. The same group of Network Engineers built a multi-node, Active/Active Failover Cluster solution.

TECHNICAL SKILLS:

Database: SQL Server 2008 R2, 2012, 2014, 2016 and 2017 Azure, Pick, Legacy and MySQL/MariaDB. I’ve been focusing my work with MariaDB, and I like it.

SQL DBA Tools: PowerShell, Spotlight and Fog Light alerting and monitoring tools, plus Idera’s SQL Diagnostic Monitor and the Red Gate tools. Strong user and supporter of the SQL Best Practices Document. AWS tools and implementation.

Windows Technologies: IIS, ADO, Net, Visual Source Safe, Visual Studio and SharePoint, Docker Tools

DBA and Developer Skills/Tools: Designed and developed hundreds of database solutions using SQL Server all versions, Basic Scripting, XML tools, Pick Basic, T-SQL, Stored Procedures, Triggers, Functions, Excel and Power Shell scripting. Have designed and deployed several HIPAA compliant

SSRS and SSIS: ETL solutions, installed and used Hallengren’s backup SQL solution, AWS S3 storage, and RDS tools plus CloudBerry.

PROFESSIONAL EXPERIENCE:

Confidential, Roseville, CA

Senior SQL Database Administrator

Responsibilities:

• Servers built around Dev, Test and Production environments.
• Added to our environment is a very robust Couchbase Server and a few MariaDB database experiments, including monitoring VOIP services, plus tools like JSON editor, AWS, MYSQL, and Azure.

Confidential, Sacramento

SQL DBA Consultant and Developer

Responsibilities:

• They have built a solution that condenses and moved a MySQL and legacy databases to new cloud-based SQL databases.
• I put together several SSIS packages to allow the conversion and import of thousands of rows of legacy data.
• They have incorporated Peachtree Cloud Accounting Software and a custom SQL/WEB farm/production software into their infrastructure.
• I built a library of SSRS reports supporting changes and production reporting.
• Daily performance monitoring and tuning of their MSSQL and SQL 2012 Servers.

Confidential, Camarillo, CA

DBA Consultant

Responsibilities:

• They have constructed EDL processes/tools that migrated legacy data to a SQL database.
• Legacy data had several formats and data structures and was over 15 Terabytes of data.
• Reporting needs were provide using SSRS.
• I have worked on several SQL tune-up problems, index issues and resolving poorly written queries.
• Build a backup solution utilizing the Hallengren scripts, and CloudBerry tools with Amazon’s S3 storage.

Confidential, Spokane, WA

DBA Consultant and Developer

Responsibilities:

• Supported SQL Database performance and tune-ups.
• Monitoring and alerting responsibilities and serviced both a Production DBAs and Developer.
• Created and deployed several SSRS and SSIS solutions, handled daily trouble tickets and produced a daily Morning Report.
• The developer of the SSIS package used to build and import data to a warehousing solution.
• Documented the backup standards and reports, applied DBA’s Mission Statement.
• I have built a database footprint report.
• The purpose of this report was to help the bank in understanding the total bandwidth used and cost of database ownership by the applications.

Confidential, OR

DBA Consultant and ETL Developer

Responsibilities:

• Career staff functioning as a SQL DBA and ETL Developer plus the responsibilities of testing of contractor’s work
• Monitoring and Alerts processes. Backup and Disaster Recovery resonsibilites, streamlining and improving.
• Developed an SSRS scorecard and reports displaying the health of the databases (about 30) and addressed HIPAA compliance issues as they related to the databases.
• Currently, still supporting BMC remotely as needed.

Confidential, Portland, OR

Senior Production DBA, Developer

Responsibilities:

• Member of a DBA team whose responsibilities were; the day-to-day operations of Greenbrier’s development, testing and production databases, as well as working with Application Developers. Manage several Oracle and Sybase database connections.
• Alerting and monitoring tools, status reports, backups and disaster recovering solutions.
• Responsible for the planning, design, and implementation of SSIS conversion of hundreds of DTS and Robocopy processes to SSIS solutions.
• We have developed and installed several audit tools to satisfy our SOX responsibilities.
• I have managed over 300 instances of SQL databases including all versions (2000, 2005, 2008 and 2008 R2) and sizes from small to partitioned database that had more than 15 million rows and 200 tables.
• SQL Server Replication - After encountering a data lag-time problem at 8 of our remote repair facilities, recommended using SQL Server Replication with redundant/local mirrored data sets. At each remote facility, we purchased workstation PCs and installed SQL Server on each one. We then setup Transaction Replication on each PC to sync to the primary server in Portland.