Experience Summary:

• Over 7+ years of experience as Oracle database administration in UNIX, Linux & Windows environment
• Experience in basic and advanced replication using GoldenGate and experience in using OEM, TOAD, ERwin, Data Migrations using export/import and SQLLDR tools.
• Performed data replication, transformation and delivery of database transactions using Goldengatereplication tool. Supported a large number of Development Databases
• Proficiency with Installation and maintenance of replication tool GoldenGate by creating extract process, extract pump, and replicate
• Implemented DataGuard in the production environment
• Experienced in Oracle installations, upgrades, migration, configuring logical/physical architecture, SQL, Tuning, database access and Security and auditing
• Experienced in using 11g features Data Pump, AWR, ASM, ADDM, Grid monitoring
• Performed backups and crash recoveries using conventional hot/cold backups and RMAN
• Experience in SQL, PL/SQL, Database procedures, Triggers, Packages
• Performing tuning of application with tkprof, explain plan, Autotrace , Statspackand Oracle Enterprise Manager.
• Experience with designing and data modeling using ERWIN data modeler, converting the logical model to physical model.
• Developed database monitoring/health check alert scripts for database uptime/downtime status, and sizing issues using grid control (OEM).
• Monitoring and optimizing the performance of the database through Database Tuning - Tuning Applications, Tuning Instance, and Tuning Disk Usage.
• Experience in Production support DBA
• Experienced with tools/utilities: OEM, SQL* Loader and export/import
• Installed and Administered Oracle 11g ASM & 10g RAC software with ASM & OCFS2 File systems.
• Implemented data replication through materialized views
• Proficient with technology domains like User Management, Resource Accounting, Security and Network Management for various platformslike Microsoft Windows, Solaris, HP and Red Hat Linux
• Data Modeling activities include designing the database to support various applications of the client by developing logical and physical models using Designer/ERwin based on the requirements specified by the client

Technical Skills:

Operating System : RHEL, SunOS, IBM-AIX , HP-UX, Windows 2000/NT/XP/Vista/7
Database : Oracle 11g, 10g, 9i, 8i, Ms-Access, SQL-Server 2006, Oracle ApplicationServer 10g
Languages : C, C++, SQL, PL/SQL, Java, J2EE, PHP, XML, TML/XHTML
Tools/Utilities :RMAN,OEM,SQL*Loader,DataPump,Export/Import,SQL*PLUS,
Crontab, Toad 10.1, AWR,ADDM,Flashback,TKPROF, EXPLAIN
PLAN, STATSPACK, AWR, DataGuard, Goldengate

Work Experience:

Company: Confidential, Maryland MD
Title: Sr. Oracle DBA
Period: Aug 2011 to Till Date

Responsibilities:

• Performing all the Database Administration activity like space management in database, user and roles administration, schema management of all databases. Experienced in automating routine server tasks and alerts using various scripting technologies Unix Shell scripting, batch files, configure alerts through OEM
• Implementing 11g Data guard with one physical database. Used OEM Grid Control Diagnostic and tuning packs to tune application and SQL queries. Installation, Configuration & Administration of Oracle 10gR2 RAC.
• Configured the Public Network/Private Interconnect for Oracle 10g/11gR1 RAC. Troubleshoot the OS level Kernel parameter errors such as Ora-600 error using Ora-600 argument Lookup tool and Ora-7445 error.
• Optimization and tuning SQL queries using TRACE FILE, TKPROF, EXPLAIN PLAN. Extensive usage of ADDM, AWR, ASSM, features of 10g/11gR2. Installed and configured Oracle GoldenGate on Oracle 10g.
• Implemented GoldenGate for data recovery and data migration for Oracle 11gR1 RAC 2 nodes on IBM AIX and debugging GoldenGate issues such as extract or replicate rebuild and abend.
• Database structure changes, table/indexsizing, SGA sizing, SQL, I/O and Application tuning, transaction monitoring, detecting lock contentions, tuning sort operations.
• Timely Reorganization of tables and rebuilt of indexes to improve the performance of the SQL queries as part of scheduled maintenance window. Developing online RMAN backup scripts to automate backup procedures.
• Database Export/Import and evaluating the Backup and Recovery Procedures periodically & performing backups using RMAN. Restoration and recovery from backup as timely manner to support application development team for testing. Cloning of application from production environment to test environment using 11g new feature active database cloning and application of patches.
• Monitoring the table growth, database growth, current users, and system resource usage.
• Creating and maintaining table spaces, tables, indexes, users, roles, privileges and security. Generated scripts for daily maintenance activity like analyzing the tables/indexes, and monitoring their growth. Sizing SGA, sizing db buffers, shared SQL area, log buffer based on requirements. Involved in team management, team building exercises for DBA team. Periodic Database Refresh/CLONING from production to Development & QA environments, maintaining Database Standards, Reviews, Documentation, Quality Assurance.

