SUMMARY

• Over 8 + years of experience in Oracle 11g/10g/9i DBA and have been involved in Installation, Configuration, Up gradation, Patching, Backup and Recovery, Migration, Memory and Space Management, Cloning, Replication, Performance Tuning, RMAN, RAC, Data Guard, OEM Grid Control.
• Experience in Installation, Configuration and Troubleshooting of Oracle Database on Solaris OS, IBM - AIX, Red Hat Enterprise Linux (RHEL) and Windows on highly transactive and Very large databases (VLDB).
• Extensive knowledge on database administration for Oracle 9i, 10g, 11g with experience within very large scale database environment and mission critical large OLTP and OLAP systems.
• Expertise in setup, installation, configuration, maintenance and troubleshooting of several Oracle tools and utilities like Oracle Grid Control, Oracle Enterprise Manager (OEM), TOAD, Oracle SQL Developer in various versions.
• Hands on experience in Grid Control (11g) and INSTALLED 12C for database Monitoring/Performance/Diagnostics.
• Expert with planning, creation, administration and troubleshooting of Oracle 11g/10g/9i, OLTP (multiple instances)/OLAP databases in production, development and Testing.
• Handful of experience in Oracle Installations, Upgrades, Patches, Critical Patch Updates (CPU’s) in various environments.
• Having good knowledge on EXADATA and Involved in moving databases in EXADATA RAC environment.
• Worked on HP-UX, AIX, Sun Solaris, Red Hat Linux and Windows environments.
• Installed and maintained Oracle 11g/10g RAC with ASM & OCFS2 File systems.
• Proficient in setting up the network connections (i.e. setting up Listener and TCP/IP Connections).
• Have implemented ORACLE STREAMS for replication and two types of standby databases logical standby and physical standby databases supported by DATAGUARD for DR and high availability.
• Solid experience in disaster recovery, Database backup concepts and options such as user-managed backup, RMAN-managed backup with or without catalog, operating system backup, cold and hot backup, full backup, incremental, cumulative backup and implementing backup and recovery strategies.
• Backup, Recovery and Cloning of databases using RMAN also profound in using the new oracle 11g features in these utilities.
• Writing scripts in the UNIX based environments for managing the user's roles and privileges, scheduled backups (using datapump /cold backups), manage statistics, Disk space management.
• Data transferring and Refreshing with export/import utilities, Data Pump and data loading using SQL*Loader and External tables.
• Performance tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK, UTLESTAT, AWR, ADDM and Tuning of SGA, Distribution of disk I/O, Sizing of tables and indexes.
• Worked extensively on forward and reverse engineering processes. Created DDL scripts for implementing Data Modeling changes.
• Expertise in Using EXPLAIN PLAN for query optimization and Performance diagnostic tools like SQL Trace and TKPROF.
• Experience in writing PL/SQL Stored Procedures, Functions Packages and Triggers, various scripting languages such as Perl, awk and UNIX Shell Scripting.
• Engage in performance tuning of all storage, backup, and SAN environments
• Extensively used BMC Remedy, HP Quality Center ticketing systems Console for monitoring.
• Excellent interpersonal and strong analytical, problem-solving skills combined with strong customer service attitude.
• Proven abilities in establishing effective task priorities, working independently, and participating as an integral part of a team in fast-paced and multitasking environment.
• 24 X 7 Production Database on Call Support

TECHNICAL SKILLS

Operating Systems: RHEL 4, RHEL 5, OEL 4, WIN NT/2003/2008, Solaris 10, HP-UX Itanium, IBM AIX, Windows XP.

RDBMS: Oracle 11g/10g/9i, Oracle 10g Real Application Cluster (RAC), ASM

Oracle Products: Oracle10g,11g (Grid Control), OEM (Oracle Enterprise Manager), RMAN, SQL*Loader, Import and Export (EXPdp/IMPdp), ASM, TKPROF, SRVCTL, SQL* Loader and SQL * Net

Networking: TCP/IP, Novell Netware, Apache

Languages: C, SQL, PL/SQL, UNIX/NT Shell Scripting, awk Scripting, Perl.

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, ADDM, AWR.

