SUMMARY

• An experienced Oracle Database Administrator with over 7 years of IT related experience with 5+ years of extensive knowledge and proficiency in Oracle 10g and 11g database design, administration and systems analysis within multifaceted environments.
• Demonstrated experience with performance tuning of Oracle databases with various in - house and vendor applications.
• Additional experience includes Project Management.
• Possess exceptional communication and organization skills with remarkable attention to details skills.
• A good team player, with the ability to coordinate multiple activities; determine and analyze problems and implement corrective actions.

TECHNICAL SKILLS

Database Technologies: Oracle 10g, 11g R2 RDBMS

Operating Systems: Red Hat Linux, Sun Solaris, HP-AIX

High Availability Solutions: RAC, Data Guard and ASM

PROFESSIONAL EXPERIENCE

Confidential

Oracle Dba

Responsibilities:

• Perform Oracle Database LifeCycle Management (LCM) tasks that included migrations, patching, upgrades, automation and decommissioning legacy databases.
• Upgrade databases from 10g, 11g to 12c (12.1.0.1 and 12.1.0.2) by doing either in place upgrades for dedicated databases or migrations for shared databases.
• Play a role in the design, implementation and maintenance of production databases.
• Install and configure Oracle 11g software on LINUX/ AIX / UNIX operating systems.
• Apply Oracle quarterly patches of the current PSU version to non-RAC and RAC configured databases.
• Perform data and metadata transfer from legacy servers to newly installed servers using Data Pump.
• Implement Oracle Database advanced security practices such as Transparent Data Encryption (TDE) and Data Masking to safeguard information.
• 24x7 remote support and on call Database support using RSA-VPN .
• Interact with development and end-user personnel to determine application data access requirements.
• Configure and manage standby databases using Data Guard.
• Perform SQL tuning using tools such as SQL Tuning Advisor, SQL Trace, ASH, AWR, and Explain Plan.
• Build and configure RMAN Recovery Catalog for Backup and Recovery strategy.
• Implement and support Administration tasks such as database utilities, and data replication/refresh technologies for both PROD and NON-PROD environments.
• Manage database security by creating and assigning appropriate roles and privileges to users depending on the user activity.
• Documentation.

Confidential

IT PROJECT MANAGER

Responsibilities:

• Day to day management of project resourcing requirements.
• Acted as first point of contact to customers responsible for handling all the incidents on related databases.
• Created and managed project plans in line with agreed project delivery timescales and budget.
• Responsible for the creation, tracking, updating of project and resourcing reporting documentations.
• Scheduling and taking part in project planning meetings to establish SLAs with backup strategies; and in executing this using RMAN/OEM.
• Utilied the CRM ServiceNow to manage Ticket assignments, updates and for change management.
• Planned and contributed to failovers/switchovers using Data Guard for Disaster Recovery (DR) and High Availability.
• Proactively used Oracle Diagnostics tools like Explain Plan, SQL Trace, TKPROF, AWR to analyze timing and execution plan for tuning. Also used TOP, VMSTATS, SAR to understand the impact on memory and CPU by processes.
• Mentored junior DBAs and managed engineers to establish and meet technical needs of projects, and also developed SOP’s for daily administration and project support.
• Scheduled and led project update calls/meetings, and circulated updates or follow up actions.

Confidential

Oracle database administrator

Responsibilities:

• Installed and configured Oracle 10g/11g servers and created of databases in UNIX, Linux and windows environments.
• Planned and scheduled Backup/Recovery Strategy (with RMAN); took Logical Backups (with Export/Import Data pump utilities).
• Created primary objects (tables, views, indexes, synonyms, procedures, functions and triggers) to help application developers with the application design.
• Performed database security and user administration via roles, profile, privilege, synonyms and auditing.
• Performed data transfer using Export/Import and Data pump.
• Performance tuning and provided technical support and troubleshooting assistance to application development teams for Oracle related issues.
• Planned and implemented the configuration and installation of Oracle Enterprise Manager (OEM) for monitoring daily database activities and overall performance, growth and tuning configurations.
• Provided capacity planning, tuning and administration support to application development efforts in PeopleSoft. Goals achieved ranged from I/O minimization, improved hit ratios, contention reduction, high database availability etc.
• Designed, tested, implemented and documented database migration procedures involving the use of the export/import and migration utilities.
• Used Tablespace Manager, Oracle Expert and STATSPACK to monitor performance bottlenecks, database response time, instance workload and operating system resource usage.
• Maintained record of daily data communication transactions, problems and remedial action taken, and installation activities.