SUMMARY:

• Over 8 years of experience in all stages of systems development life cycle including business requirements gathering, design, data conversions, programming, system / integration / user acceptance testing, documentation, production support in Oracle Database Management Systems.
• Experience in Installation and Configuration of Oracle Databases on UNIX, OEL, Red Hat Linux 5/6, and Windows advanced servers.
• Experience in Installation and Maintenance of RAC on 10g and 11g R2 on Red Hat and Oracle Enterprise Linux with ASM and non - ASM.
• Experience in Install OEM Grid Control 12c & Oracle Management Server (OMS), install the agents and add database targets
• Migrated both RAC and NON-RAC databases
• Experience in Implementation and Troubleshooting in RAC Databases.
• Have good knowledge on Oracle Golden Gate architecture and topologies.
• Configured oracle-to-oracle unidirectional replication
• Configured the schema level replication with and without pump process
• Configured the column level replication setup using defgen parameter file
• Setup Data Guard on 10g R2 and 11g R2
• Configure, trouble shoot, switchover and failover Data Guard on 10g and 11gR2
• Planning and scheduling Backups, Database Recovery, taking Logical Backups (with Export/Import utilities).
• Used RMAN Restore, Data Guard Methodologies for Migration
• Extensive uses of UNIX shell scripting.
• Daily health check of databases using STATSPACK, AWR Reports
• Tune the new databases for Maximum performance
• Experience with handling of medium to large Oracle OLTP (Online transaction processing).
• Administered databases on Linux(RHEL), Cent os and Solaries.
• Experience in working with Cost-Based Optimizer and SQL Tuning Advisor.
• Resource monitoring (servers, storage) using Grid Control.
• Experience in Partitioning and creating Global, Local Indexes on Partitioned Tables
• Experience in upgrading the databases from Oracle 9i to 10g and Oracle 10g to 11g using DBUA and Manual Upgrade methods.
• Experience in applying Patches to the database and Patch Set upgradation
• Worked as a part of team in 24x7 production environment and provided on-call and day-to-day support.
• Experience in Design, Creating and maintaining the Oracle Database.
• 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
• Applied patches as required for Oracle Databases
• Worked extensively in Hot/Cold Backup and Recovery and Cloning of databases using RMAN.
• Performance Tuning of SQL statements and Database using tools like Explain plan, TKPROF, SQL, Oracle Spatial Analyst, Analyze, STATSPACK, AWR etc.
• Monitoring and optimizing the performance of the database through Database Tuning - Tuning Applications, Tuning Instance, and Tuning Disk Usage.
• Experience in doing Backups and Recovery using RMAN and Scripts.

PROFESSIONAL EXPERIENCE:

Confidential, New Jersey

Database Administrator

Responsibilities:

• As an operational DBA, supported the database requirements of several applications with ensuring databases are up all the time and recoverable at point of failure.
• Installed, configured and maintained Oracle 11gR2 RAC on UNIX, SOLARIS and LINUX.
• Configured oracle-oracle bidirectional replication for a new schema with CDR.
• Configured Initial extract process and replicat to perform 'Initial Load'
• Performed Instantiations using exp/imp and expdp/impdp at table level
• Analyzed trail files using logdump utility
• Extensive uses of UNIX shell scripting.
• Upgraded databases from 11.2.0.2 to 11.2.0.4.
• Worked on rotation of production on call support, responding and resolving issues in timely manner.
• Worked on troubleshooting the on-call issues such as Space, Job Failures, login locked out, blocking and slow running queries.
• Configured Physical standby database for the production environment using Oracle Data guard using ASM storage.
• Involved in the manual switchover testing of the physical standby once in a quarter to test the application functionality on standby data centre.
• Performed Data guard testing by opening the standby in RW mode and switching back once the testing is completed
• Perform Daily Monitoring of Oracle Instances, monitor users, and table spaces, Memory Structures, Rollback Segments, Logs and Alerts.
• Upgrading the Oracle 10g to the latest Release 2 and applied patches as required.
• Daily Health Check Up of the Database using AWR, ADDM.
• Configured Flash Recovery Area in Dev databases.
• Creating Materialized Views.
• Database backup & Recovery with export and import for non-archive and archive database with RMAN commands.
• Used to Perform manual Backups using EXPDP and IMPDP
• Efficient in using the Oracle Tools like OEM, SQL* Plus, SQL* Loader, TKPROF, IMPORT/EXPORT, and RMAN.
• 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.
• 24x7 on-call support for critical database issues to help meet the deadlines.

Technologies: Oracle 10g/11g, RMAN, Data Guard, Shell Scripting, UNIX, ASM, SQL, SQL*Loader, Logdump.

Confidential, Atlanta, GA

Database Administrator

Responsibilities:

• Implemented the automated Hot Backup scripts for the Daily full backup created in korn Shell.
• Monitored the production Oracle alert logs for database errors and system resource availability and responded to system memory and data issues.
• Upgraded large production standalone databases from Oracle 9i to Oracle 10g.
• Tuned performance of RAC and non RAC databases. Found bottlenecking queries that impede application performance and fine-tuned them.
• Proactively monitoring the database's health and taking preventive or corrective action as required.
• Provide technical assistance and guidance to the team in implementing High Availability solutions for the group using features like Real Application Clusters, Flashback, and 10g Data Guard with Automatic Failover.
• Installed & Configured Oracle Golden Gate v11.2 in a Standalone Environment
• Tuned performance of RAC and non RAC databases. Found bottlenecking queries that impede application performance and fine-tuned them.
• Periodically clone multi-terabyte databases to QA and UAT.
• Troubleshooting application SQLs and database performance tuning, table partitioning, table space re-org.
• Design and developed alerting mechanism for several databases using Shell scripting Grid control.
• Database performance monitoring and troubleshooting using OEM, ADDM & AWR reports
• Resolved several production issues in mission critical databases and restore service.
• Scheduled and executed several planned maintenance operations like Patching, upgrading, redesigning, de normalizing, and partitioning.
• Restored databases using RMAN to fix corruption and storage issues.
• Configured the Oracle Golden Gate on Oracle Enterprise Linux 6 for data replication.
• Schedule on-call rotation shifts, allocate tasks to DBAs and monitor progress. Report progress of Projects and support activities to client management
• Opening issue tickets and tracking them for resolution
• Collaborate with data architects for data model management and version control.
• Conduct data model reviews with project team members.

Technologies: Oracle 10g and 9i, Linux Red Hat, RHEL 4.2, OEM, RMAN, Export/Import, SQL, SQL*Loader, TOAD, STATSPACK

Confidential

Database Administrator

Responsibilities:

• Managed Backups for Oracle RAC databases.
• Supported different Oracle 10g and Oracle 9i Databases of Production, Testing, Staging and
• Database Creation, Parameter Assignment in init file or session level assignment; database startup and shutdown process.
• Implemented the Data Guard i.e., setting the logical and physical standby database and setting the migration from primary to standby databases.
• Database User Creation with limited rights as per specific module under specific client. Creating roles and profiles as per system study and assign to users.
• Performed daily maintenance tasks like space management, rectified locking problems, managed quotas etc., configured network components like TNSNAMES etc. for easy and effective management of Oracle networking.
• Configured listener for external procedure calls.
• Responsible for Troubleshooting the RAC databases.
• Administering RAC databases using SRVCTL.
• Database backup & Recovery with RMAN and Export/ Import.
• Upgrade the databases from Oracle 9i to Oracle 10g using DBUA and Manual Upgrade methods.
• Creation of database objects like Tables, Indexes, Views, Users, etc.
• Oracle SQL*LOADER, Oracle Export/Import Tools and utilities.
• Responsible for Data load on different databases using SQL*Loader
• Managing table spaces, user profiles, indexes, storage parameter’s.
• Responsible to provide 24 x 7 database administrative activities over different database servers, representing various RDBMS as Oracle 9i RAC.

Technologies: Oracle 10.2.0 RAC on RHEL, Solaris 10, Oracle Enterprise Manager, RMAN backups, Data Guard, SQLPLUS.

Confidential

Database Administrator

Responsibilities:

• Supported different Databases like Production, Testing, Staging and
• Database backup & Recovery with RMAN, Export/Import methods.
• Responsible for setup and troubleshooting in RDBMS databases.
• Helped business users in resolving many issues in all the manufacturing modules.
• Perform Daily Monitoring of Oracle Instances, monitor users, and table spaces, Memory Structures, Rollback Segments, Logs and Alerts.
• Alert monitoring and Ticketing.
• Managed Oracle Database Users (like creating and dropping users, granting and revoking privileges, creation & assigning roles, session and quota as per the request.
• DB Link Creations and trouble shooting.
• Performed database cloning using RMAN.
• Efficient in using the Oracle tools like SQL Plus, SQL* Loader and Import/Export, Stats pack.
• Month end job monitoring and checklist preparation and co-ordination.
• Enact an aggressive backup strategy for all production databases.
• Creating Logical and Physical database structure, Creating and altering Table spaces, Managing Users and Resources, Granting and Revoking privileges through Roles.
• Responsible to provide 24 x 7 database administrative activities over different database servers, representing various RDBMS as Oracle 10g and Oracle 9i on operating system RHEL.

Technologies: Oracle 10g, Oracle 9i, RHEL, Oracle Enterprise Manager, RDBMS,RAC, RMAN, PL/SQL.