SUMMARY

• Have over 15 years of professional information technology experience as Senior Database Administrators/ Lead
• SQL Server Database Administrator (DBA) with extensive experience designing, coding, testing, optimizing and supporting the large databases, very large data warehouses and SQL Server environments of the last 7 versions.
• I’m proficient in performance tuning disk, indexes, queries, designing partitions, designing database SAN storage requirements and capacity planning.
• SQL Server 7, 2000, 2005, 2008, 2008 (R2), 2012 and 2014 Database Administration, SQL Server Analysis Server Database (SSAS) Administration,
• Performance Tuning & Capacity Planning, Designing Aggregations and optimizations of ad hoc queries, tables, in - memory tables, native and compiled stored procedures, Data Security, High Performance Backup & Recovery, Configuring, supporting and optimizing Reporting Server (SSRS), SQL Tuning using Business Intelligence Development Studio, Configuring SharePoint with SSRS option.
• Experience in installing, configuring and maintaining MSCS.
• Thorough testing between each step to ensure success and minimize issues due to major changes to the environment.
• Expert at configuring SSRS, optimizing and Performance Tune the versions
• Professional at addressing .NET 2.0 apps when upgrade is needed up to .NET 4.0 including CRI compatibility issues
• Assisted in planning, designing and configuring VMWare Vsphere 5.5 HA Cluster configuration and tuning with SQL Server to be fully virtualized (not counting tempdb that is stored on SSD)
• Add value to SAN Storage configurations with other teams essential to a high performing SQL Server Instance, SSRS, and SSAS
• Created optimal Lite-speed Backups, Visual Studio / (Native and compiled Stored Procedures)
• Developed backup and recovery strategies for production environment.
• Documented disaster recovery plans and participated disaster recovery drills.
• Implementing different types of Replication Models like Snapshot, and Transactional.
• Involved in installation and Implementation of Clustering and Database Mirroring for High Availability
• Experience in Log shipping with SQL Server 2005/2008/2012 for Standby Server/Reporting capabilities
• Configured and Implemented Double-Take, Disaster Recovery Solution Expert
• Develop and train users of BI tools, Database/data security expert
• Excellent troubleshooting skills, Excellent Inter-personal skills and Proficient with Power
• Experience in installing, configuring and maintaining MS Cluster Server including planning configure and successfully testing AlwaysOn 2012/2014
• Created some and migrated other tables to In-Memory OLTP (In-memory Optimization) that were good candidates for this option
• Expert at index selection including In-memory Hash and In-Range Indexes

PROFESSIONAL EXPERIENCE

Confidential

SQL Server DBA/Lead

Responsibilities:

• Created and maintained project plan essential to knowledge transfer and Business goals monitored and met. SQL Server 2005 physical Cluster environment upgraded to a Virtualize SQL Server 2014 with VMWare VSphere 5.5. HA Cluster environment. Versions migrating includes 2000, 2005, 2008 and 2008r2.
• Over 55 Databases totaling over 750GB
• Created a performance/throughput baseline for all databases to be migrated/upgraded.
• Optimized problematic Stored Procedures for errors in logic, performance, locks and poor performing as part of establishing the second baseline. The third baseline is based on test migrations, upgrades and taking advantage of Virtualize + SQL Server 2014 many optimization benefits.
• Tested to prove moving non-sequential IO intensive writes of tempdb on Solid State Disk (SSD) vs RAID 10 physical or virtual.
• Monitoring day to day operations for errors, issues and performance issues and resolve them.
• Building High Performing Backup & Recovery solutions for the many unique uses of City’s databases.
• Used SSIS to populate data from various data sources, creating packages for different data loading operations for application, and to export data from Oracle to SQL databases.
• Configured Snapshot and Transaction Replication.
• Worked on high availability SQL Server solutions, including Log shipping, Mirroring and SQL Server clustering.
• Creation, Testing, and Implementation of SSRS packages for Reporting Services that included paper-based and interactive web-based reports.
• Experience in building adhoc reports, parameterized reports, toggle reports, reports with sub reports using SSRS.
• Performed De fragmentations Techniques of most complex indexes.
• Performed Backup and recovery & Automation of Backups using maintenance plans.
• Always ready to assist Stake Holders/ end-users day or night.

