OBJECTIVE:

• Corporate Professional SQL Server DBA with 18+ years of experience. Seeking an opportunity to apply my professional experience as a SQL Server DBA to an excellent & thriving organization.

TECHNICAL SKILLS:

Skills: SQL Server DBA 7.0/2000/2005/08/12 SQL TSQL Oracle DBA Windows NT through 2008 Linux SQL Server Clusters SQL Server Replication Data Warehouse/ETL (incl. DTS/SSIS) Stored Procedures Triggers Data Modeling/Data Architecture

PROFESSIONAL EXPERIENCE:

Confidential - Atlanta, GA

Senior DBA/Database Architect and Performance Engineer

Responsibilities:

• Perform database design work and predictive performance testing of database systems to ensure the new system will handle expected loads and growth.
• Utilized column store indexing in parts of the system that are more OLAP oriented.
• Worked with UI group to produce views, stored procedures for a query tool and light weight BI system.
• Used TFS for development and source control.

Confidential - Alpharetta, GA

Senior DBA/Database Architect and Performance Engineer

Responsibilities:

• Handled running, tuning and development of a 24x365 system used to run a system that monitored parolees for various police/offender systems across the US.
• Utilized SQL Server R2 with clustering and collaborated with another consultant on the creation of a data warehouse and SSIS packages for the ETL.
• Worked with application developers to improve and performance tune the way they interact with the database.
• Completed the 2nd version of the system which improved the OLTP data model and functioning.

Confidential - Alpharetta, GA

Database Architect and Performance Engineer

Responsibilities:

• Contracted to performance tune the hardware, application and database system behind a product that is slated to support up to 60,000 client workstations on a daily basis.
• Initial measurements obtained a per second transaction rate of less than 400 TPS. Final numbers are between 6,000 to 9,000 TPS depending upon differing customer requirements.
• Effectively worked on tuning system that extracts transactional data into a simple data warehouse and also on a first step design towards a proper data warehouse.
• Report to the VP of Development and worked on a regular basis with all levels of technical management including the Technical Customer Support Group.
• Successfully completed the set up replication on their internal databases.
• Wrote database creation and setup scripts using PowerShell & T-SQL. Set up replication using SQL Server 2008 R2.

Confidential - Norcross, GA

Data Architect and SQL Server DBA 2000 & 2008 R2, MySQL DBA

Responsibilities:

• Appointed as the primary database resource for several large database systems, up to just over 1 terabyte in size, for a system that provides real time monitoring and control of water utility and waster water utility systems across the United States on a 24x7 basis.
• Work on SQL Server 2000 and 2008 along with MySQL 5.0 on a servers with 18 blades 10 terabytes of physical storage space on EMC/Dell SANs.
• Successfully set up a NAS drive for secondary storage of compressed backups, interact with every level of the company.
• Conducted performance tuning of queries, database structures, maintain database systems both for production and development.
• Designed and built a C# program to provide integration between Quick Books Enterprise and main SQL Serve database for the purposes of automating part of the billing process; which has improved the productivity of the Accounting group tremendously.

Confidential - Atlanta, GA

Data Architect and SQL Server 2005 DBA, ETL Developer

Responsibilities:

• Worked on SQL Server 2005 systems to generate real estate related reports for Wall Street organizations.
• Used SSIS primarily together with tremendous amount of stored procedures and other elements of SQL Server.
• Managed production systems, especially including dealing with issues involving replication.

Confidential - Atlanta, GA

Data Architect and SQL Server DBA, ETL Developer, BI Management

Responsibilities:

• Perform data modeling and analysis for existing and new medical equipment systems data warehouse. Re-engineered an ETL system that imports large volumes of records into a data warehouse that was failing frequently and not indicating the failures.
• Used SSIS together with some CLR/C# stored procedures.
• Worked on new ETL procedures for a new data mart that will provide drill down analysis capabilities for management including using SSAS and cubes.
• Upgraded a SQL 2005 instance to SQL 2008.
• Performed normal production and development DBA activities.

