SUMMARY:

• Database Design, PL/SQL, query development, and backup and recovery in Oracle Database 10g/11g/12c
• In - depth knowledge of complex PL/SQL, Transact-SQL, DB2, Non-Stop Tandem, Sybase scripts
• Senior SQL DBA / Database Architect with extensive experience with installing, configuring, analyzing, and supporting SQL Server 2005, 2008, 2008R2 and 2012R2 in Development, Test and Production Environments
• Experience on Oracle X3-2 Database Appliance box
• Extensive work experience on system analysis, design, development, testing and implementation of projects within the Software Development Life Cycle (SDLC)
• Extensive knowledge of Data in motion XML Schema data harmonization at enterprise level
• Quick learner, Flexible and versatile to adapt to any new environment and to work on any project
• Able to work independently and as part of a team, having excellent work ethics and team oriented with leadership qualities

PROFESSIONAL EXPERIENCE:

Confidential, MS

Senior Oracle Database Administrator

Responsibilities:

• Patching, upgrades, database troubleshooting, and supporting development effort for production deployment releases
• Patching, upgrades, supporting Oracle Database Appliance (ODA) 12c Grid environment
• Supports Oracle Weblogic Server Enterprise environment
• Interacts with My Oracle Support regularly regarding open service requests

Tools: Oracle Database Appliance (ODA) X3-2, Oracle Database 12c, Oracle 13c OEM, Oracle Weblogic Server Enterprise, Redhat Linux 7.x, Oracle APEX 5

Confidential, MD

SQL Server Database Architect

Responsibilities:

• Configured, maintained and monitored Transactional Replication for SQL Server environments
• Implemented MS SQL Cluster (Active/Passive & Active/Active), Multi Node Cluster for high availability
• Implemented Total Database Encryption (TDE) T-SQL processes to maintain the TDE infrastructure
• Implemented T-SQL based backup and restore strategies and disaster recovery solutions
• Implemented DISA Security Technical Implementation Guides (STIGs) procedures for SQL Server 2012R2
• Documented and configured SQL Server 2012 AlwaysOn High Availability / Mirroring
• Ensured backup and restore capabilities for SQL Server to the agreed upon SLA
• Provided guidance and work leadership to less experienced DBA

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

Confidential, MD

Database Architect

Responsibilities:

• 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

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 (DoDAF) 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

Responsibilities:

• 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