TECHNICAL SKILLS:

• Prior experience designing, documenting and coding Relational Databases.
• Hands on experience with Microsoft Database management systems.
• Prior Administration of Microsoft SQL Server versions 2008, 2012 and 2016 database systems. (Should possess all versions listed).
• Microsoft SQL Server 2016
• Microsoft SQL Server 2014
• Microsoft SQL Server 2012
• Microsoft SQL Server 2008
• Develops and enforces database administration and user standards and procedures; audits, modifies, and amends data in systems using SQL commands.
• In - depth knowledge and hands on experience of database transaction log and backups
• In-depth knowledge and hands on experience of database replication between multiple SQL Servers and remote sites
• Assists Database Designers/Information System Analysts in the development and creation of SQL and Web-based databases and database systems
• Manage deployment of SQL VM on virtual environment
• 16+ yrs. SQL experience
• 16+ yrs. designing and implementing reports and report interfaces. Desired.

PROFESSIONAL EXPERIENCE:

Senior Database/Alternate Program Manager

Confidential, Alexandria, VA

Responsibilities:

• Designed, installed administered, troubleshot, and tuned the project’s SQL Server and Reporting Services databases.
• Served as a primary resource/subject matter expert for the team on all SQL Server/database issues.
• Designed, installed, administered, troubleshot Windows IIS web server sites for the BOSS contract.
• Installed, configured and administered Microsoft’s Team Foundation Server as primary code repository.
• Deployed the project’s .NET code and databases to the government’s user acceptance and testing (UAT) servers on DISA’S server farm.
• Led team’s testing of developer’s .NET code.
• Created the project’s user guides.
• Granted security clearances to work on the project and the project’s DISA servers.
• Worked closely with the team’s project managers to lead the successful approach and completion of the project.

Developer/Database Administrator

Confidential, Wilson, North Carolina

Responsibilities:

• As an expert in C# Visual Studio development and SQL Server Integration Services created ETL web services processes importing data from the bank’s ServiceNow CMDB system for use by BB&T ‘s automated recovery processes for disaster recovery.
• Developed and designed new processes for the automation of system monitoring alarms for the bank’s disaster recovery operations.
• Designed, administered, installed, troubleshot, and tuned the team’s SQL Server and Reporting Services databases.
• Served as a primary resource/subject matter expert for the team on all SQL Server/database issues.
• Developed and deployed SSIS packages using both project and package deployment models. Developed scripts which production DBA’s ran to create the jobs which executed my packages along with the scripts to deploy them.
• Acquired expertise in bank’s ServiceNow systems and processes for integration with SQL Server processes

SQL Server DBA (Contractor)

Confidential, Ashburn, Virginia

Responsibilities:

• Provided analysis and update solutions for upgrading SMARTS wholesale system application to SQL Server 2008. The application originally ran on SQL Server 2000.
• Rewrote and updated 17 SQL Server 2000 DTS packages on the SMARTS wholesale system application so that the SMARTS application could run on SQL Server 2008 under Integration Services (SSIS). The SMARTS application is a key tool used by Verizon for tracking wholesale business.
• Developed and deployed SSIS packages using both project and package deployment models. Developed scripts which production DBA’s ran to create the jobs which executed my packages along with the scripts to deploy them.

SQL Server Application DBA

Confidential, Reston, Virginia

Responsibilities:

• Lead consultant for the SQL Server 2012 certification process. Setup test/feature scenarios. Documented all certified SQL Server features. My efforts resulted in Confidential adopting SQL Server 2012 for its business use.
• Led the installation team which installed 52 SQL Server instances for Fannie’s Workplace Services Project (Fannie’s server modernization effort).
• Led the installation team which installed 18 clusters in production, acceptance, testing, & development environments.
• Provided daily Application support/maintenance of all Workplace Services Project servers (52 SQL Server 2012 instances) across all environments.
• Developed new Application/processes for rapid provisioning of SQL server instances eliminating manual installation processes.
• Provided 24 hour production support for all of Fannie’s SQL Server servers (200+) in an on - call rotation schedule.
• Supported customers having issues with database query performance and other technical issues related to SQL Server.
• Provided database support to Fannie’s 2013 SharePoint development efforts.
• Provided database support/tuning to Fannie’s Enterprise Vault Database Servers (+1 Terabyte)
• Supported a SQL environment of approximately 800 instances of SQL Server.

