SUMMARY:

• Proven and accomplished Oracle Database Administrator with demonstrated success in implementing database solutions to improve business functionality in diverse environments.
• Over 12 years of progressive IT experience with Eight years of proven track record of improving and maximizing Oracle 9i, 10g, 11g, 12c cloud database performance with excellent abilities implementing network reliability measures. S elf - motivated and exceed ongoing and overlapping deadlines in fast-paced environments.

SKILL:

• Experience using BMC Remedy Change Management version 7.6.04.
• Good understanding of Oracle design architecture security auditing & performance tuning.
• Backup and Recovery utilizing Rman
• Data Pump
• Installing/setting up of Data Guard
• ASM
• RAC 10g
• 11g and 12c
• 10g Oracle 11g Golden Gate for replication upgrade and migration.
• DBA Tools: Oracle’s Enterprise Manager 12c (Cloud)
• SQL Developer
• Grid control (10 and 11)
• DB console
• Putty & Humming Bird.
• Experience with oracle performance tuning tools such as Automatic Database Diagnostic Monitor (ADDM)
• Automatic Workload Repository (AWR)
• Remote Diagnostic Agent (RDA) and SQL Performance Analyzer (SPA).
• Ability to diagnose and correct problems such as but not limited to: errors caused by program faults system resource limitations and database configuration settings.
• Production Support experience supporting a 24x7 production environment. Good skills in automation (shell scripting) and documentation. Good communication skills and the ability to work as a team member.

PROFESSIONAL EXPERIENCE:

Senior Oracle Database Advisor

Confidential

Responsibilities:

• Evaluate customer Oracle database requirements and develop optimal solutions to address their needs
• Document designs, configurations and project results
• Provide hands-on delivery of production deployment and migration
• Participate in large, complex Oracle database deployments, Migrations (Unix to Linux), consolidations and upgrades projects.
• Execute engagements independently or as part of a team for large deployments
• Address engagement requirements with minimal need to escalate to additional resources
• Provide consultative approach to develop, present and explain the value of proposed infrastructure solutions to customers
• Perform a wide variety of technical and administrative duties in overall enterprise solution assessment, design, validation, development, delivery and sales
• Operational support work in a highly decentralized and customer facing environment
• Performing user maintenance such as adding users, and maintaining security such as granting access to only required database objects. Providing support for database migration from development to production.Administered and completed Data Uploads utilizing Export/Import and Data Pump to perform refresh, migrate and clone schemas, tables and databases.

Oracle Team Lead

Confidential

• Proactive Monitoring and support of over 800 production and 400 development and QA databases, troubleshooting and maintenance via OEM Grid Control 10g, 11g and 12c in a Linux environment.
• Performing ongoing database maintenance, patching and upgrade from 11.2.0.3 to 11.2.0.4.
• Performing ongoing Rac cluster, grid, ASM and Data guard upgrade and patching.
• Optimizing database uptime/availability and performing routine audits of DBMS.
• Maintain and support RAC 10g and 11Gr2 environment in production which includes patching and migration.
• Installation, configuration, and support of Oracle Database 10g, 11g and 12c Performance tuning using oracle performance tuning advisors. Installation, configuration, and support of Oracle Grid 11g and 12c.
• Responsible for developing the upgrading strategy, 11gR2 Grid Clusterware RAC database testing and implementation Architect Golden Gate (10.4, 11.1 and 11.2.0) heterogeneous replication solutions
• Designed, Developed Implemented “Zero-downtime” bi-directional replication for data center migration and 11GR2 upgrade projects.
• Implemented active-active and active-passive replication solutions. Coordinate and lead disaster recovery testing exercises to guarantee business continuity
• Trained in-house production DBA staff on golden gate support, maintenance and troubleshooting procedures.
• Monitors Databases for Optimal Performance acting quickly to mitigate performance Issues. Performing space maintenance, database tuning, and configuration maintenance.
• Assist with Database Engineering efforts as requested to include deployments of new databases, data migration and patch/upgrade planning and documentation activities Provides guidance and recommendations for efficient use of database resources. Implementing/maintaining automation of regularly scheduled administrative tasks.
• Installing, setting up and configuring Oracle 12c agents and 11g databases. Administering, troubleshooting and debugging Oracle databases.
• Providing problem resolution for Oracle related issues.
• Developing and maintaining documentation for Oracle software configuration.
• Developing and maintaining operational standards/procedures for Oracle, providing daily monitoring to include (backups, error and system logs, database statistics, DBMS system utilization, and disk utilization and database availability).
• Monitoring ticket tracking system for (Remedy ) problem reporting system and responding to problem tickets according to established procedures and guidelines.
• Performing user maintenance such as adding users, and maintaining security such as granting access to only required database objects. Providing support for database migration from development to production.Administered and completed Data Uploads utilizing Export/Import and Data Pump to perform refresh, migrate and clone schemas, tables and databases.