Web Technology: Web Portals, BMC Remedy, HP Quality Center, HP Java ITO (OVO) console.

Other Tools: TOAD, Putty, Tectia SSH client, SQL Developer, Blade logic BMC Database automation tool, Fog light Monitoring System, AutoSys Agent, Net-backup management system, EMC Data Domain, Erwin, Nexus ticketing System, MS Office (Word, Excel, Power Point, Access), WebCT Adobe PhotoshopDreamweaver, SAS.

PROFESSIONAL EXPERIENCE

Confidential, Rochester

Sr.Oracle DBA

Responsibilities:

• Planned and Implemented Disaster Recovery (DR) and High Availability using RAC, Golden gate and Data Guard.
• Installed and configured RAC (3 node) and Performed up-gradation of grid infrastructure and Oracle databases from 11.2.0.1 to 11.2.0.3
• Performed health checks in RAC instances using Crsctl and Srvctl utility.
• Performed Database refresh from Production RAC environment to TEST RAC environment.
• Experience in monitoring and managing of Oracle instances using Enterprise Manager Grid Control (OEM grid) 10g /11g/12c.
• Starting and stopping the agents to clear metric alerts and collecting ADDM reports in OEM.
• Creating blackouts and templates in OEM and migrated databases from Non ASM TO ASM.
• Installed Golden Gate for replication of database on 11gR2 RAC environment.
• Involved in Tuning the RAC interconnect Finding RAC wait events. And Tuning the RAC using the Enterprise Manager Grid Control.
• Involved in configuration of parameter files for extract process in primary and replica process in standby using Golden Gate.
• Experience in advanced Oracle features such as table partitioning, Oracle Streams (Replication).
• Configured parameters for the Bi-directional replication using Golden-Gate.
• Implemented Golden Gate for Active-Active Replication between the Datacenter for High Availability.
• Migrated 30 TB Databases from HP UNIX to RHEL with minimal down time.
• Involved in moving databases in Exadata RAC environment.
• Knowledge on Exadata Smart Scan technology which improves query performance by intensive query processing and data mining scoring to scalable intelligent storage servers.
• Worked on Oracle Exadata Backup Configuration utility.
• Focusing on Exadata administration. With nodes ranging from 2 to 6 and incorporating Exadata clusters for maximum availability.
• Performed various tasks on ASM, creating a disk group, adding a disk to disk group, making disk online and offline and troubleshooting issues in ASM environment.
• Involved in configuring Data-guard for production databases on 11gR2.
• Maintained DR server which have physical standby databases.
• Converted Physical Standby to Snapshot Standby and also to Active data-guard.
• Applied patches on standalone servers using Opatch utility.
• Performed Migration of databases 10.2.0.4 on Solaris to Oracle 11.2.0.3 on Linux.
• Upgraded development and production databases from 10.2.0.x to 11.2.0.3 on RHEL.
• Implemented data transfer using Data Pumps and Export/Import utilities.
• Performed Cloning of databases using RMAN from production to test and development environment.
• Involved in scheduling incremental, cumulative and full backups and configured retention policy using RMAN.
• Registered databases in catalog server and also performed database cloning using RMAN.
• Performed daily maintenance tasks like space management, rectified locking problems, managed quotas and configured network components like TNSNAMES, Names Server, Connection Manager, for easy and effective management of Oracle networking. Configured listener for external procedure calls. .
• Daily Health Check Up of the Database and SQL Queries using AWR, ADDM and TKPROF.
• Extensively used AWR, ADDM and EXPLAIN PLAN for Generating reports.
• Tuned the performance of the SQL’s using TKPROF and STATSPACK reports.
• Involved in the optimization of various SQL and PL/SQL using EXPLAIN PLAN and TKPROF.
• Develop and enforce both database and OS-level security policies for data protection.
• Developed Scripts for transferring data from production server to testing/development servers
• Involved in Setup the Oracle Wallet for Encryption Functions and Expertise in protecting the Oracle wallet with ACFS access controls.
• Created Tables That Contain Encrypted Columns and Oracle Wallet Management for Transparent Data Encryption.
• Involved in various database security activities like Enabling Transparent Data Encryption (TDE), Automatic Login Enabled for Transparent Data Encryption, Setting and Resetting the Master Key, Adding and Removing Salt from an Encrypted Columns.
• Good exposure of advanced security using Database trigger, Auditing, Virtual Private Database (VPD), Table space Encryption, TDE Transparent Data Encryption.
• Involved in administration of all databases in the areas of maintenance, tuning, performance, and troubleshooting and debugging SQL/PL SQL involved in Application development.
• Efficient in using the Oracle Tools like OEM, SQL* Plus, SQL* Loader, TKPROF, LOGMINER, STATSPACK, SQL*Net, IMPORT/EXPORT, and RMAN.
• Involved in writing for shell scripts for monitoring health checks and also for taking RMAN backups and Developed Scripts for transferring data from production server to testing/development servers.

