PROFESSIONAL SUMMARY:

• Highly Energetic With 7 Years of Hands - On Experience in Oracle Database Administration, Production Support, Installation, Configuration, Upgrades, Performance Tuning, Backup and Recovery, Cloning, Space Management, and Database Security with Oracle Software 13C/12C/11G/10G on Red Hat Linux, Hp-Ux, Aix
• Installation and configuration of Oracle Server 13c/12c/11g RAC with ASM on multi node systems on OEL, RHEL, HP-UX, UNIX for OLTP environment on Very Large Databases (VLDB)
• Currently managing 190+ databases including Customer Care & Billing (CC&B) db’s, Data Warehouse db’s, SAP db’s, PeopleSoft db’s and many more applications associated db’s
• Managing multiple databases in TB size with total accumulated storage for all db around 110TB.
• Extensive experience in supporting Oracle product Customer Care & Billing CC&B applications.
• Migration of databases from one platform to another platform.
• Upgrading databases by applying patches, patch sets and critical patch updates.
• Extensive experience on Oracle 12c/11g/ASM/RAC and Upgrading standalone databases to 11g RAC environment
• Participate in the implementation of database architecture and strategies, and in the definition of standards for database environment
• Perform impact analysis whenever a change is introduced to existing database system to mitigate risk and prevent unplanned disruption of business
• Manage database services during planned and unplanned outages of systems and applications.
• Experience in Configuring Automatic Storage Management (ASM).
• Forecasting monthly, quarterly and yearly storage and coordinating with Storage team.
• Maintain optimum level of performance and reliability of Oracle technology with focus on Oracle database
• Recently Installed 13c Oracle Enterprise Manager.
• Experience in installation and implementing OEM and TOAD and setup of Oracle Grid Control.
• Developed database monitoring/health checkup alerts for database uptime/downtime status, and sizing issues using grid control (OEM) 13c and extensively used Oracle Enterprise Manager to do the daily tasks regarding the performance and maintenance
• Monitor the general health of oracle technology including databases, application mentorship and Supervisory experience.
• Extensive experience in configuring and managing Data Guard on RHEL, OEL and Windows
• Extensive experience with Database Cloning and Refreshing pre-prod/dev databases with prod/pre-prod databases.
• Experienced in setting up physical standby databases for Disaster Recovery in critical production environments using Data Guard.
• Experience on Data Replication using Snapshot, Materialized views, import/export.
• Regular database synchronization for test database environments through automation.
• Design and implementation of Backup and Recovery strategies (both cold and hot backups) and performing periodical backup, restoration and recovery using RMAN (full and incremental)
• Testing and implementing different physical and logical backup and recovery methods including point in time, media recovery, full/partial, export/import, expdp/impdp
• Respond to complex database system problems, takes corrective action, and refers problem to third level or vendor support when necessary.
• Good experience in SQL, PL/SQL, Shell Scripting, Perl Scripting.
• Detecting and diagnosing production system performance problem by analyzing STATSPACK reports, oracle trace and log files, AWR, ADDM, analyzing SQL statements, measuring system and database activity, Querying Oracle dynamic performance views.
• Troubleshooting complex problems in a large scale heterogeneous client server environment spread across multiple data centers.
• 24*7 on-call production database support and maintenance including remote database support
• Assisting in implementation of change control process in production.
• Ability to work in a team as well as to take individual responsibility.

PROFESSIONAL EXPERIENCE:

Confidential, FL

Oracle Database Administrator

Responsibilities:

• Responsible for life cycle development, testing and production performing 12c and 11g RAC installations, configuration, tuning and troubleshooting on Linux and HP-UX operating systems
• Supported installation and setup of ORACLE RAC databases. Monitoring and Administrating ORACLE RAC databases on ORACLE 12c & 11g Clusters(4 Node with high availability ) in Superdome Technology (Active - Active)
• Installed and Supported the company’s most Critical Application CC&B / Customer Care & Billing Databases
• Cloning production database to lower environments using RMAN active duplication as well as from Backups and scrubbing sensitive data before releasing to the application
• Establishing back-up policies and Restore activity, backup using User Managed Backup (Data Pump) and Recovery Managed Backup (RMAN).
• Databases/schema/table refreshes using Datapump export/import.
• Building and maintaining Oracle Stand by databases, Active Dataguard for real-time replication and for disaster recovery.
• Implemented cross platform migration from HP-UX to Linux.
• Implemented Automatic Shared Memory Management (ASMM) and Automatic Segment Space Management (ASSM).
• Table & Index partitioning to monitor performance issues and ensuring maximum uptime of the database Importing of dumps using impdp/expdp utilities.
• User accounts creation and Table Space Creation and managing the table spaces using the Oracle Default Compression.
• Implemented Oracle Advanced Security options such as data encryption for data privacy.
• Performed Patch set updates, CPU patches on RAC Databases to minimize the security issues and provide bugs fixes and Configured and Upgraded to Oracle 12c from 11gR2.
• Handled all standard database administrative tasks, such as: proactive performance tuning and monitoring, troubleshooting, back-up and recovery, installations and configurations as needed.
• Installed and supported Oracle Enterprise Manager OEM 13c.
• Implementation and monitoring of all databases using OEM/Grid Control.
• Performance tuning and monitoring of Databases through v$ views, AWR, ADDM, statspack, etc.
• Written Shell scripts to monitor daily basis activities like availability of database & listeners, space utilization, gathering statistic for the cost base optimizer, index rebuilding, alert log errors etc.
• Analyzing the Tables and Indexes using DBMS STATS package.
• Implemented scripts, which monitor database health check at regular interval, upon error, send email to the concerned person.
• Provided 24x7on call support for all the production databases.

