SUMMARY

• 8+ Years of experience in IT Industry as an Oracle Database Administrator on different flavors of UNIX and Windows environments
• Experiencedas Oracle DBA in production, development and test environments
• Implementing 2 - node RAC in different UNIX platforms and installingOracle 11g RAC software with ASM and OCFS2file systems
• Installing and Configuring Oracle11g grid and Data Guardmaintenance in large environments
• Creating database and database objects like table, index, table space, rollback/undo segments and views and analyzed relevant objects to collect statistics to tune the system performance and good hands of experience on pl/sql
• Performingmigration and upgradation of databases to 11g and 10g and multiplexing of control files and redo-logs for disaster recovery scenario
• Data loading using SQL*LOADER, logical backups using full export and DATAPUMP.
• Constructingcatalog databases and developing scripts to perform backups of large databases
• Detecting and diagnosing production system performance tuning of the database - SQL tuning, used tuning utilities like STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, distribution of disk I/O, sizing of tables and indexes measuring system and database activity, querying Oracle dynamic performance views and auditing in accordance with SOX
• Database replication using snapshots, materialized views, import/export and advanced replication methods
• Good writing skills to provide documentation for DBA and other teams.
• Experience in Oracle Golden Gate installation, configuration and troubleshooting Golden Gate issues and in high availability features
• Interacting with the Oracle support on Service Requests and implementing the solutions for successful completion of the tasks.

TECHNICAL SKILLS

Databases: Oracle 11gR2, 10g, 9i, DB2, SQL Server 2005 and 2008 R2

Oracle Products: Oracle10g (Grid Control), OEM (Oracle Enterprise Manager), RMAN, OEM 12C, SQL*Loader, Import and Export(EXPdp/IMPdp), ASM, TKPROF, SRVCTL, SQL* Loader and SQL * Net, Golden Gate.

Operating System: RHEL 4, RHEL 5, OEL 4, WIN NT/2003/2008,HP-UX Itanium, IBM AIX

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

Other Tools: TOAD, Putty, SQL Developer, Erwin.

PROFESSIONAL EXPERIENCE

Confidential, Plano, TX

Oracle DBA

Responsibilities:

• Ensured high availability and performance(24 hrs production support)
• Ongoing proactive database-level performance tuning and pro-actively monitor database systems to ensure secure services with minimum downtime
• Managedall database objects in a large mission critical system and provided end to end DBA support system and application side
• Analyzed and resolved complex technical problems regarding the integration of object-oriented applications and infrastructure with relational database technology.
• Monitored databases and performs tuning enhancements to optimize their performance.
• Developed and maintained utilities to automate problem determination, change implementation, and monitoring activities.
• Participated as a team-member in data management strategies. Integrated data architecture with appropriate components of the extended enterprise, transaction factories, and the data warehouse.
• Currently helping team to use existing infrastructure to achieve maximum benefit to reduce cost and maximum performance.
• Changes were made dynamically whenever possible to fulfill high-availability requirements
• Was responsible for implementation and release of database changes as submitted by the development team.
• Interacted with development teams, business owners, and various levels of management.
• Participated in data-sourcing, import and data validation activities.
• Provided database change and release management.
• Coordinated all Oracle system changes with the Operational DBA teams.
• Enforced need of regular data purging processes from production, design and development, to deployment.
• Continuously monitored of database performance on 12c OEM and monitored the production Oracle alert logs for database errors.
• Was responsible for two critical online applications database’sperformance which has a hugebusiness/revenue impact
• Handled production tickets/defects and solved problem with in time frame with accurate decisions and identified the root cause and fixed the same.
• Proficient in RAC Performance Tuning.
• Performance tuning of queries consuming excessive resources or slow running queries by providing required hints to the query.
• Supported development effort by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using Explain Plan.
• Was responsible for monitoring database, diagnosing errors, building, deploy, maintain and trouble shoot database objects.
• Expert at database tuning, application tuning and performance monitoring. Fine tuning Initialization parameters, I/O, memory and operating system kernel parameters.
• Managed appropriate use of free space within tablespaces, reclaimed space whenever possible. Reorganized tables and indexes within databases when needed.
• Monitored system resource availability and responded to system memory and data issues.