Environment: Oracle 11gR1, 11gR2,11.2.0.3,12c RHEL 5.8, Hp - Unix 7, Solaris 10, OEM, DBUA,RMAN, EMC SAN, Golden gate, Oracle Enterprise Manager Grid Control, RAC, ASM, Data guard, SQL*LOADER, AWR, ADDM, ASH, TTS, TDE, VPD, Oracle Wallet, Data pumps, Exports/Imports.

Confidential, New York

Sr.Oracle DBA

Responsibilities:

• Installed, configured, and maintained Oracle 10g and 11 g R2 on Linux and also Upgraded from Oracle 10g to 11g
• Worked on Performance Tuning Oracle DBA (11g &10g) on Solaris 10, AIX 5.2.
• Performed administrative maintenance, monitoring on Oracle database systems in a global 24x7 operational environment.
• Installed and upgraded Oracle 10.2.0.1 database to 10.2.0.4.
• Performed day to day administrative tasks by analyzing the database like checking for failed processors, verifying the query for particular issues and validating disk space.
• Responsible for setup and implementation of 3, 4 Node RAC on Linux in 10g and 11g R2 using VERITAS Cluster Server.
• Configured and maintained Oracle Cluster-ware.
• Configured and maintained replication using Oracle Golden Gate.
• Used to Perform Cold/Hot Backups.
• Used to perform backup and recovery using VERITAS Net Backupintegrated intoRMAN.
• Implemented and Managed Oracle Data Guard on Oracle 11gR2
• Developed a bunch of Index monitoring scripts in order to sort out the unused space occupied in table spaces.
• Involved in Datacenter Migration between New York to Monroe for All oracle databases.
• Implemented advanced features of Oracle 10g such as Automatic Database Diagnostic Monitor(ADDM),Automatic Workload Repository (AWR) for monitoring database performance. Modified and updated the Performance tuning scripts.
• Implemented schema level, table level and bidirectional oracle streams.
• Tested database performance issues (monitoring and tuning) to ensure database optimization..
• Encrypted sensitive information within the database and implemented Encryption keys on relational database management systems by using Oracle TDE.
• Enabled VPD on tables that would not degrade the performance of VLDB of size 6 TB.
• Created custom services for RAC database for distribution of load across the nodes.
• Performed Tuning, coding and Monitoring for Oracle Real Application Clusters (RAC) nodes, Production Standalone Servers via Toad.
• Tuning SQL statements using Explain Plan and STATSPACK.
• Experience in Administering Oracle Database 10g and 11g using Oracle Enterprise Manager (OEM).
• Generate and interpret Automatic Workload Repository (AWR), Active Session History (ASH) and Automatic Database Diagnostic Monitor (ADDM) reports.
• Creation of materialized views and fine-tuned them for better performance.
• Working Experience with latest TOAD having new features PLSQL & SQL Script Debugger, Database Health Checkup, ASM Manager, Diagnose Extents, Segment Advisor, SGA Trace, Query Builder.
• Performed zero downtime migration with the help of GOLDENGATE
• Configured Extract and Replicate pumps for Golden gate replication. Troubleshooting issues in GOLDENGATE Environment using LOGDUMP
• Modified SQL*Loader control scripts to eliminate while spaces generally used for data loading.
• Installed & managed 10g R3 OEM grid monitoring solution and deployed agents.
• Performed Logical backup using and full/partial export/import and Data Pump.
• Responsible in configuring and backing up database using RMAN, Hot backups, Cold backups and Logical backups.
• Performed Schema as well as Table level Replication using Oracle Golden-Gate and also did set up Disaster Recovery solution using Golden-Gate.
• Created bit-map Indexes for data warehouse databases.
• Involved in the error checking and testing of the ETL procedures and programs Informatica session log.
• Implement Encryption with Oracle TDE.
• Worked with ETL group for understating mappings for dimensions and facts.
• Configured Physical and Logical Standby database for reporting environment.
• Implemented database refresh with the hot backup using full export. Used EXPORT/IMPORT to do table level and full database defragmentation.
• Clear documentation was prepared on all the processes like program specification, bugs fixing log & change requests for future reference.
• Proactively managed the databases; set up notifications, alarms using shell scripts for managing any exceptions in day to day management of the databases.

