Professional Summary:

Customer-focused SQL Database Administrator with diverse experience, dedicated to providing a high level of support for SQL database issues. Developed and utilized SQL - SSIS Projects, Jobs, Queries, and DTS' to perform ETL, data checks, and data scrubbing. Experienced serving as database subject matter technical expert and liaison between business systems customers and the Information Technology staff. Proven ability to adapt to new requirements and technologies and is a capable team member with strong verbal, writing and exceptional interpersonal skills.

Technical Summary:

Employment Experience:

Confidential

SQL Database Manager

• Maintained Database for business needs. Created tables, maintenance plans, and logins for databases and servers. Performed regular SQL database backups, restores, updates and exports between SQL Servers, both internal and external as required.
• Consulted with DBA team to identify and implement reporting, control, and automation opportunities to improve overall access to information.
• Performed application upgrades and application support
• Designed and modified SSIS packages, SQL Stored Procedures that assisted in the ETL process for production SQL databases.
• Participated in and maintained D.R. Disaster Recovery technical processes and documentation and implemented SQL database related policies/processes.
• Designed and modified SSIS 2005/2008 packages that were utilized for the conversion of SQL 2000 DTS'.
• Utilized SSRS as required for SQL based reports.

Confidential

Database Administrator

• Supported multiple databases and servers in both clustered and non-clustered environments.
• Documentation and implemented database related policies/processes.
• Coordinated with Lead DBA, System Admin and Programming/Development teams to identify and implement reporting, control, and automation opportunities to improve overall access to information.
• Created and maintained database reports as requested for business needs.

Confidential

SQL DBA

• Supported multiple SQL Server 2005/2008 databases and servers in both clustered and non-clustered environments.
• Participated in and maintained D.R. Disaster Recovery technical processes and documentation and implemented SQL database related policies/processes.
• Coordinated with Lead DBA, System Admin and Programming/Development teams to identify and implement reporting, control, and automation opportunities to improve overall access to information.
• Managed Daily SQL Log Shipping Jobs to ensure Log Shipping was current and successful
• Supported the daily administration of SQL Server databases. Wrote/Debugged T-SQL as needed for administrative purposes.
• Created and maintained SSRS reports as requested for SQL business reports.
• Moved SSRS Reports to Production environment from Development.
• Designed and modified SSIS packages, SQL Stored Procedures that assisted in the ETL process for production SQL databases.

Confidential

Business Systems Analyst SQL DBA/DEV

• Developed and modified Pervasive Software packages, SQL Stored Procedures that assisted in the ETL process for numerous production SQL databases.
• Developed and modified I-HUB jobs that were utilized for the ETL processing to extract/integrate data to and from numerous SQL Databases.
• Created Titanium and SQL based reports as required for business needs.

Confidential

Systems Analyst/Database Administrator

• Designed and modified SSIS packages, SQL Stored Procedures that assisted in the ETL process for production SQL databases.
• Designed and modified SSIS 2005/2008 packages that were utilized for the conversion of SQL 2000 DTS'.
• Utilized SSRS as required for SQL based reports.
• Participated in and maintained D.R. Disaster Recovery technical processes and documentation and implemented SQL database related policies/processes.
• Coordinated with Sr. DBA, systems and development teams to identify and implement reporting, control, and automation opportunities to improve overall access to information.
• Created tables, maintenance plans, and logins for databases and servers.
• Performed regular SQL database backups, restores, updates and exports between SQL Servers, both internal and external as required.

Confidential

SQL Database Administrator

• Supported multiple SQL Server 2005/2008 databases and servers in both clustered and non-clustered environments.
• Created and modified SSIS 2005 and 2008 packages, Stored Procedures and DTS' that performed daily ETL process for production, development and QA databases.
• Utilized SSRS as required for SQL based reports.
• Supported the administration and development of SQL Server databases.
• Utilized T-SQL queries as required for administrative purposes and reports.
• Worked with database, development and systems teams to identify and implement automation opportunities to improve access to daily BetaNDM SQL Database data.
• Created tables, maintenance plans, and logins for databases.
• Provided Tier III support of daily BetaNDM SQL DB production issues. Identified data issues and provided resolutions to ensure optimal performance.
• Performed regular SQL database backups, restores, updates and exports between SQL Servers, both internal and external as required.
• Maintained clusters of both production and development SQL database environments, to ensure the IT Department is operational for critical SQL Servers.
• Created and maintained technical process documentation and implemented SQL database related policies and processes.

Confidential

Independent IT Consultant

• Independent work with SQL Server 2008 Express, Windows 7 and Vista self study and A Certification training/studies.
• Consulted and assisted a wide variety of users with various PC desktop, software, hardware, network or peripheral equipment issues

Confidential

SQL Database Administrator