SQL Server Database Administrator

Confidential

Responsibilities:

• Database administrator for Marriott’s Highest Profile Database Systems Including:
• Marriott Global Source System…Marriott’s largest database system (+1 Terrabyte) supporting all of Marriott’s 127,000 worldwide employees
• Ritz Carlton hotels, a wholly owned subsidiary of Marriott.
• TimeShareWare database system…Marriott’s Vacation Club and Time Share Program.
• Gaylord International Hotels, a wholly owned subsidiary of Marriott.
• All SQL Server Reporting Servers.
• Database Administrator for all of Marriott’s SharePoint databases.
• Provided database support/tuning to Marriott’s Enterprise Vault Database Servers (+2 Terabytes)
• Responsible for the daily support of approximately 200 SQL Server corporate database systems.
• Conceived, designed, and developed a new corporate process for disaster recovery. Process utilizes SQL Server Integration Services and was developed in Visual Studio.
• Conceived, designed and developed a system in Visual Studio and SQL Server Reporting Services which provides automated reports of disk space on databases servers.
• Installed and supported multiple production servers in a clustered environment. An expert at SQL Server in a clustered environment.
• Installed and supported multiple production servers in virtual and physical environments.
• Installed and supported multiple replication servers.
• An expert at database, stored procedure, and tsql tuning for optimum performance of Marriott systems.
• An expert in using SQL Server Management Studio, Precise and Idera tools to tune Marriott databases.
• Configured and maintained SQL Server database backups using Symantec’s NetBackup tool.
• Supported Oracle, DB2, and Netezza databases in on call rotation.
• Supported an environment of approximately 500 SQL Server instances.

Database Administrator

Confidential, Silver Spring, Maryland

Responsibilities:

• Database Administrator to one of the largest on-line auction companies on the web.
• I managed all aspects of company databases including SQL development, database design, daily maintenance, developer support, troubleshooting, documentation, and data architecture.
• I implemented Microsoft SQL Server Reporting Services at the company while developing many SSRS business reports and conducted training classes in SSRS. I implemented/managed 2010 SharePoint Server along with a number of company SharePoint sites.
• I developed applications in Visual Studio C# to support the business functions along with developing numerous Integration Services & Analysis Services applications.
• Initiated development of a Data Dictionary/Data Repository for new version of corporate database.
• Developed data mining solutions for fraud protection and financial applications.
• Installed multiple production servers in a clustered environment. Using SUSE Linux and LAMP server initiated development/architecture of MySQL version of production database. Integrated MySQL and SQL Server processes using SQL Server Integration Services tools.

Principal & Senior Data Architect

Confidential, Virginia

Responsibilities:

• This is my company and we’re a provider of database consulting and development to political candidates and small businesses in northern Virginia.
• Clients have included State Senator Chap Petersen and State Senator Mark Herring. Major technologies included PHP and MySQL on SUSE Linux and LAMP servers.

SQL Server Database Administrator

Confidential, Falls Church, Virginia

Responsibilities:

• Supported various application databases.
• Led SQL Server 2008 migration.
• Resolved database space issues.
• Troubleshooting jobs and worked on various data loading job Issues.
• Worked on Snapshot, Transaction replication issues in various environment.
• Worked on data loading jobs, DTS packages and troubleshooting them.
• Creating and troubleshooting SQL Server Integration Services packages.
• Created many financial reports using SQL Server Reporting Services.
• Developing DB admin related scripts, setting up admin jobs like replication monitor, data purge, and database data file shrink jobs.
• Deploying DB Changes in Production and non-production databases during various releases.
• Performed backup strategy for all the databases and resolved backup issues.
• Worked on disaster recovery plan.
• Experience in using SQL Profiler and performance monitors to enhance the performance of database servers in production environment.
• Experience with T-SQL coding, Creating Stored Procedures, Triggers, Views and Indexes.
• Experience in querying various system tables, DMV’s and running maintenance commands like DBCC etc.
• Experienced in generating reports using Crystal Reports.
• Created user audits on all production servers.
• Prepared databases space report and table space reports.
• Worked on fail over 2 Node Clustering (Active / Active).

