SUMMARY:

• 8+ Years of experience as Oracle DBA (11g/10g/9i/8i) on different HP - UX, Sun Solaris, Linux, AIX,and Windows 2000/NT environment.
• Experience in full life cycle of database administration. Worked both as a development and a 24x7
• Production Support DBA.
• Prevent & Pre-empt issues and reduced the problem tickets by proactively designing the systems andprocesses for monitoring the databases.
• Installation and Configuration of Oracle 10g Real Application Clusters (RAC) on 4 nodes with Automatic
• Storage Management (ASM).
• Expertise in Upgrade and Migration of oracle database to higher version and other platforms using Oracle
• Data Migration Assistant.
• Installation, configuration and administrating Oracle Golden Gate replication.
• Worked as a team member to provide 24x7 on-call production database support.
• Experience in HP-UX, AIX, SUN SOLARIS, RED HAT LINUX and WINDOWS environments.
• Excellent experience in installation and configuration of Oracle 8i, 9i, 10g and 11g in UNIX/LINUX and
• Windows environment.
• Have great Knowledge of Oracle architecture.
• Good experience in SQL, PL/SQL, Shell Scripting, P arallelism, Partitioning, Data modeling,
• OLAP, Logical and Physical data model using ERWIN, Backup and Recovery procedures.
• Involved in meetings with data modelers, developers, and dba s.
• Expertise in maintaining Database Security using security compliance auditing, expertise in loading data using external tables and SQL*LOADER.
• Management of schemas, objects & Partitioning of tables & indexes.
• SQL*Loader, Export, Import, datapump, PL/SQL, SQL*Plus, SQL*Net, BMC-SQL, Server Manager.
• Experience on Data Replication using Snapshot, Materialized views, import/export and Streams.
• Installation, Configuration of Oracle Data Guard for Physical and Logical mode.
• Migrating and upgrading the databases to higher versions.
• Involved in different scenarios of OLTP as well as DSS (Data warehouse) databases.
• Excellent knowledge in Hot/Cold Backup, Recovery and Cloning of databases using RMAN.
• Excellent experience in Database cloning (single instance)
• Extensively used Database Administrative tools like Oracle Enterprise manager (OEM) Grid control, DBA
• Studio, SQL*PLUS, TOAD, DBArtisan.
• Extensive performance tuning experience, specializing in Operating System Tuning, SQL Tuning,
• Database/Instance Tuning.
• Tuning the application, memory, and disk using Oracle and third party utilities and initialization parameters including explain plans, tkprof and Statspack.
• Good knowledge of SQ SERVER.

TECHNICAL SKILLS:

Operating System: Red Hat Linux, Solaris, HP-UX, AIX, Windows

Databases: Oracle 8i/9i/10g/11g/12c, RAC 10g/11g Ms Access, SQL Server

Languages: SQL, PLSQL, Java, C, UNIX shellscripting.

Web Servers: Apache, Web logic

Tools: and Utilities:(ORACLE) Import/Export, Data pump, SQL * Loader, SQL Trace, OEM, ExplainPlan, STATSPACK, AWR, ASH, ADDM, RMAN, FTP, TKPROF,Golden Gate, Streams

Other Tools: ERWIN, DB Visualizer, Microsoft Visio, Use cases, SQL Developer,OEM, VM ware, Filezilla, putty, TOAD, Query Builder, VNC, WINSCP, Golden gate.

PROFESSIONAL EXPERIENCE:

Confidential, RI

Sr. Oracle DBA

Responsibilities:

• Installation and Configurations of Oracle 11g, 10g.
• Migrated and Upgraded Oracle Database from 9i to 10g, 10g to 11g.
• Installation, configuration, maintenance and tuning of Oracle 11g and 10g databases.
• Golden Gate and Veridata installation and configuration
• Applied PSU, Opatch and Golden Gate Agent patches
• Planning Backup/Recovery Strategy, Planning and scheduling full and structural Backups, taking Logical Backups (with Export/Import Data pump utilities).
• Used different methods of database migration using scripts, RMAN as well as Export/Import Data pump utilities
• RMAN Incremental backups. Automated the nightly RMAN backups
• Creating & Managing Database Structures, Storage Allocations, Table/Index segments, Rollback segments, Constraints, Database Access, Roles and Privileges.
• Performed SQL and PL/SQL tuning, oracle contention and monitored database using automatic workload repository (AWR), automatic database diagnostic monitor (ADDM) and automatic session history.
• 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
• Worked closely with the Oracle developers for the better performance in Applications in writing the Packages, Triggers, Mat Views and Indexes on the tables.
• Enabled the audit on all the dev/test databases, analyzed and reported the audit records about the suspicious activity in the database.
• Monitoring the database storage and day-to-day activities.
• Table partitioning for better performance.
• Created Users with limited rights as per specific module under specific client. Granting roles and profiles.