Environment

Oracle 11gR1 RAC 2 node, IBM AIX, UNIX Shell Scripting, OEM, GoldenGate, TOAD, DATGUARD, SQL*Loader, PL/SQL, SQL, SQL*Plus, Erwin, VLDB

Company:Confidential, Boston, MA
Title: Sr. Oracle DBA
Period: March 2010- July 2011

Responsibilities:

• Managed several production, test and development instances.
• Installed, configured and managed Oracle 10g RAC/ 11g RAC, Standby databases.
• Administering ORACLE Databases 11g, 10g, and 9i.
• Applications Patch management: Patch application and impact analysis, and trouble shooting.
• Involved in implementing Dashboard-based Monitoring solution by developing shell scripts and SQL scripts and also worked on Perl scripts.
• Performance Tuning Databases using SQL Trace, TKPROF, Explain Plan, STATSPACK, AWR, ADDM.
• Migrating Oracle databases from Windows to Linux.
• Monitoring growth of tables and undertaking necessary re-organization of database objects when required and generating trace files for problem resolution.
• Responsible for backup/recovery using and performing backups and recoveries.
• Responsible for setting-up and managing Standby databases.
• User Maintenance (Creation, modification and deletions)and Custom code migrations.
• Proactive database monitoring using Oracle 10g grid control.
• Worked on user documentation like Instance strategy, Instance management, Problem manager, Setup document and Change management docs.
• Problem resolution repository created to reduce issue resolution timings.
• GoldenGate installation, configuration for replication.
• Creating primary database storage structures (tablespaces), altering, and modifying the database structure according to the company's requirement as necessary, from information given by the application developers.
• Creating and managing users, roles and profiles, auditing and monitoring user access.
• Planning and implementing Backup strategy for the databases, Scripting backups.
• Planning and implementing Backup and Recovery procedures (Hot, Cold Backups and RMAN), scheduling daily backups and performed periodic recovery tests.
• Involved in a project, which analyzes and applies quarterly Security patches (CPU & PSU).
• Maintenance and troubleshooting of oracle network files like listener.ora, tnsnames.ora.
• Allocated system storage and planned for future storage requirement for the database.
• Created primary database storage structure for developers to develop and test the Application.
• Data loading using Oracle SQL Loader, developing SQL Loader scripts to load global data, and fine tuned SQL Loader performance using Direct-load mechanism.
• Estimating the space requirements for database growth for next 12 months and availability of hardware to support the processes.
• Developing, Implementing and administering database policies and procedures.

Environment

HP UX, AIX 5L, Linux RHEL 4, Oracle 11g RAC, 10gRAC, Oracle 9i, PL/SQL, SQL Scripts, Shell Programming, TOAD, Data Guard, RMAN, ASM, GoldenGate, Putty

Company:Confidential, Medicare, MA
Title:Oracle DBA
Period: Jan 2009 - Feb 2010

Responsibilities:

• Provided Database Administration and support (24*7) for 3TB production oracle 10g OLTP Databases
• Responsible for all database activities such as space management, User management, database security management, rollback segments & creation of DB links.
• Responsible for installation and creation of databases (10g) (RAC) for Development and user acceptance test.
• Responsible for Installation of 10g (10.2.0.1) cluster ready services and 10.2.0.1 database in OCFS and ASM file systems.
• Responsible for Upgrading the Database from 10.2.0.1 to 10.2.0.4 and Upgrading) CRS from 10.2.01 to 10.2.0.4.
• Configured ASM file system and administering ASM Instances and Disk Groups in RAC.
• Involved in administering and maintaining Oracle Application Server 10gR2 (10.1.2).
• Responsible for implementing Load Balancing in RAC Database.
• Implemented Fast Connection Failover and Transparent Application Failover for ensuring Database High Availability.
• Responsible for using Flashback query mechanism along with automatic undo management.
• Refresh/Cloning of Database from production environment to test environment and application of patches.
• An active member of the backup and recovery team and was responsible for configuration and implementation of backup and recovery usingRMAN and Data Guard.
• Tested many backup and crash recovery scenarios on test environment, using RMAN tool.
• Responsible for automation of startup and shutdown on all production and development databases.
• Increased availability of development instances by reducing cloning time by implanting clone automation using Grid.
• Involved in export and import of database objects in order to copy them from one database to another & copying the export dump file to tape.
• Wrote scripts (Linux Shell) for database maintenance activities such as monitoring the growth rate of table space and extents. Also wrote UNIX scripts to process batch jobs.
• Project Documentation, creation and adhering to standards of Implementation and Project management.

