SUMMARY

• Around 8 years of experience in Oracle 11g/10g/9i DBA and have been involved in Installation, Configuration, Up gradation, Patching, Backup and Recovery, Migration, Memory and Space Management, Cloning, Replication, Reporting, Performance Tuning, RMAN, RAC, Data Guard, OEM Grid Control.
• Experience in Installation, Configuration and Troubleshooting of Oracle Database on Solaris OS, IBM - AIX, Red Hat Enterprise Linux (RHEL) and Windows on highly transactive and Very large databases (VLDB).
• Expert level experience in Oracle 11g RAC implementation & administration using Oracle Cluster-ware, Sun Cluster and VERITAS Cluster Server (Oracle Cluster ware setup and configuration, RAC installation, Configuration and Patching, RAC Backup and Recovery)
• Configured Automatic Storage Management (ASM) to fulfil storage needs.
• Experience in Implementing, configuring, trouble shooting, switchover, failover of Physical Standby Data Guard on 10g and 11g.
• Configured and maintained replication using Oracle Gloden Gate.
• Experience in Backup & Recovery techniques of databases running in ARCHIVELOG MODE using RMAN.
• Experience in Cumulative and Differential Incremental backups using RMAN.
• Having good knowledge on EXADATA and Involved in moving databases in EXADATA RAC environment.
• Used ADDM (Automatic Database Diagnostic Monitor), AWR (Automatic Workload Repository), ASH (Active Session History) for analyzing teh database performance and tuning
• Experience in up gradation of Data bases in 10g and 11g.
• Experience in Data Migration using Data pump utility.
• Database Refresh from Production to Development and from Development to Test environments.
• Replication of tables to cross platform and Creating Materialized Views.
• Experience in maintain of production and Non - production batch servers using Autosys scheduler.
• Managing Table/Index segments, Rollback Segments, Undo Segments, and Constraints.
• Planning and scheduling Physical Backups (offline/online) and Logical Backups.
• Experience in implementing Flash Back Pointing Time Recovery.
• Experience in maintaining ETL tools for Reporting Solutions.
• Experience in User Management by Granting, Revoking Privileges according to requirement.
• Experience in Space Management by Monitoring and Managing Tablespaces.
• Keeping teh database up to date by applying teh latest CPU and PSU using teh OPATCH utility.
• Configured network components like TNSNAMES, Names Server, Connection Manager, etc. For easy and TEMPeffective management of Oracle networking. Configured Listener for external procedure calls.
• Performance Tuning of SQL statements and Database using tools like Explain plan, TKPROF, SQL Analyze, STATSPACK and Dynamic Performance Views.
• Diagnosed and trouble-shooted typical SQL Tuning issues using SQLTXPLAIN.SQL
• Experience in Partitioning and creating Global, Local Indexes on Partitioned Tables.
• Experience in Administering Oracle Database using Oracle Enterprise Manager, Toad, and PL/SQL Developer.
• Monitoring Alert log for any errors and issues.
• Communicated and interfaced wif Oracle support via Metal-link to troubleshoot day-to-day database issues.
• Experience in UNIX shell programming.
• Hands on experience working on High Availability Environments.
• 24 X 7 Production Database on Call Support.
• Strong analytical and problem solving skills. Willingness and ability to quickly adapt to new environments and learn new technologies.

TECHNICAL SKILLS

Operating Systems: Red Hat Linux RHEL 2.1, 3.x, 4.x, 5.x, Windows 95/98/NT/2000/XPSun Solaris 2.5, 2.6, 8, 9, 10, AIX 5.x, 6.1 and HP UNIX.

RDBMS: Oracle 11g R1/R2, 10g R1/R2, 9i.

Languages: UNIX Shell Scripting SQL, PL/SQL, C, HTML.

Tools: /Utilities: RMAN, OEM, Oracle Management Server, SQL*Loader, SQL Server, Export/Import, TOAD, Data pump, Autosys, VB, MS Access, Oracle Streams, Pentaho kettle, VMWARE, VSS, VERITAS Net Backup, EMC Powerpath, Quest, Putty, VERITAS cluster manager.