Environment: Oracle 11g RAC, Oracle 10g RAC, RedHat Linux, IBM AIX, Sun Solaris, HP-UX, Windows, Shell Scripts, ASM, RMAN, OEM/Grid Control, Golden Gate, TOAD,SQL Developer, SQL*Loader, ERWIN, Data pump

Confidential, Madison, WI

Sr. Oracle DBA

Responsibilities:

• 24x7 on - call production database support. Installed Oracle 11g RAC, 10g RAC, Standby Databases for high availability and disaster recovery/reporting purpose.
• Installation and Configurations of Oracle 11g, 10g. Upgraded Oracle Database from 9i to 10g, 10g to 11g.
• Installation, configuration, maintenance and tuning of Oracle 11g and 10g databases.
• Applied CPU patches. Golden Gate installation and configuration. Replication using Golden Gate.
• Migration of the database from Sun Solaris to IBM AIX, Windows to Linux. Performed complete and incomplete database recovery.
• Configured and maintained Grid Control Repository and Deployed OMS Agents on different database servers.
• Using the 11g Grid control, OEM for the database tasks like adding the data file, resizing the data file, code compilation, User/Role creation and maintenance etc.
• Taken backups with RMAN in both Catalog/ No catalog modes.
• SQL tuning and Database performance tuning has been done based on reports generated by SQL TraceTKPROF, STATSPACK, Explain Plan, AWR, ADDM and monitor the database performance on daily basis.
• Planning Backup/Recovery Strategy, Planning and scheduling Backups, taking Logical Backups (with Export/
• Import Data pump utilities).
• RMAN Incremental backups. Automated the nightly RMAN backups
• Writing and modifying UNIX shell scripts, Perl scripts to manage Oracle environments and for Backend Oracle
• Processes.
• Developed PL/SQL scripts for Extraction, Transporting & Transforming (ETL) data from Production databases to Data Warehouse Databases.
• Logical and Physical Database Design, Capacity Planning and bench marking
• Partitioning of the tables for better performance and manageability
• Creating & Managing Database Structures, Storage Allocations, Table/Index segments, Rollback segmentsConstraints, Database Access, Roles and Privileges.
• Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of HintsStored outlines, Statistics for the same.
• Performed policies on data confidentiality, integrity, availability, and audit ability, Based on Access Controls for Access to Data at the database level.
• Performed SQL and PL/SQL tuning, oracle contention and monitored production database using automatic workload repository (AWR), automatic database diagnostic monitor (ADDM) and automatic session history.
• Cloning databases using scripts as well as RMAN.
• Worked closely with the Oracle developers for the better performance in Applications in writing the PackagesTriggers, Mat Views and Indexes on the tables.
• Enabled the audit on all the dev/test databases, analyzed and reported the audit records about the suspicious activity in the database.
• Monitoring the database storage and day-to-day activities.
• Table partitioning for better performance. Worked on exadata environment

Environment: Oracle 11g RAC, Oracle 10g RAC, RedHat Linux, IBM AIX, Sun Solaris, HP-UX, Windows, Shell Scripts, ASM, RMAN, OEM/Grid Control, Golden Gate, TOAD,SQL Developer, SQL*Loader, ERWIN, Data pump

Confidential, Irvine, CA

Oracle Database Administrator

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 the database like checking for failed processorsverifying the query for particular issues and validating disk space.
• Responsible for setup and implementation of 3 Node RAC on Linux in 10g and 11g R2.
• Configured and maintained Oracle Cluster Ware.
• Configured and maintained replication using Oracle Golden Gate.
• Implemented Bi-Directional replication in golden gate.
• Used to Perform Cold/Hot Backups.
• Used to perform backup and recovery using VERITAS Net Backup integrated into RMAN.
• Implemented and Managed Oracle Data Guard on Oracle 11gR2
• Upgrading the Oracle 10g to the latest Release 2 and applied patches as required.
• Perform Daily Monitoring of Oracle Instances, monitor users, and table spaces, Memory StructuresRollback Segments, Logs and Alerts.
• Involved in migration of applications of the clients.
• Created Users with 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 effective management of Oracle networking. Configured listener for external procedure calls.
• Database backup & Recovery with export and import for non archive and archive database with 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 the areas of maintenance, tuning, performance, and troubleshooting.
• Efficient in using the Oracle Tools like OEM, SQL* Plus, SQL* Loader, TKPROF, LOGMINERSTATSPACK, 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 the 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, Golden Gate, Oracle Enterprise Manager Grid Control, RDBMS, SQLPLUS, PL/SQL, Opnet, Shell Scripting, Stored Procedures.

