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.
• Extensive knowledge on database administration for Oracle 8i, 9i, 10g 11g with experience within very large scale database environment and mission critical large OLTP and OLAP systems.
• Excellent experience in installation, setup and configuration of Oracle 8i, 9i, 10g and 11g in HP-UX, Sun Solaris, IBM AIX, Windows and UNIX/Linux Environment.
• Expertise in upgrading the databases from Oracle 9i to Oracle 10g and Oracle 10g to Oracle 11g.
• 24 7 production database support with Support to developers end-users.
• Installed Oracle 11g ASM 10g RAC software with ASM OCFS2 File systems.
• Experienced in Installation of high availability RAC environment 2, 3 and 4 node clusters and upgraded standalone databases to 10g RAC environment.
• Expert in implementing ORACLE STREAMS and Golden Gate 11x unidirectional, bi-directional and downstream capture and managed Operational, Historical and reporting databases.
• Proficient in setting up Standby Database using shell scripts and RMAN utility tool, activating and Re-building Standby Databases both Physical and Logical supported by DATAGUARD.
• Managed very large database VLDB of maximum size 5TB with 18 servers including 6 Productions, 6 testing, 6 Development and 3 Standby databases.
• Experience in Identifying performance bottlenecks on high volume transaction systems, Analyzing SQL statements, reorganize database objects and design indexes to improve response of queries, Tuning heavy data loads, Monitoring and Performance tuning.
• Having knowledge on the ORACLE EXADATA for the extreme performance of the database.
• Created development, testing, staging, production, RAC and standby databases for OLTP, DSS and Data Warehousing using customized shell scripts and stepwise.
• Having hands on experience in Hot/Cold Backup, Recovery and Cloning of databases using RMAN with VERITAS Net Backup.
• Experienced in using Oracle's Transportable Tablespace TTS feature allows users to quickly move a user Tablespace across Oracle databases.
• Database replication using snapshots, materialized views and advanced replication methods.
• Experience in applying security patches to the databases.
• Effective troubleshooting of database and Performance problems.
• Good experience in Data Migration using export/import.
• Management of Objects, Schemas, Partitioning the tables and Indexes. Knowledge on Oracle Support Process for Technical requests using Metalink and other support procedures.
• Excellent interpersonal and strong analytical skills, Documentation Problem-solving skills with customer service oriented attitude. A very good team player, self-motivated, dedicated in any work environment.

Technical Skills:

• RDBMS: Oracle 12c,11g/10g/9i/8i/7X, Oracle 10g RAC, Data Guard Streams, and GoldenGate
• Operating Systems: HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10, AIX 5.1, 5.2, 5.3, Red Hat Linux RHEL 2.1, 3.x, 4.x, 5.x and Windows NT/2000/2003/XP,SPARC systems.
• Languages: SQL, PL/SQL, T-SQL, C, UNIX Shell Scripting, Ksh, bash and Perl Scripting.
• Software's, Applications Tools: DBCA, DBUA, Oracle Data Guard, OEM GC , RMAN, ASM, Clusterware, VCS, Shareplex, SQL PLUS, SQL LOADER, EXP, IMP, Data Pump expdp, impdp , TOAD, Rational Rose, VERITAS Net Backup, DBArtisan, SAN, SQL TRACE, EXPLAIN PLAN, TKPROF, STATSPACK, AWR, and ADDM.

Professional Experience:

Confidential

Oracle DBA

Responsibilities:

• Installation, configuration, maintenance and tuning of Oracle 11g and 10g on Red hat 5.0.
• Successfully upgraded Oracle 10g 10.2.0.4 to Oracle 11g 11.2.0.3 on IBM-AIX nodes
• Worked as a part of team in Data Center Migration project for 6 months
• Daily database administration tasks including backup and recovery through RMAN, Import/Export
• Performed data transfer using Export/Import using command line as well as in interactive mode and through Data pump.
• Involved in Installation and configuration of Oracle 10g 11g R2 RAC using Cluster ware and ASM
• 24x7 remote support and on call Database support for Database developers end-users.
• Experienced in implementing Oracle Database advanced security practices.
• Implemented Streams replication between RAC and non RAC database environments
• Successfully configured and installed Oracle Golden Gate for replication.
• Maintained the Heart beat tables to check the lag between the sites.
• Importing the Sybase data into Oracle
• Extracting from the existing Sybase database
• Did Sybase to Oracle migration support that includes a complete migration with your new Oracle database which is ready-to-use
• Worked with application team to resolve conflict handlers and troubleshooted the replication issues
• Reworking Sybase SQL to Oracle SQL compliance
• Oracle database tuning
• Migration of procedural language code into PL/SQL
• Experience in cloning RAC databases using RMAN tool
• Experienced in Design, implementation and generating documentation of Oracle 10g Data Guard on both physical/logical standby databases in high availability mode.
• Implemented Data guard, creating both Logical and Physical Standby databases in 10g 11g R2 RAC environment for the Production databases.
• Installed Oracle Streams as an enhancement for the Client's DW method and monitored Streams Issues using Grid Control.
• 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.
• Planning Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups with Export/Import Data pump utilities

Environment: Red Hat Linux 5.0,SPARC systems, Oracle 10g and 11g, TOAD 9.0, Oracle Enterprise Manager GC , RMAN, RAC, Data Guard, SYBASE, ASM, , TKPROF, Explain plan, AWR, ADDM, SQL Plus, PL/SQL, SQL Loader.

Confidential

Oracle DBA

Responsibilities:

• Responsible for administration and supporting Oracle 9i and 10g databases.
• Involved in designing of disaster recovery plan using Data Guard, and High Availability using RAC.
• Schemas refresh using Export/Import Pump, Creating the database tablespaces, tables, indexes, setting privileges and user logins.
• Configuration, Administration and tuning of Oracle 10g and 9i RAC.
• Performance tuning involving Memory, Disk I/O tuning and SQL tuning.
• Data Refresh in Test and Integration Databases using Transportable Table spaces.
• Performed Setup Recovery Manager RMAN and Flash Recovery in RAC Environment.
• Implemented backup strategies using hot/cold, exp/imp used on the business req.
• Cloning databases using scripts as well as RMAN and performed Tablespace point in time recovery TSPITR using RMAN.
• configuration of Oracle 10g 11gRAC using Cluster ware and ASM
• Installed Oracle 10g Enterprise Manager Grid Control for diagnosing and monitoring performance related problems and configured with Application servers on test databases.
• Performed conversion single instance to Real Application Cluster RAC database instances.
• Utilized Oracle Streams to capture, propagate, and apply the transfer of data, transactions, and events within managed databases.
• Downsizing and defragmenting the Very Large Databases by export / import, cloning those using RMAN duplicate features and then upgrading them to Oracle 10g and Production to development refresh.
• Storage Management Managing Space, Tablespaces, Segments and Extents, Rollback Segments Data Dictionary.
• Experienced on Database Security by monitoring User Management, Privileges, and Roles, Auditing, Profiling, Authentication and Risk management.
• UNIX Shell scripting in csh, ksh for automating startup/shutdown, backup and recovery, Import and export procedure of databases, getting system alerts.
• Implemented Streams replication between RAC and non RAC database environments
• Successfully configured and installed Oracle Golden Gate for replication.
• Experienced in documentation, provided documentation for database design, analysis, modifications, creating schemas etc.
• Resolved TAR issues 24x7 while assisting the functional team and oracle support Metalink

Environment: Red Hat Linux4, Oracle 9.2.0.8/10.2.0.3, SYBASE, Enterprise Manager GRID, RUP, RMAN, SAN/NAS, HSM, 10g RAC, Streams, CDC, Data Guard, SQL Plus, PL/SQL, ASM, ToadV9.7 SQL, Navigator V6.1.

