SUMMARY

• Confidential Database Administrator with 3 years of experience in Confidential Administration in planning, installation, configuration and upgrades of Confidential 11gR2 databases, Experience includes managing Confidential 11gR1, 11gR2 RAC environments using the OEM Grid Control tools. Experience includes Confidential Utilities Data Guard, Data Pump, Flashback and RMAN. SQL.
• Extensive knowledge on database administration for Confidential 11g,12c and with experience within very large - scale database environment and mission critical large OLTP and OLAP systems.
• Engineering, implemented, documented and support builds of new clusters to use Confidential 11g/12c RAC on HP-UX, Solaris, IBX-AIX and Unix/Linux. Including installing cluster ware, ASM (and shared disks) and creating new databases.
• Expertise in upgrading the databases from Confidential 10g, Confidential 10g to Confidential 11g and Confidential 11g to Confidential 12c.
• 24*7 production database support with Support to developers & end-users.
• Experienced in Installation of high availability RAC environment and upgraded standalone databases to 11g RAC environment.
• Expertise in Configuring, maintenance of Data guard in RAC environment and standalone environments.
• Managed very large database (VLDB) of maximum size 32TB.
• Managed and provided support for 67 production databases.
• Created development, testing, staging, production, RAC and standby databases for OLTP, DSS and Data Warehousing Environments.
• Implemented RMAN backup (Full, incremental and cumulative) and recovery, incomplete recovery and disaster recovery using Standby database or Data Guard.
• Implemented automated backup strategy using the UNIX shell script CRON UTILITY.
• Involved in Monitoring, Optimizing Confidential database for Performance Tuning & system/modules for Application Tuning using tools like AWR, ADDM, ASH, STATSPACK, CBO, TKPROF, EXPLAIN PLAN and SQLT.
• Good with concepts of Database Links, Materialized views, Flashback Technology, Partitioning Tables to improve Performance and Manageability.
• Hands on experience in Data Archiving
• Data loading using SQL*LOADER, Logical backups using full export and DATAPUMP.
• Experienced in using Confidential 's Transportable Table space (TTS) feature allows users to quickly move a user table space across Confidential databases.
• Good experience in applying Patches (Patching), Critical Patch Update(CPU)/Patch Set Update(PSU) and One-off Patches using OPatch and run installer, also involved in Upgrading and Migration of a Confidential server to higher version available.
• Effective troubleshooting of database and Performance problems.
• Good experience in Data Migration using export/import.
• Prepared DBA work plans, Documented Client site’s “Site specific work procedures”, Change Management and control, Best Practices and did Capacity planning for clients.
• Management of Objects, Schemas, Partitioning the tables and Indexes.
• Extensive knowledge of Confidential Architecture, SGA, PGA, LISTENER, TNSNames, V$ and DBA views.
• Expertise in using OEM, SQL Developer and third-party tools like TOAD.
• Knowledge on Confidential Support Process for Technical requests using Metalink and other support procedures.

TECHNICAL SKILLS

Operating System: UNIX, LINUX, Solaris, AIX, HP-UX and WINDOWS NT/2000, XP.

RDBMS: Confidential 12c/10g

Confidential Tools/Utilities: RMAN, EXP/IMP, EXPDP/IMPDP, SQL * LoaderAWR, ADDM, OEM, Sql Server.

Languages: SQL, PL/SQL and UNIX Shell

PROFESSIONAL EXPERIENCE

Confidential

Sr. Oracle DBA

Responsibilities:

• Worked on refreshing production databases on sandbox for application testing using export/imports and RMAN active duplicate.
• Performing Backup/Restore of all the Confidential databases using RMAN.
• Provided on call support for every 3 weeks and provided support on weekends.
• Worked on Real application testing to have access the work load before migrating and upgrading production databases.
• Supported mission critical databases and extensively involved in resolving the performance issues.
• Worked on implementing standard RMAN backup policies and successfully was able to restore huge database when required.
• Worked on Disaster recovery task (DR Test).
• Provided support for 3 Confidential Exadata machines - Prod, DR, QA - to be used for mission critical applications.
• Managed and resolved RAC (10g, 11g), ASM and cluster ware issues.
• Management of schemas, objects partitioning the tables & indexes.
• Worked on refreshing the QA databases with PRODUCTION backups.
• Developed scripts for monitoring Tablespace sizes, alert log files, Tablespace growth and implemented Crontab job to alert if the tablespace size exceeds above 80%.
• Responsible for taking backup of schemas, tables and table spaces using Confidential 11g Data pump.
• Experienced in developing shell scripts for deleting old file.
• Schemas refresh using Export/Import Pump, Creating the database table spaces, tables, indexes, setting privileges and user logins.
• Expertise in Confidential Golden Gate installation, configuration, troubleshooting Golden Gate issues
• Upgrade and character set conversion of RAC databases with the aid of Confidential Golden Gate utility.
• Experience in Implement and maintain monitoring tools for Golden Gate components.
• Worked on database upgrade from 11.2.0.3 to 11.2.0.4.
• Experienced in performance tuning on long running query’s in database.
• Very good experience in using performance tuning tolls like SQLT, SQLHC.
• Experienced in backups, restores, indexes, key structures and data loading.
• Worked on data blocks corruption issue, index & table rebuild.
• Experienced in documentation, provided documentation for database design, analysis, modifications, creating schemas etc.
• Worked on delphix machine to create new database.
• Worked on delphix machine to solve production connectivity issues.
• Providing Solutions to the Problems Faced by end Users or Programmers.
• Strong knowledge of Confidential internals, tools including DBMS jobs, RMAN, SQLPlus, export/import, Toad, Confidential Enterprise Manager (OEM).
• Database Refreshes from Prod to Dev, Troubleshooting Day-to-Day Users Issues in various modules.

Environment: Confidential 11.2.0.3/11.2.0.4 , Exadata X4/X5 Quarter/Half/Full RACK, OEM 12c, LINUX, IBM AIX TOAD,SQL Developer.

Confidential, NJ

Responsibilities:

• Provided 24*7 Support for Production environment for Extraction, Loading and transformation of Data in Data Mart. Remote monitoring and tuning of Database Processes in the Client environment.
• Design Evaluation and Analysis of physical and logical model.
• Involved in Installation and customization of Databases (10g&11g) in Windows, Linux and Solaris environments.
• Involved in Schema management, Tablespace Management, User Creation.
• Monitoring the Extraction and loading processes of Data.
• Upgraded and applied patches as and when required on 10g,11g.
• Database Refreshes from Prod to Dev, Troubleshooting Day-to-Day Users Issues in various modules.
• Responsible for Confidential implemented backups like LOGICAL&PHYSICAL i.e. Export & import and having experience with EXPDP&IMPDP.
• Implemented Consistent exports using SCN.
• Good experience with recovery managed backups i.e. RMAN.
• Migrated the database from non- Confidential to Confidential i.e. SQL Server to Confidential .
• Documented the complete project including all pre-installation, post installation and database configuration steps.
• Manage users, privileges, profiles, schemas, involved in writing UNIX shell scripting for automating the jobs.
• Experience in using automatic monitoring and management processes like batch processing using CRONTAB for processes like import, export databases.
• Used analyze table, analyze indexes to tune queries and increase performance.
• Experience with SGA tuning and Histograms understanding and sound knowledge in SQL execution plan.
• Tuning Confidential 10g database servers using tools dynamic, dictionary views, Stats pack, ADDM, AWR Diagnostic and tuning packages.

Confidential

Responsibilities:

• Involved in 24x7 Confidential Production Database Administration.
• Performing all the Database Administration activities like installation, configuration, cloning, patching, upgrade, performance tuning, backup & recovery, space management in database, user and roles administration, schema management.
• Installation, Configuration, Upgrade, patching of Confidential RDBMS and applications.
• Monitored Production Databases, performed performance tuning, added data files, resized segments, and tablespaces.
• Installed and configured Confidential 11g.
• Migrated Confidential 10g database to Confidential 11g.
• Storage and space management including table spaces and data files.
• Monitoring Database for fragmentation and correcting them.
• Database performance tuning using STATPACK, TKPROF, SQL Trace, Explain Plan.
• Monitoring and Management of table space growth, extent growth.
• Planning and implementation of Backup and recovery procedures and Maintenance of Database.
• Performed Backup/Recovery using RMAN.
• Wrote scripts for Startup, Shutdown and automation of backups.
• Monitoring Scheduled jobs of the daily activities for the performance of all the databases.
• Prepare the documents of the process and knowledge transferring about the project to the new team members.
• Involved in the process of tuning and refining queries of various applications.
• Written scripts for Health Check of Databases, Analyzing of Tables and Rebuilding of Indexes.
• Interfacing with Confidential for technical support.

Environment: Confidential Server 8i, SQL, PL/SQL, Sun Solaris 2.5, 2.6, Shell scripting.