SUMMARY

• Expertise in Oracle database administration, Database design, development in Oracle 10g, 11g and 12c databases on Linux, UNIX, AIX, and Windows environment.
• Experience in installing and Configuring Oracle Real Application Clusters (RAC) with Automatic Storage Management (ASM) for high availability databases..
• Good exposure of Oracle DBA tasks Installation, Patching, Cloning, and Upgrade of Oracle Databases.
• Rolling patch apply in oracle RAC environments as well as OS Cluster databases.
• Experience in Backup & Recovery, Disaster Recovery options, Oracle Recovery Manager (RMAN).
• RMAN backups are scheduled, monitoring and maintaining in Oracle 11g OEM grid .
• Participat ion in analysis and designing of Oracle Exadata Server for infrastructure and related projects. Assisted in integration of Exadata applications into current IT actionable events and solutions.
• Setting up High Availability Oracle Golden Gate OGG systems on Oracle 11gR2 RAC environments Front - end: IBM p770/AIX 6.1, Back-end: Oracle Exadata X4 Full Rack .
• Experience in setup and configuration Golden Gate .
• Replication and Extracting data and applying on production using Golden Gate .
• Hands-on experiences in trouble shooting and performance tuning Oracle Golden Gate replications.
• Experience as On-Call 24x7 production DBA support for Critical databases.
• Password Vault administration and monitoring for secured oracle user’s password (SYS, SYSTEM and other users).
• Experience in Performance Tuning (I/O, Memory & SQL Tuning etc) by using tools/utilities like tkprof, sql profile Automated Workload Repository (AWR), Automatic Database Diagnostics Monitor (ADDM) and (Automatic Diagnostic Repository) ADR .
• Experience in maintaining Oracle Data Guard physical Standby Database and providing critical solution with strategic disaster recovery plans.
• Experience in Data Guard setup in oracle 10g and Active Data guard in 11g and 12c.
• Good knowledge in Hot/Cold Backup and Recovery and Cloning of databases by using RMAN.
• Database and ASM instance monitoring and administration for oracle 9i, 10g and 11g by using 11g OEM grid control tool.
• Pro - actively monitored the database and its files growth rate and actively added adequate space for the datafiles and also in respective disk groups (Raw devices).
• Allocating system storage and planning for future storage requirements.
• Oracle Database Re-organization, index rebuilding for maintenance and administration.
• Database refresh, schemas refresh, tables and partitions refresh by using impdp, expdp, Import and Export Utilities.
• Cloned Database from Production to Test and Development.
• Experience in migration of oracle database to higher version and installing patches.
• Experience on handling very large database up to 8 TB
• Data loading using SQL*LOADER, Logical backups using full export and DATAPUMP.

TECHNICAL SKILLS

OPERATING SYSTEMS: Red Hat Linux 5.9, 5.10, 6.5, HP-UX 10.x/11.x, Sun Solaris, AIX, and Windows NT/ 2000/2003/2008.

RDBMS: Oracle 9i/10g/11g, 12c, Oracle 10g/11g Real Application Clusters (RAC).

LANGUAGES: C, C++, SQL, PL/SQL, JAVA, J2EE and Shell Scripting.

SOFTWARE/ APPLICATIONS TOOLS: OEM, DATAGUARD, Recovery Manager (RMAN), Data pump, STATSPACK, AWR, TKPROF, ADDM, ADR, Golden Gate, Exadata,SQL Loader, SQL Developer, TOAD, TPAM.

WEB TOOLS/REPORTING TOOLS: HTML, XML, BI, BO, crystal reports.

PROFESSIONAL EXPERIENCE

Confidential, Denton, TX

Senior Database Administrator

Responsibilities:

• Supporting commercial RMS applications as database administrator for various databases.
• Managing overall project delivery, quality and timely execution of Oracle Retail databases support across multiple application teams like Merchandising Systems (RMS), Store Inventory Management (SIM) and downstream external interfaces.
• Optimizing database performance by analyzing database objects, generating statistics, creating indexes, creating materialized views, Import/Export, SQL* Loader, Explain Plan, Tkprof, sql trace, analyze, hints, Oracle 11g AWR, ADDM etc.,
• Backup and recovery using RMAN, expdp.
• Switchover & Failover of DG Databases using DGMGRL Data Guard Broker
• Setting up database auditing for database securities and monitoring.
• Monitors service delivery in order to recognize trends proactively identify problem root causes; resolve service delivery problems.
• Incident, Problem and Change management to review trend, database support metrics to assess and evaluate gaps and areas of improvements in database support and team's performance.
• Coordinating periodic support meetings with client Senior Managers and Applications team partners, to prioritize Support activities and plan for support coverage and database maintenance.
• Work management for Support team members by assigning and tracking issues to closure.
• Follow communication and escalation path and involve respective stakeholders for fast resolution of issues.
• Technical and functional consulting on Oracle Retail applications by coordinating with existing application teams and guide his Oracle retail support team lead and members on new initiatives
• Responsible for discussing with client manger and AD team to arrange the resources for key releases and timeline based on the team’s availability and technical estimation.
• Experience in Performance Tuning (I/O, Memory & SQL Tuning etc) by using tools/utilities like TKPROF, SQL PROFILE Automated Workload Repository (AWR), Automatic Database Diagnostics Monitor (ADDM) and (Automatic Diagnostic Repository) ADR.
• Database and ASM instance monitoring and administration for oracle 11gR2 by using 11g OEM grid control tool.
• Experience in Building, maintaining Oracle Data Guard physical Standby Database and providing critical solution with strategic disaster recovery plans.
• Established clear working and process model for Onsite & Offshore team and executed the projects in shorter timelines by two geographical teams working without issues but with lower costs.
• Experience as On-Call 24x7 production DBA support for Critical databases.
• Contribution to ongoing security Audits to comply with client's security requirements.
• Weekly status reporting to client Managers and Cognizant stakeholders.