Environment: Oracle 10g, 11g, Oracle Enterprise Manager, ASM, AIX, Database Control, TOAD, OEM 11g r2/12c, Data Guard.

Confidential

Oracle DBA

Responsibilities:

• Installed Oracle DB 10g, 11g RDBMS, RAC on ASM, Applied Oracle critical patch updates, Implemented and Managed Data Guard, Replication, Backup and Recovery support and performance tuning
• Installed grid Infrastructure software on new Linux Servers for 2 node and 3 node RAC and failover environments and Oracle Grid Control11g Installation.
• Migrated Non-ASM databases to ASM environment for high availability using RCONFIG.
• Worked on OEM 12C grid for monitoring the listeners present in the oracle environment.
• Worked troubleshooting RAC and implemented ASM features.
• Applied necessary patches during installation and also in up-gradation of databases.
• Installed and configured of Goldengate on 11g database for the bi-directional replication.
• Resolved the issues in conflicts between the target and source database in Goldengate.
• Well experienced in taking Cold Backup for a very huge 15-Tb Database.
• Dailybackupsusing RMAN.
• Migration of databases from 10g to 11g using export/import and data pump export/import utilities and performed database refresh activities for business requirement and tuning purposes.
• Having good experience in user management, table space management, session management, undo management issues.
• Installed 12c agents on hosts and discovered targets.Experienced in switching primary database to standby and standby to primary during regular maintenances of catalog databases and disaster recovery databases.
• Upgraded analytical databases from 10g to 11g.
• Installed and configured of Goldengate on 11g database for the bi-directional replication.
• Resolved the issues in conflictsbetween the target and source database in Goldengate.
• Involved in deploying new application and setting up replication between the databases using Goldengate
• Expert in utilizing Datapump tool for exporting and importing the data between databases.
• Used datapump for schema refresh, and RMAN for database refresh and for backing up databases
• Well Experienced in taking cold backup for a very huge 15-Tb Database.
• Dailybackups using RMAN.
• Migrateddatabasesfrom 10g to 11g using export/import and data pump export/import utilities and Performed database refresh activities for business requirement and tuning purposes.
• Experienced in user management, table space management, session management, undo management issues.
• Experienced in managing space issues in the database level for table space and regular file system cleanup at UNIX level.
• Generated AWR, ADDM and ASHreports for database issues
• Installed 12c agents on hosts and discovered targets.
• Created new groups, templates, and Incident rule sets in OEM 12C.
• Designed and tested patching through OEM 12C.

Environment: Oracle 10g, 11g, Oracle Enterprise Manager, EXADATA X2-2, ASM, AIX, Golden Gate, Database Control, TOAD, OEM 12c, ASM, AIX, Golden gate, Tivoli,MS SQL Server 2008 R2

Confidential, Buffalo

Oracle DBA

Responsibilities:

• Involved in gathering user requirements, application design, and analysis of hardware requirements to meet business needs.
• Configured of system to achieve high availability, load balancing and automatic fail over functionality.
• Successfully implementedbackup andrecovery using RMAN, Hot and Cold backups.
• Took the RMAN incremental and cumulative backups.
• Installed, upgraded and maintained Oracle 10g on Sun Solaris and Windows 2003
• Implementeddatabase security, management of role-based security.
• Applied Patches 10.2.0.1 and applying Oracle DST Patches on Oracle database.
• Performed day-to-day database administration tasks like table space usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup.
• Cloned databases from production to test environments.
• Periodic data refresh from production to testing environments, Re-organized database structures
• Scheduling the databases backup using Cron tab.
• Extensive experience in RMAN recovery in RAC and stand alone database.
• Created a Clone Database using RMAN on remote Server and used SRVCTL commands for Real Application Cluster (RAC) Databases.
• Implemented Dataguard with maximum availability, protection and performance configurations and worked with dataguard fail over and switch over cases at the times of up-gradation and migration.
• Monitoring the Oracle Instances, Users, Tables, Table spaces, Memory structures, and Rollback segments, Redo logs, Archived Redo logs and Alerts.
• Creation of Users and granting them the required Roles and Privileges accordingly.
• Involvement in space management, rectification of lock problems, managed quotas.