• Supported the development, implementation and daily administration of SQL Server databases. Wrote/Debugged T-SQL as required for administrative queries.
• Utilized T-SQL programming for data scrubbing, validation and report creation.
• Created new tables, maintenance plans, and logins for SQL databases.
• Provided Tier I, II and III support of daily Prolog DB production issues. Identified data issues and provided resolutions to ensure optimal performance.
• Designed and modified SSIS packages, SQL Stored Procedures and batch files that assisted in the ETL process for production SQL databases.
• Supported multiple SQL Server 2000/2005 databases and servers in both clustered and non-clustered environments.
• Performed regular SQL database backups, restores, updates and exports between SQL Servers, both internal and external as required.
• Set up/Installed/Configured SQL Server 2005 as a standalone instance as well as in clustered environments.
• Maintained clusters of both production and development SQL database environments, to ensure the IT Department is operational for critical SQL Servers.
• Created and maintained technical process documentation and implemented SQL database related policies/processes.
• Provided Tier III database support of daily application Prolog SQL production issues. Identified data issues and provided resolutions to ensure optimal performance.
• Coordinated with DBA, systems and development teams to identify and implement reporting, control, and automation opportunities to improve overall access to information.

Confidential

Production Support Database Analyst

• Provided Tier I, II and III support for DSStores SQL database processing on six SQL servers that contained nine separate business units' individual SQL databases and MS Advanced Analysis OLAP Cubes.
• Utilized SQL, Reporting Services SSRS for multiple server, database, and table queries for data management that created reports for sales analysis on SQL Servers and MS Advanced Analysis Cubes.
• Performed data checks on servers for SQL databases and Cubes. Managed and supported SQL database data for users nationwide, including individual client SQL databases burst to VPs, CEO's, and Business Analysts via DSStores.
• Developed new processing protocols for DSStores SQL data that included detailed data validation and user restrictions. Engaged multiple users to gather data requirements and ensured validation criteria was implemented.
• Maintained SQL Jobs utilizing SQL Enterprise Manager and Query Analyzer that assisted in data validation and scrubbing for each Business Unit's specific data requirements and needs for their SQL databases, reports and OLAP Cubes.
• Converted data from various file formats into a standard layout for loading into the DSStores SQL based systems. Tested data for integrity issues and managed the resolution of multiple data issues throughout the conversion process.
• Developed SQL queries to gather data from DSStores SQL Administration system and utilized combinations of SQL Query Analyzer, Enterprise Manager, and MS Excel to identify data integrity issues and correct as needed.
• Standardized the processing protocol that ensured efficient data loading. Also verified that the data converted from internal systems was specifically what was required for DSStores SQL formatting in order to be processed correctly.
• Maintained multiple SQL DTS' via Enterprise Manager and Query Analyzer that expedited data validation and scrubbing for each Business Unit's specific business data requirements and needs for their SQL databases, reports and cubes.

Confidential

Desktop Support Analyst

• Provided Tier II and III support in a Windows 2000/NT/XP environment
• Hardware, software and network LAN-WAN-Wireless TCP/IP, Routing, Subnetting, DNS, DHCP, Connectivity VPN issues
• Install/Replace hard drives, and CD drives, Floppy drives
• Memory upgrades, Install sound cards, NIC cards, and software as needed
• Perform PC, Printer and various peripheral equipment moves installations.

Confidential

Technical Analyst/Listing Coordinator

• Provided Tier I and II support, Identify/resolve hardware/software/network LAN /WAN, Wireless TCP/IP, Routing, Subnetting, DNS, DHCP, Connectivity VPN issues, Data system back-ups.
• Installed memory, sound, NIC, Video cards, and software as needed.
• Performed PC moves, installations, asset management, security, and group policies within Active Directory.
• Manage and provide support for Company Website.

Confidential

Technical Support Engineer

• Provide Tier I and II support including but not limited to: Identify and resolve
• Hardware, software and network LAN /WAN, Wireless including TCP/IP, Routing, Subnetting, DNS, DHCP, Connectivity VPN connectivity issues.
• Create/Manage users Network and Citrix accounts: SMS, Citrix, and Active Directory.
• Supported users via desktop, phone. Used SMS and Citrix Server Manager for remote access to troubleshooting various software, hardware, network or peripheral equipment issues.
• Train via Classroom, Desktop and support Wash U. staff on Windows OS 95-XP, Lotus Notes, MS Outlook, MS Office Suite, Scanners, Label Printers, and Software: Roxio, Nero and EZ CD Creator

Confidential

Coordinator Clinical Lab Receiving

• Received, ordered tests and updated specimen progress via Cerner Lab Systems software
• Ensured that the Lab Receiving co-workers were efficiently moving the specimens on to the correct lab for proper testing
• Co-wrote Lab Receiving Standard Procedure/ Protocol Manual
• Maintain the rapid turn-around times for specimen collection, testing, and results posted in computer via Cerner Lab Systems software
• Create Daily Schedule for 12 employees 3 Shifts , as well as on-call schedule
• Train all new employees