SUMMARY

• Over six (6) years of Oracle Database Administrator (DBA) experience across Windows, Unix/Linux and Solaris platforms supporting web - based and client applications.
• Seeking a technicalposition in oracle database administration to furtherenhancemy career and skill set.
• Self-motivated,versatile team player wif excellent interpersonal and technical skills.

TECHNICAL SKILLS

Operating Systems: Windows, Linux Red Hat, zLinux and Solaris.

Languages: .Net, Python, PHP, PL/SQL, SQABasic, J2EE, and SAS.

Databases: Oracle, Informix, and Sybase.

Applications: MS Products, Crystal Report, and Siebel.

Servers: Microsoft IIS, VMWare, WebLogic and WebSphere.

Tools: SQL Developer, Toad, Oracle Forms, Telnet, FTP and Putty.

Backup Tools: NovaBACKUP, NETBACKUP and Veritas.

PROFESSIONAL EXPERIENCE

Oracle Database Administrator

Responsibilities:

• Administer over 70 database servers across multiple database environments via use of command line and Oracle Enterprise Manager (OEM) including 12c.
• Installed and managed Oracle Real Application Cluster (RAC) database wif more than 15 applications.
• Upgraded databases from 11gR2 to 12c on Red Hat Enterprise Linux (RHEL).
• Installed and configured Oracle Data Guard databases wif teh sizes from 3TB to 10TB on a four node RAC.
• Installed Oracle Golden Gate for disaster recovery process on test database servers.
• Performed database tuning, analyze objects, and recommend changes to improve performance.
• Identified objects no longer accessed and removing those objects which results in saving space in teh databases.
• Maintained DATA GUARD to provide high availability by implementing physical standby database and snapshot-standby for reporting purpose.
• Implemented Database resource manager to segregate teh current workloads at production database and reduce teh resource consumption for high volume transactions.
• Provided support for Oracle RAC, including applying patches, and performance tuning.
• Performed trace analysis, service creation for teh apps to fail over, cluster and system management.
• Refreshed database using export/import from production to other lower database environments.
• Implemented partitioning on large tables, perform composite partitioning, local indexes, and global indexes.
• Implement RMAN backup utilizing Crontab job.
• Worked wif UNIX shell scripts, materialized views, and Capacity planning.
• Performance tuning using AWR, EXPLAIN PLAN, ADDM and Statspack.
• Provided database support for development and deployment of database scripts in Development, Test, Pre-Production, and Production environments.
• Created and supported schemas including various database objects.
• Provided database administration support for application development teams for Maintenance and Emergency software releases.
• Nagios alert monitoring system for database servers’ activities.

Oracle Database Professional

Responsibilities:

• Implemented Oracle Real Application Cluster (RAC) including Grid Infrastructure and ASM disk groups on Red Hat Linux.
• Assisted wif teh specifications and requirements for determining hardware, network, and storage requirements to support databases.
• Kept teh databases up to date wif respect to teh latest database security patches.
• Was responsible for database maintenance, backups, recovery, patching, upgrades, performance tuning and user access control.
• Successfully implemented physical standby database using Oracle Data Guard and Active Data Guard feature for High availability configuration in RAC environment (RAC to RAC Data Guard).
• Upgraded database 10g to 11.2.0.4 Oracle database binary version.
• Configured notifications on Cluster activities, tablespace utilizations, Listener alerts via Oracle Enterprise Manager (OEM).
• Successfully installed Oracle Golden Gate replication between sites for High availability.
• Parallelly configured and maintained Windows and zLinux servers wif Oracle database.
• Assisted application DBA engineering teams wif performance and tuning (e.g: database parameters, indexes, and PL/SQL).
• Worked extensively on Performance Tuning, Memory (SGA) Tuning, Net backup, RAID, and RAW Devices.
• Strong experience in mentoring wif team members including documentation for database installation and configuration.
• Created and configured Real Application Cluster (RAC) on Windows servers.
• Was monitoring databases using Grid control wif proactive measures.
• Provided Pre and Post migration statistics for optimal functioning of teh databases.
• Data pump export / import from Production to teh Reporting Server on request basis.
• Supported Oracle Data Guard replication and physical standby for Disaster recovery.
• Created and monitored Job Scheduling for databases through Crontab as well as windows job scheduler.
• Trained resident DBA in administration, performance tuning, networking, backup and recovery of Oracle databases.
• 24/7 on call rotation production database.

Confidential, Reston, VA

Oracle DB Admin

Responsibilities:

• Installed and configured standalone 10g and 11g Database servers for Development, Test, Dev, Pre-prod, and Production environments.
• Installed and configured four nodes Oracle Real Application Cluster (RAC) database environments on 11gR2 wif ASM file system on Linux environments.
• Performed maintenance tasks including scheduling backup jobs, monitoring job failures, and troubleshooting.
• Used Oracle RMAN backup for Hot-incremental backups.
• Upgraded and applied CPU patches and bug fixes as required, and troubleshoot issues in various modules.
• Was responsible for collecting and analyzing performance statistics for resource consumption and performance Anomalies, managing Tablespaces, Datafiles, Rollback segments, and Temporary tablespace.
• Built reporting against database objects and Complex Custom SQL.
• Used EXPORT/IMPORT to perform schema level, table level, and full database imports as per application requirements.
• Successfully migrated databases from legacy hardware system to new Linux servers, running Oracle 10g over Oracle 11gR2.
• Developed scripts to proactively monitor teh databases and alert teh DBA team on events such as running out of storage space.
• Setup, configured and maintained of standby databases using Data Guard to ensure disaster recovery, and data protection.
• Scheduled and maintained RMAN (Recovery Manager).
• Monitored databases and performance tuning using OEM (Oracle Enterprise Manager), AWR, and ADDM.
• Applied PSU patches to Oracle Databases and Oracle Applications.
• Clear documentation was prepared on all teh processes like program specification, bugs fixing logs and change requests for future reference.
• Created UNIX shell scripts to automate batch jobs through Crontab.
• Involved disaster recovery planning; detailed out teh processes and procedures of implementing disaster recovery; implemented database backups and disaster recovery strategies using RMAN.
• Participated in business requirement gathering and applying teh business logic at teh database level.
• Analyzed and managed of Oracle problems/defects using Service Request (SR) wif Oracle Support.
• Applied Oracle Quarterly patches for database enhancements.