S QL Server DBA/ Senior Project Manager

Confidential, Ashburn, Virginia

Responsibilities:

• Singularly developed the NFSM Security System a .
• NET web application on which Verizon secured a U.S. patent. Systems administrator of five Windows servers and 1 Linux server.
• Administrator/developer of NFSM Data Repository/Data Dictionary and NFSM website with extensive knowledge of all NFSM systems and processes. Database Administrator of NFSM SQL Server System serving over 500 users.
• Administrator of SharePoint Intranet site. Manage/oversee all development projects affecting Verizon/MCI’s TELUS, Telco Summarization, and Telco Automated Audit Systems.
• These systems are utilized by Verizon/MCI’s senior management and auditors (a user base of approximately 400 individuals) to gather financial information for Verizon/MCI’s monthly accruals (approximately $950 million/Month) using Red Hat Linux, DB2, MySQL and PHP. Developed DB2 & MySQL versions of NFSM Data Repository.

Software Developer Lead

Confidential, Ashburn, Virginia

Responsibilities:

• Loop Services Symphony System (Provisioning/Procurement B to B System)

  Java development using XML and the Tibco Java Messaging API/Architecture utilizing the following components: TibRV, TibMessageBroker, TibSDK Adapter, and TibRepository. Also responsible for Java security/LDAP programming.

• WebBRE application using Java to make edits to WorldCom’s Business Rules Database.
• RENOH Project an intranet application using Oracle Web Server technologies for a port of a NEXT operating system application which tracks all of MCI’s local resale business (Oracle database).

Software Developer Lead

Confidential, Chantilly, Virginia

Responsibilities:

• Developed COM objects and Oracle stored procedures for Microsoft Internet Information Server using Microsoft Visual Basic.
• Lead developer on a 3 person team at MCI’s Finance Division in Arlington, VA. Application is an intranet application which MCI uses to track all of its leased vehicles as well as making database and general ledger transactions.
• Database Oracle 8. Port of a legacy system.

Software Developer -- Lead

Confidential

Responsibilities:

• Systems Development Center lead web developer on a seven person team for Envirofacts
• The EPA's showcase web product and the largest database on the internet wrote numerous sections using Oracle Web Developer's Toolkit, PL/SQL, PERL, Java, and JavaScript.

Software Developer - Lead

Confidential

Responsibilities:

• Systems Development Center lead web developer on a four person team on the Environmental Data Registry (EDR), the EPA's data dictionary on the web, system administrator for the first Oracle Web Server at the EPA's Systems Development Center, wrote numerous sections using Oracle Web Developer's Toolkit, PL/SQL, PERL,
• Java and JavaScript, trained team members in Java and JavaScript

Software Developer - Lead

Confidential

Responsibilities:

• Senior developer in a three person team which developed the PAL (Process Asset Library) document tracking and computer based training system for Computer Sciences Corporation, corporate headquarters.
• The system will be used by CSC personnel throughout the United States to meet ISO 9000 requirements.
• The PAL system was developed in PowerBuilder and makes extensive use of OLE server technology in a Windows '95 environment.

Software Developer - Lead

Confidential

Responsibilities:

• Full Life-Cycle Development of PowerBuilder and Microsoft Access applications to manage all customer Adjustments and Settlements for a $280 million dollar telecommunications corporation in Bethesda, MD.
• Also conducted numerous training courses for programmers in client/server development for the Information Technology Division in Bethesda and Dallas.
• Topics included PowerBuilder, Visual Basic, and Microsoft Access.

Software Developer

Confidential

Responsibilities:

• Wrote a Windows-based case management system, ECMS, in its entirety for the nation's second largest dispute resolution company.
• Client/server database application in Visual Basic to Microsoft SQL Server.