SUMMARY:

• SQL Database Administrator with over ten years of industry experience in Biotech, Manufacturing, Federal and State government agency projects.
• Performance tuning, automation, and BI are areas of concentration following the core principles of: Dedication, Integrity, Respect, Humility, Excellence, and Teach and be Taught

TECHNICAL SKILLS:

• Atlassian JIRA
• SSMS/SSRS/SSIS
• Altova
• Solarwinds/Ignite
• Visual Studio
• Winbatch
• RedGate
• Tumbleweed
• TFS
• Powershell
• DBSophic
• VMWare

PROFESSIONAL EXPERIENCE:

Confidential, Harrisonburg, VA

Database Architect

Responsibilities:

• Manage database code release and change control
• Developer and end user support for DDL and DML requests
• PowerShell scripting to increase data process efficiency
• Documentation of processes and procedures
• Database design and modeling

Confidential, Bridgewater, VA

Data Engineer

Responsibilities:

• Production and test DBA for State of Michigan DMV ExpressSOS Web Site
• Deploy database changes for builds/patches to all Lansing environments
• Stored procedure performance tuning, report writing, and correction of suboptimal query plans
• Support code defect investigation and resolution across all environments
• Develop process improvements to automate repetitive tasks
• Update/maintain process documentation

Confidential, Harrisonburg, VA

Principal Database Administrator

Responsibilities:

• Manage log shipping transactional replication to support SSRS reporting
• SSRS 2005 configuration and maintenance. Report creation and deployment
• Automate database builds for new code releases in the test and staging environments
• Coordinate database change control for software releases.
• Create and monitor ETL processes via SSIS, stored procedures, Winbatch, VB and Powershell. Create XML mappings using Altova MapForce 2008
• Database integrity monitoring and business process alert notification
• Database security administration; automate account password expiration procedures
• Install and maintain Tumbleweed Secure File transfer software. Automate and monitor ETL for inbound and outbound transfers. Ensure the data returned to the customer each day is not late. 100% success rate
• Document business processes and IT troubleshooting procedures
• Intranet Website creation to support Windows custom developed services and employee
• Define SQL coding standards and SQL templates, documentation methods and source code control methodologies
• Wiki administration to support business documentation
• Database tuning via SQL profiler, Confio Ignite, DBSophic Qure, Windows performance logs, and SQL traces
• Auditing of DDL and DML via SQL service broker event notification and audit trigger CLR assemblies

Confidential, Charlottesville, VA

Database Administrator

Responsibilities:

• SQL 2000 and Oracle 9i/10g database administration for ERP, CRM and B2B applications. Responsible for data warehouse transactional replication between Confidential USA and international locations. Maintain all Confidential data backups for disaster recovery and SOX audits.

Confidential, Charlottesville, VA

Database Developer

Responsibilities:

• Design, backup, restore, replication, tuning, programming, and optimization of ticketing sales SQL 2000 databases and server clusters. Provide ticketing sales database support for .NET developers.

Confidential, Harrisonburg, VA

Senior Programmer

Responsibilities:

• Lead developer responsible for customization and implementation of a COTS labor tracking application using ASP, JavaScript, Crystal Reports, Infragistics .NET toolset, and MSSQL. Duties included server selection and purchase, physical and logical backup recovery, documentation,, TCP/IP time clock installation, and help desk support. MSSQL tasks include: installation, backup, restore, import, export, replication, tuning with SQL Profiler, creation of databases, stored procedures, user defined functions, data transformations, roles, logins, user accounts, jobs, tables, indexes, triggers, and linked databases.
• Application enhancement and support for a 4 million+ per year optical ID card manufacturing application located in Corbin, Kentucky. Code written in MFC Visual C++ and Delphi. Database engines used included Oracle, Sybase, and Access.
• Visual Basic and SQL enhancement of an IVR (EDIFY) 10,000 call per week call center located in Burlington, Vermont.
• MSSQL application development for corporate applications including, security clearance tracking, HR information, file management, and performance reporting.

Confidential, Elkton, VA

Systems Analyst

Responsibilities:

• Design, development, integration, enhancements, tuning and support of an Oracle - based application portfolio in a multi-platform (IBM AIX RS6000, NT Server and DEC Alpha/VMS) environment using tools such as Developer 2000 (GUI and character mode), AIX Kornshell and Pro*Fortran.
• Year 2K code identification and remediation

Confidential, Grosse Pointe Woods, MI

Analyst

Responsibilities:

• Developed and supported object oriented database applications with Oracle Developer 2000, SQLWindows and ClassIQ object library in a Windows 3.x/Sun Solaris platform running Oracle 7.2.

Confidential, Dearborn, MI

Programmer Analyst

Responsibilities:

• Modeled an order/inventory application using Oracle Designer 2000. WinNT/SUN Solaris platform w/ Oracle 7.3

Confidential, Biostatistics, Detroit, MI

Programmer/Analyst

Responsibilities:

• Designed and developed research laboratory applications in a client-server PC-VAX Oracle environment via DECNET/SQL*NET. Integrated barcode and voice synthesizer technology.
• Installed and administered a Web server on a VAX 6440 and wrote CGI scripts for Oracle database reporting and integration.

Confidential, Detroit, MI

Research Assistant

Responsibilities:

• Installed a Novell 3.11 LAN for hospital administration.
• Oracle database development for chromatographic and scintillation data on a VAX 8340
• HPLC operator