SUMMARY

• Twenty years of experience with MS SQL Server stack including hands on with SQL Server Database architecture and Relational database concepts.
• Operations and Production support including SSIS/SSDT and SSRS. Some experience with MySQL, Confidential PL/SQL scripting and SQL Server DW.

TECHNICAL SKILLS

• Advanced MS SQL Server T - SQL Programming (stored procedures, functions, CTEs, triggers and dynamic SQL) in support of OLTP/OLAP applications.
• Database Physical and Logical Design.
• Performance optimization with execution plans, Profiler, Extended Events and Performance Monitoring and Tuning Tools.
• Database Administration including backup plans, capacity planning and SQL Server Agent job scheduling.
• Familiar with SQL Server Clustering, Database Mirroring Replication and Log Shipping.
• Experience with Windows Server Domain Administration, Foglight, Red Gate Continuous Integration, Virtualization; MySQL WorkBench, VBScript some PowerShell

PROFESSIONAL EXPERIENCE

SQL Server Senior Production DBA

Confidential

Responsibilities:

• Formally DiscoverReady the two companies combined in 1/2019.
• Senior Production DBA in a 24/7/365 international 300+ instance multi-terabyte production environment primarily supporting the Relativity EDiscovery platform.
• SQL Server production support, installations, upgrades, database migrations, database backups, high availability and disaster recovery preparedness.
• Instance and database optimizations including Index and statistics maintenance and optimization.
• Scheduled SQL Server Agent jobs and alerts.

SQL Server Senior Production DBA

Confidential

Responsibilities:

• • Senior Production/Operations DBA in a 24/7 international multi instance multi-terabyte production environment.
• • Advanced Query optimization as well as index analysis and best practice.
• • Introduced advanced coding concepts and table view partition elimination.

SQL Server Developer DBA

Confidential

Responsibilities:

• SQL Server Developer DBA for this midsized B2C. Duties include change control/code promotion in a Red Gate continuous integration environment.
• DB physical/logical design, complex code design, integration with a large legacy code base
• 24/7 VLDB/VLT operational support including performance trouble shooting, monitor and investigate SQL Agent jobs; implement role based security.
• Database backups and restores and replication.

SQL Server Database Engineer

Confidential

Responsibilities:

• Fox Entertainment Group SQL Server 2012 Database architecture, development and ETL for an enterprise level multi portal internet platform. Duties included writing complex SQL including Confidential pass through queries.
• Disney - ABC Television Group SQL Server 2012 Database architecture for a multi-platform Data Driven Work Flow web app. Duties include physical design, TSQL optimization, change control, trouble shooting, back up and instance optimization. Contract ended 10/2013.

Software Engineer

Confidential

Responsibilities:

• SQL Server 2008R2 database development.
• Apply advanced stored procedure optimization techniques using SQL Server profiler, DMVs, Trace Flags, Execution plans, Set statements SQL debugger and Extended Events.
• Innovate VLT (1+ billion rows)/VLDB (4.5TB) analysis, query performance and indexing optimization and partitioning solutions.
• Build SSRS reports and implement SQL Server Service Broker solutions.
• Install and Provision SQL Server in dev and test environments.

T-SQL & Consulting

Confidential

Responsibilities:

• •T-SQL and BI consulting to this world wide prepaid cell phone service provider.

Production DBA

Confidential

Responsibilities:

• SQL Server Production DBA/Domain Admin for this international Bank.
• I provided 24/7 production support in a multi-instance, 7+ terabyte data environment.
• I built complex SSIS packages, developed maintenance plans backing up system and production databases for point in time recovery.
• Provisioned Microsoft SQL Server 2005, 2008 and installed service patches.
• Involved in Change Management/Incident Management Process.
• Scheduled SQL Server Agent jobs and alerts and managed user access with SQL Server roles and permissions in a clustered environment.
• Verify backups and error logs on the servers and troubleshoot any failures or alert problems using Perfmon and SQL Profiler, supported an SSAS data warehouse.

Contractor DBA Digital IT

Confidential

Responsibilities:

• SQL Server Database Developer for this world leading live entertainment Confidential .
• Database physical and logical design, T-SQL and stored procedures, tables and views, performance optimization, ETL, and Sales/Marketing analysis.

Confidential

Responsibilities:

• Source Link - SQL Server 2000/2008R2 T-SQL and ETL development in support of a Data Warehouse multi server/multi-terabyte environment. I participated in logical and physical database design for new initiatives. Contract ended 8/2010.
• Creative Channel Services - SQL Server 2005 T-SQL, SSIS development and physical database design for a B2B eCommerce application. Contract ended 1/2010.
• MDCare Confidential - SQL Server 2005 installation, development and administration including CMS RAPS claims quality control and automation. I made recommendations on system hardware implementation. Contract ended 9/2009.
• TrailerPark.com - SQL Server/MS Access 2005 development; create and extend a 2 tier application for TrailerPark.com. Contract ended 6/2009.
• Warner Brothers Studios - Table design and input form development. Contract ended 1/09.
• CHLA Research Institute - Application development and intranet scripting.

Staff Programmer

Confidential

Responsibilities:

• SQL Server 2005 Data Warehouse development for IMS’ client, VF Corp.
• Database physical and logical design.
• Developed SSIS packages to load a high availability Datamart.

SQL Server Database Architect

Confidential

Responsibilities:

• Lead SQL Server 2005 database developer/DBA for an internet publisher.
• Responsible for performance tuning, maintenance plans and resolving deadlocks and contention in the databases.
• Responsible for writing complex T-SQL, XML Xquery and SSIS for ETL.

Confidential

Responsibilities:

• Cliffwater, Confidential - I Built a full data cycle OLAP/OLTP SQL Server backend/MS Access frontend/MS Excel reporting application for this well funded boutique hedge fund. Contract ended 5/2007.
• Confidential, Confidential . - I Built an OLTP/OLAP SQL Server/MS Access application for a midsize specialty manufacturer using T-SQL, Jet SQL and VBA. Contract ended 11/2006.
• Senior Production DBA
• Confidential, Confidential .
• As Lead SQL Server Developer/Production DBA for this internet retailer I administered a multi-server/multi-database environment for both OLAP and OLTP processes.
• I managed SQL Server logins and users, query performance tuning, physical database design, managed maintenance plans and resolved database contention and deadlocks.
• I designed DTS packages to perform ETL.
• I wrote complex SQL stored procedures, advanced queries, triggers, views, indexes, and functions for databases that Integrated Epicor CRM WMS with SQL Server.