PROFESSIONAL SUMMARY:

• 8 years of experience as an Oracle Database Administrator having hands on experience in database administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, space management, database security, cloning, migration, shell scripting and documentation on Linux, SUN Solaris, AIX, HP-UX and Windows operating systems.
• Implemented RMAN backup Full, differential and cumulative .
• Installed, Configured, Administration, Monitoring Support Oracle GRID for maintaining Oracle Databases supporting multiple applications.
• Proficient in setting up Standby Database using shell scripts and RMAN utility tool, activating and Re-building Standby Databases both Physical and Logical.
• Experience in Implementing and Maintaining Golden Gate replications across multiple Oracle and Non-Oracle databases.
• Experience in installing and configuring Oracle Enterprise Manager OEM .
• Experience in Adding Nodes for Existing RAC cluster.
• Created development, testing, staging, production, RAC and standby databases for OLTP and Data Warehousing using customized shell scripts.
• Upgraded databases from Oracle 11g to 12c.
• Experience in Real Application Cluster RAC environment Oracle 10g, 11g and 12C.
• Experience in performing recovery, incomplete recovery and disaster recovery using Standby database.
• Experience in recovering database using Flashback technology.
• Expertise in Performance tuning of the database - SQL Tuning, Used Tuning utilities like AWR, ADDM, ASH, ASMM, Statspack, TKProf, Explain Plan, SQL Trace, Tuning of SGA, Distribution of disk I/O, Sizing of tables and indexes.
• Experience on Data Replication using Snapshot, Materialized views, import/export.
• Expertise in upgrading the databases from Oracle 9i to Oracle 10g and Oracle 10g to Oracle 11g.
• Good experience in Data Migration using traditional export/import, data pump, SQL Loader from flat files.
• Experience in writing UNIX Shell scripts and Perl scripts.
• Implemented automated backup strategy and database monitoring scripts using UNIX shell script and scheduled in CRON.
• Proficient in SQL, PL/SQL, Stored Procedures, Functions, Materialized Views, Cursors and Triggers.
• Management of schemas, Data modeling, objects partitioning the tables indexes.
• Security user Management, Privileges, Roles, Auditing, Profiling and Authentication.
• 24 7 production database support with Support to developers end-users.
• Experience in using the oracle support Metalink for technical assistance requests TAR by uploading the system activity reports SAR and database log files related to performance issues.
• Scheduled jobs in the database using DBMS JOBS.
• Resolved database network problems.
• Knowledge in Microsoft SQL Server databases.
• Excellent personal time management, organizing, problem solving skills, team player and ability to learn.
• Strong ability to understand new concepts and applications. Good communication skills to work independently and in a team environment.

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Confidential

Oracle DBA

Roles and Responsibilities:

• 24x7 Production on call Database support
• Installed configured, maintained and tuned Oracle 10g and 11g databases.
• Upgraded database from Oracle 10g to Oracle 11g R2 and to Oracle 12C.
• Installed and configured Oracle 10g RAC, Oracle 11g RAC, Oracle 12C.
• Involved in Migration of Non RAC single instance to Real Application Cluster RAC database instances.
• Converted Single Instance Database to Multi Node RAC
• Involved in Design, implementation and generating documentation of Oracle 10g, 11g Data Guard on both physical/logical standby databases in high availability mode.
• Performed capacity planning and bench marking.
• Implemented Dataguard, creating both Logical and Physical Standby databases in 10g RAC, 11g RAC environment for the Production databases.
• Implemented and Maintained Golden Gate replications across multiple Oracle and Non-Oracle databases.
• Configured Golden Gate Extracts and Replicats.
• Implemented Cumulative, Differential , Incremental backups using RMAN
• Written and modified UNIX shell scripts, to manage Oracle environments
• SQL tuning and Database performance tuning has been done based on reports generated by SQL Trace, Explain Plan, AWR, ADDM and monitor the database performance on daily basis.
• Planning Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups with Export/Import Data pump utilities .
• Creating Managing Database Structures, Storage Allocations, Table/Index segments, Constraints, Database Access, Roles and Privileges.
• Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics for the same.
• Organized various migration review meetings with the application team to discuss the migration strategy based on business requirements.
• Performed SQL and PL/SQL tuning, oracle contention and monitored production database using automatic workload repository AWR , automatic database diagnostic monitor ADDM and active session history.
• Automated the backups
• Cloning duplicating databases using scripts as well as RMAN.
• Expertise in recovering the database. Performed complete recovery, data file recovery, incomplete recovery.
• Data loads using SQL Loader and external tables.
• Created and scheduled jobs using DBMS SCHEDULER
• Configured database targets in the ORACLE Enterprise Manager OEM .
• Experienced in Database Security User Management, Privileges, Roles, Auditing
• Applied security patches, Patch Set Unit PSU and Performed testing.
• Written monitoring scripts and scheduled them using the Crontab
• Worked closely with the Oracle developers for the better performance in Applications in writing the efficient SQL and PL/SQL Packages, Procedures, Functions and Triggers.
• Used Secure SCP FTP extensively for the File transfers from machines to remote server.
• Working with Oracle support to resolve critical issues like ORA-600 errors.