Environment: Oracle 10g, 11g, SQL, Oracle Grid Control, Oracle Enterprise ManagerDatabase Control, TOAD, SQL Developer, SQL*Loader, Red Hat Enterprise Linux, ASM.

Confidential

Oracle DBA

Responsibilities:

• Involved in monitoring the Database related activities using Oracle Enterprise Manager 10g Grid Control (OEM Grid) and monitored the backup jobs scheduled in OEM Grid.
• Configured and implemented Oracle 10g Dataguard for database disaster recovery.
• Performed oracle Database data refreshes using export/import from production to test Servers.
• Involved in performance tuning by general health checks and maintenance for Database using AWR and ADDM reports by finding wait events.
• Performed logical backup of the database and Schemas using DATAPUMP (Expdp/Impdp) as per the requirement.
• Involved in implementation and support of 10g migrations and upgrades from Oracle 9i and 10g databases on HP-UX and Linux.
• Involved in applying CPU and PSU patches for Oracle Server.
• Involved in writing UNIX Shell Scripts for maintains tasks for oracle database.
• Worked on data modeling using Oracle SQL Developer Data Modeler.
• Configured and implemented Oracle Goldengate replication.
• Migrated from DB2 to Oracle 11.2.0.3
• Involved in PL SQL programming and performance tuning for oracle database by generating AWR and ADDM reports
• Performed database activities using integrated development tools like SQL Developer and TOAD.
• Involved in creating Change Request and Service Requests and resolving database issues with Oracle support
• Configuration of Listener and Net Service names using NETCA.
• Created, monitoring database objects like Tables, Indexes, Views, Users, and DB Links etc.
• Cloned schemas, objects and data on new server using Datapump.
• Created, monitoring database objects like Tables, Indexes, Views, Users, and DB Links etc.
• Creation of Users and granting them the required Roles and Privileges accordingly.
• Configuration of Listener and Net Service names using NETCA.

Environment: Oracle 10g/11g, Linux, SQL Server 2008, Oracle Enterprise Manager Database Control, RDBMS, TOAD, PL/SQL, Shell Scripting, ASM, Data guard,MS SQL Server 2008 R2.

Confidential

Oracle DBA/Developer

Responsibilities:

• Involved in Installation and customization of Databases (10g and 9i).
• Involved in Schema management, Table space Management, User Creation.
• Monitoring the Extraction and loading processes of Data.
• Upgraded and applied patches as and when required. Database Refreshes from Prod to Dev. Troubleshooting Day-to-Day Users Issues in various modules.
• Responsible for Oracle implemented backups like LOGICAL and PHYSICAL i.e. Export and import and also having experience with EXPDP and IMPDP
• Evaluated the hardware requirements before upgrading/migrating the database.
• Good experience with recovery managed backups i.e. RMAN
• Migrated the database from non-Oracle to Oracle i.e. SQL Server to Oracle.
• Maintained and audited Application and data servers.
• Documented the complete project including all pre installation, post installation and database configuration steps.
• Manage users, privileges, profiles, and schemas.
• Experiences in using automatic monitoring and management processes like batch processing using Crontab for processes like import, export databases.
• Used analyze table, analyze indexes to tune queries and increase performance.
• Tuning Oracle 9i database servers using tools dynamic, dictionary views, Stats pack, ADDM, AWR Diagnostic and tuning packages.

Environment: Toad, Oraclecle9i/10g,a Linux, AIX5.1, Hp-UX, Sun Solaris, SQL, PL/SQL, Shell Scripting.