Sql Server Support

Reginald E. Burns

***** ********** *******, ***** *****

Hm: 281-***-**** Cell: 832-***-****

************@*****.***

SUMMARY

Twenty years of experience in the IT field with emphases as a Business Analyst, a System Analyst, DBA and a Storage Consultant and an Architect in the Computer, Legal, Oil and Consulting Industry. Experiences are in development, test, implementation, support, back-up and recovery of DR, SQL Server Databases, Oracle Databases, Storage Area Network configurations Network Attached Storage configuration, Virtualization for Consolidation and Containment of Hardware.

PROFESSIONAL EXPERIENCE

HCL Consulting: Entergy Corp Nov 2015- Present

SQL Server Special Projects DBA

Work remote/onsite for Entergy Corp as a SME for SQL Server Special Projects to Upgrade, Migrate and Decommission SQL Server environment

Migrate or upgrade databases and ssas cubes from old environment to new environment

Implement Maintenance plans onto new SQL Server environment

Modify and or Edit cloned jobs (ETL and SSIS)

Manage and security for new environment

Create Backup jobs with Commvault

Document process and scripts for cloning environment

Assist application admins with creating connections to new environment

Created and mange new Dev/Test/Prod environment

Created SSRS environment

Document new infrastructure and environment

Work with vendors with deploying new tools for environment

Assist the operation support sql server team with service tickets

Presented as SQL Server SME for certain Special Projects

3Coast: Jonas Fitness

Sr. Consultant July 2015-Oct 2015

Work remote/onsite for Jonas Fitness as a SME for SQL Server to migrate and clone SQL Server environment

Mirror SQL Server environment from one Storage configuration to new Storage configuration

Migrate databases and jobs and logins to new Storage configuration

Implement Maintenance plans onto new SQL Server environment

Modify and or Edit cloned jobs (ETL and SSIS)

Manage and security for new environment

Document process and scripts for cloning environment

Assist application admins with creating connections to new environment

Document new infrastructure and environment

Modis Consulting: Exterran/RemainCo

Sr. Consultant April 2015-June 2015

Work remote/onsite for Exterran as a SME for SQL Server to migrate and clone SQL Server environment for spin-off company (RemainCo)

Migrate SQL Server environment from Parent Company (Exterran) to spin-off company (ReMainCo)

Clone databases and ssas cubes from parent domain to new domain

Implement Maintenance plans onto new SQL Server environment

Modify and or Edit cloned jobs (ETL and SSIS)

Manage and security for new environment

Document process and scripts for cloning environment

Assist application admins with creating connections to new environment

Created new Dev/Test environment

Created SSRS environment

Document new infrastructure and environment

Addison Consulting DNow (Distribution Now)

Sr. Consultant Oct 2014 – March 2015

Work remote/onsite for DNow as a SME for SQL Server and assist support for Storage infrastructure

Support the Test, Dev, and Production virtualized infrastructure of the SQL Server environment

Migrate SQL Server environment from Parent Company (NOV) to spin-off company (DNOW)

Discover or identify infrastructure design issues

Build POC for SSAS environment

Patching and Maintenance of Servers using SCCM

DB refresh as requested

Manage different environments (Mirroring, Clustering, All-Ways-On)

Architect Storage and SQL Server Database environment

Close assigned support tickets

Implemented SSAS environment

Support of the SSIS ETL scheduled jobs

Edited SSRS reports

Investigate 3rd party support and management tools

Investigate and diagnose Blocks and or Locks

Migrate code to production environment

Clone Production Databases

Backup support for Oracle DBA

Monitor the health of SQL Server environment with Monitoring tools(SCOM, Quest)

Completed Implementing Data Warehouse with MS SQL Server 2014 Boot-camp at CTREC IT Academy

Deloitte Consulting (Transocean LLC)

Sr. Consultant April 2014 – Jan 2015

Work remote/onsite for TransOcean as a SME for SQL Server and assist support for Storage infrastructure

Support the Test, Dev, and Production virtualized infrastructure of the SQL Server environment

Backup Support of the EMC and Compellent Storage infrastructure

Backup Support of the Physical and Virtual infrastructure

Discover or identify infrastructure design issues

Build POC

Architect Storage and SQL Server Database environment

Assist with migrating environments to Cloud Computing

Close assigned support tickets

Create IT management reports

Investigate 3rd party support and management tools

Migrate code to production environment (SSIS, SP, TSQL Code)

Clone Production Databases

Patching and Maintenance of Servers with SCCM

Monitor the health of SQL Server environment with Monitoring tools(SCOM, Quest)