Environment: Operating Systems: Red hat Linux 6.5 and Windows 2003/2008 RDBMS: Oracle Database Server 11g/12c, Programming Language/Tools: TOAD, PL/SQL, SQL Developer,RMAN

Confidential, California

Database Administrator

Responsibilities:

• Expertise in Oracle database administration, Database design, development in Oracle10g and11g database on Linux, AIX, UNIX and Windows environment.
• Database and ASM instance monitoring and administration for oracle 9i, 10g and 11g by using 11g OEM grid control tool.
• TPAM administration and monitoring for secured oracle user’s password (SYS, SYSTEM and other users).
• Database refresh, schemas refresh and tables refresh by using impdp, expdp, Import and Export Utilities.
• Oracle database upgrade from 10g to 11gR2.
• Managing Real Application Cluster in 10g and 11g.
• Golden Gate configuration and implementation in Linux and Exadata environments.
• Installing Oracle Real Application Cluster Versions 10g and 11g on Linux servers.
• Rolling patch apply in oracle RAC environments as well as OS Cluster databases.
• Responsible for Database administration work like applying PSU patches, Interim patches for the single instance.
• Pro - actively monitored the database and its files growth rate and actively added adequate space for the datafiles and also in respective disk groups (Raw devices).
• Performances tuning for database using ADR, AWR, ASH and ADDM reports analyze as well as query tuning explain plan /SQL TRACE/TK Prof report.
• Backing and restoring the database by using RMAN/EXPDP/IMPDP.
• Protecting Oracle Database Appliance - Tape Backup with CommVault Simpana.
• Security Configuration for Oracle Database 11g.
• Oracle Database Re-organization for maintenance and administration.
• Allocating system storage and planning for future storage requirements.
• DB link/materialized view creates need to be done.
• Monitoring and detecting the locked objects and releasing the locks. Killing unwanted sessions.
• The Database refresh, Schemas refresh and Tables refresh in Development and Test databases.
• Monitoring Space and Index usage. Rebuilding Index on the needed objects.
• Managing Privileges by creating roles, profiles, system and object privileges and granting to database users.
• Performed SQL tuning on issue like slow running queries and hanging etc.,
• Administrating database, managing users, profiles, tablespace, schema, rollback segments and instance.
• Worked out privileges and Roles to be granted to the users
• Database Objects Creation and Space Management and automate the house keeping procedure.
• Day to day database activities like space monitoring, DB health checking and monitoring alert logs.
• Good command over Utilities like RMAN, Export, Import, expdp, impdp, SQL*Loader, DB verify and DBID.
• Working with FTP/TELNET/WRQ Reflection for Linux and RDP for windows.
• Sensibly carried out checking Alert Logs and taken steps to rectify in case of any error messages.

Environment: Operating Systems: Redhat Linux, IBM-AIX and Windows 2003/2008 RDBMS: Oracle Database Server 10g/11g, Programming Language/Tools: TOAD, PL/SQL, SQL Developer and TPAM

Confidential, Michigan, US

Sr. Tech Specialist

Responsibilities:

• Installed Oracle 11g database on AIX and Red Hat Linux.
• Installed RAC on Oracle 10g and worked on ASM feature of Oracle and managed disk groups.
• Installed and administered Real Application Cluster (11g RAC) environments; adding and removing nodes to the cluster and handled performance tuning using AWR.
• Reviewing of database design document and creating ER diagrams, providing conceptual and logical data model and translating into physical database.
• Have worked on different environments like test, development and production databases.
• Have worked on backup/recovery, performance tuning.
• Worked on OLTP and OLAP database systems.
• Responsible for upgrade & migrating databases from 10g to 11g, applying patches.
• Database Restore using RMAN, Cold Backup and Export/import.
• Involved in Design and implementation of oracle 10g Data guard both physical/logical standby databases.
• Responsible for configuring database memory structure, managing storage allocation, creating user accounts, roles and privileges for DB operations and security maintenance.
• Managing database instances for production and test environments to ensure strong testing environment and smooth transition to production.
• Used impdp /expdp and SQL- loader to load data into tables.
• Utilized Oracle Enterprise Manager (OEM), Grid control to manage users, privileges, profiles, and schemas.
• Automated monitoring the databases, performance parameters, and backup/recovery activities by RMAN and VERITAS Net Backup, running Cron jobs and write UNIX shells scripts for job automation.
• Performed database and memory tuning using tools like STATSPACK, TKPROF, EXPLAIN PLAN, OPTIMIZER and SQL tuning advisor.
• Interacted with data modelers, developers, application owners for gathering the required information and resolving various issues.

Environment: AIX 5.1, HP -UX 11.23, Solaris, Windows XP, Oracle 10g / 11 g, RAC, OEM, Grid ControlRMAN, DBCA, Data Guard, Putty, TOAD 8.1, UNIX, Linux 4.0