EXPERIENCE SUMMARY:

• Extensive experience with installing, configuring, analyzing, and supporting SQL Server 2005, 2008, 2008R2 and 2012R2 in Development, Test and Production Environments.
• In - depth knowledge of complex Transact-SQL.
• Power user of advanced SQL queries with multi-table joins, group functions, sub-queries, set operations and functions.
• Extensive work experience on system analysis, design, development, testing and implementation of projects with Software Development Life Cycle (SDLC).
• SQL Database Design, PL/SQL, query development, and backup and recovery in Oracle Database 10g/11g.
• Consistently demonstrates ability to communicate well with different organizational levels, from end users and technical staff to the executive level.
• Extensive knowledge of Data in motion XML Schema data harmonization at enterprise level.

PROFESSIONAL EXPERIENCE:

Confidential, Aberdeen Proving Ground, MD

SQL Server Database Architect

Responsibilities:

• Implemented Total Database Encryption (TDE) T-SQL processes to maintain the TDE infrastructure.
• Implemented MS SQL Cluster (Active/Passive & Active/Active), Multi Node Cluster for high availability.
• Implement T-SQL based backup and restore strategies and disaster recovery solutions.
• Implemented DISA Security Technical Implementation Guides (STIGs) procedures for SQL Server 2012 with documentation.
• Providing guidance and work leadership to less experienced DBA.
• Oversees environment management, database health (monitoring, proactive and reactive responses), resource planning, database upgrade, backup and recovery strategy, planning and implementation.

Tools: MS SQL Server 2008R2, MS SQL Server 2012, VMware vCenter 5.5, VMware ESXi 5.5, CA Erwin 9.x

Confidential, Aberdeen Proving Ground, MD

Database Architect

Responsibilities:

• Participated in the design, maintenance, enhancement, coding, and administration of relational databases.
• Participated in continuous improvement efforts in enhancing performance and providing increased functionality, including performing proactive maintenance such as ensuring continued space availability, monitoring activity, and documenting problems, changes, and solutions.

Tools: MS SQL Server 2008R2

Confidential, Laurel, MD

Senior DBA / Senior Systems Engineer

Responsibilities:

• Provided Data Flow Subject Matter Expert (SME) support for Office of Cyber Computer.
• Provided MS SQL Server DBA support for management support reporting system.

Tools: MS SQL Server 2008, JIRA, JIRA Confluence

Senior Metadata Systems Engineer

Confidential

Responsibilities:

• Provided metadata expertise in Confidential sponsored Distributed Common Ground Systems ( Confidential ) related architectural development, metadata crosswalks, data harmonization, data modeling, and standards adoption using XML schemas.
• Assisted in providing Confidential SIGINT elements planning support to Under Secretary of Defense for Intelligence ( Confidential (I)) sponsored Intelligence, Surveillance and Reconnaissance (ISR) demonstrations and exercises.
• Participated regularly as active member in support of Confidential related-meeting and focus groups as required.
• Provided system engineering support for the Confidential Integration Backbone (DIB) development environments.

Tools: Stylus Studio 2010, Altova XMLSpy MissionKit 2012

Senior DBA / Senior Systems Engineer

Confidential

Responsibilities:

• Provided SQL Server DBA support for IBM enterprise architectural products on windows.
• Provided Oracle 11g DBA support for enterprise architectural products on windows and Linux platform.
• Developed and maintained Confidential Architecture Framework ( Confidential ) 1.5 and 2.0 enterprise architectural objects and VBscript processes.

Tools: MS SQL Server 2005, Oracle 11g, IBM Rational System Architect 11.4, VBscript

Confidential, Columbia, MD

Senior Data Modeler

Responsibilities:

• Developed and maintained enterprise level common data exchange models in UML 1.4. After the XML Schemas is generated from the UML Models, the XML schemas and Xpaths was validated using Stylus Studio XML editing tool.
• Interacted with multiple projects across the enterprise to harmonize and map their databases with the enterprise common data models.