Environment: Red Hat Linux, AIX, Oracle 10g RAC, 11g RAC and 12C RAC, Oracle Enterprise Manager/Grid Control, OEM 12C, RMAN, DataGuard, Oracle Golden Gate, ASM, SCP/SFTP, Net App ,TKPROF, Explain plan, AWR, ADDM, SQL Plus, Crontab, PL/SQL, SQL Loader.

Confidential

Oracle DBA

Roles and Responsibilities:

• 24x7 Production on call Database support
• Upgraded database from Oracle 10g to Oracle 11g.
• Involved in Installation and configuration of Oracle 10g RAC, Oracle 11g RAC.
• Migration of Non RAC single instance to Real Application Cluster RAC database instances.
• Involved in Design, implementation and generating documentation of Oracle 10g, 11g Data Guard on both physical/logical standby databases in high availability mode.
• Migrated databases from HP-Unix to Linux.
• Written Shell Scripts for implementing and automating various daily tasks.
• SQL tuning and Database performance tuning has been done based on reports generated by SQL Trace, TKPROF, STATSPACK, Explain Plan, AWR, ADDM and monitor the database performance on daily basis.
• Extensively used Export/Import, Data pump utilities.
• Creating Managing Database Structures, Storage Allocations, Table/Index segments, Constraints, Database Access, Roles and Privileges.
• Responsible for installing, upgrade and configuring the Oracle Server, Creating Databases, Storage Structures and Objects, Database Backup and Recovery, Monitoring and Optimizing Database Performance.
• Creating both Logical and Physical Standby databases in 10g RAC, 11g RAC environment.
• Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics for the same.
• Organized various migration review meetings with the application team to discuss the migration strategy based on business requirements.
• Performed SQL and PL/SQL tuning, oracle contention and monitored production database using automatic workload repository AWR , automatic database diagnostic monitor ADDM and active session history.
• Cloned databases using RMAN.
• Develop, implement and test Backup and recovery strategies.
• Performed data file recovery, complete and incomplete recovery.
• Experienced in Database Security User Management, Privileges, Roles, Auditing
• Applied security patches and Performed testing.
• Worked closely with the Oracle developers for the better performance in Applications in writing the efficient SQL and PL/SQL Packages, Procedures, Functions and Triggers.
• Used Secure SCP FTP extensively for the File transfers from machines to remote server.

Environment: Red Hat Linux, HP-UX, Sun Solaris, Oracle 10g RAC and 11g RAC, Oracle Enterprise Manager/Grid Control, OEM 12C, RMAN, DataGuard, ASM, SCP/SFTP, TKPROF, Explain plan, AWR, ADDM, SQL Plus, PL/SQL, SQL Loader.

Confidential

Oracle DBA

Roles and Responsibilities:

• Upgraded database from Oracle 9i to 10g and 10g to 11g.
• Installed and created Oracle 10g/11g databases in development, Production and QA environment including configuration, backup performance tuning.
• 24x7 Production on call Database support
• Applied RDBMS patches.
• Applied CPU patches
• Cloning of the database is done from Production to the Test, Development environments.
• Performed Backup Recovery.
• Maintained Database Security by creating Roles, Privileges, Quotas, and Passwords.
• Configured TNSNAMES.ORA and LISTENER.ORA for SQL NET connectivity.
• Extensive Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL Trace and TKPROF, AWR, ADDM, STATSPACK.
• Worked with Oracle Data Pump expdp and impdp which provides high speed, parallel, bulk data and metadata movement of Oracle database contents.
• Recovery of Database Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, recovering from Block Corruption .
• Reading Alert Log and User trace Files and Diagnosing the Problem.
• Implemented cold backup and hot backup depending on the requirement.
• SQL, PL/SQL and UNIX Shell Scripting.
• Daily Health Check Up of the Databases
• Written scripts to monitor tablespaces and extent growth. Space Management.
• Loaded data from flat file to Oracle database using SQL Loader. Created indexes on tables for performance tuning. Performance monitoring, tuning and space management in database with Grid control. Performed Troubleshooting and system maintenance.
• Performed Database Reorganization regularly to remove row migrations and fragmentation using export and import utilities. Write UNIX Shell Scripts to schedule the code.

Environment: Oracle 9i/10g RAC, RHEL, HP UX, SQL, PLSQL, Sql developer, OEM, UNIX Shell Scripting.

Confidential

Oracle Developer / DBA

Roles and Responsibilities:

• 24x7 Production on call Database support
• Installed and maintained Oracle 9i/10g databases.
• Upgraded databases from lower version to higher version.
• Served as a member of 24-hour on call support staff.
• Refreshed development and test databases from production using logical backups export and import .
• Performed database administration and user/security management. Resolved issues related to client/server connections.
• Implemented Cold backup, Hot backup in manual methods using scripts and Using RMAN and recovered various development and critical Production databases.
• Tuning of Shared Pool, Library Cache, and Data Dictionary Cache.
• Very high transfer of data from one database to other by using two utilities of oracle data pump which are expdp Data Pump Export and impdp Data pump Import .
• Rebuilding of Indexes for better performance, maintenance of Oracle Database.
• Scheduled jobs in the database using cron job and DBMS JOBS.
• Participated in the Installation of Oracle 10gRAC.
• Generated performance reports using utilities like AWR, STATSPACK to gather performance statistics.
• Identified and tuned poor SQL statements using EXPLAIN PLAN, SQL TRACE and TKPROF. Analyzed tables, indexes for improving the performance of the Query.
• Analyzed SQL statements and reorganized database objects and designed indexes to improve response of queries.
• Monitored Overall system Performance and Database growth.
• Created users and allocated appropriate tablespace quotas with necessary privileges and roles for all databases.
• Configured TNSNAMES.ORA and LISTENER.ORA for SQL NET connectivity.
• Reading Alert Log and User trace Files and Diagnosing the Problem.
• Daily Health Check Up of the Databases
• SQL, PL/SQL and UNIX Shell Scripting.
• Implemented cold backup and hot backup depending on the requirement.
• Designed, documented and implemented backup and recovery Procedures. Simulated few possible crucial recovery scenarios using the current available backups to check the effectiveness of the backup plans and also to get a rough estimate of the recovery time involved.
• Involved in migration of data from SQLSERVER to Oracle.
• Written scripts to monitor tablespaces and extent growth. Space Management
• Involved in user creation and user access control. Involved in Schema creation and management. And Developed stored procedures, stand alone functions and PL/SQL packages to comply with the requirements.

Environment:Oracle 9i/10g, 10g RAC, RHEL, HP-UX, IBM AIX, SQL, PLSQL, SQLSERVER, Unix Shell Scripting.

Confidential

Oracle Developer

Roles and Responsibilities:

• Worked on complete SDLC system development life cycle including system analysis, high level design, detailed design, coding and testing.
• Creation of database objects like tables, views, procedures, packages using Oracle tools like PL/SQL, SQL Plus, SQL Loader.
• Written Database Triggers, Stored Procedures using PL/SQL.
• Successfully created and debugged many PL/SQL procedures, functions and Packages for the application.
• Analyzing requirement of client, generating and designing reports.
• Created Data Structures Tables, views and applying the referential integrity.
• Designing Data conversion Interface with the use of SQL Loader, and Open Interface, and convert data.
• Design and development of data entry screens.
• Created from level objects i.e. Libraries and property classes.
• Implemented Security by creating different users/roles and assigning roles to users forms.
• Preparing and talking Clients about enhancements and modification of problems.
• Documented User requirements and Testing of developed modules.

Environment: ORACLE 9i, MS-SQL, SQL, PL/SQL, SQL Loader, UNIX Shell Scripting.