Environment

Oracle 9.2.0.8, 10.2.0.4 & 11.1.0.6, RHEL 4.2, IBM AIX 5.2, Windows XP, SQL*Plus, SQL*Loader, OEM, PL/SQL Developer, Import/Export, TOAD

Company: Confidential, Hyderabad, India
Title: Oracle DBA
Period: Aug 2007 - Dec 2008

Responsibilities:

• Configured and installed Oracle 9i on UNIX environment.
• Upgraded database from Oracle 7.3 to 8i, 8i to 9i
• Actively participated in team meetings with Business team for changes in design of the database.
• Worked on database setup and monitored the database growth on daily basis.
• Involved in the logical and physical design of the database tables.
• Sizing database objects for effective space management and optimal performance.
• Actively participated in Database and application developers troubleshooting.
• Developed scripts for hot, cold and logical backup.
• Performed Backup and Recovery using RMAN and user managed techniques.
• Modified and established backup and recovery strategies and procedures.
• Administrated User accounts by creating users, roles and privilege and managing those using grants and profiles.
• Created tables, views and other schema objects with appropriate table space sizes.
• Database maintenance, upgrades, and patches release.
• Worked on database performance monitoring using OEM.
• Carried out Physical and Logical database design and database reorganization.
• Written SQL, PL/SQL functions, procedures, packages and triggers.
• Written shell scripts for backup and cloning automation, custom monitoring
• Created database links for accessing data from remote databases.
• Used EXPORT/IMPORT utility for performing logical backup for table level and full databases.
• Used the Crontab in UNIX and Scheduler in Windows for Automatic Tasks (Analyzing tables, loading into Tables, Imp/Exp).

Environment

Oracle 9i, 8i, 7.3, SQL*Loader, SQL*Plus, OEM, ASM, PL/SQL, RMAN, LINUX, Sun Solaris,SQL Server 2005,My SQL,Erwin, Windows 2000

Company:Confidential, Hyderabad, India
Title: Oracle DBA
Period: Aug 2005 - July 2007

Responsibilities:

• The work involves overall Maintenance of ORACLE Database, Performance Tuning, Backup, Recovery and other database related activities.
• Created database users, roles; manage database user security, passwords for all Development engineers/users.
• Performed daily maintenance tasks like space management, managed quotas etc.
• Used Oracle export and import to transfer bridge specification data from production to development systems
• Worked with PL/SQL developers to write limited database code, Packages, Procedure, functions and DB triggers to query bridge data.
• Managed Oracle space, performed Oracle table space management tasks, maintained tables, database objects.
• Monitoring of database objects like rollback segments, temp segments and table spaces
• Involved in the installation of Oracle 9i on Solaris and UNIX platform.
• Responsible for regular Physical as well as Logical Backups and maintaining the databases using RMAN.
• Configuring network components like TNSNAMES, SQLNET etc. For easy and effective management of Oracle networking. Configured listener for external procedure calls.
• Assured Load balancing, monitored disk I/O statistics, Data file I/O statistics, read/write ratios and fixed problems.
• Identifying the poorly performing queries using TKPROF, STATSPACK reports and assisting the developers in optimizing and tuning the SQL and PL/SQL code using SQL trace.
• Tuning SGA, Rollback segments, Latch contention issues, Optimize sort operations.
• Used SQL Loader to load data from bridge survey sheet text files to Oracle tables

Environment

Oracle Server 9i, SQL, PL/SQL, SunOS 5.7, Shell scripting, EXPORT/IMPORT, TKPROF, EXPLAIN PLAN

Education Qualifications:

Bachelor of Technology