SUMMARY

• MS SQL Server DBA working in Microsoft Practice unit of Confidential
• 16 + years of work experience in IT Services industry and 7+ specifically with RDBMS supporting OLTP SQL Server databases as a production support DBA including some SQL development work and OLAP (SSAS) cube production support
• Microsoft certification in best practices for managing SQL server databases including best practice for data recovery in a disaster, security administration, replication, High availability group/Always On, Windows Failover Cluster, mirroring, log shipping, architectural design based on requirements, performance, and other practices. Resourceful in harnessing dynamic management views, extended events, profiler and other tools to acheive the best outcome for trouble shooting problems or solving performance issues
• Excellent flexibility and team skills
• Participates in industry conferences and user groups for best practice decision - making and collaboration on difficult problems (helping others and taking help) and creative problem solving

TECHNICAL SKILLS

RDBMS Experience: SQL server 2016/2014/2012/2008 R2/2008/2005

Monitoring tools: Quest Spotlight and Foglight, Solarwinds Database Performance Analyzer for SQL Server and IPMonitor, Idera Diagnostic Manager, AdeptSQL

PROFESSIONAL EXPERIENCE

Confidential, Denver, Colorado

SQL Database Administrator

used: SQL Server 2016/2014/2012/2008 R2/2008

Responsibilities:

• Played role of production support DBA providing 24/7 production support to crucial OLTP systems with more than 37,000 prod servers on standalone/clustered, mostly high availability group/Always On servers, physical/virtual environment
• Made changes to Always on/High Availability Groups, failed over AG, and trouble-shot AGs
• Performance tuned slow servers
• Joined critical outage calls to trouble-shoot essential application and database issues

Confidential, Denver, Colorado

SQL Database Administrator

used: SQL Server 2008

Responsibilities:

• Administered, configured, and supported over 300 operational databases in each of the QA, development, and production environments.
• Installations include two-node active/active cluster, log shipping, TDE, filestream, spatial features of SQL Server with spatial indexes, triggers, stored procedures monitored by Solarwinds
• Stopped SQL injection hacking on large-datatype columns that had been disrupting business operations.
• Utilized profiler trace to research the problem
• Wrote code for collation translation since SaaS database converted from Oracle was required to be in different collation than the rest of the servers
• Set up Filestream on new server.
• Filestream group contained GIS maps

Confidential, Denver, Colorado

IHD Engineer

used: SQL Server 2008, 2008 R2

Responsibilities:

• Resolved issues and closed tickets involving replication, cluster, security, deadlocking, and other issues for fortune 100 companies using perfMon, Profiler, etc.
• Supported SQL Server Analysis Services (SSAS) for applications that involved taking phone calls, converting phone data to XML / text data (voice-to-text) and running data analytics, KPI, on voice calls
• Administered, configured, and supported operational databases, data warehouse, SSIS, SSRS and SSAS cubes for analytical processing off of the data warehouse.
• Installation includes multi-site, replication, clusters, and high availability.
• OLTP environment includes partitions, triggers, stored procedures, XML data fields. Also supported Crystal Reports, OLAP, MDX queries, and XMLA queries
• Created large number of knowledge articles for sharing information

Confidential, Denver, Colorado

Database Administrator

used: SQL Server 2008, 2008 R2, and SQL 2012

Responsibilities:

• Supported more than 120 servers (MySQL and MSSQL), several mirrors, RCSI (read-committed-snapshot-isolation-level implementation added to reduce blocking), table compression, log shipping, clusters, service broker, triggers, CLR assembly, database snapshots, SSIS, SSRS, SSAS as production and project DBA supporting lab and SOX-compliant and Idera- supported production environments
• Collaborated with software-as-a-service (SaaS) vendor to define requirements and install new database
• Utilized SSIS 2012 deployment feature SSISDB
• Set up High Availability group / Always On feature using SQL 2012 (development environment).
• Unlike mirror, secondary replica can be used for reporting directly without snapshot.
• Created jobs and Powershell code to sync server-level objects to mirror and log-shipped DR servers using PowerShell SMO to script the server-level objects
• Administered MySQL including restores/refreshes and security grants
• Installed and configured SQL Server and installed service packs
• Reviewed code and deployed to production for SQL Server, SSRS, SSAS, and MySQL in highly-controlled change management environment

Confidential, Louisville, Colorado

Database Administrator

used: SQL Server 2005 and SQL Server 2008 R2

Responsibilities:

• Responsible as production DBA for environment with more than 15 servers, over 150 databases, 5 Terabytes of data, with approximately 1 Terabyte in production, replication, column-level encryption, log shipping, multi-node clusters, service broker, CLR (C#.NET assembly), SSIS, Maintenance Plans, linked servers
• Performed server migration from old hardware to new hardware with no data loss including SSIS packages, server-level objects, service broker endpoints, maintenance plans, and databases
• Refreshed non-production environments with production data including cleanse social security number
• Fixed column-level encryption scripts and worked with security certificates, asymmetric and symmetric keys, and master key
• Documented replication and service broker processes
• Responded to Quest monitoring tool alerts and fixed failing SQL jobs
• Weighed architectural options to boost performance.
• Implemented transactional replication in production with push subscriptions, a central distributor, and DDL change propagation.
• Finished product ran with low latency and stored procedures executed and column unencrypted for use on the other (replicated) end
• Installed and configured SQL Server on a Windows cluster, modified TSQL scripts. Utilized subversion for

Confidential, Louisville, Colorado

Contract Database Developer/Administrator

used: SQL Server 2005 and 2008

Responsibilities:

• Cleansed data, de-duplicated data, added constraints, ensured data integrity source control of code
• Utilized SSIS to do ETL of data

Confidential, Lakewood, Colorado

Senior Database Administrator

used: SQL Server 2005

Responsibilities:

• Wrote TSQL scripts, employed SSIS to manipulate data, solved reporting needs

Confidential, Broomfield, Colorado

Technical Support for Developers

Responsibilities:

• Provided technical support for UML modeling company to Java developers, software architects, business analysts, and others for issues involving MySQL, Java, XML, data modeling, Access database, Apache Tomcat, JDBC, Entity-Relationship data model (ERD database model) code forward and reverse