Tools: IBM Rational Rose Enterprise Edition 2003, Stylus Studio 2006, Sybase PowerDesigner 15.2, IBM Rational Clear Quest, VBscript.

Confidential, Atlanta, GA

Senior Database Administrator

Responsibilities:

• Wrote T-SQL views, procedures, and function for various DTS packages that generated Excel worksheets and csv export files.
• Created logical/entity data models (ERD) and physical data models (PDM) for SQL Server.

Tools: JIRA, T-SQL, SQL Server 2000/2005, DTS/SSIS Packages, CA ERWin Data Modeler, MS Visio

Confidential, Smyrna, GA

Data Warehousing DBA (Consultant)

Responsibilities:

• Developed complex T-SQL procedures to load the data warehouse.
• Developed SSIS packages to load operational data to data warehouse staging databases.

Tools: SQL Server 2005, SSIS Packages, T-SQL

Confidential, Atlanta, GA

SQL Server Database Administrator / Database Developer

Responsibilities:

• Responsibilities included applying changes to SQL Server 2000/2005 databases, software installation, testing, problem solving, backup and recovery, database maintenance, performance tuning, security administration, database auditing documentation, and T-SQL scripting.
• Defined data modeling standards and naming conventions.
• Established database change controls and versioning procedures and work with subject matter experts and developers to migrate database changes into test, acceptance, and production environments.
• Developed Perl scripts for batch reports to HTML and Excel XML formats.

Tools: SQL Server 2000/2005, MS Visio 2003, SSIS/DTS 2000 Packages, T-SQL, Red Gate SQL Compare, Perl, Oracle 9i

Confidential, Columbia, MD

Senior Database Engineer

Responsibilities:

• Provided DBA support for 18 plus SQL Server 2005 Servers totaling over 3 terabytes.
• Designed extraction, transformation, and loading (ETL) processes utilizing SQL Server BCP scripts and Oracle 10g external tables with PL/SQL scripts.
• Developed and implemented automated procedures for backup, recovery and disaster recovery of the Oracle databases using Rman and PL/SQL scripts.
• Moved and migrated Oracle windows databases to new Redhat Linux servers.
• Key player in re-engineering of a legacy enterprise system to integrate into a Service Oriented Architecture (SOA) via Web Services.

Tools: SQL Server 2005, T-SQL, Oracle 10g, RMAN, SQL*Pus, SQL*Net, PL/SQL, Sybase ASE 12.5.2, PowerDesigner 10, Redhat Linux 6

Confidential, Ellicott City, MD

Lead Data Warehouse DBA

Responsibilities:

• Provided Oracle 10g DBA support for Software Developers in re-design of a Java J2EE application.
• Developed Perl scripts and ETL processes for data migration between corporate systems and SQL Server 2000 via XML formatted files.
• Reverse-engineered the Conceptual and Logical data models of the Sybase ASE 12.5.2 databases using Sybase Power Designer 10.
• Designed extraction, transformation, and loading (ETL) processes using Data Junction and Active Perl.
• Created logical data models and physical data designs for SQL Server 2000 and Oracle 9i.
• Migrated Sybase ASE 12.5.2 database to Oracle 10g using ER/Studio and Data Junction.

Tools: SQL Server 2000, Perl, Oracle 10g, Sybase 12.5.2, Embarcadero ER/Studio, Toad, Data Junction

Confidential, Alpharetta, GA

Oracle DBA / Senior Software Developer

Responsibilities:

• Developed Oracle backup and recovery strategy and scripts.
• Technical lead for team of software developers on the reporting functions.
• Provided technical support for database maintenance and disaster recovery procedures.
• Performed modifications and enhancements to table spaces, tables, etc. Performed backup/recovery, and other DBA related tasks. Wrote PL/SQL procedures, and functions for various tasks. Created automated monitoring tools to check that a given database is up and running, and disks and table spaces are within acceptable bounds.

Tools: Oracle Database (8i, 9i), Sybase PowerDesigner 9, Toad, ManDrake Linux, Sybase Powerbuilder (6.5, 7.0)