SUMMARY

• Confidential Certified System Engineer & Database Administrator with over 20 years of experience in information systems and technology.
• Has interest in sharing knowledge, overcoming challenges, and providing expertise in software development, database administration and systems engineering resulting in support of the strategic company goal.
• Driven by new challenges and desire to be successful in all endeavors. Immensely enjoy navigating all aspects of complex projects
• Established Migration paths for data from UNIX, Oracle, DB2, flat files, access using DTS/ETL process and procedures. Established log shipping & database replication to ensure maximum uptime of mission critical database applications.
• Performed database backups and restores using SQL Backtrack and Oracle RMAN. Setup and deploy log shipping to stand by servers to maintain SLA standards

TECHNICAL SKILLS:

• C/C++/C#
• VB
• .NET
• SQL Server 7
• SQL Server 2000
• SQL Server 2005
• SSIS
• SSAS
• SSRS
• HTML
• XSL
• XSLT
• XML
• ASP
• ASP.NET
• Confidential Office products
• Photoshop
• Oracle
• DB2
• Java
• Unix
• NCR Teradata
• MTS
• COM
• COM+
• PHP
• ARCU
• Tibco Spotlight
• Unity 3D
• MongoDB

WORK EXPERIENCES:

Database Architect / Software Programmer

• Database Administration and Development for database driven video game
• Unity 3D development for game engine
• .NET development for internal web based application to support game needs.

Senior Database Administrator & Software Engineer

Responsibilities:

• Sole DBA responsible for 137 SQL Server DB Servers, 387 production SQL databases, 5 Oracle servers, 2 MySQL servers and 9 DB2 DB servers, 1 MongoDB for BI reporting.
• DBs range from 50mb in size to 16tb. Total data for all databases 800TB
• Software development responsibilities range from product support to new application development
• Business Intelligence development and support for various business departments within the organization.
• Data Warehouse development and support following Kimball methodologies.
• All new development being done using Entity framework 6x, MVC and .net 4.x
• Responsible for company reporting needs. Using Confidential Access, Confidential SSRS, SQL Server Data Cubes & DataMart’s.
• Design and support all ETL efforts to import/export data into data warehouse and out.

Principal Database Engineer (Architect & Administration)

Responsibilities:

• Design, deployment, maintenance and administration of high - volume, high-performance DB systems to include but not limited to SSAS, SSIS, SSRS, SQL 2008, Data Warehouse, MySQL solutions.
• Overhaul of existing DB systems for improved performance. Complete retrofit of Database layer of network. New 4 Node Active-Active DB cluster and n-tier database layer
• Design and overhaul of DB systems for long-term flexibility and extensibility within performance criteria.
• Improve automation for reduced maintenance costs.
• Build key systems for consumption of data by stakeholders and customers.
• Purpose upgrades in infrastructure or solutions to achieve business objectives.
• Setup, Train and management of ITIL methodology including ITIL change management solution.
• Creation of Dash boards using Silverlight and WPF components.
• Evaluation of DB monitoring tool or design own tool based on internal need.
• Redesign and implement new SSRS environment.
• Setup, Train and enforce Database Best practices and standards to include database modeling and versioning control

Database Architect / Administrator / Developer

Responsibilities:

• Database Security: Following guidelines from ITIL, Sarbanes Oxley, SOCS and various Federal agencies. Active Directory Security replacement of SQL Security (exceptions; legacy applications & DR purposes). Implementation of SQL Auditing for login as well as audit of key data. Encryption of key data located in key tables.
• Database Modeling: Maximizing data reuse, modeling of existing applications, creating data models for new development projects. Established Data Warehouse and various Data marts. The use of Computer Associates Erwin 7.2r and Confidential Visio used for data modeling. Implementation of data stewards to take ownership of topical data. Confidential access used for support reporting and DataMart needs.
• Database Performance: Continue to improve upon the speed and delivery of data for the use in applications and reporting. Monitor index performance and query design to maximize performance.
• Database Capacity Planning: Monitor and scale SAN space for data needs. Project and determine potential growth of volumes based on data retention.
• Database Installation: Installation of Confidential SQL Server 2000, Confidential SQL Server 2005, Confidential SQL Server 2008, Oracle 10g, Oracle 11i, Confidential SQL Server 2005 (SSAS, SSRS, SSIS). Upgrade of SQL Server 2000 to SQL Server 2005 to include the migration of DTS packages to SSIS.
• Database Development: Create and support numerous SSIS projects to import flat files, work with data and place into normalized tables for the purpose of reporting or application use. Create numerous stored procedures for application use. Access development for reporting and converting needs.
• Database, Disaster Recovery: Current SLA 30 Minute environment has 6 NODE cluster SQL Server 2005, running in Active/Active. DR located off site with DS3 between locations. Key systems have matching hardware and configurations in DR site to minimize down time of mission critical applications.
• MySQL Database development experience and planning, optimized SQL queries, web front-ends with PHP utilizing solid ground-breaking approach for database development. Tuning performance issues, bulk data load implementations and automatic backup scripts, handled big tables with millions of records sized in gigabytes and terabytes, under both MyISAM and InnoDb, troubleshooting, complicated cases of slowness and imperfections with database design. Preformed ETL processes to share information between Oracle and SQL Server for the purpose of application and reporting needs

Contract Database Administrator / Architect

Responsibilities:

• DB Architect: Design, review and modify models based upon current database environment (Non-Normalized). Design new normalized database based off existing db. Impact analysis comparing existing db with new db concepts. Setup Data warehouse to share information across numerous processes and applications in a centralized & decentralized methodology. Establish and use data mining concepts.
• DBA: Create Roles, Users, Stored Procedures, Indexes, views and perform database backups. Monitor performance problems, recommend changes or perform changes to enhance RDBMS. Use SQL Profiler to see where processes need to attention or build objects to enhance data delivery and data integrity. Implemented Data Mining to show impact of patient and provider information to enhance business forecasting. Database Replication, transactional and snapshot for transfer of data between application and reporting needs.

Contract Database Administrator / Database Modeler

Responsibilities:

• DB Architect: Design, review and maintenance of numerous simple and complex data models to support projects and dataware house needs.
• DB Engineer: Create complex SQL & PL/SQL scripts to support applications and data needs.
• DBA: Create Roles, Users, Stored Procedures, Indexes, views and performed database backups. Migration of data from various sources to Databases using DTS and other methods both in SQL Server 2000 & 2005. Perform database backups and restores using SQL Backtrack. Setup and deploy log shipping to stand by servers to maintain SLA standards. SQL Server environment had three stages; development, QA and production. All environments were part of a clustered environment.
• Development: Develop Apache2/PHP Web based tool kit for Data Management.
• Skills used/learned: PHP 5.2, Oracle 9i, Oracle 10g, XMii (Light Hammer), Apache 2

Contract Database Administrator

Responsibilities:

• Installed New SQL Server 2000 Enterprise server from box to production.
• Migrated data from Unix IRMS Health care application onto SQL Server, using DTS / ETL.
• Design/Setup New Normalized Database structure to support new in house .NET application for use with clinical staff and consumer billing. Application and data environment in a clustered environment.
• Constructed numerous Stored Procedures and Triggers to populate and maintain patient data.
• Reporting needs meet with using SSRS and Confidential Access

Contract Software Engineer

Responsibilities:

• Development and maintenance of CA (Cost Accounting) NCR UNIX C daemons and utilities to aid in the processing of Patient Finical data.
• Develop NCR Teradata Macros and Stored procedures to aid in various applications and utilities using Teradata SQL.
• Develop and support Web pages used for the Cost Allocation application. This product is written on the IIS platform using the technologies of VBScript, JavaScript.
• Development and support of numerous Active reports (version 1.1) with VB 6.0 supporting the technology of MTS, COM and COM+. Confidential Access used for middle ware solutions between application/Data sources to reporting.
• Documentation of (Cost Allocation) application to include all Functions, ASP pages, Java classes and business logic processes.
• Work closely with user community to ensure project mile stone achievements and project completion.