Manage different environments (Mirroring, Clustering, All-Ways-On)

Investigate and diagnose Blocks and or Locks

Backup Support for Oracle DBA

DB refresh as requested

Cephei Technology Group LLC Nov 2007- March 2014

Sr Consultant

Worked with partners and clients (ie DiversiTech, AIG, Rail-Road Commission, Grocery Supply, Consolidate Wealth Holdings, National Practitioners Clinic ”NPC”, Bourque Data Systems “Exxon hosted database”, Matthew Goff Investments, Houston Casualty Company, US Legal Support, ExtremeTix, Equivalent Data E-Discovery, Diversi-Tech). Travel to Client Sites for Consultation, Assessment, Installation, Implementation and Maintenance of Microsoft, Oracle, and BI software on Windows platform.

Create End Of Engagement Reports for engagements

Architect designed and deployed Cloud Computing infrastructure with virtualization techniques

Setup Clustering for Failover

Implement and or Migrate client/server infrastructure to Cloud Computing

Create LUNS from NetApp Storage Device

Assign Drives to MountPoints of NetApp Storage Device

Maintain and Support SQL Server 2000-2008R2 Standard and Enterprise infrastructures on physical and Virtual servers

Maintain physical and VM infrastructure

Support for the Data Warehouse environment for GSC( SSIS support and migration of new SSIS code)

Migrate Database environments and infrastructures

Clone Databases from old environment to new environment

Upgrade SQL Server from 7,2000,2005 to 2008R2 and 2012 Enterprise version

Build POC for testing application features and Database Performance

Setup Performance Monitoring Metrics for Performance Tuning (Database, OS,TSQL and Storage Tuning)

Implement Disaster Recovery Plan for Database

Give knowledge transfer to Clients IT dept for supporting environment.

Use Quest Spotlight to monitor and perform health checks of 1000’s of Cloud SQL Databases and Data Warehouse databases

Use Quest to manage and migrate Active Directory objects

Use SonaSoft and Quest SQLSafe for Disaster Recovery configuration

DELL COMPUTER CORPORATION Apr 2005-Nov 2007

Field Technical Consultant

Travel to Client Sites (ie Exxon, Harris County Court, Texas A&M, Ok State Univ) in a 5 state region for installation, implementation and maintenance of Dell hardware, EMC hardware, on Windows or Linux platforms.

Rack, stack and cable Dell and EMC hardware.

Setup network and fibre network for SAN environment.

Create Raid Groups, Storage Groups and LUNS.

Create Zones for access new storage.

Assign storage mount points to nodes

Setup Tape Backup system.

Setup Clustering for Failover

Maintenance SAN environment

Implement Microsoft SQL Server Clustering

Give knowledge transfer to Clients IT dept for supporting SAN.

Create End Of Engagement Reports for engagements

Continue studying, training, and testing for building knowledge of new technologies.

GLOBAL INDUSTRIES INC. Houston Texas Jan 2005- Apr 2005

SQL Server DBA

Support for Production, Test and Development SQL Server 2000 Databases and LAWSON ERP administrator.

Daily Support and Administer task for Production, Test and Development SQL Server databases.

Created backup process for on-shore production databases.

Refresh Test and Dev environments.

Implement Replication of Push and Pull from Corporate to Mobile databases

Implement Link servers for querying sources databases

Use SSIS to create Import and Export packages

Install, Patch, and Administrator SQL Clusters

Setup Performance Monitoring Metrics for Performance Tuning (Database, OS, and Storage Tuning)

Implement Disaster Recovery Plan for Database

Implement SQL Server Backup Plan and schedule

Manage user access for LAWSON ERP application.

Assist with investigating and answering Auditing process.

PERFORMACE TUNING INC, Houston, Texas Jul 2003-Nov2004

Performance Consultant

Travel to Client Sites ( ie Pentagon, Quonaco “FBI HQ” Welches HQ, La Tech)for installation and tuning of Oracle 9iRAC or Microsoft Cluster and Storage Configuration

Setup and network hardware for Oracle 9iRAC or Microsoft Cluster configuration.

Install RedHat Linux OS and patches, tune the OS for optimum performance.

Install Oracle 9i Advance Server or Microsoft SQL Server software and patches.

Create SEED database.

Setup Clustering for Failover, Pre-connect or Load-balancing.

Setup Dell/EMC SAN and SCSI Storage Systems.

Migrate SQL Server 7 to SQL Server 2000

Give formal knowledge transfer to Clients IT dept for supporting Cluster.

Perform data migration for Oracle and Microsoft database.

