SUMMARY

• Over fifteen years of experience as a SQL Server Database Administrator which include the administration of all versions of sql server and the design of the sql architecture for Databases, SSIS, SSAS, and SSRS environments.
• In depth understanding of the SQL Server Query and Relational Engine their components and internal processes.
• Extensive understanding and experience on how to identify, research and develop solutions to database performance issues correctly and in a timely manner.
• Extensive knowledge of SQL Server indexes there use associated issues and how to troubleshoot those issues by using execution plans, Profiler Traces, Statistics DMV’s and other third party tools.
• Extensive experience in using Performance Monitor, SQL Profiler, SSMS, System Monitor Extended Events and other third party tools to identify long running queries, blocking, deadlocks and other performance bottlenecks.
• Over fifteen years performing all aspects of database backup and restore operations on all versions of MS SQL Server including FULL, Differential, Log, File, Partial, Copy Only backups and the associated restores.
• Over ten years of hands on experience in SQL Server Clustering (multiple as well as single node configurations), Replication (transactional, snapshot and merge), Log Shipping, Mirroring and Large Table Partitioning.
• Over fifteen years of hands on experience with SQL Server security aspects such as maintaining database authentication modes, creation of users, creation of logins, configuring permissions, assigning roles to users, creating schemas, creating proxy accounts and implementing security certificates.
• Proven ability to manage environments which consist of anywhere from 5 to 2600 servers and applying patches and service packs to keep all SQL instances / versions at current patch levels.
• Extensive knowledge of C# along with the ability to use SMO to automate any SQL Server task.
• Proven experience in installation and configuration of SQL Server 2000/2005/2008 R2 and 2012.
• Proven track record of working with large database teams to support large service oriented companies using ticketing systems and supporting 24X7 on call rotations.
• Extensive experience in communicating and coordinating with offshore database and applications teams to support the mission regardless of the time zone.
• Well verse in the use of ticketing tracking systems and password and account tracking software as well as an advance level of understanding on how to connect to and work with remote database systems.

PROFESSIONAL EXPERIENCE

Confidential, Jupiter, FL

Senior SQL Server 2012 Database Administrator

Responsibilities:

• I was contracted by Confidential to assist IBM with a large (2600 server) client and asked to implement environment (six distinct domains) wide automations for all aspects of SQL Server which included performance and to review the overall architectural layout of the SQL systems for improvements.
• I Implemented SQL RML data capture/replay to support replay/testing of performance issues. Then I implemented a performance website to consolidate all performance metrics into one central performance reporting portal.
• Provided daily recommendations on the creation of indexes and other performance enhancing auxiliary objects for implementation in production environments based on the timeout and or the long running of SQL queries and transactions.
• Monitored production systems for the existence of parameter sniffing by the sql server query engine and developed coding practices to resolve these issues when identified. This resulted in an overall performance increase of 69% in stored procedures on the measured servers and SQL Server Agent Jobs that used stored procedures.
• Directed the architecture/construction of 22 Single and Multiple Node SQL Clusters and installed over 80 SQL Server 2008 R2/ 2012 production, development and QA instances. Developed and implemented SQL Installation Standards to ensure that all installations of SQL Server were installed the same across all environments.
• Developed and deployed High Availability solutions using SQL Server Clustering, Mirroring, Log Shipping and Replication, creating 22 single and multiple node clusters.
• Developed guidelines for partitioning and archiving of production data to assist in managing disk space and performance for over 160 VLDB’, resulting in the reorganization of over 700 Terabytes of data.
• Provided guidance and training for database developers regarding the standardization of all production code. Conducted training classes for developers and DBA’ on such topics as correct creation of indexes to support DML operations and how to eliminate possible parameter sniffing.
• Trained and developed junior DBA’ and developers on the new TSQL components of SQL 2012 as well on advanced subjects as the MERGE, EXCEPT, INTERSECT and CROSS APPLY statements.

Confidential

Senior SQL Server 2012 Database Administrator

Responsibilities:

• I was contacted by the CEO of Confidential to assist the company in closing down their systems. Confidential had over 200 SQL Server systems and associated hardware.
• I established a hard backup policy for all production database systems and developed SSIS packages to backup systems as of a specific date and then take the databases offline where appropriate. The hard backups consisted of the backup files along with information pertaining to the number and type of records for each individual table.
• I used SQL SMO in a C# script object inside an SSIS package to script the creation of all database objects which would then programmatically be added to the code repository for historical reference along with the location and information pertaining to the specific backups. Ensured that all historical versions of the databases where encrypted and that the encryption keys where stored off site for future use.
• Developed an SSIS package to record specific information about all database servers their configuration and purpose. This information was used to create a decommission spreadsheet which was used to control the sequence of the system closures and the reporting of total company assets.
• Developed a reporting environment to allow specific senior managers to view the progress of accounts and assets as they were being closed out. Developed a myriad of multipage complex reports from production databases to ensure that all accounts where closed and that all funds and assets associated with each account were accounted for.
• Developed complex SSIS packages to ensure that customer accounts where zeroed out and that all assets associated with each account were either place in liquidate status or returned to the customer status.
• Provided daily updates to the CEO on the progress and current status of the systems shutdown and provided him with a list of all closed systems and the expected date and time for the closure of the remaining systems.

Confidential, Melbourne, FL

Senior SQL Server 2008 Database Administrator

Responsibilities:

• I was contracted by Confidential to provide emergency assistance as a SQL Server Database Administrator.
• Immediately I established enterprise level backup and recovery procedures to guarantee 24X7 recovery ability for all production and critical development database. I also established backup and recovery techniques to ensure that all of the company’s cubes and reporting databases where backed up and recoverable.
• Developed automated scripting techniques using SSIS packages to script out all of the development databases with timestamps to ensure recoverability of development database data structures and database development code in case of a catastrophic event.
• Accomplished the Dynamics AX Upgrade for the enterprise. Ensuring that all supporting roles, cubes, KPI’s and reports where upgraded and tested.
• Created architectural designs and requirements for the new Confidential production application and production database servers and associated storage.
• Developed 23 SSIS packages to transfer production data to Confidential data warehouse on a nightly basis.
• Implemented and maintained SQL 2008 SSRS reporting environment for all business departments and senior management.
• Implemented SQL Server Snapshot Replication to create a reporting environment which alleviated the production database environment of supporting ongoing live reporting.

Confidential, Orlando, FL

Senior SQL Server 2008 Database Administrator

Responsibilities:

• I was engaged by Confidential to research and resolve the performance issues they were having with their virtual machines and their new SAN.
• Implemented SQLIO metrics gathering to establish degraded performance between the Compellent SAN and the database VM servers which in turn established an IO issue between the SAN and the database servers.
• Implemented a production performance analysis to determine the cause of the web applications performance degradation. Reviewed current network configuration from the database servers to the Compellent SAN, and performed a rebuild of all ESX’s and VM servers which supported any production databases culminating in a 75% increase in IO throughput for the Confidential web applications.
• Implemented automated performance metrics gathering to support the rewrite of the top ten worst performing queries. Provided email notification to web application managers when a deadlock occurred in the application database to support rewriting queries which caused deadlocks.
• Completely revamped the production and development backup scenarios and implemented a twenty - four by seven full database recovery plan. Established remote backup locations to support the automation of restores from production to development.
• Developed SSIS packages to script development databases schemas into VSS automatically to support versioning control. Assisted in the development of a SQL Coding standards document to be used for consistency in TSQL code/object creation.
• Developed deployment packages for the ZC time keeping application, which include the installation of SSEE as the application backend.
• Developed TSQL code to provide full re-indexing of large (2TB) databases while at the same time mitigating log file growth.

Confidential, Palm Bay, FL

Senior SQL Server 2008 Database Administrator

Responsibilities:

• Implemented a production database performance data warehouse which was used to monitor all production instances of SQL 2000/2005/2008 the resulting data is consolidated and reviewed daily by the DBA manager for appropriate action.
• Implemented a centralized maintenance server to consolidate 385 SQL jobs. Resulting in a 42% reduction in job errors and in the DBA job error resolution timeframe.
• Developed the Standards for implementation and configuration of SQL 2008 installations and database creation which included clustered SQL 2008 installations.
• Developed and deployed to production SQL 2008 SSIS packages which emailed the on call dba’ of a database server which had less than 10% free disk space using SQL Server Agent Alert conditions and jobs.
• Supported MS Dynamics AX Reporting and Backend environments for the Communication Division. Ensuring all reporting and supporting AX Databases where tuned for performance and backed up nightly.
• Completed the requirements and the development of the MCS Data Warehouse to gather operational metric for Buoy’ in the Mediterranean Ocean. Developed the data architecture for the MCS Data Warehouse as well as the logical and physical data models for deployment of the data warehouse into production environments.
• Developed SSIS packages for data migration and data consolidation for several data warehouse systems. These packages provided metrics on files processed, record counts and exception tables which were reported to PM’s on a daily basis for remediation of errors.
• Created TSQL scripts to enable the update and or removal of user accounts which possessed unnecessary elevated privileges these scripts were executed every week to ensure compliance with HIPPA laws.