Environment: Oracle 9i/10g RAC on Solaris/Linux, RMAN, Data Guard, UNIX Shell Scripting, Quest Performance Analysis, Quest Space Management tool, DB Artisan, TDE, VPD, Toad, PL/SQL Developer, OEM.

Confidential

Sr.Oracle DBA

Responsibilities:

• Installation, Configuration and Administration of Oracle 10g databases on Sun Solaris Operation System.
• Implemented Real Application Cluster (RAC) Setup & Administration using Sun Cluster.
• Supported different Databases like Production, Development, Testing, UAT and Training.
• Recovered critical databases from failures with minimum downtime.
• Responsible for planning, testing and implementing different backup and recovery strategies.
• Designed Logical and Physical Modeling using C.A Erwin.
• Logical to Physical Transformation using Erwin
• Forward engineering using Erwin
• Reverse engineering using Erwin
• Model to model comparison using Erwin
• Conducted daily routine checks on alert logs and trace files.
• Creating the Database, table space, Control files, log files and user profiles
• Performed Backup and Recovery with export and import for non-archive and archive database using RMAN, scheduled backup on Solaris& NT environments using the incremental complete and full back up strategies based on the database purposes.
• Automated back-up procedures using crontab.
• Performed activities such as Query Optimization, Database Consistency Monitoring. Configured and managed replication server.
• Expertise in Installation, Configuration, Application Support, Performance Tuning/ Optimization, User/Security Administration, Backup/Recovery, Data/Network Administration and Maintenance and configure database stand by database using Data Guard.
• Automated database backup using shell scripting.
• Involved in the database design, installation, creation of various instances, and creation of tables, granting roles to users and maintain the security according to application.
• Worked on performance and tuning on SQL queries wherever it is required.
• Install OCI header files on Client Machines.
• Migration of database from one server to another server.
• Creation of database objects like Tables, Indexes, Views, Users, and DB Links etc.
• Rename the database and database SID.
• Create Directory in the database.
• Moving data files from one location to other.
• Scheduling Oracle Jobs in the database.
• Analyze the schema and tables.
• Finding average row length for all the tables in each schema. Performed daily maintenance tasks like space management, rectified locking problems, managed quotas etc.,
• Configured network components like TNSNAMES, Names Server, Connection Manager, etc. for easy and effective management of Oracle networking. Configured listener for external procedure calls.
• Efficient in using the Oracle Tools like SQL* Plus, SQL* Loader, TKPROF, LOGMINER, STATSPACK, SQL*Net, IMPORT/EXPORT, and RMAN.
• Managing table spaces, user profiles, indexes, storage parameter’s.
• Develop table structures, PL*SQL stored procedures and database triggers to implement.
• Responsible to provide 24 x 7 database administrative activities over different database servers

Environment: Oracle 10.2.0.3/11.1.0.6/.7, Linux, Solaris 10,Window 2003, Oracle Enterprise Manager Grid Control, RDBMS, SQLDBA, PL/SQL, Shell Scripting, Stored Procedures, ASM, ASO, VPC, Data guard, CICS business rules.

Confidential, Miami, FL

Oracle DBA

Responsibilities:

• Installation, Configuration and Administration of Oracle 10g databases on Sun Solaris Operation System.
• Implemented Oracle Database 10g 2 Node Real Application Cluster (RAC).
• Maintained and troubleshooting cluster-ware components in 10G RAC environment.
• Installation, Configuration and Administration of Oracle 10g databases on Sun Solaris Operation System.
• Implemented Real Application Cluster (RAC) Setup & Administration using Sun Cluster.
• Supported different Databases like Production, Development, Testing, UAT and Training.
• Recovered critical databases from failures with minimum downtime.
• Responsible for planning, testing and implementing different backup and recovery strategies.
• Installed 10g standalone servers on Sun Solaris and installed databases on it.
• Used oracle configuration assistants like Database Configuration Assistant (DBCA) for creating databases, Database Upgrade Assistant (DBUA) for upgrading databases.
• Configured listener and TNS names manually.
• Involved in Up-gradation of databases from 9i to 10g.
• Configured Oracle Data-guard for Oracle Disaster recovery on 10g Solaris.
• Achieved High availability, Data protection and maximum performance by maintaining both physical and logical standby databases.
• Converted physical standby databases to Snapshot standby database.
• Implemented Oracle database backup & recovery solutions using RMAN.
• Configured and Tuned RMAN for better performance and backup strategies.
• Involved in writing for shell scripts for taking RMAN backups.
• Restored and Recovered database at the times of occurrence of critical failures using RMAN.
• Extensive used Oracle Data pump, Exports/Imports utility for moving data among the servers.
• Created user accounts, roles and granting required access permissions and privileges to the database based on the application they are accessing.
• Ongoing proactive database-level performance tuning, with a good working knowledge of Oracle
• Automatic Workload Repository (AWR), Active Session History (ASH) and Automatic Database Diagnostic Monitor (ADDM).
• Performed large batch jobs and tuning of SQL queries and database systems.
• Performance Tuning for the SQL queries which are Running slow and taking more CPU cost
• Performed automated backups and scheduling using scripting.
• Written Stored Procedure and Triggers for database maintenance and management using PL/SQL and Involved in gathering requirements from end users.
• Estimate growth of database size by detail analysis of the company's future policies and generating reports for the management to act in advance.
• Clear documentation was prepared on all the processes like program specification, bugs fixing logs & change requests for future reference.

Environment: Oracle /10g/9i, Sun Solaris 5.x, HP-UX 11.x, OEM 10g, Oracle 10g RAC, TOAD, putty, STATSPACK,EXPLAIN PLAN.

Confidential 

Oracle Developer/ Jr. DBA

Responsibilities:

• Review of Database logical and Physical design.
• Install, upgrade and maintain Oracle 10g, 9i on Sun Solaris and Windows 2003, Redhat4.
• Installation, setup and configuration of DATA GUARD.
• Created new Table Spaces, added Data Files and resolved Disk Contention Issues.
• Monitored, Allocated Share memory, Table space as needed and managed Replicated servers.
• Monitoring daily Hot Backups and weekly Cold Backups performed using RMAN.
• Application Tuning by tuning queries, identifying problematic code, creation of indexes, re-writing queries using an optimized path, creation of materialized Views and gathering necessary statistics on objects etc.
• Implementing Database Security, Management of role-based security.
• Applying Patches 9.2.0.6 and applying Oracle DST Patches on Oracle database.
• Write and modify UNIX shell scripts to manage Oracle environment.
• Performed Data Migration as a part of enterprise data warehouse project.
• Extensive Performance Tuning, Memory (SGA) Tuning, Net backup, EMC (Time finder and SRDF), RAID, RAW Devices.
• Cloning databases using scripts as well as RMAN.
• Configured and Tuned RMAN for better performance and backup strategies.
• Established database backup/recovery strategy for different databases.
• Recovery procedures are applied for complete and incomplete recoveries depending on the type of failure.
• Management of table space growth, monitoring data files additions, extent growth.
• Constantly monitor the performance of the Databases and viewing Alert log files & Trace files.
• Used PL/SQL, SQL Loader as part of ETL process to populate the operational data store.
• Performed scheduling Control-m for scheduling jobs.

Environment: Oracle 10g and 9i, Sun Solaris, RHEL 4.2, Windows 2003 with Active Directory, OEM, RMAN, Export/Import, SQL, PL/SQL, SQL*Loader, TOAD, STATSPACK.