Confidential - Atlanta, GA

Data Architect and SQL Server 2005 DBA, ETL Developer

Responsibilities:

• Designed a mixed OLAP and OLTP database for the business benchmarking group with approximately 110 tables in the final design.
• Built the ETL to move data from a series of business benchmarking tools into the new database using a combination of SQL scripts that are executed by a SQL Server Integration Services package and parameter tables that permit the ETL to be data driven.
• Use Erwin for database design work. Interface with other groups and met with senior management to determine requirements and assist with project related presentations.
• Worked with developers on database related issues and participate in meetings with users and consumers of the data. Recently started picking up a little of SQL Server SSRS in order to assist with minor report work.

Confidential - Alpharetta, GA

Senior Production DBA/Data Analyst

Responsibilities:

• Worked as a production SQL Server DBA.
• Managed hundreds of SQL Server systems across the world on a 24x7 basis. Systems were both traditional and active/passive and active/active clustered systems, with in one case 1.3 terabytes of data and a total dataspace of ~6 terabytes.
• Installed SQL Server 2000 & 2005 on Windows server 2003 clustered systems. Manage more than 60 servers that are located across the United States, about 25% of which are clustered systems.
• Built Server Side Trace system to manage the collection and reporting of Sarbanes-Oxley data for sensitive systems.
• Helped diagnose performance issues, including some that were very critical and helped the developers understand what changes they could make to help resolve the problems as well as dealing with SQL Server issues related to these problems.
• Interacted with teams in the US, the EU as well as Latin America for systems that are involved in financial, shipping and other management activities.
• Worked on and set up SQL Server clustering along with SQL Server replication for systems all across the U.S.A.

Confidential - Norcross, GA

Senior DBA and ETL Developer

Responsibilities:

• Assisted with building the code to move millions of rows of data from the old structure into a format that could be loaded into SAP.
• Worked with a team that was located across the US on functional specifications and actual development. Final work done in both SQL Server 2000 and 2005 including DTS and SSIS and some C# coding to deal with some difficult to parse flat files.

Confidential - Norcross, GA

Senior Production DBA and Data Modeler

Responsibilities:

• Monitor and manage systems in a SQL Server 2000 clustered, replicated and distributed environment to provide High Availability for databases of over 500G in size that run 24x7.
• Implemented conversion to Litespeed backup system and am working on an across the board upgrade to SQL Server 2005.
• Wrote SQL and DTS packages to deal with weekly data extracts to a data repository.
• Worked to convert the DTS packages over to SSIS in SQL Server 2005.
• Assisted Customer Support Representatives with ad hoc queries and data analysis as well as with generation of reports for executive staff.

Confidential - Alpharetta, GA

Senior ETL Developer & DBA - Contract

Responsibilities:

• Upgraded the ETL system to a new version of Data Junction running on HP-UX.
• Analyzed, designed and implemented new ETL processes to permit 'futures' analysis of sales and customer data in a corporate Data Warehouse.
• Built a Java application and a series of libraries to replace one portion of the system to get better performance and system control and to improve monitoring and logging.
• Improved performance of SQL, Data Junction and DTS software packages.
• Wrote Korn Shell scripts to automate the execution of the various packages through Data Junction, handle file management and also run the Java application.
• Performed data analysis and data modeling in order to design our system to support OLAP activities by the Business Intelligence unit of the organization.

Confidential - Atlanta, GA

ETL Developer/Application Developer

Responsibilities:

• Moved and corrected customer, order and related Customer Relationship Management (CRM) data from 2 SQL Server 2000 databases to a centralized SQL Server 2000 database as part of an enterprise level data conversion. Designed the data mapping, data extraction and data cleansing systems to move over 400K customer records and millions of related records into the target system.
• Performed formal designs for the above including reviews with management, Quality Assurance, the Production Database Administrators and Business Analysts.
• Used MS Word and Visio in the preparation of the documentation. Ran hundreds of T-SQL (Transact SQL) queries to perform data analysis of records and fields needed for the conversion so that any transformations needed could be determined.
• Extracted data from the source databases into a staging database where the transformation operations took place and then used SQL Server DTS to migrate the converted data into the final database. Databases are 30G to 70G in size.
• Designed and developed changes to the CRM system to add functionality required to support the users of the source system. Designed, coded and called web services in VB and some C# in a .Net environment in order to add functionality in keeping with the client's architecture.

