SUMMARY

• Over 8 years of experience as Oracle DBA on 10g, 11gR2 database servers with high availability.
• Pose strong experience working as an Oracle DBA which includes experience in 10g, 11g, ASM, Grid Control, 12 Cloud Control, Materialize Views, Data Guard, RAC and managing databases using Toad and dictionary tables and views.
• Worked with large database
• Build RAC Clusters from scratch on Linux
• Worked with offshore DBAs
• Supported multiple projects in parallel.
• Created Data Guard for RAC and standby servers.
• Provided 24*7*365 DBA on - call
• Worked on RMAN backups, restores and cloning of databases.
• Strong experience in OEM (Oracle Enterprise Manager) and TOAD.
• Worked with Developers during Deployments and SQL tuning
• Worked on instance tuning as per teh best practices.
• Identified root cause of performance issue using ASH, AWR, ADDM, SQL Advisor, tkprof, execution plan etc.
• Worked on databases ranging from a few GB to up to few TB.
• Worked on Oracle 10g and 11g R2 database server installs from scratch.
• Upgraded database from 10g to 11g R2 and 11.2.01 to 11.2.0.2 to 11.2.0.3
• Monitored databases using Grid control and 12 cloud control
• Used Export Import / Data Pump, DBLinks for data movement.
• Experience in writing Shell and SQL Scripts.
• Oracle RAC Good knowledge of Flashback technology.
• Performed Database Migrations.
• Performed Database Upgrades.
• Worked with Storage Admins for carving out partitions for datafile systems.
• Worked with SAN, NAS for ASM disks.
• Experience in schema management, Tablespace, datafile and extent management, as well as user and privilege management.
• Experience monitoring Oracle RDBMS availability, database exports, tablespace, and extents reports.
• Experienced in Database Security Administration using roles/grants.
• Managed SQL Server Databases
• Installed SQL Server 2005, SQL Server 2008 databases
• Installing, configuring, and maintaining Enterprise Manager Cloud Control to monitor and manage Exadata and regular databases
• Assisted in management and database administration of Oracle database applications on Exadata platforms
• Strong administrative skills in Windows and Linux.
• Tablespace Management
• Capacity planning
• Database installation using Oracle Silent Install.
• Applied Quarterly CPU and PUS patches.
• Troubleshoot Oracle Networking Issues
• Worked with Oracle in resolving issues.
• Very familiar with Oracle Dictionary

TECHNICAL SKILLS

Operating Systems: RHEL, HP-UX, Windows, Sun Solaris, CentOS

RDBMS: Oracle 10g R2, 11g R2, 12c Database, SQL Server 2005/2008

High Availability: RAC, Data Guard, ASM

Languages: SQL, PL/SQL

Tools: RMAN, OEM, SQL Loader, TOAD

PROFESSIONAL EXPERIENCE:

Confidential

Oracle DBA

Responsibilities:

• Responsible for new 11g database installation
• Upgraded and patched existing Oracle homes.
• Build 2-node 11g R2 cluster from scratch on Linux.
• Build Data Guard.
• Designed roles and assigned permissions
• Responsible to improve teh performance by Using teh Hints, Indexes, Explain Plan
• Performance tuning of SQL statements using STATSPACK, TKPROF, Explain Plan and SQL Trace
• Automating teh backup processes using shell scripts.
• Build RAC clusters and added nodes.
• Tablespace management including, adding/resize data files, allocated quotas to user and managed disk space
• Export and Import of User, Tables and Database using exp/imp and Data Pump
• Created Users/Roles, granted/revoked Permissions/Roles, defined quota on Tablespaces for users, and TEMPeffective management of Locally Managed Tablespaces, Dictionary-Managed Tablespaces, and Temporary Tablespaces.
• Used exp/imp, data pump and dblinks to move teh data
• Worked on standard and enterprise edition of teh Oracle RDBMS.
• Worked on database backup using RMAN for HOT backup and scripts written for COLD backup.
• Worked on schema Reorganizations for better space management
• Performed Database Refreshes and Database Copies for Development, Test and Production databases
• Installed, Migrated, configured and tested Oracle 9i databases in various environments
• Configured and Managed ASM disks and disk groups thru both Grid Control and ASMCMD utility.
• Conducting Installations of Oracle9i and Oracle 10g, Oracle 11g, sizing/capacity planning efforts for teh Oracle database applications on varied platforms like Solaris, Windows and Linux Servers
• Data modeling / Logical database design and implementation (including index design)
• Migration of system and applications from Oracle 9i to 10g.
• Configuring and using teh Oracle Enterprise Manager in 10g for Performance, Maintenance and Administration tasks
• Create and maintain multiple databases.
• Create multiple 11g databases on RHEL5 in development.
• Schedule backup in 11g using db console.
• Monitoring frees space in tablespaces, Archive log destination, Database/Listener availability, Blocking Locks monitoring etc.
• Configured RAC database with 4 nodes. Implemented Data Guard, Physical and logical Stand by databases to ensure high availability, data protection and disaster recovery.
• Improving teh performance of teh database by tuning SQL and database instance parameters using Automatic Database Diagnostic Monitor and SQL Tuning Advisor in Oracle 10g
• Using TCP/IP Protocol Configured SQL*Net files on server / client machines, and resolved client connectivity issues.
• Implemented backup strategies which involved taking an incremental backup and enabled teh block change tracking feature.
• Worked with Oracle in troubleshooting issues.
• Worked with Development team in deployments.
• Managed databases on Exadata and GlodenGate.
• Oracle 12c /11g/10g/9i, ASM, RAC, Partitioning, Exadata, GlodenGate, Upgrades, Migration,
• Worked on Performance tuning of databases on Exadata
• Installed 2 node and 4 node clusters on Exadata
• Worked on High availability of teh databases including RAC, ASM and Data Guard on Oracle Exadata

Environment: RHEL, 12c cloud control, 10g and 11g & 11g R2 databases, Offshore DBAs, RAC, Oracle Data Guard, Oracle GlodenGate

Confidential, IL

Jr. Oracle DBA

Responsibilities:

• Build database servers.
• Performed Silent installs.
• Ran scripts
• Install database with dbca, scripts and silent install.
• Worked with Sr. DBAs and shadowing them.
• Implemented procedures and practices regarding database design, development, monitoring, access, and upkeep.
• Helped deploying RAC
• Helped deploying Data Guard.
• Installed Oracle clients on application servers.
• Worked on a faced pace working environment.
• Developed and implemented backup and recovery strategies.
• Developed policies and procedures for system operations to better serve clients.
• Setup Alerts via Grid Control.
• Load Data using SQL Loader from flat files
• Supported developers in running scripts
• Used TOAD to manage databases.
• Worked on SQL Server 2005 and 2008 instances.
• Schedule daily and weekly maintenance jobs in SQL server
• Setup teh log shipping to create standby database in DR data center.
• Database Backup, Database Restore and Database Recovery using various tools.
• Database Reorganizations for better space management.
• Performed Database Refreshes and Database Copies for Development, Test and Production
• Supported multiple accounts on versions 9i to 11g
• Silent Installation of Oracle 11g on CentOS
• Create and maintain users, roles and privileges.
• Installed and configured Oracle Grid control.
• Extensively used data moving utilities like export/import, Data pump, Migrated flat files from different sources into Oracle Database using SQL*Loader and Performed DB cloning.
• Performed Online/Offline database backups.
• Built and configured RMAN Recovery Catalog for Backup and Recovery strategy.

Environment: 10g, 11g, 11g Grid Control, RHEL