Confidential, Orlando, FL

Senior SQL Server 2008 Database Administrator

Responsibilities:

• Implemented production database performance enhancements such as nightly re-indexing of specific tables and updating of statistics which resulted in 57% performance increase in the enterprises MS CRM 4.0 application.
• Implemented a centralized maintenance server to consolidate 643 SQL jobs. Resulting in a 51% reduction in job errors and in particular job error resolution timeframe.
• Developed a migration plan which relocated 92 databases from 14 physical servers to 4 MS Windows 2008 R2 Virtual servers allowing for the redistribution of 10 physical servers.
• Implemented a High Availability Clustering Solution for MS SharePoint services consisting of a two node active\active cluster.
• Developed production ETL SSIS packages to detect and correct inconsistent production data which was then offloaded to a staging server for review by departments for correction.
• Developed Log Shipping for 42 databases to provide the enterprise with two warm stand-by servers of the organizations primary production databases.
• Performed an in depth Performance analysis of all production databases which identified and corrected several system I/O issues, hardware configuration issues as well as several issues relating to SQL Server indexes.

Confidential, Melbourne, FL

Senior SQL Server 2008 Database Administrator

Responsibilities:

• Provided daily SQL Server reports which reported the success of 120 SSIS packages that transfer Radiological treatment device metrics to SNC Diagnostic warehouse for product managers and quality control personnel to review.
• Supported four C# application development teams which use SQL Server 2008 as the database backend. Developed CLR Stored Procedures, UDF’s and Triggers as well as database upgrade and deployment scripts.
• Developed the requirements, purchased and implemented a SQL Server 2008 Enterprise Reporting Portal, supporting Accounting, HR, Manufacturing, Receiving, and Medical hardware departments.
• Created 18 SSIS Packages to transfer and clean sales data to provide the CEO and sales managers with up to the minute sales reporting data and sales related metrics.
• Configured and deployed SSRS Report Builder to allow many of the companies managers to create their own ad hoc reports.
• Designed and implemented a three node Active/Active/Active SQL 2008 Cluster to provide hardware redundancy for the internal SNC production databases.
• Provides daily support to client solutions personnel regarding the installation and configuration of all SNC SQL Server application databases.

Confidential, Titusville, FL

Senior SQL Server 2008 Database Administrator

Responsibilities:

• Coordinates with the application and network teams to ensure the timely response to and resolution of assigned database incident tickets.
• Prepared systems for shut down or transfer due to contract turnover of JBOSC to new contracting company. Consolidated several application databases on a SQL 2008 Cluster configuration, allowing the reuse of six production servers.
• Redeployed most of the nightly sql jobs to a centralized master server designed for ETL processing, resulting in a reduction of time associated with job maintenance, job monitoring and job trouble shooting.
• Developed a migration plan to upgrade from SQL 2000 to SQL 2005. Upgraded 39 SQL 2000 database to SQL 2005.
• Developed traces executed by procedures for gathering performance metrics to aid in the resolution of production performance issues which identified a large number of fragmented indexes along with out of date statistics in production.
• Provided guidance to other database administrators on policies regarding the monitoring and performance tuning of production databases.

Confidential, Orlando, FL

Senior SQL Server 2005/2008 Database Administrator

Responsibilities:

• Attended coordination meetings with vendors and application teams to ensure SQL Server requirements were established, understood, and implemented correctly. Submitted weekly status report of all projects along with the current status of the timelines.
• Created a checklist to ensure that all major components such as; IP’s both external and heartbeat, cluster group configuration, installation and configuration of MSDTC components, and logical drives where correctly configured and available prior to all cluster builds.
• Migrated 27 SQL 2000 database to SQL 2005. Developed a matrix of cross reference to assist DBA’s in rebuilding SQL 2000 DTS packages into SQL 2005 SSIS packages.
• Conducted daily maintenance and when necessary performance tuned the SQL Server 2000/2005 production databases to include SAP, PEOPLESOFT, and the Enterprise Web Portal databases.

Confidential, Melbourne, FL

Senior SQL Server 2005 Database Administrator

Responsibilities:

• Ensured that the CIO and upper level managers where briefed daily on the status of all SQL Server systems. Submitted weekly written status reports on all issues relating to backups, DTS package success/failures, and any other relevant SQL Server Production issues.
• Created DTS packages to transfer web site usage data from production database systems to the centralized SQL Server reporting environment which was used by all of the senior managers.
• Created data integration packages which consolidated data from all aspects of the company such as Finance, Construction, Architecture, Marketing, and HR to support enterprise consolidated reporting.
• Collection baseline performance metrics for all databases in production. Stored this baseline data in a performance data warehouse which was used to resolve sudden unexpected production performance issues.
• Installed and configured the Enterprise SQL 2005 Reporting environment. Created reports for internal Confidential departments and provided email delivery of all reports to senior managers.

Confidential, Jacksonville, FL

SQL Server 2000 Database Administrator

Responsibilities:

• Provided a daily status report to my manager on all SQL Server 2000 systems their backups, DTS Package success/failures as well as any pertinent information regarding SQL Server systems.
• Implemented a standard code review for TSQL to assist developers and DBA’s in the correct use of JOINS, WHERE clauses, SELECT list functions, aggregates, SARG’s, triggers and stored procedures.
• Reviewed, modified and or corrected over 163 database ETL jobs and database backups to ensure a 99% or higher nightly job success rate.
• Monitored production databases for performance issues on a weekly basis. Developed a repository of performance solutions which were tested in a nonproduction environment.
• Implemented Database Replication to facilitate a reporting environment for the Sales department, allowing reporting to be performed without degrading production performance.

Confidential, Jacksonville, FL

SQL DBA

Responsibilities:

• I was contracted by the Duval Public School system to design and implement their new SQL 2000 environment which consisted of a new SAN and three two terabyte environments, Production, Test and UAT.
• Created the VSS coding standards and implemented the VSS Repository to ensure that all code whether VB, C#, DTS Package, T-SQL or any other related database object code was securely maintained.
• Outlined and created the specifications for the enterprise SQL 2000 environments which included Production, Development, Testing and UAT. Created the detailed specifications to purchase one HP 8TB SAN for support of all SQL 2000 environments.
• Created Transactional Replication Scenario for use in replication of production database to the reporting server for real time reporting requirements.
• Created SQL 2000 Job which executed a Stored Procedure that initiated a SQL 2000 Trace. The trace captured Statement starts and Statement completions, cache misses, recompiles, table scans, amount of CPU usage, amount of memory usage and execution times which were then dumped to a performance database for review of possible performance issues for all new code being introduced into production.

Confidential, Orlando, FL

SQL Server DBA

Responsibilities:

• Created a SQL 2000 DTS Package which captured specific trace events. These where dumped into the performance database to create both a baseline for SQL 2000 production databases and to gather performance statistics.
• Established guidelines for database development and deployment processes to ensure the successfulness of production releases using VSS and other third party release applications.
• Provided training on database recovery, performance tuning, operating system configurations, SQL security, daily maintenance of servers, and configuration of SQL installation to junior DBA’s.
• Directed junior DBA’s in the creation of a master server to control maintenance and reoccurring scheduled jobs, which significantly reduced the time spent monitoring servers for failed jobs.
• Supported the Point of Sale application development process for release of the new POS system.

Confidential, Orlando, FL

SQL Server DBA

Responsibilities:

• Analyzed performance data and conducted research then developed a course to correct the performance issues. As a result of performance monitoring it was discovered that hypothetical indexes existed in the production databases and where directly effecting server performance. Removal of these indexes resulted in an immediate performance increase of 200%.
• Developed and implemented a test environment to replicate any issues discovered in production in order to test any proposed solutions into production.
• Developed and deployed a disaster recovery plan for the enterprise which ensured a 24X7 recovery scenarios.
• Purchased, configured and deployed a NAS for the use in storing local copies of database backups for quick recovery situation.
• Documented hardware and software requirement for the purchase and configuration of an Active / Active SQL Server Cluster.

Confidential, Austin, TX

E-Commerce SQL Development DBA

Responsibilities:

• Responsible for all SQL 7/2000 databases, residing on 14 servers. Developed 32 SQL databases of varying sizes using SQL Database Diagram Tools and ERWIN and VISIO software.
• Developed physical and logical database designs and assisted developers in reducing the development life cycle.
• Developed highly customized replication architecture to provide business segments with transformed and up to the minute data from production environments.
• Developed master target server configuration for centralized management of SQL server maintenance jobs, reducing the time DBA’ spent on job maintenance tasks.
• Evaluated performance traces from production environments to identify and isolate performance issues.
• Conducted testing and development of SQL 2000 Clustering test environments and created a cluster build document.