Confidential

Senior Development DBA/ETL Developer

Responsibilities:

• Served as Senior Developer/Architect DBA for the Thames Valley Police.
• Preformed all the database design and development of an ETL system to extract data from a crime database into XML files that were then applied into a national level data warehouse system.
• Designed and developed Java modules that were then called from DTStudio to extract the data. Designed data staging areas, logging, and error handling. Supervised one Junior Developer.

Technical Environment: Oracle 8i, Windows 2000; 2003, XML, Java, JDBC, Data Mapping, ETL, SQL

Confidential - Duluth, GA

Senior DBA/Data Modeler/ETL Developer

Responsibilities:

• Designed databases at the logical and physical level of the database for international clients of MDS, in particular the National Health Service (NHS) in the UK.
• Delivered database software and other Server system software and created relational databases for the systems.
• Performed backups, restores, performance tuning, stored procedure writing and tuning, capacity planning, disaster recovery planning, data conversions, data imports/exports, and system upgrades. Setup and ran replication using MS SQL Server.
• Supported production DBAs in the UK Provided assistance to the Customer Support group dealing with customer questions/problems. Databases were run on a 24x7 basis.
• Assisted Programmers with database issues and design issues as well as reviewing all SQL and stored procedures the developers created.
• Designed/set up the data warehouse and staging databases as well as created the ETL/SQL code required to move data from the OLTP systems through to the OLAP systems. Tuned system performance resulting in improvements of over 100x in several cases.
• Built a load testing program that aided in tuning the system for a Scottish client gaining the ability to handle five times the number of connections as previously.

Confidential - Alpharetta, GA

Senior DBA/Software Architect/Developer

Responsibilities:

• Designed MS SQL Server and Oracle databases and software for Web based Customer Relationship Management system (CRM).
• Installed software, operating system software, configured the machines for service, and created the relational databases for the system. System used MS SQL Server and Windows NT/2000 or Linux/Oracle 8i as the platform.
• Performed backups, restores, performance tuning, stored procedure writing and tuning, capacity planning, disaster recovery planning, data conversions, data imports/exports, and system upgrades. Managed NT Servers and Linux Servers along with the databases. Spearheaded moving the SQL code into stored procedures instead of using embedded code in the Java Servlets to improve performance and to mask the SQL differences between MS SQL Server and Oracle.
• Databases were run on a 24x7 basis. Additional duties included Java Servlet coding for Apache and JServ. Assisted other Programmers with database and Java issues. Setup firewalls on Linux and SSL for Apache.

Technical Environment: MS SQL Server 7.0/2000, SQL, Oracle 8i (8.1.5), Data Modeling, Linux/Windows NT 4.0/2000, Apache/JServ, Server Side Java/Java Servlets

Confidential - Alpharetta, GA

Senior Development DBA

Responsibilities:

• Handled backups, restores, startups, shutdowns, hardware selection, system tuning, and assisting development staff with any database related issues.
• Researched the unique differences between the various database packages supported by Confidential and then trying to get their product to efficiently handle those differences.
• Tuned the triggers used in MS SQL Server, Sybase, and Oracle and made them literally twice as fast. Installed and managed Oracle, MS SQL Server, Sybase, and SQL Anywhere databases.
• Took client Oracle database with over 1000 tables in it and tuned the database for best performance in batch processing. Original batch took 2.5 hours to run, now takes one hour and ten minutes. Used Sybase Data Architect for data modeling.

Technical Environment: MS SQL Server 7.0, Oracle 8i (8.1.6), Sybase ASE 12.0, C/C++, Data Replication, DB Tuning, SQL