SUMMARY

• Around 8 years of experience in installation, migration, designing, backup, recovery, scripting and performance tuning in development, test and production databases (OLTP and OLAP databases).
• Had a very good experience in the environments like Oracle 9i, 10g release 1 and 2, 11g release 1 and 2 with OLTP and OLAP databases.
• Expertise in upgrading the databases from 9i to 10g and from 10g to 11g. Extensive experience in configuring and managing Dataguard on RHEL, OEL and Windows.
• Worked with a team to provide 24x7 on call production database support. Experience in installation and maintenance of Oracle RAC using ASM.
• System administration, Oracle Problem analysis and resolution and active cloning of databases from one server to another server
• Experience in creating users, configuring grants, roles, privileges and managing tablespaces. Having hands on experience in Hot/Cold backup, recovery and cloning of databases using RMAN.
• Good experience in migration of data using export, import, expdp and impdp. Extensive knowledge of Oracle Architecture, configuring LISTENER and TNS, V$ and DBA views.
• Managing and creation of objects, schemas, indexes and partition of tables. Experience in applying Opatch and Patchset to the databases.
• Good experience of creating PL/SQL packages, Stored Procedures, Functions, Triggers, Materialized views and Views to retrieve, manipulate and migrate complex data sets in Oracle Databases.
• Having knowledge on Exadata administration and architecture.
• Familiar with Exadata monitoring, backup and recovery scenarios.
• Proficient in setting up the standby database using RMAN utility tool, activating and re - building standby databases both physical and logical supported by dataguard.
• Loading data from flat files, external tables to oracle database tables using SQL*Loader.
• Implemented RMAN backup (Full, incremental and cumulative) and recovery, Incomplete recovery and disaster recovery using Standby database or Data Guard.
• Tuning of the database for increasing performance using the tuning utilities like STATSPACK, TKPROF, EXPLAIN PLAN, SQLT, AWR, ADDM.
• Partioning large tables depending on the data for performance of the database.
• Maintaining database security using security compliance auditing and profile management, password complexity in order to control access to the database.
• Database management for scheduling, tuning, taking backups using Oracle Enterprise Manager (OEM).
• Expertise in using Oracle Grid Control.
• Developed database monitoring/health checkup alerts for database uptime/downtime status, and sizing issues using grid control (OEM) and extensively used Oracle Enterprise Manager to do the daily tasks regarding the performance and maintenance.
• Experience in web logic server and creating domains. Experience in troubleshooting web logic server issues
• Experience in installing and upgrading Retail applications (RMS, ReSA, SIM, RIB and CO)

TECHNICAL SKILLS

RDBMS: Oracle 9i and 10g, 11g, SQL SERVER 2008

Application: Retail Applications (RMS,SIM,ReSA,ReIM,BackofficeCentraloffice,POS),Oracle Weblogic

Tuning Tools: SQL Auto Tracing, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, Tuning advisors, ADDM, oradebug, OS Watcher and SQL Plan stability management etc.

Operating System: Solaris 8/9/10, HP-UX, SUSE Linux, Red Hat Enterprise Linux Advance/Enterprise Server 4/5, HP-UX, Windows 9X/XP/2000, IBM AIX 5.1/5.2/5.3/5.5/6.1

Languages: SQL, Perl, PL/SQL, Linux/UNIX Shell Scripting,HTML, C & C++

Database Tools: Oracle Enterprise Manager Database Control, Rman,OEM, Dbverify, Tkprof, Statspack, AWR, ADDM, SQL Loader, Data Pump,SQL Server 2005/2008/2012

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, North Carolina

Senior Database Administrator

Responsibilities:

• Managing data file objects including tablespace and datafiles, object sizing as well as monitoring database usage and growth.
• Managing tablespaces, user profiles, indexes. Responsible for creating user logons and managing user accounts.
• Monitor the instance and plan for future availability of storage on user’s table spaces
• Suggesting tuning solutions for SQL queries and Database.
• Adding space to the data files according to tablespace growth. Backup and Recovery strategies for Oracle database using exp/imp, cold and hot backups.
• Performed export backup of tables for future database recovery. Modifying Oracle parameter (init.ora) for Oracle performance and growth.
• Responsible for the setup and implementation of three node RAC on Oracle 11g. Configured Oracle Dataguard for Oracle Disaster Recovery.
• Implemented Dataguard on Production Database.
• 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.
• Monitored queries with high response time and high disk read per execution (Top SQLs) and tuning the same using Explain Plan, TKPROF and SQL tuning advisor.
• Extensively used features such as Data Pump, Flash Back Recovery, ASM, AWR, ADDM for generating reports
• Efficiently used Oracle Tools like OEM, SQL* Plus, SQL* Loader, TKPROF, AWR, ADDM, STATSPACK, Data Pump, FLASHBACK and RMAN.
• Worked extensively on SQL tuning and Database tuning based on reports generated by Run time SQL execution plans, AWR Reports, ASH reports, Explain Plans and monitor the database performance on a daily basis.
• Created users and granting them their roles and privileges.
• Configured Listener and TNS names using NETCA and NETMGR.
• Install, configure and support uni-directional and bi-directional Oracle to Oracle replicated environments utilizing GoldenGate.
• Experience in trouble shooting and performance tuning Oracle Goldengate replications. Worked with Oracle on SRs for critical issues.
• SQL tuning and Database tuning has been done based on reports generated by Run time SQL execution plans, AWR Reports, ASH reports, Explain Plans and monitored the database performance on a daily basis
• Resolved RAC issues, OCR related issues, rebooting of faulty nodes, relocating the switched over services.
• Database Services creation for distributing the applications across multiple nodes, extensively used all command line utilities SRVCTL, CRSCTL, ADR, ASMCMD.
• Performed Online Redefinition of tables using DBMS REDEFINITION, partitioning the tables in the production, re-defining the columns data types, conversion of LOB to securefile.
• Experienced with ASM, adding, deleting disks to the disk group.
• Provided on-call support regarding production-related database problems.
• Analyzed performance issues in production Oracle databases by using AWR/ADDM, statspack/tkprof tools.
• Provided and implemented performance tuning recommendations of all components in Exadata database machine.
• Advised, provided guidance and developed Disaster Recovery strategies for the Exadata Database machine.

Environment: Oracle 11g,12c,Linux 5/6, Oracle Enterprise Manager, Grid Control, HP-UX, AIX, Windows 2003 server, OEM Database control, PL/SQL, SQL*Loader, Shell Scripting, PERL, TOAD, ASM, Golden Gate, Data Guard,, SQL plus, Oracle Enterprise Manager (OEM), RMAN.

Confidential, Warren, New Jersey

Senior Database Administrator

Responsibilities:

• Installation, configuration, and maintenance of Oracle 10g on RHEL 4 and 11g on RHEL 5, HP-UX, AIX and Windows 2003 Server and Upgradation from Oracle 10g to 11g.
• Responsible for the setup and implementation of two node RAC on Oracle 11g.
• Maintained 10g/11g RAC environment and troubleshooting issues. Configured Oracle Dataguard for Oracle Disaster Recovery.
• Implemented Dataguard on Production Database.
• 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.
• Migration of large number of databases from 10g to 11g. Implemented ASM on RAC and stand-alone databases. Managing disks and disk groups with ASM.
• Migration of non ASM database to ASM database. Using list partitions for large tables and bitmap indexes for the OLAP databases.
• Cloned a database using RMAN Utility. Installation and configuration of Goldengate
• Monitored database health checkup and took evasive action for any problem. Looking into day-to-day activities of Production database, Monitoring its growth and performance.
• Creation of users and granting them their roles and privileges. The configuration of Listener and TNS names using NETCA and NETMGR.
• Database backup & Recovery for non archive and archive database with RMAN commands. Done exports and imports of tables, schemas and tablespaces with datapumps.
• Archive weekly all production database exports to Tapes. Developed and enforced both database and OS-level security policies for data protection.
• Monitored all the databases in the areas of maintenance, tuning, performance, and troubleshooting. Managed databases using OEM Grid Control.
• Worked on the integration of Exadata monitoring and escalation into existing IT monitoring and actionable events solutions.
• Focusing on Exadata administration. With nodes ranging from 2 to 8 and incorporating Dataguarded Exadata clusters for maximum availability.
• Proficient in Exadata configuration/maintenance/support/dataguard/backup/recovery. Post installation process, kernel upgrade, applying support packs and add-ons.
• Daily incremental backups and weekly cumulative backups using RMAN.
• Worked extensively on Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics.
• Worked extensively on monitoring grid control database, the configuration of error notifications, installing listeners, and adding them to the grid control.
• Used SQL*Loader to load data into database tables. Expertise in replication technologies including GoldenGate and Materialized Views.
• Install, configure and support uni-directional and bi-directional Oracle to Oracle replicated environments utilizing GoldenGate.
• Efficiently used Oracle Tools like OEM, SQL* Plus, SQL* Loader, TKPROF, AWR, ADDM, STATSPACK, Data Pump, FLASHBACK and RMAN.
• SQL tuning and Database tuning has been done based on reports generated by Run time SQL execution plans, AWR Reports, ASH reports, Explain Plans and monitor the database performance on a daily basis.
• Developed Scripts for transferring data from the production server to testing/development servers.
• Cloning of databases using RMAN and also user managed. Management of databases on multiple servers.
• Developed table structures, PL*SQL stored procedures and database triggers to implement business rules.
• Managing and providing 24X7 supports for various versions of databases. Performed on-call technical support to minimize the impact of system disruptions.

