SUMMARY

• Oracle Certified Professional with 8 years of diversified experience in Oracle Database Administration in various environments Extensive Database Administration in Linux, Solaris, AIX environments Provided 24x7 production support for Oracle 9i/10g/11g databases on various platforms
• Proficient in all DBA responsibilities such as Installation, Configuration, Upgrades, Patches, Performance Tuning, Backup Cold and Hot , Recovery, Cloning, Space management, Database Security, Auditing, Troubleshooting, Database Design, SR support, Unix Shell Scripting and Documentation
• Planned and implemented high availability solutions using Oracle 11g/10g RAC Standby Database using Oracle Data Guard
• Good expertise in Oracle performance tuning using Automatic Database Diagnostics Monitor ADDM , Automated Workload Repository AWR , Active Session History ASH , Statspack, TKPROF and EXPLAIN PLAN
• Proactive monitoring and performance tuning of databases including partitioning and creating materialized views
• Experience in User Management Synonyms, Privileges, Roles, Quotas, Table Partitioning, Indexes, and Sequences , Space Management Tablespace, Rollback Segments and Monitoring Alert logs, Memory, Disk I/O, CPU, Network activity
• Experience in managing large databases VLDB including OLTP and OLAP
• Expertise in working with File Systems, RAW Devices, Volume groups and Shared Storage for creating large databases
• Experience in Data Migration using Oracle Data Pump, Export/Import, SQL Loader
• Design and Document backup and disaster recovery plans for critical databases using conventional HOT, COLD and RMAN backups
• Supported 24/7 Production databases and responsible for round-the-clock database operations. Offering solutions for Production/Development of database applications.
• Experience in working with Oracle Product Support using Metalink to resolve critical issues
• Demonstrated ability to identify root causes of problems, considering both long-term and short-term impact of proposed solutions. Strong interpersonal and analytical skills
• Ability to manage multiple project tasks with changing priorities and tight deadlines

Technical skills:

• Operating Systems: Red Hat Enterprise Linux, Sun Solaris, AIX and Windows 2003
• RDBMS: Oracle 11g/10g/9i, Oracle 11g/10g RAC
• Tools: RMAN, OEM 11g/10g GRID, SQL Loader, EXP, IMP, EXPDP, IMPDP, TOAD, Putty, SCP
• Tuning Tools: TKPROF, EXPLAIN PLAN, Statspack, ADDM, AWR, ASH
• Backup Tools: TSM, NetApp, VERITAS NetBackup

Work Experience:

Confidential

Role: Oracle DBA

Roles and Responsibilities:

• Design, Install ,Configure and Build 11g databases on new servers
• Implemented advanced security standards like Transparent Data encryption, Wallet and Row level security
• Implement high level auditing on Database as per the security standards
• Identify storage requirement based on the usage and plan accordingly
• Cloning of the database from Production to the Test, Development environments
• Perform Schema and Table Refresh on regular basis
• Implement Data guard and perform disaster recovery testing
• Applied security related CPU PSU and One-off patches using Opatch utility
• Resolved block corruption and system level issues by working with oracle support.
• Using partitions to improve the maintenance and performance of the data
• Upgraded Oracle Database from 10g to 11g
• Applied security related CPU PSU and One-off patches using Opatch utility
• Configured and performed Server level backup in various environments using RMAN
• Created users and granting them appropriate privileges and roles
• Worked on reorganization of tables and rebuilding indexes
• Implemented Cold backup, Hot backup in manual methods using scripts and using RMAN and recovered various development and critical Production databases
• Tuning of Database performance using AWR reports and provided optimization reports
• Analyzed SQL statements and reorganized database objects and designed indexes to improve response of queries
• Generated performance reports using utilities like AWR to gather performance statistics
• Identified and tuned poor SQL statements using EXPLAIN PLAN, SQL TRACE and TKPROF
• Analyzed SQL statements and reorganized database objects and designed indexes to improve response of queries
• Checked alert logs and background trace files on daily basis and resolved problems
• Implemented backup for production database

Environment: Oracle 10g/11g RHEL, Windows Server.

Confidential

Role: Oracle DBA

Roles and Responsibilities:

• 24x7 production support for several mission critical systems which utilize multiple Oracle databases
• Worked on critical 5 node Real Application Cluster environment
• Create and configure ASM for RAC databases
• Installation, Configuration and Maintenance of Stand by database
• Installed and Implemented Backup and Recovery procedures
• Refreshed databases according to the requirements
• Applied security related CPU PSU and One-off patches using Opatch utility
• Knowledge transition from shadow phase to steady phase directly with the clients
• Engage in critical P1 and P2 calls, resolve the issue in stipulated timeframe
• Working on providing the RCA for priority issues
• Work on Tickets and Change requests as per IT IS standards
• Refreshed databases according to the requirements
• Perform tuning using Explain Plan and SQL Tuning Advisor, ADDM, AWR
• Mentor Junior DBA's

Environment: Oracle 9i/10g, RHEL, HP UX, AIX, Sun Solaris and Windows Server

Confidential

Role: Oracle DBA

Roles and Responsibilities:

• 24x7 production support for several mission critical systems which utilize multiple Oracle databases
• Worked on Oracle Streams involving replication and integration
• Worked on Real Application Cluster ,Data guard environments
• Create and configure RAC databases along with ASM
• Troubleshoot RAC installation and performance issues
• Troubleshoot Data guard sync and archive log missing issues
• Installation, Configuration and Maintenance of Stand by database
• Installed and Implemented Backup and Recovery procedures
• Refreshed databases according to the requirements
• Applied security related CPU PSU and One-off patches using Opatch utility
• Knowledge transition from shadow phase to steady phase directly with the clients
• Engage in critical P1 and P2 calls, resolve the issue in stipulated timeframe
• Work on Tickets and Change requests as per IT IS standards
• Regular Team meetings with client to understand the requirements
• Refreshed databases according to the requirements
• Perform tuning using Explain Plan and SQL Tuning Advisor, ADDM, AWR

Confidential

Role: Oracle DBA

Roles and Responsibilities:

• 24x7 production support for several mission critical systems which utilize multiple Oracle databases
• Installed and configured Oracle 10g
• Create and configure ASM for RAC databases
• Other duties include applying oracle database patches, design and creation of databases as per user requirement, creation of database users, monitoring, tuning, troubleshooting and backup and recoveries
• Experience in using Data Pump, Export/Import.
• Responsible for setting and managing user accounts granting required privileges to users
• User management: creating users, granting roles and privileges and Security Auditing
• Refreshed databases according to the requirements
• Working on providing the RCA for priority issues
• Work on Tickets and Change requests as per IT IS standards

Confidential

Role: Oracle DBA

Roles and Responsibilities:

• Maintaining and Monitoring QC and production Databases
• Tablespace and DB Object creations
• Creation of users, profiles and roles accordingly.
• Monitoring Database backups and alerts
• Monitoring Backup alerts
• Working on basic alarms and tickets
• Perform Quarterly patch activities
• Perform Basic Networking and troubleshoot Hardware issues
• Doing Export and Import at Database, Schema, table level.
• Created Technical Notes and Documentation