Sql Server Quality Assurance

Danny J. Carter Dallas, TX 501-***-****

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

Summary

Perform Database Administrator (DBA) duties to assist in security, integrity, development, performance, and recovery of production database systems and data warehouses using SQL Server 2000 and SQL Server 2005/2008.

Education

Master of Science, Computer Science, University of Arkansas at Little Rock

Bachelor of Science, Computer Science, Philander Smith College

Certificates:

2030: Creating Reporting Solutions with MS SQL Server 2000 Reporting Services

2543B:Developing Dynamic ASP.NET 2.0 Applications - VB.NET 2.0 and Visual Studio 2005

2780: Maintaining a Microsoft SQL Server 2005 Database

SQL Server 2005: Reporting Services – Course 523

SQL Server 2005: Server Side Programming with .NET and XML – Course 133

SQL Server 2008: Comprehensive Hands On – Course 137

Windows Server 2008: Comprehensive Hands On – Course 960

SQL Server 2008: Database Administration – Course 138

SQL Server 2008: Database Administrator - Certified Professional

Experience

Business Intelligence Maintenance Plans Stored Procedures

Clustering Automation Performance Tuning

ETL Parallel Data Warehouse Log Shipping

Replication Mirroring SQL Profiler

Analysis Services Report Services Integration Services

Employment History

Crossmark

Sr. Database Administrator September 2011 - present

Maintain 24/7 availability to production databases and warehouses

Provide development and staging environments for Application Developers and Quality Assurance Analyst

Tune stored procedures to increase overall SQL Server performance

Convert DTS packages to SSIS packages

Make recommendations to customers to solve efficiency problems

Work with Network and System Engineers to provide high level of service to customers

Disaster Recovery planning committee

Parallel Datawarehouse owner – support replicated data movement to DW

GDH Consulting

Sr. SQL Developer July 2011 – September 2011

Develop SQL applications for clients

Make enhancements to existing applications

Work with team managers to implement client requests

Intuit, Inc.

Database Administrator February 2010 – June 2011

Migrate very large databases from SQL 2000 to SQL 2008 to a co-location

Upgrade/Develop DTS 2000 packages to SSIS packages for 2008 with Visual Studio

Monitor and review current security measures and make recommendations

Configure SQL Agent for jobs, schedules, maintenance plans and notifications

Document steps for future reference in QA/DEV/PERF/PROD environments

Communicate with other DBA’s business owners to provide a high-level of service

Prepare, design, implement disaster recovery plans and deployment plans

Encrypt databases – Transparent Data Encryption; column encryption

Configure SQL DB’s to transmit messages to SYSLOG servers

Program server-side traces for monitoring with low impact

UA Medical Sciences

Database Manager December 2007 – June 2011

Manage and develop secure database solutions for Cancer Control Registry

Use SQL Server Management Studio, SSIS, and DTS as extraction, transformation, loading (ETL) tools to develop, integrate and migrate SQL Server 2000 and SQL Server 2005 relational databases

Tune SQL Server 2000/2005 databases to increase performance and increase scalability

Rewrite T-SQL queries and create indexes to improve performance

Generate reports ad hoc and programmatically from different data sources with T-SQL code

Install/upgrade instances of SQL Server 2000/2005 DBMS software as needed

Develop objects and stored procedures for repeated requests in SQL Server 2000/2005 environment with T-SQL

Perform and coordinate database backups and recovery using for SQL Server 2000/2005

Sharepoint Administrator: manage shared documents, calendars, and event planning for partners associated with Rockefeller Cancer Institute, UAMS

Compose web applications for data entry and retrieval for multiple users using SQL Server 2005 Reporting Services

Monitor SQL Server 2005 Profiler to measure database performance

SSRS 2005 used for reporting Prostate, Colorectal, Breast Cancer research data

Provide direction for Cancer Bioinformatics Information Grid (CaBIG) committee

UA Medical Sciences

Database Solutions Developer/Administrator March 2004 – December 2007

Manage and develop secure database solutions for medical research departments on server platforms including SQL Server 2005, Filemaker, MySQL

Consult network engineers to configure hardware for database deployment

Database migration – Filemaker, SQL Server 2000/2005, MySQL, Oracle environments

Utilize web technologies for GUI development and data delivery; secured and encrypted

Database Administrator SQL Server 2005 and Filemaker– UAMS Addiction Treatment Center – ATCDB software

Manage Protocol Online Status Tracker database; Reporting, planning, development solutions and training – DBA/Developer

Provide IT consultation to other database developers throughout UA network.

DBA- Colorectal Cancer Outreach Center – full management, development, deployment, backup and recovery

Significant Achievement & Award

Increased revenue within Cancer Center clinical trials program by 12% due to implementation of online enrollment application via web.

Little Rock School District

Booker T. Washington Magnet Elementary School February 1997 – March 2004

Technology Specialist

Develop, schedule, monitor and document technology curriculum for students

Install and configure computer workstations in all classrooms for teacher/students

Monitor and troubleshoot client/server problems on a daily basis

Supervise installation/configuration of peripherals ( network cards, hard drives, modems, external storage devices, printers and more )

Develop software solutions for better efficiency of daily activities

Train faculty and staff to use software

Generate and examine reports to monitor network traffic and maintenance

Arkansas Department of Finance and Administration

Systems Analyst May 2001 – August 2001

AASIS Team

Logged and created problem tickets coming in by phone and by e-mail during the State of Arkansas’ changeover from an older system to a more efficient electronic system

Documented progress of each problem until completed

Provided immediate solutions to some point-of-entry requests for assistance

HEAT, SAP software, Service Now

United States Army

Combat Engineer / Cable and Wire Specialist November 1989 – November 1997

References provided upon request.

Contact this candidate