Confidential

Senior SQL DBA /Technical Coordinator

Responsibilities:

• Infrastructure projects build out planning across environments and with platform project timelines (e.g. remote site network, Citrix,etc)
• Manage threshold testing and monitoring (integration / load / performance / availability-failover)
• Ensuring High Availability preparedness / Application dependency analysis / Landscape review
• Coordination of large multi functional projects both within TPS and externally with GIS and other IT partners
• Development of platform specific detailed Release Sequencing Plans (application and database)
• Experience in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor (DTA).
• Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• Development of integrated Cross Pipeline Release Sequencing Plans (application and database)
• Export or Import data from other data sources like flat files using Import/Export through DTS, SSIS.
• To analyze long running slow queries and tune the same to optimize application and system performance.
• Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Involved in Source Data Analysis, analysis and designing mappings for data and Design/Development of SSIS Packages to load the Data from various Databases and Files.
• Migrated SQL server 2008 to SQL Server 2008 R2 in Microsoft Windows Server 2008 R2 Enterprise Edition.
• Managing On-Call platform team technical rotations, hand offs and incident reviews.
• Developing SOPs for diagnosing and triaging production issues per platform team.
• Management of cross pipeline SWAT escalation / engagement.
• Produced the quickest Software/Hardware Releases in the history of Confidential performing them.

Confidential

Sr. SQL Server Database Administrator

Responsibilities:

• Served as Subject Matter Expert (SME) and lead SQL DBA for two SQL DBA’s and nearly 100 physical and virtual servers. One resource is offshore.
• Responsible for migrating nearly 200 databases across 75 SQL Server to the new Global Data Center at the World Headquarters location in St. Louis.
• Install, configure and maintain SQL Server 2005 Cluster services.
• Performed Security Administration by creating Logins, Users, granting permissions through roles, managing Schemas,
• Monitored database performance on tables using Index tuning Wizard and rebuilt indexes to reduce fragmentation.
• Development of automated daily, weekly and monthly system maintenance tasks such as database backup and Re-indexing, update Statistics and Performed Object Level Recovery.
• Experience in capacity planning. Created custom SSRS reports to track the Database growth and volume changes on periodic basis.
• Worked with various teams for technology upgrades (.Net, IIS, PowerBuilder, Power Logic, SDE GIS, Windows Server 2008)
• Worked with Security/Firewall teams to open specific ports for SQL Server monitoring
• Created jobs, alerts, Schedules and monitor activity logs, error logs to capture and fix any possible errors.
• Configured MS SQL Server 2005/2008 in-built log shipping from primary server to standby server for report generation.
• Experience with RAID levels and SAN storage infrastructure.
• Developed disaster recovery plans and contingency systems including evaluating and recommending appropriate backup, archival software, media, hardware, and offsite storage.
• Configured Various Replication Types between servers, with separate Distributor server and experience in troubleshooting replication issues in MS SQL Server 2008/2005.
• Worked on DB Programming using stored procedures, Views functions and BAT Scripting.
• Developed various Reports using SQL Server reporting services (SSRS 2005/2008)
• Production support for over 20 Divisions of Emerson on three different continents.
• Avamar Backup Admin and Network Backup Admin
• Maintain, support, troubleshooting all issues with both SQL Server and SharePoint.

Confidential, Fenton, MO

SQL Server Database Administrator

Responsibilities:

• Served as Subject Matter Expert (SME) in the migration and support of nearly 100 medium to large scale databases, BI development and data warehouse to both the primary and backup facilities.
• Responsible for a $1.3 million dollar cost savings in designing and optimizing existing hardware and software verses buying new.
• Received three company driven performance awards for my work and cost benefit to the company.
• Developed and tested storage strategies for OLAP and OLTP applications that guaranteed high performance response times and efficient storage management.
• Developed and tested Disaster Recovery strategies for nearly 10 servers and nearly 100 medium to large databases and data warehouse.
• Worked with development team to create, test and optimized triggers, stored procedures, views, index views, tables and data warehouse cubes.
• Developed an enterprise wide Reports Server that would support 20+ users and thousands of reports that was robust and on time and budget.
• Served as Subject Matter Expert (SME) in allocating and configuring disk storage that provided high performance and high availability to all database and data warehouse servers.
• Trained end-uses on using Business Intelligence tools.
• Extensive in 24/7 production support and assisted end user in testing application functionality
• Helped Development Team in deploying and testing the application, which uses SQL Server 2000/2005 backend.
• Developed cubes, partitions, aggregations including testing using Business Intelligence Development Studio

