SUMMARY:

• 9+ years of experience as Oracle Data Base Administrator, providing 24x7 production support of both development and production 12c /11gR2/10gR2/9i/ databases on different Platforms
• Outstanding knowledge in Installation and Configuration of Oracle 9i, 10g and 11g in Linux/AIX/ SunSolaries/ Windows/ HP - UX environment.
• Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, ORADEBUG, 12c/11g/10gOEM Grid Monitoring custom scripts troubleshooting oracle databases using SQL trace utilities.
• Skilled in regular Database Administration activities such as Upgrades, Patches, TAR support, Cloning, Backups and Recovery Manager, Performance Tuning, capacity planning, script development, and documentation
• Skilled in setting up/Installation and configuration of release 11gR2 RAC and 10g R2 RAC with ASM. Experienced in configuring & Managing the ASM
• Experienced with GoldenGate 11g replication for Oracle databases
• Planned and implemented Disaster Recovery & High Availability solutions using Oracle 11g/10g Standby Database using Oracle Dataguard, 9i and 10g RAC/11g RAC
• Skilled in taking backups using cold, hot and RMAN backups and also tested different recovery procedures also Cloning/Refresh
• Skilled in developing RMAN scripts for database back up including hot and cold backup options for both RAC and standalone instances
• Knowledge in writing shell scripts for automation of jobs
• Knowledgeable about how to Configure, Migrate and Maintain, manage I/O Resource, Optimizing Database Performance of Exadata Storage Server
• Hands on experience on Oracle 11g Active DataGuard/10g DataGuard with swithover, failover and Dataguard Broker
• Skilled in different environments like HP-UX, SUN SOLARIS, AIX and Linux.
• Installed and configured 10g RAC on LINUX platform with ASM disks for storage.
• Skilled in dealing with ASM environment such as Installation, taking backup, migration from NON-ASM to ASM environment
• Co-ordinated in OEM12c Grid Control setup
• Skilled in Cross platform migrations from Windows to Linux, Solaris to Linux, Linux to AIX
• Skilled in database Upgrades 9i to 10g R2, 9i to 11gR2, 10R2 to 11gR2
• Skilled in using 11g/10g features Flash-Back Recovery, Data Pump, AWR, ADDM,ASH, ASM Recycle Bin, 10g Grid Monitoring
• Experienced in loading data from flat files using SQL Loader and External Tables.
• Skilled in using tools such as SQL Developer and TOAD.
• Dealing with database security and auditing
• Excellent experience in creation and maintenance of Logical Standby
• Skilled in Space Management and Security
• Skilled in MySQL, SQL Server Database Administration 2012/2008
• Experienced with Data ware house environment.
• Experienced with working on large database environment upto 25TB
• Awareness on Oracle Support processes for technical requests through Meta link

TECHNICAL SKILLS:

Operating Systems: Sun Solaris 9/10, HP-UX 11i v1.5, AIX 5.3/6.1/7.1, RHEL 3/4/5, Windows 2003, Windows 2000/NT, Windows XP.

Databases: Oracle 12C,11g, 10g, 9i, 8i, Mysql, Microsoft Sql Server 2005, Netezaa, Oracle 11g/10g Real Application Cluster (RAC), ASM

DB Utilities: SQL*LOADER, exp, imp, EXPDP, IMPDP, RMAN, Opatch, TK Prof, Utlbstat, Utlestat, Statspack, AWR, ADDM, QOPATCH, ExaData NID, DBVERIFY, SRVCTL, CRSCTL, ASMCMD, DBCA, ADRCI and DBUA

Scripting: Shell Scripting Korn & Bourne, C Shell

Monitoring Tools: Quest Fog light, VERITAS Net Backup, Legato backup, Cisco Tidal, Performance and Web Portals, BMC Remedy, HP Quality Center.

Tools: Oracle Enterprise Manager 10g/11g, TOAD 8.5, SQL Developer, Putty, SQL*PLUS, iSQL*Plus, ERWIN 4.14, SQL- Navigator, ERWIN, LogMiner and Flashback Data Archive, Macromedia Flash, Dream-weaver, MS Office, Joomla.

Languages: SQL, PL/SQL for Oracle, C, Java, Php, XSLT.

PROFESSIONAL EXPERIENCE:

Confidential, NY

Sr Oracle DBA

Responsibilities:

• Supported multiple database farms including development/production sizes up to 5 TB for 24/7.
• Designed, Installed and configured the Oracle server software and related products. Upgraded 30+ databases from 10.2.0.1 to 10.2.0.3 to 11gR1/R2 on RHEL.
• Completely build RAC from scratch including OS and RAID configuration.
• Scheduled meetings with application team for database migration review to gather legacy information such as type of application, database options, current oracle configuration, capacity and oracle outstanding tasks.
• Setup and documented Oracle Golden Gate replication on 11g for support team.
• Developed, revised and implemented policies, standards, procedures and guidelines necessary to effectively administer the database environments.
• Monitoring and maintaining 2/3 node RAC database on Red Hat Linux. Providing support to the development team and handling release schedules.
• Maintaining sound backup and recovery policies and procedures using RMAN. Monitoring the scheduled backup procedures for daily basis using crontab.
• Database refreshes using export /import and data pump. Used RDA, ADDM and AWR reports to monitor the database performance.
• Used power designer, E/R Studio for data modeling and to estimate the database size, database design reviews.
• Developed and maintained PL/SQL Stored Procedures, Packages, Functions and Database Triggers. Developed and maintained shell/Perl scripts for setting up batch jobs and managing release scripts.
• Implemented SQL outline to get the better execution plan for the offending queries. Setting up analyzing scripts and coordinated with development team to gather table statistics.
• Perform Database Tuning & Performance, Storage Management, Plan growth and changes (capacity planning), Database Monitoring, Security Management and Tuning SQL queries.
• Diagnosed Oracle bugs and coordinating with Oracle support through meta link to resolve them in timely manner.
• Performed various tasks like Administering RAC using SRVCTL, Adding nodes and instances, Administering Storage Components, Parameter Management, and Configuring High Availability Features for RAC.
• Worked on OLTP and Data warehouse farms.
• Have installed and setup Oracle 12c databases on test servers to test the multitenancy
• Refreshed multiple databases for Development and Testing upon short request.
• Performance Monitoring and Tuning of Oracle Application Servers using Statspack, TKPROF, and OEM for tuning on10g and on 11g using SQL access manager, SQL tuning manager.
• Performed database cloning/exp/imp to setup identical databases in the production and development environments.
• Perform Backup and Recovery thru RMAN.
• Strong exposure in Installing / configuring / maintaining RAC, Dataguard, Physical / Logical Standby environments.
• Worked extensively with Netezza scripts to load the data from flatfiles to Netezza database.
• Worked with NZSQL scripts, NZLOAD commands to load the data to Netezza target involved in monitoring the lock processes, releasing locks in case of resource blockage and gathering statistics.
• Used Oracle 10g AWR & ADDM to monitor database activities and performance tuning.
• Performed Database Administration using TOAD, Oracle Enterprise Manager and SQL scripts.
• Monitoring Smart Flash Cache Activity on Oracle Exadata.
• Configured various Oracle Exadata Database Machine
• Installed, migrated, configured and tested Oracle 11g databases in various environments.
• Extremely dedicated, self - motivated, Pro-Active and willing to assume responsibility.

Environment: Oracle 10g, 11gR1, 11gR2, OEM-12C, Linux 5.5, RHEL, Sun Solaris, IBM AIX, DBUA, RMAN, RAC, Grid, Dataguard, Exa-data, Control-m Job Scheduling, Netezaa, BMC Remedy Ticketing system, SVC EMC Data Domain, Net-Backup, Teamquest tool.

Confidential, Cleveland, OH

Oracle DBA

Responsibilities:

• 24/7 Production Database Administration Support
• Installed and Configured Oracle 9i/10g RAC.
• Worked on Multiple RAC clustered environments ranging from 2 nodes to 4 nodes per cluster.
• Experienced with SRVCTL, OCR and Voting Disk of 10g RAC.
• Managing two node RAC databases on Red hat Linux advanced server 2.1.
• Performed Database migration from Oracle 9.2.0. To 10.1.0.3
• Implemented Golden Gate for Standby Configuration and developed procedures for Replication.
• Creation of Test and production databases of Oracle Enterprise Edition 8.1.7
• Monitored the growth of the database objects for capacity planning.
• Has primary responsibility for Oracle Data Base and Application performance tuning, physical/logical design and optimization and availability.
• Used Flashback Technology-Query, Table, Drop and Database to undo specific transactions, provided point-in-time recovery of database objects, recovered database objects and rewind entire database to a particular time respectively.
• Perform requirements gathering, data mapping, metadata management and Database modeling.
• Designed and implemented OLS oracle 9i label cache to enable use of Hibernate with OLS and to improve performance by eliminating repeated use of Oracle conversion functions.
• Optimized data loading using SQL*Loader to load different types of data from flat files to the Oracle server.
• Configured the automated alerts for the production servers, which alerts DBA with the alert log errors and proactively space related errors.
• Cleaning the ORACLE HOME file system by cleaning the log files, alert log file and listener.log files
• Identified and trouble shot everyday issues like locking, scripts execution, Data Audits etc.
• Backup and recovery utilizing RMAN.
• Working with the application support people to resolve database related issues and running the scripts for the application support people.
• Creating users and database links, snap shots on production and development servers.
• Maintaining system security, defining of roles, profiles etc.
• Checking CRON jobs. Monitoring Application specific background processes.
• Creating materialized views and materialized view logs to implement the table level replication for the MIS databases.
• Use Oracle Metalink Support to resolve different issues related to database servers, security patches.
• Installed and Upgraded Shareplex (3.2 to 4.1) a replication tool for reporting environment.
• Performing Online and Offline database backups on schedule.
• Scripting of Automated backup for Cold / Hot backups.
• Implementation and Configuration of OEM & Oracle Management Server for maintenance and monitoring.
• Installation and Maintenance of Shareplex Replication, Quest-Spotlight.
• Perform database cloning/exp/imp to setup identical databases in the production and development environments.
• Upgrade/Migrated the production and development databases from 9i to 10g.
• Involved in Database sizing, Capacity Planning.
• Identify Top SQL that are consuming heavy resources and provide support to the development team in identifying SQL queries that are consuming high resources and to see if these queries can be fine tuned for better performance.

Environment: Oracle 10g/9i, Solaris, VERITAS, OEM, EXPLAINPLAN, TKPROF, AIX, Oracle 10g,RAC,TOAD.

Confidential, Boston, MA

Sr Oracle DBA

Responsibilities:

• Installation, Configuration and maintenance of Oracle 11g/10g database software on RHEL and Oracle Enterprise Linux (OEL).
• Configured 3-node Real Application Cluster (RAC) and monitored RAC instances with Oracle Enterprise Manager Grid Control.
• Configured Physical Standby databases and logical Standby database for ACTIVE DATA GAURD.
• Configuration of Oracle ASM on RHEL and HP-UX and managing disks and disk groups.
• Done migration of non-ASM database to ASM databases.
• Implemented ASM on RAC databases and standalone databases.
• Involved in monitoring the database related activities using Oracle Enterpriser Manager 10g Grid Control and monitoring the backup jobs scheduled in Oracle Enterpriser Manager (OEM).
• Performed oracle database refreshes using expdp/impdp from production to test database.
• Done with performance tuning related jobs like general health checks and maintenance of databases using Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM) reports by finding wait events.
• Performed logical backups of schemas and database using DataPump (expdp/impdp) as per requirement.
• Cloning of Databases using RMAN.
• Written SQL scripting to monitor Tablespaces.
• Migrating and upgrading the Oracle 9i database to Oracle 10g and incorporating the changes in the database design.
• Performed rolling patch upgrades for RAC environment for bug fixing and also involved in applying PSU and CPU patches for Oracle Server.
• Oracle Database and SQL Tuning using STATSPACK, EXPLAIN PLAN, TKPROF, AWR and ADDM reports.
• Performed Range Partitioning as a cause to improve the performance of the database.
• Daily incremental backup and weekly full backup of databases using RMAN.
• Participated in regular on-call support for production databases.
• Importing of dumps using impdp/expdp utilities.

Environment: Oracle 11g/10g, Oracle Enterprise Manager Grid Control, ASM, Real Application Cluster Loader, Oracle Enterprise Manager (OEM), TOAD, Red Hat Enterprise Linux (RHEL) and Oracle Enterprise Linux (OEL).

Confidential, Washington, DC

Oracle DBA

Responsibilities:

• Installation, configuration and maintenance of Oracle 10g and 11g databases on AIX.
• Created Databases on SUSE 10 and SUSE 11 servers.
• Oracle 10g, 11g (R1 and R2) installation on all major UNIX flavored operating system like RHEL, Oracle Unbreakable Linux (OUL), and WINDOWS server 2000, and 2003.
• Installed Oracle 10g, 11g RACdatabase on Red Hat Linux.
• Creating and maintaining the Oracle databases.
• Installation and maintenance of Oracle 11g Data Guard (Active).
• Data Guard using physical standby database, Implement log miner, Data guard / Standby both physical and logical standby perform switchover/failover and monitor using Data Guard manager command line and GUI.
• Upgrading databases to Oracle 11g and 11gR2 from Oracle 10g.
• Provided backup/recovery, problem diagnosis, performance tuning, data reorganization, and database upgrade.
• Installation, Configuration and Maintenance of Oracle RDBMS Software.
• Experience in applying critical patches and patch sets whenever required.
• Applying patches both Server side and Client side.
• Coordinate with UNIX administrators for space management on various servers.
• Setting up new environments (Development, Production etc.).
• Database Sizing, Table space Management and Rollback Table Space Management, Transaction Management and Security Administration
• Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups.
• Installed and Implemented Backup & Recovery procedures. Implement Hot, Cold and Logical backup plans.
• Worked on import/export and SQL- loader.
• Setup backup and recovery procedures using RMAN.
• Configured and support Oracle middleware applications and Oracle Web Logic Server for Linux x86-64
• Experience in Oracle Golden Gate installation, configuration, troubleshooting GG issues.
• Involved in I/O tuning by moving data files and redo log files to faster disks.
• Performed Explain Plan analysis for Query Optimization and SQL tuning with OEM.
• Performed Database and SQL tuning by using various Tools like STATSPACK, AWR, TKPROF, EXPLAINPLAN, and optimizer hints.

Environment: Oracle 11g/10g/, Red Hat Linux, TOAD, ERWIN, RMAN, SQL server, Data Guard, OEM, Grid Control, Golden Gate, Data Guard, STATSPACK, AWR, Explain Plan.

Confidential, Overland Park, Kansas

Oracle DBA

Responsibilities:

• Involved in 24x7 supports for Production database and applications with on-call pager.
• Installation and creation of 10g RAC and 9i databases for Testing, Development and Production.
• Major activities include logical and physical database design, capacity planning, performance tuning, database security, disaster recovery, installation and ongoing maintenance.
• Configured Disaster Recover and Logical standby for Production database in 10G.
• Tune databases performance, Schedule backup, jobs using OEM Grid Control.
• Involved optimizing database schemas, SQL queries, database procedures, and installation.
• Cloned/Refreshed Oracle Databases using RMAN for development and testing.
• Worked with Erwin, ER/Studio, Data Warehousing, Extract Transform and Load (ETL), Oracle Warehouse Builder, SQL, PL/SQL.
• Responsible for setting and managing user accounts, granting required privileges, profiles to users, Auditing Users.
• Written shell scripts for digitization the process and for Startup and Shutdown, Health Check of Databases, Analyzing of Tables and Rebuilding of Indexes.
• Supported upgrades from oracle 9i to 10g, 9i/10g.
• Performed migration from 9i to 10g from AIX to Linux.
• Tuning SQL queries using AWR, ADDM, TKPROF, EXPLAIN PLAN, and SQL TRACE.
• Developed startup/shutdown guides, trouble shooting documents, root cause analysis documents.
• Worked on Data pump (Expdp / Impdp), Import / Export for logical database maintenance.
• Performing Backup/Recovery of all the Oracle databases using RMAN and also setup RMAN catalog for the same.
• Creating tablespaces sizing the system table space, allocating default tablespaces for users.
• Creating tables and indexes, sizing their extent, partitioning and so on.
• Creating users with restricted access, with default and temporary tablespaces.
• Developed database system build sheets, code review checklists, code promotion process documents, outage reporting documents.
• Resolving SQL tuning issues and Tuning Considerations for Different Applications.
• Monitoring the table growth, database growth, current users, and system resource usage and so on.
• Experience in SQL*Loader, loading data from text files.
• Performed scheduling of Change Control-activities and scheduling jobs.
• Performed Database Reorganization regularly to remove row migrations and fragmentation using export and import utilities. Write UNIX Shell Scripts to schedule these activities.
• Contact oracle meta link to resolve database issues and to raise SR's.

Environment: Oracle 10g /9i, ASM, Sun Solaris 9, Red Hat Enterprise Linux 4.x, OEM, Explain Plan, Tkprof, SQL*LOADER

Confidential, Marysville, OH

Oracle DBA

Responsibilities:

• Installing 10g/9i for TEST and Development.
• Developing shell script to automate the processes.
• Create table spaces, tables, and users for custom applications.
• Creating and dropping of users, granting and revoking permissions to users/roles as and when required
• Applying standalone RDBMS patches
• Installed and Implemented Backup & Recovery procedures.
• Monitoring Growth of tables and undertaking necessary re-organization of database as and when required.
• Created PL/SQL procedures (jobs) to automate maintenance tasks.
• Write SQL scripts to monitor tablespace and extent growth.
• Developed RMAN scripts for database backup and recovery including hot and cold backup.
• Using TKPROF, EXPLAIN PLAN for better performance
• Data loads using SQL loader utilities

Environment: Oracle 9i, Linux, Solaris, Windows NT/2000, Toad.