SUMMARY:

• Results - oriented database architect / administrator / systems integrator / leader with over 18 years of experience in the development, build, test (SQA), production, installation, monitoring and support of large end-to-end solutions built on multiple database technologies.
• A Masters in Systems Management from USC and the right balance of technical skills helped me work with cross-functional groups to build a replicated database environment for an internal Cisco application and to build and support Confidential ., Smart Grid technologies, to include, large clustered databases holding near real-time data used in the analysis and management of utilities’ electric grids. In addition, my leadership and technical skills in database administration, SaaS, SDLC, and project management resulted in the build, house and support of large, multi-terabyte marketing databases and applications for Aetna, Humana, United Healthcare, Anthem (Wellpoint) and others in the healthcare insurance industry during my ten years with the Confidential

TECHNICAL SKILLS:

• Oracle Database Enterprise ed. 10g, 11g, 12c, RAC, ASM, Oracle Enterprise Manager / Grid Control(OEM), AWR, ADDM, Oracle Database Machine / Exadata, RMAN, NetBackup, Data Guard / StandbyDatabase, SQL & PL/SQL tuning, database tuning, SQL Server 2012 & 2014 with clustering, mirroring andlog shipping, MySQL 5.6 & 5.7 / MariaDB 10.1 & 10.2 with MySQL replication, Galera Cluster, andXtraBackup, Sybase IQ 12.(5, 6, & 7), Unix/Linux, CentOS/RHEL, shell scripting including awk, Erwindata modeler including Model Mart, PowerDesigner (Data Architect), Toad, DBArtisan, OLTP, OLAP, datawarehousing, analytics, Citrix, VNC, Java, .Net, SAS, Solaris, HPUX, and Linux administration, WindowsServer 2008, 2012 R2, 2016, TestTrack, MS Team Foundation Server (TFS), Atlassian Jira, Kanban,Bitbucket, Docker, Puppet, Git, SaaS, Cloud, SDLC, Waterfall, Agile, SCRUM, SOX and database role

PROFESSIONAL EXPERIENCE:

Confidential, Raleigh NC

Database Architect / Administrator

Responsibilities:

• Built a multi-node MySQL / MariaDB high-availability, replicated database environment for a Ciscointernal Ruby-on-Rails application used to store and scan release images for known vulnerabilities toinclude the collection and storage of NSRL and Protecode data. System built on the Cisco Cloud.
• Worked with the Ruby on Rails developers to optimize the data model using the MySQL Workbench andRuby Gem tools.
• Productionalized the environment by automating nightly backups, database replication, the collection ofoptimizer statistic, encryption of data in transit, and the monitoring of the system’s status.
• Performed slow-query analyses to determine appropriate indexing and necessary code changes to improvesystem performance.
• Produced a 50-page production database runbook describing the database environment and how toadminister the databases.

Confidential, Cary NC

Database Administrator

Responsibilities:

• Performed database administration (DBA) activities on ~100 Oracle 11g, and 12c Oracle Ent. Ed. Databases including Exadata and on ~1,600 SQL Server databases, versions 2008 & 2012 the majority on three-nodeclusters providing weekday and on-call support in a 24/7/365 environment for the client Leidos, Inc., a USgovernment contractor.
• DBA activities included installs, patching, configuration, monitoring, security, building of schema objects, and support for application teams on hundreds dev, QA, and production databases, to include performancediagnosis, advice on coding modifications and database design, performing database refreshes,import/export, and cloning.
• Performed backup and restore, automation of maintenance plans, and cluster database management.
• Documented various environments, installs and configuration setup, and performed capacity planning.
• Provided SOX support and database role recertification and began work on my CISA certification.

Confidential, Raleigh NC

Technical Consultant (database focus) / Integration (SQA) Engineer

Responsibilities:

• Installed database software, created new databases, built the database schemas, installed patches, and automated maintenance routines including backups using RMAN for the Oracle databases and
• Management Studio for the SQL Server databases.
• As a subject matter expert with the database focus, performed database activities including installs andsupport on Itron’s Openway Collection Engine, Openway Reporting System and Meter Data Management databases on versions 10g and 11g Oracle RAC and SQL Server 2012 and 2014.
• Worked with Itron’s R&D and the SQA teams to install, setup, and test the porting of the OpenwayCollection Engine .Net software application from Oracle to SQL Server 2012 and 2014.
• Used Erwin to make changes to the logical and physical data models to support the porting of the Itron Openway Collection Engine application from Oracle to SQL Server.
• Performed database administration (DBA) activities.
• Initially assigned to Itron’s Smart Grid implementation at San Diego Gas and Electric, San Diego, CA.
• This implementation included over two million Smart Grid endpoints and data management systems on Oracle databases ranging in size to multiple terabytes and the Openway Reporting System on SQL Server
• Enterprise Ed. Produced scripts for reports and system data analysis. Commuted to the project in San Diego 18 months until project wind down.
• Most recent Oracle installs, RMAN setup, etc. were on Oracle 11gR 2 11.2.0.4.
• Most recent SQL Server installs were on 2014.
• Attended Oracle 12c Grand Tour Workshop provided in-house by Oracle.
• Attended SQL Server Adminisration 2012/2014 class with Global Knowledge.
• Created and performed SQA test cases for the international smart-grid solution and the recently ported
• Openway Collection Engine software including installation and database builds, Scale testing, TestTrack, MS Team Foundation Server (TFS), Agile and SCRUM planning.
• Performed capacity planning on multiple database solutions.

Confidential

DBA Consultant

Responsibilities:

• GlassHouse provides vendor-independent data center consulting and managed services.
• Helped GlassHouse to move into providing outsourcing of database administration services by assisting with the preparation of SLAs, Terms of Reference, Escalation, and Runbook documentation and the interviewing and hiring of DBAs at their Service Operations Center in Cary, NC.
• Performed DBA activities on 300 Oracle databases versions 9i through 11g, to include Oracle RAC, ASM,
• Data Guard, OEM Grid Control, and database cloning. Most of these databases belonged to a client in thePharmaceutical Industry.
• Hired to assist GlassHouse with their endeavor to become a provider of database administration (DBA)services to multiple clients.
• Performed DBA activities on 300 Oracle databases versions 9i through 11g, to include Oracle RAC, ASM,Data Guard, and OEM Grid Control. The majority of these databases belonged to a large client in thebiotech industry, Biogen.
• Prepared SLA, Terms of Reference, Escalation, and Runbook documentation.
• Interviewed and assisted in the hiring of multiple DBAs to work out of the Glasshouse Service andOperations Center in Cary, NC.
• Trained newly-hired members of the database administration team.

Confidential

Director of Database Administration

Responsibilities:

• Confidential is a knowledge-based marketing solutions leader, helping companies manage, analyze andoptimize marketing data more effectively.
• Performed and coordinated DBAactivities on 60 Oracle databases, OLTP and OLAP (data warehousing /analytics), on single node and Oracle RAC installs, some using ASM, anOracle Exadata server, a Sybase IQdatabaseand 25 development and test databases. These databases on Oracle 9i, 10g and 11g were marketing databases we built, housed, and supported for numerous clients in the healthcare industry. Clients: Aetna,Healthnet, Humana, Mutual of Omaha, United Healthcare, and WellPoint (Anthem).
• Supervised a team of four DBAs and threeUnixadmins including hiring and appraisals.
• Prepared budget for personnel requirements, software and hardware purchases, software licenses, and software and hardware support contracts.
• Researched the latest technologies from Oracle, Sybase, and hardware vendors.
• Defined and implemented database security requirements.
• Performed capacity analysis and planning.
• Attended Erwin Data Modeler & Model Mart classes at Computer Associates. Defined the data modeling process, installed Model Mart on Oracle for version control, performed database modeling activities with the development team and defined and implemented the resulting physical data models in the databases.
• Assisted developers with SQL and PL/SQL queries.
• Performed database tuning and diagnostics, including use of AWR, Oracle software upgrades, patching, and new installs on Sun Solaris and Linux, to include ASM, CRS, and OEM/Grid Control.
• Setup of Oracle Recovery Manager (RMAN) and NetBackup. Extensive restore/recovery experience.
• DataGuard (logical/physical standby) methods also used.
• Produced scripts to automate backups, analyzing of tables, rebuilding of indexes, and the paging /notification of the DBA staff based on database conditions.
• Participated in the 24/7/365 on-call rotation.
• Transferred Oracle knowledge to the junior DBAs.

Confidential

Applications Development Manager

Responsibilities:.

• Designed Oracle backup/recovery processes.
• Performed capacity planning on the production systems.
• Performed systems administration on five H.P. 9000s including O/S patch installs and software installs forOracle and Vantive.
• Served as the systems architect and project manager on numerous I.S. development projects.