Confidential, Sunset Hills, MO

SQL Server Database Administrator

Responsibilities:

• Major responsibility was managing over 85 database servers that comprised over 4TB of data.
• Established and documented a complete Disaster Recovery Plan for the Database servers
• Tuned SQL Server performance using SQL Server Profiler and Execution Plans.
• Developed and enforced organizational SQL standards and best practices
• Evaluated new releases of operating systems and database management software (DBMS) and suggested processes for migrating to new releases
• Participated in application development process and code reviews of database objects
• Responsible for training junior and mid-level Database Administrators.
• Contributed to enhancing performance tuning and capacity planning by designing and testing hardware configurations.

Confidential, Brentwood, MO

SQL Server Database Administrator

Responsibilities:

• Developed complex ETL solutions to move data from multiple sources to very large databases.
• Responsible for creating, testing and implementing Active-Passive Cluster nodes for a more robust high availability system for Banks, AON Warranty, IBM and Government Electronic companies.
• Responsible for building data marts and training users to create pivot tables and reports by using Excel, Analysis Services, Visual Studio, Share Point and Reporting Server.
• Developing and implementing Replications using SQL Server 2000 and SQL Server 2005.
• Developed Disaster Recovery solutions using Double-Take software for 800GB database.
• Managed the training of on-site SQL Server Database Administrator’s for various companies.

Confidential, Hazelwood, MO

SQL Server Database Administrator

Responsibilities:

• Implemented and tested SQL Server 2000 hosted on EMC and Clariion SAN for high speed Online Banking application.
• Served as project lead in the support of 100 servers and 100 databases.
• Developed DTS packages for data migration between various servers that provided a robust feed to our security group.
• Implement process and/or manage transfers of data between external data structures (e.g. flat files, Excel files) and existing databases.
• Create, test, and conduct performance tuning on SQL Server databases using Windows Performance Monitor and SQL Server Profiler.
• Develop and implement backup and recovery strategies involving complete database backup/restore, transaction log backup/restore
• Implemented and supported 4 node Active-Passive Cluster for SQL Server 2000.
• Developed high performing Backup & Recovery strategy using SAN storage.

Confidential, St. Louis, MO

SQL Server Database Administrator

Responsibilities:

• Served as project leader for all Database Functions and management.
• Monitor daily SQL jobs, event logs, error logs and performance of the database.
• Implement database standards and naming convention for the database objects
• Implement Transactional Replication for Sales Application.
• Had good experience in 24/7 production support.
• Create Document for Transactional Replication and production change requests.
• Manage replication and database modifications for replicated objects
• Design, document and implement complex DTS packages and stored procedures.
• Test and implement SQL Server 2000 SP4 to the existing SQL Server infrastructure.
• Support and troubleshoot as required, optimize performance and resolve production problems.
• Investigate and resolve SQL process issues using various SQL commands.
• Developed Replication for our Online Trading application for use by our remote sites.

Confidential, St. Louis, MO

Project Leader for Applications Development & Database Administrators

Responsibilities:

• Responsible for training all junior Visual Basic, SQL Server 7.0 and Oracle 8 developers and DBA’s.
• Configured Log shipping to Stand-by servers to provide Disaster Recovery.
• Using DTS packages of SQL Server to populate data from various data sources.
• Monitor daily SQL jobs, event logs, error logs and performance of the database.
• Installed SQL Server Reporting Services and SQLXML Services which provided xml data import utility to SQL developers for various systems.
• Created documentation to install SQL Server, hot fix and clustering installation.
• Used BCP to transfer the data from summary tables to flat files.
• Created & configured Snapshot, Transactional & Merge Replication.
• Enhanced end-users understanding of database systems in a client-server environment.