Database Architect / Administrator / leader
Resume:
Joel Fox
***.****@*****.***
**** ***** ***** ****** **., Apex, NC 27523
SUMMARY
Results-oriented leader / database architect / administrator / systems integrator 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 Itron, Inc., 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 KBM Group
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 / Standby Database, SQL & PL/SQL tuning, database tuning, SQL Server 2012 & 2014 with clustering, mirroring and log shipping, MySQL 5.6 & 5.7 / MariaDB 10.1 & 10.2 with MySQL replication, Galera Cluster, and XtraBackup, Sybase IQ 12.(5, 6, & 7), Unix/Linux, CentOS/RHEL, shell scripting including awk, Erwin data modeler including Model Mart, PowerDesigner (Data Architect), Toad, DBArtisan, OLTP, OLAP, data warehousing, analytics, Citrix, VNC, Java, .Net, SAS, Solaris, HPUX, and Linux administration, Windows Server 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 certification.
TRAINING
Oracle Database Administration.
Oracle Database Tuning.
Oracle SQL and PL/SQL Programming.
Oracle Backup and Recovery
Oracle Grid Control
Oracle Database Machine / Exadata
Oracle 12c Grand Tour Workshop
SQL Server 2012 & 2014 Administration
Microsoft Solutions Development Discipline
Sybase IQ Database Administration
Erwin Data Modeler and Model Mart
SAS Base (I and II)
SAS Warehouse Administrator
PROFESSIONAL EXPERIENCE
Cisco Systems Jul 2017 – Feb 2018
Database Architect / Administrator
Built a multi-node MySQL / MariaDB high-availability, replicated database environment for a Cisco internal Ruby-on-Rails application used to store and scan release images for known vulnerabilities to include 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 and Ruby Gem tools.
Productionalized the environment by automating nightly backups, database replication, the collection of optimizer 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 improve system performance.
Produced a 50-page production database runbook describing the database environment and how to administer the databases.
HCL America Nov 2015 – Mar 2017
Database Administrator
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-node clusters providing weekday and on-call support in a 24/7/365 environment for the client Leidos, Inc., a US government 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 performance diagnosis, 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.
Itron, Inc. May 2010 – August 2015
Technical Consultant (database focus) / Integration (SQA) Engineer
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 and support 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 Openway Collection 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 11gR2 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.
GlassHouse Technologies July 2009 - April 2010
DBA Consultant
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 the Pharmaceutical 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 the biotech 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 and Operations Center in Cary, NC.
Trained newly-hired members of the database administration team.
KBM Group (KnowledgeBase Marketing, Inc.) May 1999 - June 2009
Director of Database Administration
KBM Group is a knowledge-based marketing solutions leader, helping companies manage, analyze and optimize 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 IQ databaseand 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.
Ericsson, Inc. November 1996 - May 1999
Applications Development Manager
Ericsson is one of the world’s leading providers of technology and services to telecom operators.
Managed a team of 14 software developers and DBAs involved in Java and ASP, .NET applications to include resource planning, hiring, and performance evaluations.
Senior Oracle DBA on the DBA team
Performed DBA functions on 11 Oracle instances (OLTP and OLAP processes) and three SQL Server instances.
Performed data modeling, database creation, and database tuning on numerous projects to include data warehouses for financial reporting and quality statistic, and applications for inventory control, orders and sales.
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 for Oracle and Vantive.
Served as the systems architect and project manager on numerous I.S. development projects.
EDUCATION
University of Southern California
Master of Science Degree in Systems Management
Specialty Option: Information Systems
University of Maryland
Bachelor of Arts Degree in Business Administration
Minor: Computer Studies
Contact this candidate