Confidential, Overland Park, KS

Oracle DBA

Responsibilities:

• Installed and Configured Oracle 10g databases on Linux and also Upgraded Oracle databases from 9i to
• 10g version using Opatch. Converted a single instance database to Oracle RAC 10g.
• Installation, Configuration and Administration of Oracle 10g RAC.
• Involved in RAC administration including 10g Database cloning, tuning, patching and monitoring concurrent manager processing etc.
• Maintenance of around 200 databases combined on all the production, development and testing environment: s on various databases (DB2, SQL servers 2005).
• Configured Oracle Data guard for Oracle Disaster recovery.
• Achieved High Availability, Data protection and Maximum performance by maintaining both physical and logical standby databases. Written Stored Procedures and Triggers for database maintenance and management using PL/SQL
• UNIX Shell Scripts for backups.
• Experienced in performing Point in time recovery using RMAN.
• Used oracle configuration assistants like DBCA (Database Configuration Assistant) for Creating databasesDBUA (Database Upgrade Assistant) for Upgrading databases and NETCA (Network Configuration
• Assistant) for creating a Client-Server environment using Listener, TNS names etc.
• Management of schemas, objects partitioning the tables & indexes.
• Automation of data load and data parsing using Pl/Sql procedures, Korn shell scripting and Sql*loader.
• Tested database performance issues (monitoring and tuning) to ensure database optimization.
• Involved in gathering requirements from end users.
• Restoration and Recovery of databases at the times of occurrence of critical failures.
• Responsible for installing, upgrading and configuring the Oracle environment by creating databasesstorage structures and objects, monitoring and optimizing database performance.
• Implemented Oracle database backup & recovery solutions using RMAN.
• Extensive use of Oracle Data pumps utility for moving data among the servers.
• Created User accounts, Roles and granting required access permissions and privileges to the database based n the applications they are accessing.
• Configured and implemented Oracle Streams (Advanced Replication) for high availability.
• Responsible in configuring and backing up database using RMAN, Hot backups, Cold backups and Logical backups.
• Performed automated backups and scheduling using scripting.
• Continuous monitoring of database performance during peak and non-peak loads using STATSPACK.
• Estimate growth of database size by detail analysis of the company's future policies and generating reports for the management to act in advance.

Environment: Oracle 11g/10g, Red Hat Enterprise Linux 4.x and 5.x, AIX 5.2, OEM, Oracle 10g RAC, SybaseSTATSPACK, EXPLAINPLAN, IBM Data stage, C++, Web logic, SQL Server 2005.

Confidential, Wayzata, Minnesota

Oracle DBA

Responsibilities:

• Installation and maintenance of Oracle 9i on Linux OS.
• Installed, upgraded and patched Oracle installations.
• Managed data files, control files, redo log files, tables, indexes, constraints for performance and availability.
• Performed hot and cold backup and recovery using RMAN and UNIX Scripts
• Monitored database and SQL performance using Statspack, OEM, EXPLAIN PLAN and tuned problem areas to enhance performance.
• Loading of tables into oracle.
• Created Users for the Applications, giving them different level of permissions.
• Monitored database and system performance.
• Configured the Event Manager to notify support personnel.
• Worked on application and database security (data access, passwords, network, etc).
• Handled daily production problems/change requests with Oracle.
• Performed daily database administration tasks: User management, Space monitoring, Performance monitoring and tuning, Alert Log monitoring and backup monitoring.

Environment: Oracle 9.2.0.7, Window NT/2000/2003, Oracle Enterprise Manager, MS SQL Server 7/2000,RDBMS, VERITAS Netback up, SQLDBA, PL/SQL, TOAD7.5, Shell Scripting, HTML, Stored Procedures, Triggers