SUMMARY:

• Database professional with 10 years of experience supporting small to large, complex environments on Microsoft SQL Server 2014, 2012, 2008 R2, 2008, 2005, 2000, and 7.
• Innovative team player and strategist, instrumental in supporting organizations visions and strategies.
• Qlikview administration and development.
• Created QVWs and QVDs sourced from DataMart
• Mentors juniors and peers throughout the organization.
• Strong expertise in Install, setup, configuration, tuning, and deployments on SQL Server Instances.
• Skilled in collaborating with executives, stakeholders, and clients.
• Maintenance and support of all environments from development to production.
• Experienced in working with leaders to create strategies that meet businesses RPO/RTO and disaster recovery needs.
• Adept at various Disaster Recovery and High Availability technologies (Clustering, Log Shipping, Database Mirroring, Merge Replication, Transactional Replication, Always - On, and Service Broker).
• Proactive Database Administrator; developed automated processes, checks and measures for core administrative tasks.
• Experienced with regulatory compliance standards: PCI (Payment Card Industry), Sarbanes-Oxley SOX, and with protecting PII (Personally Identifiable Information).
• Experienced in implementing multiple encryption processes ranging from native MS SQL Encryption to multiple 3rd party tools.
• Effective Business Intelligence developer that is able to gather and interpret business requirements for delivery.
• Qlikview development of QVWs and QVDs sourced from DataMart
• Experience in designing new databases and document existing systems using data modeling tools.
• Effective process analysis, reverse engineering and documentation skills.
• Experienced in multiple full SDLC cycles using Agile, SCRUM, and waterfall processes.
• Kimball, Star-Schema support for Datamart and data warehouses

TECHNICAL SKILLS:

Database Administration: Install, Configure, design and creation of Databases, tables, views, stored procedures, triggers, functions, SQL jobs, backup, restore, indexing, security, linked servers, Recovery Point Objective RPO, Recovery Time Objective RTO.

High Availability: Log Shipping, Service Broker, Clustering (Active-Active, Active-Passive, 3 Node)

Diagnoses and Troubleshooting: Identify performance, locking, blocking, security, connectivity, logic, syntax.

Database Engineering\Development: Transact SQL T-SQL, Tables, stored procedures, triggers, functions, XML, aggregates, cursors, joins, case statements, database normalization/ denormalization, temp tables, table variables, common table expressions, and table valued functions.

Performance Tuning and Optimization: Query execution plan, SQL Profiler, Index Tuning Wizard, Windows Performance Monitor, Perfmon, SCOM (Systems Center Operations Manager).

Replication: Merge replication, Transactional replication, Service Broker.

Extract Transform Load ETL: SQL Server Integration Serviced SSIS, BCP, Data Transformation Services DTS.

Business Intelligence: SQL Server Reporting Services SSRS, Ad Hoc reporting. Datamarts, Data Warehouses using Star/Snowflake schema s

Tools: SQL Server Management Studio SSMS, SQL Profiler, JIRA, Remedy, Team Foundation Server TFS, SVN, Visual Studio, SQL Server Data Tools SSDT, Foglight, Symantec ESM.

Technologies: ASP, ASP.NET, VB.NET, MS SQL Server 2000, 2005, 2008, 2012, Merge Replication, Service Broker, Clustering (Including 3-node DB s), mirroring, Log-shipping, triggers, SSIS, SSRS, DTS

Languages: VBScript, JavaScript, T-SQL, HTML

Applications: MS Visio, MS Project, MS SQL Tools, MS Office Suite, Qlikview, Tortoise SVN, JIRA

PROFESSIONAL EXPERIENCE:

Confidential Plano, TX

Data Services / SQL Server DBA

Responsibilities:

• Installed multiple instances of SQL 2014 using automation tools
• Security remediation for hundreds of SQL Servers including Symantec ESM scanning.
• DA/DR support for Always ON, Mirroring and Replication.
• Performance, monitoring and capacity planning on multiple servers.
• Provided support for Microsoft SSAS, SSRS and SSIS tools and applications.
• Worked with audit and security teams to provide evidence and documentation for compliance and regulation. Specifically Sarbanes-Oxley (SOX)

Confidential Richardson, TX

Data Services / SQL Server DBA

Responsibilities:

• Installed multiple instances of SQL 2014 as well as upgraded multiple instances of SQL Server to 2014.
• Created SSIS packages to exchange and transform data between 3rd party companies.
• Created objects to Post to REST API’s SQL Server.
• Query tuned multiple stored procedures and tables.
• Implemented 3rd party tools such as sp Blitz for server monitoring and Ola’s maintenance solution for index, statistic and backup plans.
• Automated many processes for business.
• Instructed business on reports now available through SSRS.

Confidential Plano, TX

Lead SQL Server DBA

Responsibilities:

• Architected MS Service Broker Technology to allow for multi-site replication. Savings of 1.6 million a year to stay on SQL Server 2012 Standard
• Supported SQL Server 2008 r2, Enterprise, SQL Server Express 2012, and SQL Server 2012 Standard 24x7 on call rotation
• Troubleshoot MS SQL Server and application issues using profiler, extended events and DMVs
• Installed DML/DDL change tracking logic for data and schema changes
• Installed custom monitoring and maintenance solutions for SQL health, capacity and performance monitoring.
• Work with Network and system engineers to add addition space and storage for capacity requirements.
• Built ETL applications for Qlikview and SQL Server Datamarts. Built and deployed SSIS/SSRS and Qlikview BI solutions.
• Implemented and modified backup and recovery plans for RTO and RTO requirements
• Successfully migrated Data center from Colorado to California for new headquarters.
• Responsible for optimizing and tuning queries
• Database code deployment and release into QA and production environments
• Collaborate with report engineer on best practices for SSRS logic and performance
• Deploy database code to performance and production environments using Tortoise SVN and custom script generator application.
• Performed maintenance and patching of SQL Servers, Report Servers and Business Intelligence servers.
• Develop work-around solutions for RTB issues for business utilizing T-SQL/ SSIS and or jobs

Confidential Plano, TX

Lead SQL Server DBA

Responsibilities:

• Built, supported and maintained SQL Server 2005, 2008, 2008r2 and 2012 Enterprise, Standard and Express editions.
• Patched and updated SQL Servers for necessary service packs and releases
• Supported several environments including Development, Performance, E2E, QA and Production.
• Built Central Management Server to automate reporting and ETL applications on SQL Server.
• Upgraded and Installed SQL Server 2012 Enterprise 3-node cluster for two geographically separated sites
• Supported SQL Server 2005 Enterprise 2-node cluster for two geographically separated sites
• Designed new replication process using MS Service Broker technology.
• Optimized systems to achieve greater than 30 transactions per second (TPS).
• Product development with Agile software development.
• Implemented many solutions to assist online support team.
• Created flowcharts and diagrams to document data/ system order
• Responsible for troubleshooting MS SQL Server data and system issues
• Utilized many of the 3rd party tools for Comparing data, checking memory/cpu usage and automating maintenance plans
• Designed and advised on purging and archive strategies for business and developers
• Reviewed database design and structures for standards, performance and security
• Installed DML/DDL change tracking logic for data and schema changes
• Adhered to HA/DR requirements set for Enterprise operations

Confidential Dallas, Texas

Technology Leader, Online Services

Responsibilities:

• Implemented an Offshore strategy. Reduced payroll hours by almost 40%. Decreased days level of effort by 80% in less than six months on projects, bugs and enhancements.
• Improved client satisfaction surveys by 60%. This is a survey that clients score us on in areas of project management, satisfaction and client referrals.
• Developed and promoted Account Directors and Project Managers from internal staff.
• Recruited outside talent with expertise in specific technologies in Microsoft technologies.
• Negotiated favorable contracts with vendors and consultants.
• Migrated several clients to our SQL Server 2000 platform.
• Led project deliverables, customer expectations, change requests, scheduling, and day-to-day operations of internal and offshore development teams from initialization through implementation for .NET application development projects for top-tier educational institutions.
• Coordinated data migration from multiple client systems to PCI’s architectural design to ensure accurate data collection and delivery of powerful data.
• Developed and documented procedures, processes, and SOWs for new product deployments.
• Demonstrated live software applications to clients at company conferences, and consulted with clients to strategically improve their online communities and provide software training to their end users.
• Built relationships with clients to assist them in defining their e-marketing strategies and provide tools to improve the attraction and retention of clients’ customer bases.
• Designed, developed, and maintained online applications and databases for multiple client sites.
• Used SQL Server 2000 Enterprise Edition for supporting backend for application sites.
• Acted as technical liaison and subject matter expert for internal sales department to provide training, technical support, and consulting services on current and future product offerings.
• Utilized CRM methodologies in site design.