SUMMARY:

• I'm a certified results - driven professional with over 15 years of Information Technology (IT) experience in government contracting that includes more than seven years of Oracle database development, administration, performance tuning, upgrades and maintenance.

TECHNICAL SKILLS:

Operating Systems: AIX 6.1/7/1, VMware (Vsphere4&5), Windows O/S (Windows 2008/2012, MS Office suite).

Hardware: IBM Power 740/780, EMC-Celerra, EMC Symmetrix.

Software: TOAD, SQL Developer, OEM Grid Control, Putty, Hummingbird Exceed, FileZilla.

Databases: Oracle 9i, 10g, 11gR2, Data Guard, Oracle OEM Grid Control.

Languages: SQL, SQL*Plus, PL/SQL, Unix Shell scripting

Tools: PL/SQL Developer, TOAD, SQL*Loader, AWR/ADDM, Oracle Enterprise Manager (OEM), Oracle Recovery Manager (RMAN).

WORK EXPERIENCE:

Confidential

Sr. Oracle DBA

Responsibilities:

• Expert in the creating and administering Oracle databases on Oracle 9i, 10g and 11g in UNIX and Windows operating systems with experience in Oracle 12c administration.
• Expert in configuring and managing Oracle Data guard in physical and snapshot standby.
• Expert in creating and enhancing shell scripts to automate jobs within and across databases and domains.
• Create and schedule Cron jobs for logical, RMAN backup and shell scripts jobs. Also schedule weekly cold backup jobs for some Oracle 9i databases that support legacy applications.
• Created a scrubbing database for the financial application service unit. This scrubbing database is use to scrub out the financial database personal identifiable information (PII) before being exported to the test environment during database refreshes to comply with security directives.
• Perform quarterly Oracle critical patch updates (CPUs) one run-off security patches during agency’s established maintenance windows. Troubleshoot and resolve any issue discovered during test before production deployment.
• Develop a new Standard Operation Procedure (SOP) and step by step instructions on installing Oracle 12c database Patch Set Updates (PSU) - 12.1.0.1.6 (19769486).
• Performed Oracle database upgrade and Migration from Oracle 9i and 10g to 11gR2. This help move organization towards archiving goal of a unified Oracle database version for all applications.
• Developed and review capacity planning with performance metrics planning reports that are presented to management on a scheduled basis. The reports help management with decision making on procurement of next-generation equipments.
• Work and assist developers with new database creation from development to production using the System Development Life Cycle (SDLC).
• Support developers for code promotion from development/test to production environment.
• Clone production databases for training, testing or development purposes as requested by developers.
• Develop and enhance shell scripts to improve automation of various tasks such as space usage and failed backup jobs monitoring.

Sr. Oracle DBA

Responsibilities:

• Planned, installed, configured, managed and troubleshot Oracle 10g and 11g databases on Linux and Windows OS.
• Created tablespaces, tables and views for developer and client per request.
• Remotely assisted users via SSH and remote desktop to administer Oracle databases to remote users
• Utilize database security guidelines per Oracle recommendations when creating and managing users and roles. Also assign users only needed roles per application requirements.
• Experienced compiling and running shell scripts on Linux, and Windows platforms.
• Created and maintained Oracle 10g and 11g databases using the optimal flexible architecture (OFA) for best layout to enhance data file, rollback, and redo objects.
• Documented database structure, changes, problems, issues for future reference
• Assisted developers in tuning databases to maximize query result return time
• Partitioning large tables using partitioning keys (Range partitioning)
• Performing exports, cold and hot database backups
• Providing remote technical support using SSH and terminal services
• Perform database security management, user permissions and privileges in accordance with application/database requirements.
• Configure, run AWR and ADDM to diagnose and tune databases for optimal performance.
• Use Remedy ticketing system to monitor trouble tickets and follow ITIL processes for incident and problem management.
• Use the Oracle Enterprise Manager (OEM) grid Control to perform various Oracle functions and monitoring.

Oracle DBA

Responsibilities:

• Analyzed and reviewed existing database architectures and provide expert support and inputs for better database performance.
• Installation and maintenance of Oracle Internet Directory and application servers. Created and configured databases per developers' and user's requirements.
• Tuned database to ensure optimal level of performance and availability.
• Installed and configured Oracle client on developers and end-users machines for network connections.
• Planned, designed, implemented, maintained and upgraded Oracle 9i to 10g.
• Solid experience in disaster recovery, routine maintenance for Oracle databases
• Created tables and views for developer and client needs
• Managed and maintained the data dictionaries
• Performed daily incremental backup and full weekly backup using RMAN utility.
• Maintained database log and audit files.
• Monitored and tuned database performance using AWR and ADDM reports in OEM.
• Enforced proper database access methodology practice.
• Responsible for building and deploying application WAR files developed by the developers to fix bugs.

Network Administrator

Responsibilities:

• Configured, Troubleshot and resolved TCP/IP, Frame Relay, ATM, EIGRP, PPP, ISDN, BGP, OSPF, and RIP problems on various Cisco equipments.
• Primarily responsible for supporting and maintaining client's WAN and LAN connections including ATM, Frame Relay, and dedicated circuits using Cisco equipments.
• Configured and implemented Catalyst 3560G Switches with enhanced image to provide routing between vlans, with dot1q trunking enabled between switches, and spanning-tree port fast, enabled on ports.
• Configured and implemented two Cisco ASA (Adaptive Security Appliance) 5540 to provide both site-to-site and remote-access VPN solutions.
• Configured and installed Cisco 2600 series routers with WICs (WAN Interface Cards) Cards and two Fast Ethernet Interfaces to replace existing Cisco 2524 routers.
• Created Visio diagrams of the entire LAN and WAN infrastructure to provide the NOC with adequate information for Tier 1 troubleshooting.
• Provided VPN support to over 2500 End Users throughout the nation.

System Administrator

Responsibilities:

• Supported the Center for Drug Evaluation & Research (CDER/FDA), in various buildings onsite and remotely. Supported the migration of Windows 98/NT systems unto Windows 2000 active directory.
• Utilized the Windows Active Directory structure to manage and support user network accounts. Used the SMS tool to troubleshoot and resolve user pc problems
• Performed server (NT/ Win2K/2003) maintenance including upgrades, backups and configuration of resources and end-user services.
• Worked with project managers to ensure certification and accreditation of FDA infrastructure and compliance with NIST, FISMA, and other government guidelines.
• Worked directly with management to evaluate client requirements, plan projects, & document Standard Operating Procedures (SOPs) and Service Level Agreements (SLAs).
• Worked directly with senior management and led a Functional Team in the development, implementation, and integration of standards-based security policies and management of procedures for systems and handheld devices.