PROFESSIONAL SUMMARY:

• 8 years of experience in IT industry as an Oracle Database Administrator.
• Installation and administration of Oracle 12c/11g/10g, PostgreSQL on OEL, RHEL, Windows, and UNIX and Solaris platforms.
• Designing and building database structure and objects that best support operational and analytics application.
• Upgrading and migrating databases, applying patches, patch sets and critical patch updates, replication and extraction of data using GoldenGate
• Installing, creating and maintaining Oracle Data Guard and Oracle Grid Control.
• Installing and configuring Oracle RAC with ASM file systems on multi - node systems, 12c, 11g, and 10g in different operating systems.
• Performance tuning, SQL tuning services with EXPLAIN PLAN, TKPROF, AWR, ADDM, DBMS STATS to collect and maintain performance statistics and improve database performance.
• Installing and configuring RMAN with and without Recovery Catalog on Oracle 12c/11g/10g/9i.
• Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Successfully resolved problems which involved in-depth knowledge of Oracle Architecture, Connectivity, Backup/Restore, Database Corruption and Security.
• Participated in Problem determination and Trouble shooting in Development, Test and Production Environments.
• Experience in implementing RAC Database in AIX platform.
• Hands-on experience in Oracle Data Appliance (EXADATA) monitoring System utilization and performed health check on cell nodes.
• Performed periodic maintenance tasks like Index rebuilds, data purge, Table Analysis and Partitioning to ensure efficiency and reliability of the applications and databases.
• Preparation of High Level document, Detail Level Design document and other relevant documents for development process.
• Having knowledge on developing software at the data layer in an Oracle/Hadoop environment using Transact-SQL Software development skills in object oriented programming.
• Knowledge Transition by preparing plans, work schedule, understanding documents, managing transition calls and tracking transition status.
• Refreshing, migrating and upgrading databases.
• Conceptually strong knowledge on clustering.
• Analysis and development of Batch Programs using the Business Rules and code of the existing system
• Conceptually strong knowledge on Golden Gate integrated Extract Architecture.
• Coordinating Oracle SR engineers for resolving the critical production Issues.

TECHNICAL SKILLS:

Core Strengths: Oracle Database (RAC and Standalone) Administration, SQL, PL/SQL UNIX.

RDBMS: Oracle 9i, 10g, 11g and 12c Administration

Operating Systems: LINUX, UNIX, AIX, HP-UX, Sun Solaris, Windows 2000, 2003, 2007

Programming Languages: SQL, PL/SQL, Shell Scripting, Perl, Php, and Python

Tools: Oracle Enterprise Manager, Oracle Grid Control (10g, 11g and 12c), TOAD, SQL Developer.

EXPERIENCE:

Confidential, Lincolnshire, IL

Senior Oracle DBA

Responsibilities:

• Deploy database changes on production needed for new requirements, to fix application defects or performance issues on Sun OS, Linux and AIX.
• Participated in analysis and designing of Oracle Exadata Server for infrastructure and related projects.
• Hands-on experiences in resolving the EXADATA critical issues like Cell disk metadata corruption and loss of cell disk content (i.e. grid disk, ASM disk).
• Knowledge Transition for database activities from the existing teams.
• Perform activities of data maintenance, table maintenance, database re-organizations, data archival and other efforts typically undertaken to improve the efficiency and reliability of the applications and databases.
• Oracle 11g/12c RDBMS installation, upgrade, configuration, backup, recovery, archiving and purging activities.
• Installation, Configuration and Maintenance of Oracle Grid Control.
• Perform database activities like schema backup/restore, import/export, expdp/impdp required for the health of the application and release processes.
• Migrating databases from Windows to Linux.
• Analyze database activity, perform application database performance and tuning activities and maintain development, test and production databases.
• Installing and migrating databases including structure and scripts.
• Hands-on experience in implementing Database Security and Auditing.
• Oracle 12c DB Patching on 12.1.0.1.2.
• Implementing Oracle 11g RAC (3 node) systems in High availability environment in AIX.
• Configuring and managing active Data Guard for Production and Pre Prod databases for reporting purpose and monitored log transport services and log apply services in Physical/Logical databases.
• Perform analysis and reporting of results from processing and database monitoring.
• Developing materialized views for data replication in distributed environments.
• Proactively maintain stability of production databases.
• Hands-on experience in High-availability CRS, ASM and Active Data Guard
• Hands-on experiences in scripting languages are Perl, php and Python.
• Periodic data purge to follow retention policies and space constraints.
• Work with application team and production support team to debug production issues.
• Good Exposure in disaster recovery, routine maintenance for Oracle databases.
• Good Exposure in Oracle cluster ware and HACMP cluster ware concepts.
• Having expert knowledge in Configuring Recovery Catalog Database and maintaining RMAN.
• Experience in Oracle GoldenGate 10.x/11.x installation, configuration, troubleshooting GG issues and GoldenGate replication implementation on Oracle 10g and 11g with different OS flavors.
• Understand existing Oracle Golden gate Integrated extract architecture and provide recommendations to improve performance.
• Replication and Extracting data and applying on production using GoldenGate.
• Experience working in PCI, SOX and CPNI environments and processes related to management of such environments and disaster recovery activities.

Environment: Oracle 9i, 10g, 11g,12c, RAC, EXADATA,Active Data Guard, Oracle Data Appliance, SQL/PLSQL, UNIX Shell Scripts, Toad for Oracle, AIX, SUN Solaris.

