SUMMARY:

• 8+ years of experience as an Oracle Database Administrator. Extensively worked on Installing, configuring Oracle 11gR2, 10g, 9i&8i and Patch Installation, Migration, Upgrades, Backup and Recovery, Cloning, Replication, Database Security
• Memory Management Database on AIX, Linux, UNIX and Windows environments. Experienced in configuring and managing Oracle Real Application Cluster (RAC) 10g/11g,Data Guard and Golden Gate for Oracle High Availability
• IT experience in Oracle products on multiple platforms and environments spanning Finance, IT, Insurance and Tech sectors. Ability to work both as an individual contributor and as a member of a team.
• Hands on experience in Oracle 10g/11g RAC implementation & administration (Oracle Clusterware setup and configuration, RAC installation using ASM, Grid Installation)
• Good experience in RAC Clusterware administration, Configuration and Patching, RAC Backup and Recovery.
• Installation and configuration of Oracle Server 11g RAC with ASM & OCFS2 file systems on multi node systems, 11g, 10g and 9i in different operating systems according to OFA for OLTP and Data Warehouse(OLAP) environment on Very Large Databases(VLDB).
• Knowledge on EXADATA and the latest version of ORACLE 12c.
• Monitoring and scheduling backups for a database using EM 12c cloud control.
• Configuring and implementing Oracle ASM on UNIX, Linux, and Windows platforms.
• Supported ASM database and performed migration of normal database to ASM database using RMAN.
• Extensive experience with Database Cloning and Refreshing pre - prod/dev databases with prod/pre-prod databases.
• Experience in Backup & Recovery techniques of databases running in ARCHIVELOG MODE using RMAN(scheduling full/incremental/cumulative backups, hot/cold backups writing/editing UNIX Shell Scripts for RMAN).
• Experience in LOGICAL BACKUPS and Database migration tools with DATA PUMP, Export/Import and Transportable Tablespaces.
• Experience in databases applying patches, patch sets and critical patch updates.
• Extensive experience in Data guard configuration, implementing and maintaining standby databases on different platforms.
• Experience of Oracle Golden Gate installation, configuration for replication and data migration and troubleshooting Golden Gate issues.
• Experience in monitoring and managing of Oracle instances using Enterprise Manager Grid Control (OEM Grid), Toad.
• Experience as On-Call24x7productionDBA support, application/development DBA.
• Monitoring and optimizing the performance of the database through Database Tuning - Tuning Applications, Tuning Instance, and Tuning Disk Usage.
• Experience in SQL Tuning, Optimization, rule based optimization, cost based optimization and Hints.
• Delivering Oracle Database performance-tuning services for customers by analyzing STATSPACK reports, Oracle trace and log files, AWR, ADDM,EXPLAIN PLAN, TKPROF and SQL TRACE.
• Developed database monitoring/health check alert scripts 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 using Erwin as a Data Modeling tool.
• Expertise in UNIX shell Scripting.
• Managing Database Structure, Storage Allocation, Table/Index segments, Rollback Segments, Undo Segments, and Constraints.
• Experience in Capacity Planning, Space Management, Database Upgrades / Migration Data Extraction.
• Hands on experience working on High Availability Environments.
• 24 X 7 Production Database on Call Support.
• Strong analytical and problem solving skills. Willingness and ability to quickly adapt to new environments and learn new technologies.

TECHNICAL SKILLS:

Languages: SQL, PL/SQL, Linux, Unix shell scripting, C, C++

RDBMS: Oracle 9i, 10g, 11g

Tools: Oracle Grid control, Oracle Enterprise Manager(OEM), TOAD, PUTTY, SQL Plus, SQL Developer, SQL Access Advisor, SQL Tuning Advisor

Utilities: SQL Loader, Export / Import, Expdp / Impdp, AWR, RMAN, STATSPACK

Operating Systems: RHEL 4/5, Sun Solaris 5.8, 5.9, Windows 98/NT/2000/2003/XP/7, AIX

Protocols: HTTP, TCP/IP, FTP, SFTP, SSH, Telnet

