Management Manager
Resume:
JOHN C. WOOD
***********@*****.***
Frederick, MD
DOD Secret clearance
DHS (USCIS) Pubic Trust
PROFESSIONAL SUMMARY:
Extensive work on Oracle 11g and 10g involving database administration, support, installation, configuration, upgrades, patches, migration, backup and recovery, performance tuning, cloning, space management and security.
Manage backup & recovery of large databases and provided 24X7 support to high critical databases.
Manage root cause analysis and permanent fix of production problems.
Manage installation, administration and maintenance of Oracle 11g
Works extensively on Oracle Installation, Oracle Version Upgrade, Migrations (from 10g to 11g) and patching
Experience in performance tuning and database reorganizations.
Experience in Disk management and problem resolving techniques with a good understanding of capacity planning and efficient usage of the disk space.
Performed SAN analysis and provided recommendations.
Experience in all the phases of Software Development Life Cycle (SDLC) as well as Software Implementation Life-Cycle (SILC).
Experience in using Grid Control and OEM Features and worked with databases which have critical data
Extensively uses Database Administrative tools like Oracle Enterprise Manager, SQL*PLUS, TOAD
Monitors VLDB (Very Large Databases) using Grid Control
Experience in writing several Purging shell scripts on Linux which have been using as standard script at the workplace
Manage operational responsibilities like database refreshes/copy backs, security, documenting standards and procedures, data migration, data clean-up, data archiving, etc
Develops RMAN scripts for database back up and recovery including- hot and cold backup
Performance tuning of the database – SQL Tuning, Used Tuning utilities like STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, distribution of disk I/O, Sizing of tables and indexes
Manage Data Dictionary views, User Security and Auditing.
Experience in writing scripts to inform the DBA team on the status, performance and space management of the database
Experience in planning and implementation of off-site Disaster-Recovery planning and testing
Works with development and operations staff in resolving problems quickly and efficiently
Resolves the bottlenecks in all the database environments
Manage and monitors various database components (logical & physical) like table space, segments
Works extensively on shell scripting for backup, recovery and maintenance for databases
Team player with excellent interpersonal, analytic and communications skills
PROFESSIONAL EXPERIENCE:
Geocent – Vienna, VA
Oracle DBA
December 2015 to Present
Environment: Oracle 11g, Oracle RAC(11g), SQL Developer, SQL *Plus, Seibel
Supporting DHS on the their USCIS JETS Risk & Fraud, CIDR(Citizenship & Immigration Data Repository) project.
Manage performance tuning of the database – SQL Tuning, Used Tuning utilities like EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, distribution of disk I/O, Sizing of tables and indexes.
Manage database reorganizations and refresh schema-using Export/Import.
Creates database, table spaces, tables, indexes, setting privileges and user log-ins.
Refresh the Testing environment from production environment for testing purposes.
Perform plan analysis for Query Optimization and SQL tuning.
Assist tester’s with test scripts before deployment.
Analyzing tables & analyzing indexes to tune queries and increase performance.
Monitor and perform database sizing, table space management and rollback table space management, transaction management and security administration.
Support Security User Management, Privileges, Roles, Auditing, Profiling, and Authentication.
Manage Top Secret data, databases and servers.
Brontech Solutions – Greenbelt, MD –Junior Oracle DBA
October 2014 to December 2015(1 year contract) – Environment: Windows, RHEL, Oracle 11g, Oracle RAC (11g), 12(c), Data Guard, Oracle Grid Control, RMAN, SQL Developer, TOAD, SQL*Plus.
Installed, configures, and maintains Oracle 10g and 11 g R2 12c on Linux and also Upgraded from Oracle 10g to 11g.
Experienced work in RMAN recovery testing, and stand alone database.
Refreshed the Testing environment from production environment for testing purposes.
Created Cloned Database using RMAN on remote Server.
Managed performance tuning of the database – SQL Tuning, Used Tuning utilities like STATSPACK, TKPROF.
Managed sizing of tables and indexes, and tuned the SGA, distribution of disk I/O using EXPLAIN PLAN, AWR, and ADDM
Experienced using Grid Control extensively and set up Rules for alert notification and schedule RMAN backups
Experienced in writing shell scripts for purging trace files, alert log and network log files in Linux boxes which is used as standard script across all the databases.
Installed Oracle software using silent feature and also created databases.
Supported & maintained the Production/Development databases on various servers.
Extensively works on setting up auditing in many databases.
Experienced in managing Database Structure, Storage Allocation, Table/Index segments, Rollback Segments, Undo Segments, and Constraints.
Managed database reorganizations and refresh schema-using Export/Import.
Created database, table spaces, tables, indexes, setting privileges and user log-ins.
Supported Oracle DB backups (online/offline), logical backups and UNIX scripts, created clone databases, configured standby database, performed DBA day-to-day activities.
Supported Security User Management, Privileges, Roles, Auditing, Profiling, Authentication.
Monitored and performs database sizing, table space management and rollback table space management, transaction management and security administration.
Managed database monitoring and performance tuning using OEM (Oracle Enterprise Manager) and STATSPACK.
Created index creation and management for optimization of DB Processes.
Managed use of tools like TKPROF, STATSPACK, SQL advisor fortuning application and instances.
Conducted I/O tuning by moving data files and redo log files to faster disks.
Analyzed tables & analyzed indexes to tune queries and increase performance.
Used hints for SQL tuning and optimization.
Performed plan analysis for Query Optimization and SQL tuning.
Created a Clone Database using RMAN on remote Server and used SRVCTL commands for RAC Databases.
Used OEM and set up Rules for alert notification and schedule RMAN backups with failure notification.
Worked with Rman, monitoring Backup and Recovery
United States Army
Automated Logistic/IT Specialist
Ft. Huachuca, Arizona December 2008 to February 2011
Katterbach Kasrne Ansbach, Germany March 2011 to October 2014
Cross trained into a IT specialist on military orders, due to military down-sizing:
Worked with Oracle and MYSQL databases creating databases, tables, and scheduled backups performance tuning and troubleshooting.
Was responsible for secret clearance level assignments.
Worked with Linux and Unix performance tools, as well as Oracle and MYSQL performance tools.
Supervised a small squadron of soldiers during this mission. Led meetings, finalized decisions, and was responsible for each soldier professional and personal well being.
Responsible for all supply transactions regarding aviation equipment ensuring asset protection.
Maintained 100% wall-to-wall inventory of all tech supply equipment and merchandise.
Served as Production Control Clerk tracking all work production performed on all military aircraft's throughout the brigade such as work orders, supply transaction, and storing military equipment ensuring asset protection.
Opened work orders and dispersed to appropriate shops.
Controlled entire work flow process from beginning to end serving as final approval ensuring proper policies and procedures were adhered to.
Scheduled all monthly maintenance.
Established and maintained stock records and other documents such as inventory, material control, accounting and supply reports.
EDUCATION/CERTIFICATIONS:
BS Pursuant, Information Management Systems, University Of Maryland University College
University Of Maryland University College
Bachelor’s in Information management systems
Expected Graduation: June 2020
Certified, Oracle database 11g: SQL fundamentals I exam code: 1Z0-051-ENU-ONLINE certified 16MAY2015
Certification: Oracle Certified Associate(OCA) Pursuant
COMPUTER SKILLS:
Microsoft Office, MS Word, MS Excel, MS PowerPoint
ULLS-A (Unit Level Logistic System-Aviation)
SARSS (Standard Army Retail Supply System)
SAMS-E (Standard Army Material System-Enhanced)
TECHNICAL ENVIRONMENT: OPERATING SYSTEMS: Red Hat Linux RHEL 5.x and Windows XP; RDBMS: Oracle 11g/10g; LANGUAGES: SQL, PL/SQL,UNIX Shell Scripting, Ksh, bash and Perl Scripting
SOFTWARE/APPLICATIONS/TOOLS: DBCA, DBUA, Recovery Manager (RMAN), Oracle Enterprise Manager (OEM), OEM Grid Control, Oracle Data Guard, Oracle Management Service (OMS), Real Application Clusters (RAC), ASM, Sql Navigator, TOAD, Data Pump (expdp,impdp),SRVCTL,SQL*Plus
TUNING TOOLS: SQL TRACE, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM
WEB TOOLS: HTML, XML
Contact this candidate