Environment: Oracle 11g/11gR2/12c databases, Superdome, RMAN, Data pump, Export/Import, Physical Backups, Oracle Data Guard, HP-UX, RHEL, HTTP, F-Secure SSH, F-Secure FTP, Oracle Enterprise Manager OEM, TOAD, ASM, Oracle Tools

Confidential, FL

Oracle Database Administrator

Responsibilities:

• Design and Create new databases based on requirements of the application / project
• Responsible for all the database related jobs for all the instances, performance tuning, backup and recovery, managing users & privileges, resource limits. Administration of database objects such as indexes, tables, views, constraints, and stored procedures.
• Performed database tuning using explain plan, tkprof, stats pack and other custom utilities
• Installed, configured 11g RAC on Four node cluster, created databases in both in standalone and RAC environment on Linux Operating system
• Oracle Streams Enabled the feature: data replications and integration feature in Oracle 11g
• Developed RMAN backup scripts and automating the RMAN backup scripts.
• Implement partitioning and indexing strategies
• Create users, roles and profiles with different security levels. Grant and revoke privileges.
• Migrate changes to Oracle database objects and monitor/administer existing databases security with Oracle database environment.
• Provide DBA support to developers, develop stored procedures and triggers. Also Provide on call support related to Oracle DBA activities.
• Taking reviews of physical database models. Develop procedures to troubleshoot issues.
• Handled day to day database activities including performance monitoring and tuning to ensure the efficient and accurate operation of the database software. Scheduling maintenance and health check of the applications and databases.
• Analyzing the schemas and individual tables Expert in Oracle Backend programming in SQL and PL/SQL, Writing Stored Packages, Procedures, and triggers in a Multi tier environment.
• Performed rolling patch upgrades for RAC environment for bug fixing and also involved in applying PSU and CPU patches for Oracle Server.
• Planned and Implemented Disaster Recovery(DR) and HA using RAC, Data Guard, Streams and made sure that the database is always available for the users even at the critical times like failures and up-gradations
• Written Shell Scripts to monitor Database health checkups, backups etc.
• Cloned or refreshed the databases from production to development and test environments.
• As a member of the analyzing and designing team, the responsibilities were to understand the application requirements and build up system specifications

Environment: Oracle 11g/10g, Oracle Enterprise Manager Grid Control, ASM, Real Application Cluster, Data Guard, RMAN, Import/Export, Oracle Enterprise manager (OEM), TOAD, Win SCP, Red Hat Enterprise Linux (RHEL) and Oracle Enterprise Linux (OEL)

Confidential, IL

Oracle Database Administrator

Responsibilities:

• Configured and Installed Oracle 10g/11g Databases; handled migration/upgrades of databases from 10g to 11g manually and with DBUA.
• Data modeling / Logical database design and implementation (including index design)
• Performed Backup/Recovery using RMAN and established testing standards utilizing the advantages of 10g Flashback.
• Performance tuned application/table design, data access methods, memory allocation, disk I/O, CPU usage and resource contention.
• Worked on debugging of databases and applied Oracle patches.
• Monitored Oracle Databases using scripts and OEM for database connectivity, table spaces monitoring and object growth.
• Analyzed tables and rebuilt indexes to improve performance. Managed rollback segments, server processes, SGA, online redo log files and data files.
• Monitored the server’s memory, disk, CPU I/O and network to establish baseline and peak performance for applications using UNIX command-line utilities.
• Wrote SQL scripts for DBA functions. Designed and created database objects such as Tables, Indexes, synonyms, database links, views and snapshots.
• 24*7 production databases and handled all day to day database issues, upgrades and enhancements
• Provided maintenance of User accounts and privileges. Using Data- Pump, Export/Import to ensure that the latest data is available in the development/test database.
• Resolving incident tickets in the production environment with an good Service level Agreement

Environment: Oracle 10g/11g on Linux, Real Application Clusters, IBM X Series, Oracle10g/11g, RMAN, Oracle Enterprise Manager, EXPLAIN PLAN, RMAN