OBJECTIVE:

Database analysis, design, implementation and general DBA duties using Microsoft SQL Server 2005, SQL Server 2008, SQL 2008R2, SQL 2012. Corp to Corp rates start at 75.00/hr or full time starting at 120k/year. Considering contracts in all areas of North America.

SUMMARY:

• Over 18 years’ experience in database analysis, design and development.
• 18+ years total as a DBA
• Tier III Production Support
• Database development MS - SQL 6X, 7, 2000, 2005, 2008, 2008R2, 2012
• Experience in doing database conversions from SQL 2000 to SQL 2005 to SQL 2008 to SQL 2008R2 to SQL 2012.
• Experience with new features in SQL 2005, sliding partitions, database mirroring, converting DTS packages to SSIS packages.
• Experience in implementation of enterprise OLTP, Datamarts, Clustering, Replication, Database Mirroring, Log Shipping and AlwaysOn
• Several years of experience dealing with Very Large Databases, 6TB+.
• Specializing in Logical and physical design, full development, high performance tuning,
• Disaster recovery, and capacity planning.
• Exceptional ability to find solutions to complex problems.
• Thorough knowledge of NT, Server 2003, Windows 2008, Server 2012.
• Skilled in doing conversions to and from SQL and scrubbing the data before transformation
• Extensive experience in pulling and pushing data from many different sources using SSIS
• Experience in using design tools such as Erwin and DBArtisan.
• Strong communication skills.
• Excellent documentation ability.
• Experience reading and creating UML Documents.
• Limited experience using Azure and Cloud computing
• Ability to consolidate databases based on transactions per second from many servers down to one in most cases.

TECHNICAL SKILLS:

Hardware: Windows Servers, EMC SAN

Operating Systems: Windows Technology

Databases: SQL 6x - 2012

Packages: Crystal Reports, Erwin, DBArtisan

PROFESSIONAL EXPERIENCE:

Confidential, Lacey, WA

SQL Architect

Responsibilities:

• Confidential database 1.5TB
• Performance tuning using partitioning and filtered indexing, 400% faster
• Replicated database had 68 extra tables, moved extra tables to a separate database. Created views for stored procedures and SSIS packages that used extra tables. Snapshot replication took 4 days, after implementation of my process it now takes 45 minutes
• Set up Confidential database objects in TFS for development and deployment
• A member of the Confidential agile development team
• Worked with lead developers and project managers to solve difficult architectural problems
• Migrated SQL Serves from SQL 2008 to SQL 2016
• Implemented Always On

Confidential, Tacoma, WA

SQL Architect

Responsibilities:

• Major consolidation project of VM and Bare Metal servers for license true up
• Worked closely with Sysadmins, Project Managers and Business Owners
• Part of a 3 member DBA team to manage 4 environments and over 300 servers
• Wrote SQL Server Best Practice documents for Security, Maintenance and Deployment
• Daily work included going through the tickets in our queue and doing triage and resolution
• Production deployments using Octopus Deploy
• 3 Node clustering
• Database Mirroring
• Log Shipping
• Transactional Replication
• SQL Server Versions 2000, 2008, 2008R2, 2012, 2014
• Creating and maintaining SSIS packages
• Set up NLB Clustering for SSRS Servers
• Writing Change Management for CAB process

Confidential, Seattle, WA

SQL Architect

Responsibilities:

• Project is working in Confidential Cloud Services Division
• Responsible for requirements gathering
• Responsible for all logical and physical database design
• Responsible for all SQL Standards
• Responsible for all SQL code reviews
• Member of 6 global Agile Scrum Teams
• Responsible for Data Dictionary
• Responsible for SQL Version control, this includes forward and backward compatibility, using Microsoft Team Foundation Server
• Writing stored procedures, views and functions
• Intimate dealings with Service Center Service Manager and Microsoft Azure
• Writing test cases and unit tests for SQL Server
• Worked closely with PAAS and IAAS JSON templates
• Load testing of product using Redgate SQL Data Generator
• Performance testing of product
• Responsible for creating SQL updates for customers resulting in 0 data loss
• Work with Chief Architect and gathered requirements
• Full logical database design
• Physical database model
• Worked with 90 global team members to coordinate database development
• Gatekeeper for all SQL objects using TFS and code reviews
• Extensive testing of SQL install procedure
• Shipped Beta, HotFix1, HotFix2 and Beta2
• Collaborative work between Customer Implementation teams and clients to resolve distinct environment problems

Confidential, Seattle, WA

SQL Architect

Responsibilities:

• Performance tuning
• Working with third party vendors to help trouble shoot and streamline their applications
• Providing full written analysis after root cause investigations
• Capacity Planning
• Implementing changes from development to test to production
• Full production support
• Multi node clustering, 4 nodes active-active
• Log Shipping
• Reverse engineering of MXP application
• SQL 2000, 2005, 2008, 2008R2, 2012
• After 2 days at client, I had to completely take over a SQL Server migration and upgrade project as their DBA had emergency surgery. Successfully deployed to 25 Confidential America Cruiseline ships via satellite connections, 6 weeks.
• Completed a thorough analysis of software that client was co-owner of.
• Compiled recommendations in 2 stages, easy to implement (low hanging). Also more comprehensive long term goals to sustain high transactions

Confidential, Portland, Oregon

Senior DBA

Responsibilities:

• Tiered support calls
• Writing Run Books
• Writing change management requests
• Proof of concept plans
• Writing Powershell scripts
• Implementing SSIS
• Implementing changes from Development, Cert, and Production\
• Full Production Implementation and support
• TDE
• Database mirroring
• Multi node clustering
• Log Shipping
• SQL 2005, 2008, 2008R2, 2012
• Completed several projects for app based banking solutions, multiple financial institutions
• Designed migration path, clustering and disaster recovery plan for Navy Federal Credit Union
• Built SQL environment for Confidential project
• Fully implemented Confidential project

Confidential

Senior Database Consultant

Responsibilities:

• Proof of Concept design and implementation
• Extensive SQLIO performance testing
• Experience in installing and running SQL 2008R2 on VMWare
• Large migrations from DB2 to SQL 2008R2 for Siebel. Including several schemas, jobs and custom packages.
• Many experiences in doing migrations from Oracle to SQLServer, duties have included process analysis and documentation. Creation of all jobs in SQL Server that were previously in Oracle. Creation of SSIS packages to handle processes previously done in Oracle. Writing custom import and export packages to handle data conversions. Ability to find resolutions when dealing with data anomalies between SQL Server and Oracle during conversion. Conversion of batch jobs using PowerShell in many cases.
• Comprehensive documentation, run books and power point slides
• Skill in doing Oracle Migration Assessments
• Experience in writing PowerShell scripts
• Limited experience with Azure and Cloud computing with Confidential

Confidential

Database Architect

Responsibilities:

• Gathering information for analysis on business requirements. Creating dataflow diagrams, database design using ER/win, data dictionaries and writing all stored procedures and triggers for database.

Confidential

Database Architect

Responsibilities:

• I was a sub-contractor for Microsoft to Boeing. My main focus was converting a large number of databases from SQL 2000 to SQL 2008R2.
• The goal was to help Boeing DBA’s convert their DTS packages to SSIS.
• I worked with a Microsoft consultant creating and presenting talks on various subjects concerning moving DTS to SSIS. I wrote the guidelines and runbook for the Boeing DBA’s.

Confidential, Seattle, WA

Database Architect

Responsibilities:

• (2+ TB)
• SQL 2005
• Writing stored procedures(T-SQL)
• SSIS
• Performance tuning
• Capacity Planning
• Disaster Recovery Planning and Testing
• Tier III Production Support

Confidential, Seattle, WA

DBA

Responsibilities:

• (4+ TB)
• SQL 2000, SQL 2005
• Writing stored procedures(T-SQL)
• ETL processing
• DTS
• SSIS
• Database Design(Erwin)
• Tier III Production Support
• Performance tuning
• Capacity Planning
• Disaster Recovery Planning and Testing
• Sliding Partitions
• Implemented active - active clustering
• Responsible for data layout on SAN

Confidential

DBA/Database Developer

Responsibilities:

• (4+ TB)
• SQL 2000, SQL 2005
• Writing stored procedures(T-SQL)
• ETL processing
• DTS
• SSIS
• Database Design(Erwin)
• Performance tuning
• 24/7 on call Support

Confidential, Kirkland, Washington

DBA

Responsibilities:

• (3+ TB)
• Migration from SQL 7 and SQL 2000 to SQL 2005
• Converting DTS packages to SSIS packages
• Database Mirroring
• Writing stored procedures(T-SQL)
• Database Design(Erwin)
• Database Development
• Performance tuning
• 24/7 on call Support
• Tier III Production Support

Confidential, Seattle, Washington

Lead Database Architect

Responsibilities:

• (3+ TB)
• Data Warehousing
• ETL Processing
• Writing stored procedures(T-SQL)
• Database Design(Erwin)
• Database Development
• Sliding Partition Schemes using SQL 2005
• NOC Evaluations
• SQL Server Tool Evaluations
• Performance tuning
• 24/7 on call Support
• Tier III Production Support