PROFESSIONAL EMPLOYMENT:

Database Administrator

Confidential, Raleigh, NC

Responsibilities:

• Principal responsibility for designing and implementing SSIS driven solutions for data warehouse that held 25,000,000 patients clinical, de - identified data to be extracted to Partners who could analysis the data for clinical trends without a possibility of identifying the patients.
• Data was tokenized separately for each partner so that even if multiple partners worked in unison the data could not be personalize

Sql Server DBA, Database Architect, SSIS Developer

Confidential, Cary, NC

Responsibilities:

• Sql Server jobs, database Backup and restores
• Standup Sql Servers and migration of databases form old to new
• Monitor Sql Server performance and evaluate poor performance of existing queries.
• Designed new database and associated processes via SSIS to automatically control and import files from numerous sources while tracking status and file metrics.
• Installation, maintenance, security, performance and tuning of Database Management Systems and related third party software.

Database Architect SSIS Developer

Confidential, Cary, NC

Responsibilities:

• Designed new database and associated processes via SSIS to automatically control and import files from numerous sources including in-house data from Sql Servers.
• The purpose was to aggregate the data relative to several pharmaceutical programs and report on sales, dispense, copay and administrative metrics to a third party customer.
• All the files were automatically detected and logged in control tables with constraints to prevent the same file from being loaded more than once.
• Separate processes staged, validated and processed the data into the central Hub while logging metrics about the files.

SSIS Developer

Confidential, Raleigh, NC

Responsibilities:

• Involved in daily meetings to establish and understand the business requirements needed to meet legal and business requirements for loan processing.
• Tasked with streamlining and upgrading a collection of existing packages into one of a similar architecture for the purposes of easier maintenance.
• Responsible for rewriting all of the packages.
• Tasked to determine the cause of a loans exclusion from the extract.
• Processed on average about 2,400 loans per week.
• Designed a table driven system to dynamically build queries, used by diverse systems, from a collection of rules developed for various extracts.

Database Architect SSIS Developer

Confidential, Cary, NC

Responsibilities:

• Brought a new level of automation to the process of analyzing the effectiveness of cancer patient’s medical treatment.
• My job here was to create the database architecture and SSIS packages to control and extract files into the database for the use of existing SQL processes.
• Further enhanced and automated the given processes for analyzing and reporting on the data.
• Consulted with the in-house DBA to set up a new clustered/mirrored environment.

SQL Server Developer

Confidential, Durham, NC

Responsibilities:

• Developed the stored procedures and functions for reports and scripts to keep clients databases working with current reports.
• Created and modified the reports to current requirements

SQL Server Integration Services Developer

Confidential, Richmond, VA

Responsibilities:

• Used SSIS to developed extracts and imported and transformed data from clients files into db tables.
• SSIS packages were designed to check the data against the business rules that applied.
• SSAS dimensional modeling tools were used to load the data warehouse with client data.
• Temp tables were used to load data and then records were written to production tables once they passed essential test.
• Production tables were built with referential integrity to prevent insertion or data with incorrect format or range but the checks for such conflicts were performed within the package prior to attempt. Performance tuning was always a high priority in the development of stored procedures.
• If the process failed in the stored procedure error messages were passed to the package and were written to logs.
• Worked with business contacts within the company and client contacts to establish extract requirements.

SQL Server DBA

Confidential, Charlotte, NC

Responsibilities:

• Standard DBA responsibilities included installing and hardening security configuration for new test instances of SQL Server 2005.
• Established maintenance plans, provide for disaster recovery, monitored job performance, migrated databases, established baseline performance measurements for new test environment.
• All databases were clustered and mirrored for fail safe, high availability.

SQL Server DB A

Confidential

Responsibilities:

• Evaluate and managed upgrade to the existing Windows 2003 Server and SQL Server 2005 to optimize its performance.
• Monitor db’s and provide for disaster recovery.
• Evaluate and modified the configuration of data files, disk partitions, indexes for maximum performance.
• Responsible for tuning queries for maximum performance.
• Altered SSIS packages and created stored procedures to enhance performance of jobs that extracted data from multiple SAP servers to SQL Server 2005 data base for analysis.
• Substantial time savings were realized in package run times.
• One job that had previously taken 36 hours was reduced to a 2.5 hour run time.

SQL Server DBA

Confidential

Responsibilities:

• Created packages using Data Transformation Services and SQL Server Integration Services to create the data marts. ETL packages (Extraction, Transformation and Loading) prepared data to be used by SQL Server Reporting Services and Analysis Services to create reports.
• Converted existing SQL Server 2000 DTS packages to run in 2005’s SSIS.
• Daily activity included monitoring and trouble shooting job failures.
• Served as DBA for the productions and test servers where responsibilities included disaster recovery and tuning queries for maximum performance.

SQL Server DBA

Confidential

Responsibilities:

• Created and Maintained Schema for a rapidly evolving database used for proprietary applications created for use by the armed services.
• Applications and database were deployed in Iraq and Afghanistan.
• Data replicated across numerous servers to provide real time information from the field to the officers in charge all the way to the Confidential .
• Setup and maintained replication rules files for database and installed the replication engine.
• Created and Maintained scripts for all schema objects to build and update db.
• Database was SQL Server 2005. SQL Server Integration Services was used for ETL (Extraction, Transformation and Loading) to bring data from different schemas into CCIS’s db. SQL Server Reporting Services and Analysis Services were used to create report models.
• Visual Studio Foundation Server was used to store all SQL scripts and application code.

SQL Server DBA - VB Developer

Confidential

Responsibilities:

• Addressed maintenance concerns with existing in-house VB, VB.net and ASP applications and SQL Server 2000 database.
• Created or made modifications to stored procedures to tune for maximum performance.
• Made modifications to ASP, VB6 or .Net applications to in corporate those changes.

SQL Server DBA & .Net Developer

Confidential

Responsibilities:

• As DBA my responsibilities included providing regular maintenance and backup to hospital’s SQL Servers.
• Disaster Recovery on a high availability server, future infrastructure planning, index optimization, performance tuning, intervention upon system slow-downs and user lock analysis.
• Created stored procedures, views and reports for internal customers.
• Served as application developer creating web applications with VB.Net and Crystal reports.
• Created ad hoc reports for various managers.