Confidential

Oracle DBA

Responsibilities:

• Installed RAC on Oracle 10g release1 and worked on ASM feature of Oracle.
• 24x7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical I/O and Memory Usage.
• Performance Tuning i.e. Tuning RAC, tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms
• Oracle Grid Control Management Server Installation.
• Successfully configured and installed Oracle Golden Gate for replication.
• Used transportable tablespaces TTS to move the data Oracle on a different platform and also much faster than performing either an export/import or unload/load of the same data.
• Implementation of 10g Data Guard and Bi-directional streams implementation.
• Made performance improvements to the database by building Partitioned tables, Index Organized Tables, Materialized Views and Bitmap Indexes.
• Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups.
• Performed application migrations to non-cluster databases to cluster databases.
• Devised Implemented backup strategies using hot, cold, and exports based on the business requirements.
• Implemented VERITAS Net Backup-using RMAN Recovery Manager as a media management layer.
• Applying security patches both Server side and Client side and Performed testing.
• Cloned schemas, objects and data on new server using exports from 9i database and imported in 10g using Oracle data pump.
• Performed conversion Non RAC single instance to Real Application Cluster RAC database instances.
• Trouble shooting of various database performances by proper diagnosis at all levels like SQL, PL/SQL, database design, database tables, indexes, Instance, memory, operating system and java calls.
• Worked with production DBA team in perfect coordination with seniors and team members.

Environment: Oracle database 10g 10.1.0.5 to 10.2.0.4 , 9i 9.2.0.8 , Redhat4,Solaris, HP-UNIX 10.0, RAC, TOAD, TTS, Erwin 7.2, J2EE, ASM, Oracle Enterprise Manager, Network setup and Management, ASM, RMAN, SQL Plus, PL/SQL, SQL Loader.

Confidential

Oracle DBA

Responsibilities:

• 24x7 Database administrations, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Migration of Oracle databases from windows to Linux.
• Applied patches to Oracle Databases and Oracle Applications.
• Upgrading development and production databases to Oracle 10g.
• Proactive database monitoring using 10g grid monitoring tool.
• Database tuning using SQL-Trace, STATSPACK, EXPLAIN PLAN and TKPROF.
• Extensive Performance Tuning, Memory SGA Tuning, net backup, EMC Time finder and SRDF , RAID, RAW Devices.
• Performed database cloning to setup test and development databases.
• Responsible for optimizing the queries and application tuning.
• Performed SQL tuning and assist developers with coding PL/SQL.
• Provided support to Application Database Administrators in designing the database.
• Used RMAN for backup and recovery. Performed Hot, Cold and Logical backups. And performed backup validations using RMAN.
• Management of schemas, objects partitioning the tables indexes.
• Automation of data load using Korn shell scripting and SQL Loader.
• Responsible for setting and managing user accounts, and granting required privileges to users.
• Performed other DBA activities like including space management and performance monitoring.
• Experienced in Oracle Database monitoring, troubleshooting and resolve the issues.

Environment: Oracle 10g/9i, SQL Server 2000, Sun Solaris 8.0, SUN SPARC, HP UNIX, Windows 98/NT/2000, Oracle Enterprise Manager, SQL Loader, T-SQL, STATSPACK, TKPROF, EXPLAIN PLAN.

Confidential

Oracle Developer/ DBA

Responsibilities:

• 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 Korn 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.
• Translated business requirements into creation and alteration of database objects: tables, indexes, constraints, triggers and stored procedures.
• Designed database tables as per technical specifications.
• Involvement in all phases of the project life cycle.
• Analyzed the table structures using Analyze command.
• Implemented automated backup strategy using the UNIX shell script CRON UTILITY.

Environment: Oracle 8.1.7/9i, HP-UX, Windows NT/2000, PL/SQL, SQL Server 2000, T-SQL, Database Tools/Utilities, OPS, Shell Scripting.