SUMMARY:

• 7+ years of experience in Oracle database administration, system Analysis, implementation and Testing of Relational Database Management systems for Business solutions.
• Expertise in Installation. Configuration. Upgrading. Patching. Migration Trouble shooting and Performance tuning of oracle 10g/11g and 12c databases on UNIX, LINUX and Windows environments.
• Practice in creating Backups & Recovery procedures and implementing BACKUP and RECOVERY strategies for off - line and on-line Backups.
• Build configured and managed multi node RAC Cluster on RHEL.
• Worked on Exadata X5.
• Build RAC Clusters.
• Migrated standalone databases to 2-node RAC Exadata.
• Practiced in OEM (Oracle Enterprise Manager).
• Set up and managed GoldenGate Replication.
• Experience in Oracle Data Guard, and SQL*PLUS, Explain Plan and TOAD.
• Worked on Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitoring (ADDM) reports for the health check of the databases.
• Used OEM Grid Control Diagnostic and tuning packs to tune the application and SQL queries.
• Good exposure on Amazon Web Services (AWS).
• Good knowledge of Flashback database, Flash recovery Area, ASM and RAC.
• Experienced with tools/utilities: OEM, RMAN, TOAD, and Data Pump (expdp/impdp).
• Supporting development 24/7 production systems. Providing on call support for mission critical applications.
• Performing backups and crash recoveries using conventional hot/cold backups and RMAN.
• Full control of tablespaces.
• Fair knowledge ln writing UNIX Shell scripts to automate business process and daily backup.
• Experience with testing and pre-production and production of Oracle 11g R2 with 2 nodes RAC on Red Hat Linux with ASM.
• Good knowledge in Hot/Cold Backup, Recovery, and Cloning of database using RMAN.
• Performed all aspects of database administration including installs, builds, upgrades, object sizing, object creation backup/recovery, patches, monitoring, and exports/imports.
• Good experience in SQL, Shell Scripting.
• Experience with installing and maintaining Oracle Grid Control. installed and configured 11g RAC on LINUX platform with ASM disks for storage.
• Supported the system 24x7. Ability to work beyond regular hours.

TECHNICAL SKILLS:

Scripting: Unix/Linux bash shell programming, Windows batch files

OS Administration: Solaris, Linux, Windows, AIX

Database: Oracle 10g, 11g, 12c Microsoft SQL Server, Microsoft Access

Concepts & Administration: Full Database Administration, Data Guard (standby), RAC, ASM, GoldenGate, AWS, Exadata, Partitioning, Flashback, Scripting

EXPERIENCE:

Confidential

Oracle DBA

Environment: Oracle 11g, 12c RAC, ASM - Linux, Solaris, Data Guar

Responsibilities:

• Setup standby data guard between primary and standby data center.
• Managed 4 node RAC clusters.
• Upgraded databases to 12c on Exadata.
• Setting and Monitoring Exadata using EM12c.
• Maintaining and Troubleshooting Exadata Cell/Storage and DB/Compute node performance issues.
• RCA for Node evictions and Instance evictions in Exadata.
• Troubleshooting Infiniband/RDS performance issues.
• Troubleshooting Exadata smartscan/offloading issues.
• Supported production, development and testing databases of Multi Terabytes DB sizes.
• Skilled with Stats pack, AWR. And ASH to check health of database & hardware.
• Used Performance tuning tools such as explain plans and SQL tune advisor (OEM).
• Migrated databases to different datacenter.
• Handled RAC Node hangs and node failover tests.
• Maintaining schemas and tablespaces.
• Responsible for administration and supporting Oracle 11g and 12c databases.
• Performing day-to-day database administration tasks like Tablespaces usage, checking alert log, monitoring disk usage, running SQL scripts against tables/schemas, table partitioning … etc.
• Worked in Tuning OS, Shared Pool, Golden Gate monitoring, creating crontab jobs.
• Experienced in using Data Pump (expdp/impdp) to transfer databases from one server to another.
• Experienced in using BBDA to build servers/nodes, databases/instances, and RAC on Linux box.
• Good experience in SQL Tuning, and performance tuning.
• Provided day to day support along with 24-7 on-call rotation.

Confidential

Oracle DBA

Environment: Oracle 11g, 12c RAC, ASM - Linux, Solaris, Data Guard

Responsibilities:

• Provided Operations support of 10g, 11g and 12c Databases.
• Coordinated the migration of oracle instances to AWS.
• Setup the disaster recovery site using Oracle Data Guard.
• Managed databases on Exadata.
• Apply Oracle Quarterly patches.
• Setup instances on Amazon Web Services.
• Worked on Instance Tuning.
• Worked on SQL Tuning.
• Used Data Pump to refresh schemas.
• Performed backup, restore, recovery using RMAN.
• Cloned Databases using RMAN Duplicate.
• Setup alerts, threshold and jobs using 13c Cloud Control.
• Oracle 11g with Physical Stand by Data Guard.
• Written shell scripts.
• Managing users, profiles, roles and table space according to the requirement.
• Worked on Tablespace Management
• Analyzed ASH/AWR and ADDM reports and guided application team.
• Build 4-node 12c RAC Clusters.
• Migrated Oracle database from file system to ASM.
• Provided on-call support
• Worked with onsite and offshore teams.
• Setup GoldenGate replication.
• Administered and maintained database security policies and procedures. Experience with administration of high-performance and large-scale multi-terabytes databases.
• Used external tables and SQL*Loader to import data from flat files.
• Created Documents for DBA processes and Procedures.
• Refresh database and schemas using export/imports and data pump.

Confidential, Detroit, MI

Oracle DBA

Environment: Oracle 11g - AIX Unix, Windows Server 2008

Responsibilities:

• PSU patching for both AIX and Windows servers’ databases.
• Used Performance tuning tools such as explain plans and trace files to tune SQL Queries.
• HOT/COLD RMAN backups for databases on all kind of servers.
• Responsible for administration and supporting Oracle 11g and 10g databases.
• Created, upgraded, and cloned Oracle databases for Development and testing databases
• Experienced in using Data Pump (expdp/impdp) to transfer databases from one server to another.
• Involved in 24x7 support for production RAC databases.
• Supported production, development and testing databases of Multi Terabytes DB sizes.
• Installation of 9i, 10g and 11g clients/databases on Solaris and Linux.
• Complete Build of 3-node 11g RAC Cluster on RHEL 5.x.
• Migrated 10g database to 11g R2.
• Skilled with Stats pack, AWR. And ASH to check health of database & hardware.
• Used Performance tuning tools such as explain plans and trace files to tune SQL Queries.
• Migrated databases to different datacenter.
• Experienced with SRVCTL, LSNRCTL, and CRSCTL of 11g RAC.
• Handled RAC Node hangs and node failover tests.
• Maintaining schemas and tablespaces.
• Responsible for administration and supporting Oracle 11g, 10g and 9i databases.
• Created, upgraded, and cloned Oracle databases for Development and testing databases
• Performing day-to-day database administration tasks like Tablespaces usage, checking alert log, monitoring disk usage, running SQL scripts against tables/schemas, … etc.
• Experienced in using Data Pump (expdp/impdp) to transfer databases from one server to another.
• Experienced in using BBDA to build servers/nodes, databases/instances, and RAC on Linux box.
• Good Experience in SQL Tuning, and performance tuning.