Office Packages: Word, Excel, Power point, Access

Web Tools: HTML, XML

PROFESSIONAL EXPERIENCE:

Confidential, Wilmington, De

SR Oracle DBA

Responsibilities:

• Hands on experience in installing and configuring in 12c database and grid.
• Upgraded databases from 11g to 12c manually and using DBUA.
• Hands on experience on 12c RAC administration.
• Performed Installation, Configuration, Monitoring and Troubleshooting of Oracle Clusterware and RAC on 11gR2, 11gR1, 10g databases on Linux, Unix and Solaris environments.
• Created implementation plan for the up gradation of Production and Non production RAC databases from 10g to 11g and successfully completed the upgrade.
• Hands on experience in Up gradation of All production and non Production RAC databases from 10g to 11g 11.2.0.4.
• Converted a single instance database to Oracle RAC 11g.
• Responsible for Quarterly auditing process. Performed auditing user re to verify database users to comply with Organization policies.
• Experience in development, testing, performance tuning, deployment, and support in Data warehouse system.
• Worked to improve the efficiency of data warehouse application through the use of indexes, compression, materialized views and other techniques.
• Applied latest PSU patches after the up gradation of databases.
• Services creation in RAC environment for load balancing.
• Configured Oracle label Security (OLS) for row level security.
• Migrated 20TB database from regular file system to ASM using RMAN.
• Displayed a high level of expertise while handling the various scenarios of database Backup & recovery and cloning using the RMAN tool in RAC and Data Guard environments of large to very large databases also setup RMAN catalog for the same.
• Hands on experience in installation and implementation of 12c cloud control and migration of 11g grid control to 12c cloud control.
• 12c agent installation for all prod and non production servers, configuring credentials and converting unmanaged hosts to managed hosts.
• Performing all the Database Administration activity like space management in database, user and roles administration, schema management, checking alert log of all the databases and production change deployments from application users.
• Involved in team management, team building exercises for the DBA team.
• Knowledge in writing shell scripts for automating database monitoring, backups and restoration.
• Implemented and scheduled shell script for data guard log gap monitoring.
• Experience in creating Physical Standby databases for RAC and standalone environments, and involved in converting Physical to Snapshot Standby, and also Active Data-guard.
• Experience in switchover testing using broker and OEM and resolving any sync issues.
• Configured Dataguard-broker and involved in registering of databases in Dataguard broker using utility DGMGRL.
• Involved in Disaster Recovery Testing Exercises.
• Migrated11g database from Solaris to Linux. Cross flatform migration.
• Cloning databases with RMAN and also with user managed.
• Creating and maintaining Databases manually as well as using DBCA for new applications.
• Configured level 0, level 1 and archive backups using RMAN for production and non production environments and Refined existing Backup and Recovery procedures for production database And registering databases in catalog.
• Installed and implemented SWINGBENCH tool load generator for stress test on oracle database
• Database and oracle Query performance tuning using OEM, AWR, ASH, ADDM, Explain Plan.
• Involved in Application tuning using explain plan, SQL Trace, DBMS STATS and ADDM.
• Experience in using SQLT to force the optimizer to use better explain plan and pin hash values.
• Worked extensively on Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics.
• 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 daily basis.
• Experience in Analyzing AWR and ASH reports and identifying key performance issues.
• 24x7 production database administration.

Environment: Oracle 10g, 11g,12c Linux 4/5,Solaris, DBUA, RMAN, Grid, RAC, ASM, Data Guard,12c Cloud Control,TOAD,RDBMS, SQLPLUS, PL/SQL, SQLT,Shell Scripting, Stored Procedures.

Confidential, Denver, CO

Sr Oracle DBA

Responsibilities:

• Installation, configuration, implementation and monitoring of oracle 11GR2(11.2.0.3) with ASM on AIX, Linux, UNIX and Windows environments.
• Installed and configured4 Node RAC/Multinode RAC of 11gR2 on AIX, LINUX and UNIX environments..
• Installed and configured oracle one node RACfor 11gR2 with ASM.
• Performed disk and disk group management in ASM while installing 11gR2 RAC.
• Monitoring Health checks of OCR, VOTING DISKS and troubleshooting issues in RAC environment (11GR2).
• Ensured that oracle database systems operate securely and efficiently.
• Managing databases from planning and testing stages through implementation and support.
• Performed day to day activities like resolving Tickets for multiple environments, provided Development Support, coordination with development for Application Tuning.
• Worked extensively on monitoring grid control database, configuration of error notifications, installing listeners, and adding them to the grid control.
• Performed conversion Non RAC single instance to Real Application Cluster (RAC) database instances.
• Installation and configuration of GOLDEN GATE for replication on 11gR2.
• Configured parameters for the Bi-directional replication
• Implemented Data Guard (Physical standby) on Oracle 10g and 11g with high availability and performance configurations and participated in Data Guard Fail over tests.
• Performing switchover of database form primary to standby and standby to primary.
• Configured Active data guard and performed Troubleshooting data guard environment.
• Migrated data from old 10g environments to new 11gR2 environments using database cloning and DATAPUMP (EXPDP).
• Weekly refreshes of database and schemas using DATAPUMP(EXPDP).
• Taking logical backups using EXPDP.
• Data Refreshin Test and Integration Databases using Transportable Table spaces.
• Involved in migration of 10g environments to 11g.
• Monitoring and scheduling backups for a database using OEM 12c grid control.
• Applied both CPU and PSU patches as per requirements.
• Applied grid infrastructure PSUincluding database PSU to upgrade grid and database home to latest version using OPatch utility.
• Upgraded oracle 10g to the latest oracle version 11gR2 using DBUA and by applying required patches.
• Performed schema, and table refreshes from production environment to development and test environments.
• Performed database restoration from hot and cold backup using RMAN.
• Performed cloning of database using RMAN.
• Experience in performing backup, restore and recovery operations using RMAN.
• Performing Daily and weekly backups and incremental backups using RMAN.
• Involved in tuning top SQL’s from production database by using SQL hints and by using SQL Plan Management (SPM).
• Monitoring the performance of database by doing general health checks and maintenance of database by taking AWR and ADDM reports to find wait events.
• Updating and implementing UNIX shell scripts for database monitoring and daily backups.
• 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 daily basis.
• Performance tuning of queries consuming Excessive Resources or slow running queries by Providing Required Hints to the Query and fixing the plan using SQL Plan Management (SPM).
• Performed database activities using SQL Developer and TOAD.
• 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.
• Worked with oracle support raising SEV1 for resolving production issues and bugs
• Managing and providing 24X7 supports for various versions of databases.

Environment: Oracle 10g, 11g, Linux 4/5,Solaris, DBUA, RMAN, Golden gate, Grid, RAC, ASM, Data Guard, TOAD,RDBMS, SQLPLUS, PL/SQL, Shell Scripting, Stored Procedures.

Confidential

Sr. Oracle DBA

Responsibilities:

• Involved in Implementation and support for Oracle 11g RAC instances in Enterprise Linux andAIX Environment.
• Provided support for Oracle Enterprise Manager Grid Control and Agents.
• Involved in monitoring and managing of Oracle instances using Enterprise Manager Grid Control (OEM Grid) and attending the alerts from OMS service..
• Developed generic package for partition maintenance job for multiple environments.
• Worked on Automatic Storage Management (ASM)with SAN Storage for managing data in EMC Symmetrix
• Involved in PL SQL programming and Performance tuning for oracle Database by generate and interpret AWR and ADDM reports, performed SQL Tuning by gather Auto trace information for oracle session using SQL Trace and interpret Trace file using TKProf utility.
• Used Database Configuration Assistant (DBCA), Database Upgrade Assistant (DBUA) for upgrading Oracle 10g versions in RAC.
• Implemented Data Guard on oracle 10g and 11g and performed switchover.
• Performed Oracle flashback recovery, flashback query and flashback tables.
• Involved in creation of materialized views from different data sources and refreshed the materialized view using DBMS MVIEW package.
• Using Oracle Data Pump utility making faster exports/imports on large databases and saving lot of time.
• Configured RMAN and performed daily backups.
• Data Refresh from Production to Test and Development environments using RMANDuplicateDatabase.
• Raised service request for production issues and worked with Oracle support resolving bugs & issues.
• Conducted daily routine checks on alert logs and trace files.
• Creating the Database, tablespace, Control files, log files and user profiles.
• Installed, Configured and Administered Oracle Streams.
• Designed Logical and Physical Data Modeling using Erwin.
• Creation of database objects like Tables, Indexes, Views, Users, and DB Links etc.
• Scheduled Oracle Jobs in the database.
• Analyze the schema and tables.
• Securing the data by using Oracle data vault.
• Extensively used SQL Loader to load data from flat files to the Oracle Database.
• Created and enhanced DB utilities needed for automation of system and unit tests and investigation of production issues, troubleshooting.
• Responsible for network configuration and involved in a Client - Server environment using TNS, LISTENER, Net Configuration Assistant and other configuration files.
• Created and configured database manually using Oracle Database Configuration Assistant.
• Monitored and tuned long running jobs by working closely with the application development team and analyzing objects, created or rebuilt indexes, query tuning using SQL TRACE, TKPROF, Explain Plan, TOAD from Quest software (DB Tuning).
• On call 24X7 Production Support.

Environment: Oracle 10g/11g Linux, Windows 2003, Oracle Enterprise Manager Grid Control, RDBMS, SQLPLUS, PL/SQL, Shell Scripting, RAC.

Confidential, Atlanta, GA

Sr. Oracle DBA

Responsibilities:

• Installed and Configured Oracle 9i/10g server on HP-UX, RHEL 5 and Windows for Large Multi-Terabyte Databases (VLDB).
• Configured and implemented Oracle ASM on Linux, UNIX and Windows platforms and maintained ASM instances and ASM disk Groups.
• Involved in Implementation and support for Oracle 10g RAC instances in Enterprise Linux Environment.
• Configuration and Maintenance of Physical Standby databases.
• Experience in working with SQL Server.
• Supported different Databases like Production, Testing, Staging and .
• Online and Offline Database backup and Recovery.
• Oracle Database software installation, Instance creations, schema creations.
• Upgrading databases from 9i to 10g. Creating databases manually or with DBCA.
• Installed and configured Oracle 10g database on a test server using Oracle standard procedures and OFA, for performance testing and future 10g production implementation
• Supported different Databases like Production, Development, Testing, and Data warehouse.
• Upgraded Databases from Oracle 9i to Oracle 10g on Solaris.
• Cloning of databases from production to test environments for testing purposes.
• Troubleshoot databases, provide reports on the database health check, follow up and recommendations.
• Operational Responsibilities - Database refreshes/ backs, security, documenting standards and procedures, data migration, data clean-up, copy data archiving, etc.
• Automated monitoring the databases, performance parameters, backup and recovery activities by running Cron jobs and customized various Unix Shell Scripts in sending Email for ORA- errors, reports for Quick Morning Check (QMC), automate routine DBA tasks of taking backups, exports, space usage monitoring, move Archive Logs to different mount point when Archive Destination is full and Resync RMAN catalog.
• Worked with a team for installation and maintenance of ORACLE 10g RAC, ASM database for high availability.
• Well conversed using the CRSCTL and SRVCTL tools for maintaining database, ASM and node applications.
• Monitored and tuned long running jobs by working closely with the application development team and analyzing objects, created or rebuilt indexes, query tuning using SQL TRACE, TKPROF, Explain Plan, TOAD.
• Performed troubleshooting of database using AWR and ADDM reports.
• Planned, tested and implemented backup strategy using RMAN, Oracle Utilities (Export/Import)EXPDP and OS methods.
• Performed Database replication from production to test/development environment Using RMAN, Data pump utilities and manually
• Responsible for network configuration and involved in a Client - Server environment using TNSNames, LISTENER, Net Configuration Assistant and other configuration files.
• Extensively used SQL LOADER as a tool for loading data.
• Installed and Configured of Oracle OEM (Oracle Enterprise Manager) Grid Control and OEM Database Control to monitor database.
• Handling large database environments (Data warehouse) using Oracle Enterprise Manager (OEM) on daily basis observing the performance of the production database and constantly active regarding performance and space management issues and accordingly providing on-fly solutions to make database healthy and running.
• Extensively compressed large tables in Data warehouse Environment to reduce space usage.
• Created and Managed users, user profiles, table spaces, data files, archive log.
• Created database links that are required for databases.
• Tuning SGA, Rollback segments, Latch contention issues, Optimize sortoperations.
• Perform extensive testing on new versions of database products and tools to identify and resolve migration issues before these products are installed in the production environment. Worked as a member of production DBA team in perfect coordination with seniors and team members.

