William J. McCoy
PO Box *** Round Hill, VA ***** 571-***-**** acxdt2@r.postjobfree.com
I/T Management
Qualifications Profile
Highly self-motivated and results-driven management professional with 13 years providing high-performance leadership, global service delivery, and management of large database installations, information technology, database architecture development, and systems implementation. Detail-oriented, analytical and methodical with critical thinking to strategize solutions in addressing process and people-centric work issues. Versatile, adaptable, with fast learning abilities to acquire and apply new skills immediately and independently even under fast-paced work environments. Well-organized and resourceful with multitasking and prioritization skills that optimize resources to achieve outstanding results from concurrent tasks. Strong people management and exceptional interpersonal communication skills that inspire customer confidence while forging teamwork synergies with colleagues and subordinates across diverse ethnicities.
Key Expertise
•System Implementation Management
•Database Conversion/ Migration
•Data Security Management
•I/T Project Management Support
•OLTP & Data Warehousing
•Disaster Recovery Administration
•Large Database Management
•Project Resource Management
•Systems Development & Prototyping
•Resources & Budget Management
•Management Presentation
•Tehcnical & Functional System Documentation
•Multilingual Fluency in English, Bahasa Indonesian, Malay with basic Spanish and Hindi
Database Administration: Oracle databases running on multiple platforms including Windows, Linux, UNIX HP-UX and IBM/AIX v6.x; Oracle GoldenGate CDC 10g/11g, IBM/DB2 Database Server Administration, Exadata Storage Structure Configuration v.1:2; Dataguard physical/logical stand-by, SQL, PL/SQL, AIX, UNIX, Linux and Windows Scripting,
Security Clearances: Cleared with US government Department of Defense (Level – Secret), currently active, Cleared with Department of Homeland Security (Level- MBB), currently active
Professional Experience
Datapipe Inc Reston, Virginia
Senior MarkLogic/Oracle DBA Feb 2015 - Present
Support multi-tiered, multi-level commercial clients in Database
Administration and management. Support advanced monitoring systems,
replication and fail-over utilizing Oracle tools and third party vendor software.
Escalation/on-call support for large financial, retail and medical/pharmaceutical clients
requiring 24/7 high availability and utilization.
Support server-based and Cloud based systems housing multi-tiered, multi-leveled storage
and high availability, highly assessable database stacks.
Supporting and sustaining large scale Agile and Waterfall design strategies for commercial
customers.
Advising with costs and estimates as well as executing customer strategy/proposal
from conception to development to testing/integration to production.
Advanced NoSQL data extract and load utilizing MarkLogic Content Manager.
IBM-Kaiser Permanente (Contractor) Remote
Senior Oracle DBA (CDI Corporation) Sep 2013 – Jan 2015
Responsible for supporting the production, development and testing database environments. Provide 24/7 on-call support on a rotating bases. Administer and manage several large databases in RAC and non-RAC environment. Ensure backup and recovery and cloning of databases.
Responsible for the planning, administration, configuration, performance tuning, recovery, backup and maintenance of the Oracle database environment covering base definition, structures, documentation, upgrades, long range requirements, operational guidelines, protection, recovery, software installation, and resolving Oracle errors and failures. Provide Oracle RDBMS support along with Production Support and Troubleshooting.
Provide database support for GoldenGate replication on Real Application Clustered environment, one direction OGG data center configuration, and troubleshooting of Replicat and Extract issues. Managed large data movement utilizing various tools/assistance as BCV, RMAN, EMC Replication Manager
Collaborate with internal and end-client customer to maintain HIPAA standards and guidelines. Manage large storage databases; lead backup strategy for 4TB highly visible environment; conduct performance tuning of highly transactional OLTP databases to maintain access from users on a global scale across time zones and language/cultural differences. Work with project team in the implementation of new projects, analyzing performance
Assess customer needs and recommend improved configuration and system changes as needed. Performance tuning of database Provide 24/7 support & on call as required.
Department of Defense Washington, DC
Senior Oracle/DB2 DBA, Department of the Army Headquarters- Pentagon (Contractor) Aug 2012 – Aug 2013
Managed the army’s Financial Access Management Systems (FAMS) database and architecture. Provided database support covering system maintenance, patching, cloning, upgrades/installations and system administration, database analysis, design, problem solving, programming and/or system management in a multiple hardware and software environment. Implemented database, table, table space partitioning to ensure optimal delivery of data warehouse, Screened prospective candidates to ensure meeting the required technical aptitude for onboarding.
William J. McCoy
PO Box 167 Round Hill, VA 20141 571-***-**** acxdt2@r.postjobfree.com
Professional Experience (continued)
Department of Homeland Security Washington, DC
Senior Oracle/DB2 DBA, United States Center for Immigration Services (Contractor) Jan – Aug 2012
Responsible for implementing multiple IBM/DB2 version 9x databases supporting a Tivoli Storage Server, and LDAP Tivoli Identity Manager Environment. Designed and implemented strategy for database partitioning. Managed backup, test recovery, and LDAP level configuration for high availability user-managed environment. Configured Tivoli Storage Manager (TSM) for advanced backup tape storage for databases. Implemented monitoring tools (DB2 Data Studio, Control Center and Oracle Grid Control 11g/12c) for proactive maintenance.
Senior Oracle DBA (Contractor), JP Morgan Chase Columbus, OH Oct 2011 – Jan 2012
Provided technical support for Exadata Storage in the Development/Production environment. Used Oracle GoldenGate solution/configuration for heterogeneous databases (SQL 2005, Oracle 11g). Supervised a team of 21 I/T professionals in implementing Exadata rack storage server for the global banking and mortgage sector, leveraging several technologies such as Oracle GoldenGate and Exadata Cell structures to gain high availability and zero downtime.
Senior Database Administrator (Contractor), The Boeing Company, Washington, DC Jul – Oct 2011
Provided comprehensive database support in various multi-level computing environments. Managed Oracle 11g Active DataGuard as well as Oracle GoldenGate version 11.x for high availability. Administered data and system backup. Worked with a team of 200+ in managing 4000 or more databases in a very diverse and global environment.
Database Administrator, Oracle Corporation Reston, VA Mar 2009 – Jul 2011
Supported large national and international companies with multi-user, multi-tier computing environments. Maintained database instances with Oracle Recovery Manager (RMAN) by utilizing command-line, Grid Control, GoldenGate, Dataguard, Used Enterprise Manager and other tools to ensure high availability. Managed production databases for federal/private businesses. Tuned databases and servers using scripting to ensure high availability. Led DBA team to implement new backup/Change Data Capture plan for production environment. Co-led DBA team in consolidating multiple Oracle (9i, 10g, 11g Windows, Linux) installations to reduce cost and maintain availability. Tested and ensured database recoverability regularly. Upgraded Oracle E-Business Suite from version 11.2.0.5 to R12 version 12..0.2 for large scale retail enterprise.
Senior Database Administrator, Newbreed Logistics High Point, NC Mar 2008 – Mar 2009
Management of production and Development databases using Oracle Recovery Manager (RMAN).
Database Administrator, University of Michigan Ann Arbor, MI Sep 2004 – Feb 2008
Provided extensive DBA support to approximately 40,000, Students, faculty, employees.
Database Administrator, The Atlanta Journal and Constitution Atlanta GA Aug 2001 – May 2003
Designed, implemented, and maintained databases. Formatted and generated reports, including summaries, statistics and information. Tested and documented work; wrote and maintained operator instructions.
Education & Credentials
Business Administration, CLEARY UNIVERSITY Ann Arbor, MI
Professional Training & Certifications
Administering MarkLogic Server
Oracle Certified Professional (Version 10g)
Oracle Administration Workshop Level I and II Oracle SQL Oracle
Exadata Storage Structure Admin I and II
RMAN Backup and Recovery 10/11g
Oracle Applications Server Administrator 10g
Oracle Real Application Clusters Administration
Certified Release of Information Specialist
Awards & Recognition
Recipient of the Employee Recognition and Dedication UMHS (2005, 2004),
Award for Dedication and Excellent Attendance (1991)
Professional & Community Affiliations
Key Note Speaker, Institute for Electrical and Electronics Engineers (IEEE), Ann Arbor, MI
Data Fellow, Democratic Party Information Technology Volunteer, Ann Arbor, MI
Transplant Center Volunteer, University of Michigan, Ann Arbor, MI
Volunteer Service, Mental Unit University Hospital, Newark, NJ
Volunteer Coordinator, Apalachee Center for Mental Health, Tallahassee, FL
Training & Expertise in MarkLogic Version 7
Administering MarkLogic Server
MarkLogic ACID Transactions Database
Replication
Government Grade Security
MarkLogic NoSQL technology
MarkLogic Architechture
MarkLogic 7 Installation and Configuration on Linux, Unix and Windows
MarkLogic REST, XQuery, and XPATH For Administration
Migration from RDBMS to MarkLogic
MarkLogic Search Foundation
MarkLogic Indexing
Content Processing Framework
Security
Transaction Based Processing for MarkLogic
Data Merging
MarkLogic Rebalancing
MarkLogic Backup and Restore Procedures
HADR for MarkLogic
Monitoring MarkLogic Database, Application Architecture
MarkLogic Support Network