Environment: Oracle 10g,11g,12c,Linux 4/5, Oracle Enterprise Manager, Grid Control, HP-UX, AIX, Windows 2003 server, OEM Database control, PL/SQL, SQL*Loader, Shell Scripting, PERL, TOAD, ASM, Golden Gate, Data Guard,, SQL plus, Oracle Enterprise Manager (OEM), RMAN.

Confidential

Data Base Administrator

Responsibilities:

• Involved with installation and maintenance of Oracle RAC for high availability.
• Involved in the change control process and Upgraded the Oracle 10g database to 11g version and also applied patch set and interim patches whenever required to make the database software up to date.
• Worked extensively on monitoring 10G/11g Grid Control and Configuration of error notifications, installing listeners, and adding them to the grid control
• Maintained 10g/11g RAC environment and troubleshooting issues. Having good experience in Migrating single Instance database to RAC Environment
• Performed Capacity Planning, Undo segments and Health check reviews in RAC.
• Monitoring Day-to-Day Backups, Log’s & recovering them as per the requirement. Scheduling the databases backup using Cron tab and VERITAS net backup.
• Involvement in space management, rectification of lock problems, managed quotas. Performed Migration of databases 10g on Hp - UNIX to Oracle 11gR2 on Linux.
• Created, monitoring database objects like Indexes, Views, Users, and DB Links. Implemented High availability using Golden Gate Replication.
• Wrote scripts for database maintenance activities such as monitoring the growth rate of table spaces and extents. Also wrote UNIX scripts to process batch jobs.
• Monitored queries with high response time and high disk read per execution (Top SQLs) and tuning the same using Explain Plan, TKPROF and SQL tuning advisor.
• Extensively used features such as Data Pump, Flash Back Recovery, ASM, AWR, ADDM for Generating reports
• Created Partition’s estimated stats on one partition1 and copied the stats to remaining partitions using dbms stats.
• Worked with DW team on problem resolution and implemented change requests. - Performance tuning on DW such as Data extraction from production to Data warehouse.
• Installing web logic server and creating domains. Troubleshooting weblogic server issues.
• Starting up and shutting down the weblogic services and managed servers. Deploying ear/jar/war files from weblogic admin console.
• Installing Retail applications (RMS, ReSA, SIM, RIB and CO). Applying patches to all retail applications.
• Upgradation of retail applications.
• Deploying the custom code into all retail applications. Creation of Point of sale (POS) stores and Backoffice(BO) domains under weblogic server
• Involved in 24x7 production database maintenance and on-call support. Conducted time-to-time analysis and monitoring of the software and hardware requirements and act accordingly

Environment: Oracle 10g/11g, RAC on Sun Solaris, Linux, RMAN, Data Guard, Toad, Exadata, OEM, ASM, Oracle Enterprise Manager (OEM),weblogic server,oracle retail applications.

Confidential, Chicago, IL

Oracle DBA

Responsibilities:

• Installation and Configuration of Oracle 11g on HP Unix
• Managing data file objects including tablespace and datafiles, object sizing as well as monitoring database usage and growth.
• Managing tablespaces, user profiles, indexes. Responsible for creating user logons and managing user accounts.
• Monitor the instance and plan for future availability of storage on user’s table spaces
• Suggesting tuning solutions for SQL queries and Database.
• Performance Monitoring the Server for Better performance. Adding space to the data files according to tablespace growth
• Backup and Recovery strategies for Oracle database using exp/imp, cold and hot backups.
• Taking an export backup of tables for future database recovery. Modifying Oracle parameter (init.ora) for Oracle performance and growth

Environment: Oracle 9i/10g/11g RAC with Solaris/redhat,, Toad, SQL plus, Oracle Enterprise Manager (OEM), RMAN, Solaris 9/10,AIX,Shell Scripting,, Net Backup, Time finder Backups, RMAN, Redhat/Suse Linux, expdp, impdp, AWR, ADDM, Statspack, tkprof