Environment: OEM Grid Control, Oracle 9i, 10g RAC, Solaris 7, RMAN, Sql*Loader, Import & Export, Data pump, Data guard, RMAN, AWR, ADDM, Statspack, ASM, TOAD 7.4, Shell scripting, Data warehouse, AIX 4.3 etc.

Confidential

Oracle DBA

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&9i) in Windows, Linux and Solaris environments
• Involved in Schema management, Table space Management, User Creation.
• Monitoring the Extraction and loading processes of Data.
• Upgraded and applied patches as and when required. Database Refreshes from Production to Development. Troubleshooting Day-to-Day Users Issues in various modules.
• Responsible for Oracle implemented backups like LOGICAL & PHYSICALi.e.Export & Import and also having experience with EXPDP & IMPDP.
• Evaluated the hardware requirements before upgrading/migrating the database.
• Good experience with recovery managed backups i.e. RMAN
• Migrated the database from non Oracle to Oracle i.e. SQL Server to Oracle.
• Maintained and audited Application and data servers.
• Documented the complete project including all pre installation, post installation and database configuration steps.
• Involved in writing UNIX shell scripting for automating the jobs.
• Manage users, privileges, profiles and schemas.
• Experience in using automatic monitoring and management processes such as batch processing using Crontab for processes like import, export databases.
• Used analyze table, analyze indexes to tune queries and increase performance.
• Experience with SQL query tuning, SGA tuning and Histograms understanding and sound knowledge in SQL execution plan.
• Tuning Oracle 9i database servers using tools dynamic, dictionary views, Stats pack, ADDM, AWR Diagnostic and tuning packages.

Environment: Oracle9i/10g, Windows NT/03, Linux, AIX5.1, Hp-UX, Sun Solaris, SQL, PL/SQL, Shell Scripting.

Confidential

Oracle DBA

Responsibilities:

• Created and Managed users, roles, schemas, tables, views, indexes and rebuilding Indexes and granted privileges.
• Configured Recovery Manager (RMAN) and Performed Hot and Cold backups for production databases using RMAN.
• Involved in taking logical backup using Data pump Expdp and Impdp Utility.
• Involved in checking the status of listener and restarting listener.
• Grant and Revoked user privileges and roles as per requirement and killed blocking session.
• Performed auditing on user activities on request and per organization policies.
• Created and managed database objects like table spaces and increase the size of the table space by resizing and adding the data files.
• Conducted daily routine checks on alert logs and trace files for database errors and taken necessary actions to resolve the issue.
• Developed and modified PL/SQL code to make new enhancements or resolve problems, as per customer requirements.
• Created complex analytical reports using inline view, lexical parameters with Oracle Reports 9i.
• Modified Kron shell scripts as per technical specifications.
• Prepared Data Flow Diagrams for existing PL/SQL code.
• Involved in coding of data extraction scripts as per technical specifications.
• Analyzed the table structures using Analyze command.
• Involvement in all phases of the project life cycle.
• Designed database tables as per technical specifications.
• Translated business requirements into creation and alteration of database objects tables, indexes, constraints, triggers and stored procedures.
• Implemented automated backup strategy using the UNIX shell script CRONUTILITY.