PROFESSIONAL SUMMARY:

• I have over 17 years of experience in the programming, analysis, design, development, implementation, testing, and maintenance of application systems running under Internet/Intranet Web based and Client - Server environments and over 10 years of experience as an SQL Server Database Administrator (DBA)/Developer of object-oriented applications including MS Access/VBA, Visual Studio/VB.NET.
• I’ve maintained SQL Server 2005/2008R2/2012 database environments and deploy associated patches and service packs, and provides extensive programming support using Transact (T-SQL), ADO.NET, Open Database Connectivity (ODBC), SQL, XML, used Business Intelligence tools: SSRS, SSIS, SSAS and XQuery, Performance Tuning, Batch scripts for automating tasks.
• Developed, tested, and maintain a disaster recovery plan for critical Virtual Machines (VMs) and application data, and architected and implemented Storage Area Network (SAN) environments to ensure high availability and acceptable performance characteristics for VMware vSphere and SAN-backed applications, designing, installing, and configuring VMware.

TECHNICAL SKILLS:

SQL Server 2000/2005/2008 R/2012; SSIS, SSRS, SSAS, VMware ESX, Sans, PL/SQL & T-SQL; Visual Basic (VB) 5/6, Visual Basic for Applications (VBA), SourceSafe for Visual Studio, Visual Studio Professional Edition 2005/2007/2010 , VB.NET, ASP.NET, ADO.NET, VB Script, and JavaScript; MS Access 2.0, 97, 2002, 2007, 2010; Oracle 10g, SQL PLUS; Active X Data Object (ADO), Crystal Reports, ODBC, Distributed Component Object Model (DCOM), COM, TOAD, HTML, XML, XQuery; Windows NT Server, Windows Server 2003/2008; Erwin; Windows 95/98/ 2000 ; Windows Server 2008R2; UNIX; MS-Office products, including Office and Visio.

ADDITIONAL EXPERTISE:

• Extensive Experience with Recovery Methods on Database Backups/Restoring Master Databases
• Data Modeling and Mapping
• Outstanding Computer/Server Troubleshooting & Repair Skills
• Database/Application Troubleshooting & Issue Resolution
• Knowledge of CMM/SEI & (SDLC) and Industry Best Practices
• Full Application Life Cycle Support
• Experience/Proficiency with Application Tuning on Dell Enterprise-Class Servers
• Expertise in VMware/Virtual Environments
• Expertise with SQL Server Reporting Services (SSRS) & Scripting
• Creation of System Documentation, Work Breakdown Structures (WBSs), Standard Operating Procedures (SOPs), Security Policies & User Guides
• User/Staff Training
• Requirements Analysis
• Database/Application Tuning & Optimization
• Development of SQL Server Integration Services (SSIS) Packages
• Drive Storage/Space Allocation
• Windows Server 2003/2008; SQL Server 2005/2008
• Data Transformation Services (DTS) packages
• SQL Database Security/Access Control
• Broad Understanding of DNS & IP Addressing
• Database Management System (DBMS) Product Evaluation, Analysis, and Recommendations
• Outstanding Verbal and Oral Communication Skills
• Extract, Load & Transform (ELT) Processes and Scripting
• Data Access Objects (DAOs) & Object-Oriented Design

RELEVANT EXPERIENCE:

Developer/DBA

Confidential, Hunt Valley, MD

Responsibilities:

• Write and edit code in Visual Basic, NET and VB Script and JavaScript
• Migrated several databases from MS Access, Oracle to SQL Server using ETL processes and SSIS.
• Write cost estimates for projects and deliverables for several clients.
• Set up Maintenance Plans/Backup Strategy on several remote sites
• Backup/Restore databases, Reorganize, rebuild indexes based on fragmentation levels
• Write script to automate loading data into SQL Server, using ETL process
• Identify user requirements and translate into technical specifications.

DBA/Developer

Confidential, Washington, DC

Responsibilities:

• Installed and configured several instances of SQL Server 2005/2008R2, and implemented “High Availability” log shipping on failover and clustered servers.
• Wrote stored procedures to setup automated maintenance plans/jobs and monitor and troubleshoot several SQL Server databases on various networks.
• Wrote scripts to STIG MSSQL database environment to comply with government requirements.
• Used BI tools, ETL Processes (Data Extraction, Transformation) with MSSQL Databases; which included DTS/SSIS, Data Cleansing, Analysis Services (SSAS), Reporting Services (SSRS), Notification Services (SSNS) and MDX ad-hoc Reporting.
• Wrote stored procedures to compress data files and backups to reduce storage cost on several servers for very large databases.
• Identified and resolved performance issues with very large terabyte size databases that required partitioning and created automated stored procedures/ jobs that archived older data.
• Collaborated with management, system engineers on Capacity Planning, and storage requirements for SQL Server database environments.
• Developed Service Level Agreement, and Test Plan, for database development, maintenance and support.
• Created linked servers to work with multiple data sources
• Migrated several large MS Access databases into SQL Server architecture.
• Migrate data and log files to new location after SQL Server upgrade to 2008R2.
• Provide maintenance and support to databases that has over 5 terabytes of data and partition very large tables to increase performance.
• Provide guidance to developers for query tuning, to increase performance using Profiler to identify poor performing queries.
• Wrote T-SQL scripts to monitor several instances which send alerts to DBA team to ensure storage requirements are met.
• Installed SQL Server 2008 on several instances in VM environment set up test server to test database level patches and data migration projects prior to pushing out to production servers.

DBA/Developer

Confidential, Bethesda, MD

Responsibilities:

• Installed and configured several instances of SQL Server 2005/2008R2
• Wrote complex T-SQL scripts in XML and HTML formats that captured available space on all disk drives, automated the report for continuous monitoring of disk space and database size on several servers, and set thresholds and alerts to provide notification of low disk space
• Wrote complex views to extract data from Project Professional/SharePoint repositories to track user licenses and create reports in Crystal Reports
• Migrated several MS Access databases to SQL Server
• Set up roles to manage service accounts and user logins
• Configured DB Mail to set up alerts on enabled jobs if any job or backup failed
• Wrote a script to detect when developers create new databases so that they could be incorporated into maintenance plans
• Set up a physical data entity model to define table relations for a client-server Web application using MS Visio

DBA/ETL Developer

Confidential, Chambersburg, PA

Responsibilities:

• Migrated data from Oracle, MS Access, and SQL Server schemas to Confidential running under Windows 2003 and UNIX AIX environments; installed and configured database software for Oracle and Maxdb application development environments; and created new database instances that involved importing and exporting data.
• Developed ETL scripts for populating and maintaining database registries; analyzed, designed, built, tested, documented, and implemented ETL data with scripts; and wrote scripts to map source data into destination table structures.
• I developed reports using SSRS in SQL Server; managed and administered data using SQL Studio and Database Manager with Confidential ; and managed and implemented database security, creating users, roles, and schemas.
• I also designed, developed, and implemented automated data backup and restoration procedures; provided technical support for database maintenance and disaster recovery; wrote VB scripts to automatically backup several production and development databases and automate various tasks; wrote scripts to access remote databases; and designed, developed, and interpreted data models as well as defined data models for table relationships for physical and logical models using MS Visio.
• I used Putty to access remote UNIX servers and set up Confidential private and public keys and certificates for single sign-on authentication.

DBA/Software Engineer

Confidential, Vienna, VA

Responsibilities:

• Developing an MS Access client-server application to track inventory
• Migrating several databases into Oracle architecture using ETL processes
• Writing complex scripts to monitor database size and growth and documenting database standards and procedures
• Converting a small MS Access training database to ASP.NET and migrating the data into SQL Server architecture
• Managing maintenance plans in SQL Server schemas and writing T-SQL scripts for various tasks
• Writing triggers to update front-end applications to make them read-only to various off-site locations

DBA/Software Engineer

Confidential, Chantilly, VA

Responsibilities:

• Mapped data elements from MS Access data structures to SQL Server 2005 architecture, developed data models for front-end ASP.NET applications and created Entity Relationship (ER) diagrams using ERwin, and implemented database standards and naming conventions for database objects. rote several scripts to load and extract data from various data warehouses, used MS Visual Source Safe 6.0 as a Version Control System, and developed DTS packages to extract, transform, and load data into several databases from an Online Transaction Processing (OTLP) database. Also developed tables, T-SQL Stored Procedures, Views, Triggers, Rules, and other user-defined types and functions; wrote SQL Server - stored procedures to execute on the front-end of ASP.NET; converted a large client-server application with SQL Server back-end and an MS Access front-end from 97 to 2003; and converted legacy system data into MS SQL Server using DTS packages.
• Developed routines to load large amounts of data into SQL Server tables and worked with a team of developers and DBAs to convert a large complex MS Access application to ASP.NET with an SQL Server back-end.

Software Engineer

Confidential, Fairfax, VA

Responsibilities:

• Developed various routines and scripts to normalize database structures and migrated data from MS Access to SQL Server 2000 using the data modeling tool, ERwin.
• Developed data models for front-end Web applications and created ER diagrams using ERwin, set up data mappings from MS Access to SQL Server 2000, used Informatica for moving and uploading large volumes of data into SQL Server tables, and developed a script routine in T-SQL to format/reformat data structures.