Publish White Papers for advertisement and Client usage.

Hewlett-Packard Corp – assist the Database Performance Engineering Group with the

setup, installation and configuration of 9iRAC 10G RAC, DB2 and SQL Server, Storage Area Networking (Fibre and SCSI technology)

for Performance and Benchmark testing of TPC, on HP equipment.

PARKER DRILLING INC, Houston, Texas Jun 2002-Jul2003

Systems Analyst /DBA

Perform all System Analyst duties. Also performs Oracle/SQL Server Database Administration.

Integrate, support and maintenance of Object Oriented client/server Applications.

Design, implement and modify new and existing Reporting systems with Oracle 9i backend.

Support and administer MS Biztalk Middle-ware and EDI for B2B transmission.

Development and maintenance of database backup and recovery plans for SQL Server 2000.

Refresh Test and Development databases for Oracle 8i and SQL Server 2000.

Import and Export database to database using DTS.

Migrate data from legacy database system to new Oracle 9i and SQL Server 2000 databases.

Truncate, rebuild, and update Oracle 8i tables.

Manage table space for Oracle 8i Databases.

Replicate databases in SQL Server 2000.

Install, setup and maintain SQL Server 2000 and Oracle 9i Instances.

Administer all task needed with Oracle Enterprise Manager.

Maintained Connection Manage

COMPAQ COMPUTER CORPORATION, Houston, Texas Jan1995 – Jun2001

Business System Analyst II 2000 – 2001

Developed, tested and implemented batch programs for Worldwide Service Logistics Planning and Forecasting application.

Created, tested and implemented batch scripts and schedules based upon the business logic or business requests.

Provided system administration for of worldwide Planning and Forecasting application.

Documented batch scripts and schedules.

Backup and recovery of Oracle 8i Database.

Refresh Test and Development Databases

Create Oracle 8i SQL queries for reporting.

Administer all task needed with Oracle Enterprise Manager

Business Analyst I 1999 – 2000

Ensure a quality web application for all of North America’s Service Providers.

Created business reporting tool with Access97 and Visual Basic.

Analyzed and proposed Internet/Intranet business requirements for web application.

Conducted test scripts to ensure quality assurance.

Facilitated training to end users.

Trouble shot web application.

IM System Administrator and Jr. Database Administrator 1996 – 1999

Policed and maintained Computer parts Inventory Database, and ISO website.

Maintained SQL Server Inventory database.

Serviced and created Access97 databases.

Support and Maintenance client/server Corporate Application with upgrades, patches and diagnoses.

Product Support Representative 1995 – 1996

Offer knowledge to clients of Compaq’s commercial and consumer line of products.

Trouble shot hardware issues.

Resolved customer complaints and raised satisfaction levels.

INTERNSHIPS

Dell Computer Corporation, Austin, Texas 1993 – 1994

Sales Consultant

Supply information to clients about hardware, software and network configurations.

International Business Machines, Austin, Texas 1990 – 1993

Test Operator

Executed test scripts for electrical failures and environmental failures on computer hardware.

EDUCATION

Bachelor of Arts, Computer Science

Huston Tillotson University, Austin, Texas

Quick-Strike Learning Institute, Woodland Texas for Oracle

TechSkills Learning Center for SQL Server

CTREC Bellaire Tx, Implement Data Warehouse Infrastructure

PROFESSIONAL DEVELOPMENT

Windows 2000,2003 and 2008 2012 Administration

Oracle 9i and 10G 11G Database Administration

SQL Server 2k, 2k5 and 2k8 2k12 Administration

Red Hat Linux Administration

Unix Administration

EMC SAN Certified

MCP Certified

Working on MCDBA Certification

TECHNICAL SKILLS

Hardware: EMC Storage, NetApps NAS, Equalogic Storage, Tape Backup, Dell, HP, IBM, Compaq, DEC servers

Software: ORACLE 10G and RAC, MS SQL Server and Cluster, SCCM, SCOM, Orchestrator, VMWare, Hyper-V,DTS, Quest TOAD, Spotlight, LiteSpeed and Foglight, Idera, SonaSoft, SQL Admin tool-set, Citrix, Switch Zoning, MS Biztalk, EDI, C++, ASHWIN Scheduling, ERWIN/ERX, VBA, Access97, FrontPage98, ASP, XML, HTML, Homesite, JOUST, Dreamweaver 2.0

Operating System: NT, 2000, 2003, 2008, 2012,XP, Vista, OS/2, Unix, Red Hat Linux, VMWare, HyperV

Contact this candidate