Tuning Tools: AWR, ADDM, TKPROF, EXPLAIN PLAN, STATSPACK, AND ASH.

Database Modelling: Erwin 4.0, 7.3; Oracle Designer.

PROFESSIONAL EXPERIENCE

Confidential, Omaha, NE

Sr. Oracle DBA

Responsibilities:

• Installed, configured, and maintained Oracle 10g and 11g R2 on RHEL and also Upgraded from Oracle 10g to 11g
• Performed day to day administrative tasks by analyzing teh database like checking for failed processors, verifying teh query for particular issues and validating disk space.
• Migrated 30 TB Databases from HP UNIX to RHEL wif minimal down time.
• Responsible for setup, implementation and maintenance of 2 Node RAC on RHEL 11g R2.
• Used to perform backup and recovery using Oracle Recovery Manager (RMAN).
• Involved in migration of applications of teh clients.
• Performed daily maintenance tasks like space management, rectified locking problems, managed quotas etc., configured network components like TNSNAMES, Names Server, Connection Manager, etc. for easy and TEMPeffective management of Oracle networking. Configured listener for external procedure calls.
• Perform Daily Monitoring of Oracle Instances, monitor users, and table spaces, Memory Structures, Rollback Segments, Logs and Alerts.
• Installed, Configured and maintained ETL Pentaho tool for Reporting Solutions.
• Involved in moving databases in Exadata RAC environment.
• Data loading using SQL*Loader into Oracle Database from different sources (OLTP).
• Used to Perform Cold/Hot Backups and also performed database cloning using RMAN.
• Maintained Non-production and production batch servers using Autosys Job Scheduler.
• Daily Health Check Up of teh Database using OEM Tuning Pack, AWR, ADDM.
• Worked wif SAN admins on EMC PowerPath to provide replication and disaster recovery solutions for mission critical databases.
• Replication of tables to cross platform and Creating Materialized Views.
• Database backup & Recovery wif export and import for non archive and archive database wif RMAN commands.
• Installed Autosys client maintained server application batch jobs in Non production and production servers.
• Develop and enforce both database and OS-level security policies for data protection. Administer all databases in teh areas of maintenance, tuning, performance, and troubleshooting.
• Efficient in using teh Oracle Tools like OEM, SQL* Plus, SQL* Loader, TKPROF, LOGMINER, STATSPACK, SQL*Net, IMPORT/EXPORT, and RMAN.
• Developed Scripts for transferring data from production server to testing/development servers.
• Diagnosed and trouble-shooted typical SQL Tuning issues using SQLTXPLAIN.SQL
• Shell scripting and PL/SQL programming to resolve business problems of various natures.
• Migration of database from one server to another server.
• Managing databases on multiple servers.
• Developed table structures, PL*SQL stored procedures and database triggers to implement business rules.

Environment: Oracle 9.2.0.8/10.2.0.4/11.2.0.3, RHEL 5.8, Hp- Unix 7, Solaris 10, ASM, RMAN, RAC, Oracle Enterprise Manager 12C, RDBMS, AUTOSYS, SQLPLUS, PL/SQL, Shell Scripting, Stored Procedures.

Confidential, Stamford, CT.

Sr. Oracle DBA

Responsibilities:

• Installed, configured, and maintained Oracle 10g and 11gR2 on Linux and also Upgraded from Oracle 10g to 11g
• Performed day to day administrative tasks by analyzing teh database like checking for failed processors, verifying teh query for particular issues and validating disk space.
• Responsible for setup and implementation of 3, 4 Node RAC on Linux in 10g and 11g R2
• Configured and maintained Oracle Cluster-ware.
• Configured and maintained replication using Oracle Gloden Gate.
• Used to Perform Cold/Hot Backups.
• Used to perform backup and recovery using VERITAS Net Backupintegrated intoRMAN.
• Implemented and Managed Oracle Data Guard on Oracle 11gR2
• Upgrading teh Oracle 10g to teh latest Release 2 and applied patches as required.
• Perform Daily Monitoring of Oracle Instances, monitor users, and table spaces, Memory Structures, Rollback Segments, Logs and Alerts.
• Daily Health Check Up of teh Database using OEM and Applications servers health using APPInternals Opnet
• Installed Opnet agents on all Production servers, and monitoring teh different application servers.
• Involved in migration of applications of teh clients.
• Created Users wif limited rights as per specific module under specific client. Granting roles and profiles as per system study to users.
• Replication of tables to cross platform and Creating Materialized Views.
• Performed daily maintenance tasks like space management, rectified locking problems, managed quotas etc., configured network components like TNSNAMES, Names Server, Connection Manager, etc. for easy and TEMPeffective management of Oracle networking. Configured listener for external procedure calls.
• Database backup & Recovery wif export and import for non archive and archive database wif RMAN commands.
• Also configured database cloning using RMAN.
• Implemented Data Guard on production database.
• Develop and enforce both database and OS-level security policies for data protection. Administer all databases in teh areas of maintenance, tuning, performance, and troubleshooting.
• Efficient in using teh Oracle Tools like OEM, SQL* Plus, SQL* Loader, TKPROF, LOGMINER, STATSPACK, SQL*Net, IMPORT/EXPORT, and RMAN.
• Developed Scripts for transferring data from production server to testing/development servers.
• Shell scripting and PL/SQL programming to resolve business problems of various natures.
• Developed and maintained teh applications by utilizing ASP.NET.
• Migration of database from one server to another server.
• Managing databases on multiple servers.
• Disk Space Monitoring.
• Developed table structures, PL*SQL stored procedures and database triggers to implement business rules.

Environment: Oracle 10.2.0.3/11.2.0.3, Linux, Solaris 10, ASM, RMAN, RAC, Oracle Enterprise Manager Grid Control, RDBMS, SQLPLUS, Autosys, PL/SQL, Opnet, Shell Scripting, Stored Procedures.

Confidential, Chesterfield, MO

Oracle DBA

Responsibilities:

• Installation, Configuration and Administration of Oracle 10g/9i databases on various Operating Systems.
• Configured RMAN and performed daily backups.
• Implemented Data Guard on Oracle 10g and 9i.
• Conducted daily routine checks on alert logs and trace files.
• Creating teh Database, table space, Control files, log files and user profiles
• Designed Logical and Physical Data Modelling using Erwin.
• Creation of database objects like Tables, Indexes, Views, Users, and DB Links etc.
• Scheduled Oracle Jobs in teh database.
• Analyze teh schema and tables.
• Used Database Configuration Assistant (DBCA), Database Upgrade Assistant (DBUA) for migrating Oracle 9i versions in RAC
• Data Refresh from Production to Test and Development environments using RMAN Duplicate Database.
• Securing teh data by using Oracle data vault.
• Extensively used SQL Loader to load data from flat files to teh Oracle Database.
• Created and enhanced DB utilities needed for automation of system and unit tests and investigation of production issues, troubleshooting.
• Responsible for network configuration and involved in a Client - Server environment using TNS, LISTENER, Net Configuration Assistant and other configuration files.
• Created and configured database manually using Oracle Database Configuration Assistant.
• Monitored and tuned long running jobs by working closely wif teh application development team and analyzing objects, created or rebuilt indexes, query tuning using SQL TRACE, TKPROF, Explain Plan, TOAD from Quest software (DB Tuning).

Environment: Oracle 10g/9i, Linux, Windows 2003, Oracle Enterprise Manager Grid Control, RDBMS, SQLPLUS, PL/SQL, Shell Scripting, RAC.

Confidential

Oracle DBA

Responsibilities:

• Installation, Configuration and Administration of Oracle 10g databases on Sun Solaris Operation System.
• Implemented Real Application Cluster (RAC) Setup & Administration using Sun Cluster.
• Supported different Databases like Production, Development, Testing, UAT and Training.
• Recovered critical databases from failures wif minimum downtime.
• Responsible for planning, testing and implementing different backup and recovery strategies.
• Designed Logical and Physical Modelling using C.A Erwin.
• Logical to Physical Transformation using Erwin
• Forward engineering using Erwin
• Reverse engineering using Erwin
• Model to model comparison using Erwin
• Conducted daily routine checks on alert logs and trace files.
• Creating teh Database, table space, Control files, log files and user profiles
• Performed Backup and Recovery wif export and import for non archive and archive database using RMAN, scheduled backup on Solaris& NT environments using teh incremental complete and full backup strategies based on teh database purposes.
• Automated back-up procedures using crontab.
• Performed activities such as Query Optimization, Database Consistency Monitoring. Configured and managed replication server.
• Expertise in Installation, Configuration, Application Support, Performance Tuning/ Optimization, User/Security Administration, Backup/Recovery, Data/Network Administration and Maintenance and configure database stand by database using Data Guard.
• Automated database backup using shell scripting.
• Involved in teh database design, installation, creation of various instances, and creation of tables, granting roles to users and maintain teh security according to application.
• Worked on performance and tuning on SQL queries wherever it is required.
• Install OCI header files on Client Machines.
• Migration of database from one server to another server.
• Creation of database objects like Tables, Indexes, Views, Users, and DB Links etc.
• Rename teh database and database SID.
• Create Directory in teh database.
• Moving data files from one location to other.
• Scheduling Oracle Jobs in teh database.
• Analyze teh schema and tables.
• Finding average row length for all teh tables in each schema.
• Performed daily maintenance tasks like space management, rectified locking problems, managed quotas etc., configured network components like TNSNAMES, Names Server, Connection Manager, etc. for easy and TEMPeffective management of Oracle networking. Configured listener for external procedure calls.
• Efficient in using teh Oracle Tools like SQL* Plus, SQL* Loader, TKPROF, LOGMINER, STATSPACK, SQL*Net, IMPORT/EXPORT, and RMAN.
• Managing table spaces, user profiles, indexes, storage parameter’s.
• Develop table structures, PL*SQL stored procedures and database triggers to implement.
• Responsible to provide 24 x 7 database administrative activities over different database servers

Environment: Oracle 10.2.0.3/11.1.0.6/.7, Linux, Solaris 10,Window 2003, Oracle Enterprise Manager Grid Control, RDBMS, SQLDBA, PL/SQL, Shell Scripting, Stored Procedures, ASM, ASO, VPC, Data guard, CICS business rules.

Confidential

Oracle DBA/Developer

Responsibilities:

• Created new Table Spaces, added Data Files and resolved Disk Contention Issues.
• Monitored, Allocated Share memory, Table space as needed and managed Replicated servers.
• Monitoring daily Hot Backups and weekly Cold Backups performed using RMAN.
• Monitoring inconsistency Issues long Transactions and Locking Issues.
• Monitoring Alert log file and Trace file.
• Performing analysis and diagnosis of Database Performance Statistics.
• Monitoring performance using Advisors, AWR, ADDM, SQL Tuning etc.
• Monitoring Online and Offline backups wif RMAN as well as User managed.
• Schema and Table level replication using export/import.
• Performed activities such as Query Optimization, Database Consistency Monitoring.
• Applying and monitoring Patches on Oracle 9i database.
• Responsible for granting required privileges and roles to users.
• Creation and maintenance of database objects.
• Managing table spaces, User Profiles, Indexes and Storage parameters.
• Scripting languages mainly HTML, XLML and JSP.
• Working as a Database developer, writing SQL Queries.
• Involved in developing and implementing PL/SQL functions, Stored Procedures and Triggers.

Environment: UNIX, Oracle 8i/9i, PL/SQL, SQL Loader, RMAN, Oracle Enterprise Manager (OEM), Shell Scripting, Java, HTML, Oracle forms and reports 6i/9i.