Confidential, Arlington, VA

Senior Oracle DBA

• Responsible for overall strategic planning and redesign of databases requirements gathering and analysis, design, test and implementation through the phases of System Development Life Cycle. Creation, migration, upgrade and administration of 9i, 10 g and 11g Oracle database, SQL server 2005/2008/2012 for development, QA and production in RHEL 5.4/6.4, Unix, Solaris 10 and Windows environments.
• Developed and implemented database automation solutions and performed QA verification of various databases.
• Migrated databases to new datacenter with zero downtime using Golden Gate replication technology.
• Implemented Active Data Guard with fast start failover options, proactive monitoring and support of the RAC High availability set up, applied Oracle patches (interim, CPU, PSU) for bug fixes and security. Performed database, schema and table level refreshes/overlay.
• Used Oracle support to troubleshoot and solve critical database issues.
• Implemented and monitored RMAN backup jobs.
• Upgraded 11gR2 RAC Grid Infrastructure to 11.2.0.3 from 11.2.0.1.

Confidential, Washington, DC

Oracle DBA

• Performed proactive performance monitoring, reporting, and tunning of Oracle databases to ensure the highest standards of availability, resilience, integrity, security and performance required by business systems.
• Managed and maintained backup and recovery procedures (RMAN and Data Pump), rollout, patches and upgrades. Set up, configured and troubleshot Oracle streams replications.
• Resized, relocated and duplexed redo logs to either reduce log switching or eliminate contention. Resized, cloned, moved, partitioned and stripped table spaces, tables, indexes and rollback segments as the case might be.
• Performed data migration using Import/Export, Data Pump and SQL*Loader either interactively or batch mode.
• Designed, tested, implemented and documented database migration procedures.
• Provided a 24/7 support.
• Spearheaded special projects by instructing management on space projections for budget purposes, and database concepts during database tuning and report analysis.

Confidential

Oracle DBA

• Performed proactive monitoring of Oracle database using OEM and Grid Control. A member of the DBA team that managed several production and development databases running in a production support system of a telecommunication service provider using Oracle 9i, 10g and 11g on Unix OS, Sun Solaris and Windows NT servers.
• Installed and configured the Oracle software on several Unix and Windows servers. Successfully implemented scripts for new database creation and database moves.
• Executed Oracle TKPROF on session trace files to identify wait events, CPU timing and to query the Explain Plan.
• Created the development database hot backup and cold backup scripts scheduled utilizing Veritas net backup. Implemented database security through user administration, granting correct roles and privileges and the maintenance of the password utility.
• Tested and applied Oracle patches for software fixes and database upgrades.
• Managed logical and physical data structures, resolved errors from database links, snapshots and table space fragmentation.
• Troubleshot and resolved database connectivity issues for clients/users.
• Configured and created databases in the development, testing and production environments. Successfully upgraded several databases from 9i to 11g while providing both technical and functional support to internal customers.
• Developed and implemented Unix shell scripts used for both physical and logical backups.

Confidential

Network and Computer System Administrator

• Installed, configured, maintained and resolved issues for the networks.
• Planned, coordinated and implemented network security measures to protect data, software and hardware.
• Performed data backups and disaster recovery operations. Operated Master Console to monitor the performance of computer networks and to control user’s access.
• Designed, configured and tested computer hardware, networking software and operating system software. Trained and supervised staff, or participated in staffing decisions.
• Evaluated data processing proposals to assess project feasibility and requirements.
• Met with department heads, managers, supervisors, vendors, and others, to solicit cooperation and resolve problems. Stayed abreast of advances in technology.
• Reviewed project plans to plan and coordinate project activity.
• Developed computer information resources, provided data security and control, strategic computing, and disaster recovery.
• Provided users with technical support for computer problems.

Confidential

Computer Support Specialist

• Oversaw the daily performance of computer systems.
• Answered user inquiries regarding computer software or hardware operation to resolve problems.
• Entered commands and observed system functioning to verify correct operations and detect errors. Set up equipment for employee use, performed or ensured proper installation of cables, operating systems, or appropriate software.
• Installed and performed minor repairs to hardware, software, or peripheral equipment, followed design or installation specifications.
• Maintained records of daily data communication transactions, problems and remedial actions taken, or installation activities.
• Read technical manuals, conferred with users, or conducted computer diagnostics to investigate and resolve problems or to provide technical assistance and support.
• Referred major hardware or software problems or defective products to vendors or technicians for service.
• Developed training materials and procedures, or trained users in the proper use of hardware or software.
• Conferred with staff, users, and management to establish requirements for new systems or modifications.