Confidential

Oracle DBA

Responsibilities:

• Installation and Troubleshoot of Real Application Cluster (RAC) Database and Cluster ware.
• To troubleshoot and resolve all the Database Issues, Network Issues and the Application Issues.
• Worked in Production, Development, Testing and Implementation environment on Linux and AIX
• Involve in various Implementations like (DB Creation, Patching, Cloning and Up gradation) on Database Tier.
• Installing Oracle 10g/11g/12c stand-alone and RAC systems in High availability environment in different platforms including OEL, Linux, RHEL and VMware.
• Setting up BACKUP strategy and disaster recovery procedures to ensureminimal downtime and data loss.
• Good Exposure in disaster recovery, routine maintenance for Oracle databases.
• Involved in Implementation of RMAN backup strategies.
• Involved in configuring of ASM Databases and Migration of Non-ASM Databases To ASM databases Using RMAN
• Handling alone in validating the Developed scripts for Hot and Cold Backup and Database Refresh
• Implemented Symantec net backup.
• Hands-on experiences in scripting languages are Perl and Python
• Monitor physical and logical backup for Integrity and checking the Data files consistency using DBverify.
• Check the log alert files if any problems occurred and necessary action to rectify them.
• Having expert knowledge in Configuring Recovery Catalog Database and maintaining RMAN
• Analysis and Documentation of the existing database architecture.
• Applying the Critical Patch Update (CPU) based on the requirement
• Preparation of High Level document, Detail Level Design document and other relevant documents for development process.
• Providing support as required and mentoring team members while solving technical problems and providing technical guidance on solutions.
• Hands-on experience in High-availability CRS, ASM, Data Guard and ACFS.
• To Create the Standby Databases to improve the high availability, configuration and Management of Standby Data guard setup.
• Monitor the Database Health Check, Capacity Management, Logical/Physical Backups and Server/Database parameters.
• Developing complex Stored Procedures, Functions, Packages and Triggers using SQL, PL/SQL.
• Developingmaterialized viewsfor data replication in distributed environments.

Environment: Oracle 11g RAC database, AIX, SQL, PL/SQL, UNIX Shell Scripts

Confidential

Oracle Database Administrator

Responsibilities:

• Migration Oracle Server databases.
• Database Administration and Maintenance.
• Executing routine jobs/tasks as a part of every release and providing support during Implementation on Production for a release.
• Managing Table space and Data files.
• Managing Database Security (Creating users, logins and roles, granting permissions)
• Query Performance tuning using Execution Plan, Hints and AWR.
• Checked database locks and cleared the blocking sessions.
• Worked on user managed backup strategies like online and offline.
• Implemented Backup and Recovery strategies using RMAN(migrated from user managed backup to RMAN)
• Performed Cloning of database.
• Integration of Patches, Creation and Modification of tables in the database, Execution of Jobs, Bug fixing etc.
• Resolving user requests for the technical issues as well as various other tasks for the development environments.
• Responsible for migration of database from IBM DB2 to Oracle. Production database support and responsible to implement the high availability
• Installation and Configuration of Oracle 10g Cluster, ASM and database on Linux environment.
• Automatic Storage Management installation, configuration and management.
• Performance tuning of databases using AWR, ADDM and OEM.
• File management on Automatic Storage Management.
• Applying the Critical Patch Update (CPU) based on the requirement.
• Performed database backups - Cold backups, Hot backups, RMAN Incremental Backups, Data pump and Export utility.
• Performed database duplication, database restore and recovery using RMAN
• Database replication using SharePlex and Data Guard
• Production database schema upgrade.
• Production support for database availability and backup related alerts
• Handling and Maintaining databases on Archive and No-Archive log modes.
• Creating and scheduling the shell script on databases to carry out various database activities
• Data loading using Oracle data dump and Import utility.
• Report and Document preparation: Database growth and PRD

Environment: Oracle 9i, 10g, 11g, ASM, Toad for Oracle, AIX, SUN Solaris.

Confidential

Oracle Database Administrator

Responsibilities:

• Installing and Configuring Oracle 10g, including service pack deployments.
• Executing routine jobs/tasks as a part of every release and providing support during Implementation on Production for a release.
• Automatic Storage Management installation, configuration and management
• Migration of oracle databases.
• Developing complex Stored Procedures, Functions, Packages and Triggers using SQL, PL/SQL.
• Implemented disaster recovery plans.
• Working Imports and Exports utilities.
• Managing Security (Creating users, logins and roles, granting permissions)
• Performance tuning of databases using AWR, ADDM and OEM
• Creating Index & managing other objects of Database.
• Analyzing the data of billing database and preparing the reports using the data.
• Generation of consolidate bug report and prioritizing the severity of bugs.
• Software release closure review with the design team and projects.
• Releasing the software to the customer and tracking the status of installation/upgrade.
• Involved in Hardware and software testing.
• Creating and scheduling the shell script on databases to carry out various database activities
• Production database schema upgrade.
• Migration of database from file system to Automatic Storage Management
• File management on Automatic Storage Management
• Applied the Critical Patch Update (CPU) based on the requirement
• Database version upgrades from 10.2.0.1.0 to 10.2.0.5.0 and from 10g to 11g
• Responsible for database and configuration, db sizing, monitoring.

Environment: Oracle 10g, 11g, SQL, PL/SQL, Toad for Oracle, AIX, SUN Solaris.