SUMMARY

• Having 9+ years of experience as ORACLE & SQL Server DBA with expertise under multiple platforms. Extensive experience in support DBA activities Including Oracle Apps and AWS Redshift administration.
• Good knowledge of AWS RDS, Big Data & Cassandra cluster architecture.
• Designed AWS infrastructure to move our local applications to hybrid cloud, as an intermediate stage and then it will all public cloud
• Established security policies in the AWS cloud also, quite involved with other cloud architectures not just AWS.
• Responsible for: Oracle, SQL Server and Amazon AWS cloud infrastructure.
• Hands on experience withInstallation, Configuration, Migrations, Oracle Data Guard,Backup and Recoveryusing RMAN, Disaster Recovery and Patching, upgradingand administering10 Terabytesof Oracle Databases on Oracle 12c/11g/10g/9i
• Solely involved in database cross platform migration and upgradation.
• Oracle Database Administration on 24x7 critical production and large databases of over 7 TB using Oracle 10g RAC, 9i.
• Design and implement capacity planning strategy for OLAP databases, providing operational estimates.
• Extensive experience in planning and execution of database Migrations, Upgrades & applying PSU/CPU patches (Single instance, RAC, Data guard).
• Expertise in Oracle Architecture, I/O tuning, Capacity planning, space management, Memory Tuning, Performance tuning, Backups, Recoveries, RMAN backups, Networking, troubleshooting.
• Performed backups and tested crash recoveries using conventional hot & cold backups and RMAN. Point - In- Time Recovery through RMAN.
• Worked in both OLTP and DSS environments.
• Expertise in designing and implementing Oracle databases, cloning of databases and setting up RAC database.
• Expertise in Oracle Enterprise Manager (OEM) Grid Control, TOAD, RMAN.
• Design and implement SOX Compliant database environment.
• Performed Backup/Recovery of the Oracle databases using RMAN Incremental & Hot Backup.
• Configured Recovery Manager (RMAN) like Advice on data recovery, parallel backup of the same file, and virtual catalogs for security.
• Restore and Recover, Cloning and Duplicating databases using scripts as well as with RMAN.
• Migration: Duplicated database using RMAN and upgraded it to oracle 10g/11g and applied latest patch set.

TECHNICAL SKILLS

Operating Systems: Unix, AIX 4.3, AIX 5.3, Red Hat Linux, OEL, Fedora, Ubuntu, Solaris10,9,8, HP-UX. Windows (NT 4, 2000/2003 Prof/Adv Server, XP Professional)

Databases: Oracle 12c/11g/10g/9i/8i,SQL Server

DB Utilities: SQL*Loader, Sql*Plus,10g OEM, Grid Control, RMAN, DBCA, DBUA, 10g Data Pump, Toad, Data guard, Export / Import, TKPROF, Statspack.

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR / ADDM / ASH.

Languages: SQL, UNIX Shell Scripting, Perl.

PROFESSIONAL EXPERIENCE

Confidential, Schaumburg, IL

Database Support services

Responsibilities:

• Planned and executed multiple server upgrades and migrations.
• Coordinated capacity planning through in-depth trend analysis.
• Initiated and executed disaster recovery and backup initiatives.
• Collaborated with business analysts and development teams in design and deployment of relational databases from legacy data.
• Facilitated database performance tuning.
• Actively involved in strategic Backup, Restore and Recovery using RMAN for complete recoverability.
• Performed Import and Export using Oracle Data pump utilities EXPDP and IMPDP.
• Installed, and applied patches to Oracle software and associated application.
• Involved in Database migration from Oracle9i to Oracle 10g.
• Performed Database and Application Performance tuning using EXPLAIN PLAN, TKPROF, Statspack and SQL Tuning.
• Performance tuning for optimized results using tools like AWR and ADDM reports.
• Created and maintained all databases required for development, testing and production usage.
• Worked as part of a team and provided 24/7 support when required.
• Implemented Standby Database and Database Replication to realize database high availability.
• Created partitions for large table to improve performance.
• Architecting, planning, designing, developing, deploying and supporting RAC/ASM environment
• Setting up new instances and configuring with RMAN Catalog for RMAN Backup and recoveries.
• Migrated Non-ASM Single Instance to ASM RAC Instance.
• Backup and Recovery issues related (loss of OCR, Voting Disk and Oracle clusterware) & also issues with corruption of individual disk data blocks, loss of OS configuration files, loss of net configuration files. Also used the Merge backup for backing terabyte databases. Issues with block change tracking & also flash recovery area.

Confidential, Schaumburg, IL

Database managed services

Responsibilities:

• Coordinated installation, configuration and deployment of multiple Oracle database server releases.
• Designed and set up databases aligned with company's IT standards.
• Designed & Implemented Disaster Recovery solutions.
• Monitored daily database performance / availability, backup and reporting jobs.
• Planned and implemented database schema and security changes.
• Expertise Server Installation, Configuration, Maintenance, Backups & Restores, Security Management, Datapump, Performance Tuning.
• DBA activities such as configuring Grid events, Regular Backup’s, Replication, Tuning, and troubleshooting performance issues.
• Maintenance and monitoring of oracle 11g/10g database instances hosted on Linux and Sun platform.
• Used Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitor (ADDM) in RAC for Performance Tuning.
• Space Management which includes table space creation, adding new data files.
• Oracle installation, creation of database, which includes physical and logical design.
• Recovered databases and clone applications Using RMAN.
• Installed Oracle Application Express on Oracle 11g.
• Partitioning of large tables for fine tuning performance.
• Designed and implemented crash recovery strategies, and Hot, Cold and Logical backup plans.
• Experience with DBUA/Export and Import to migrate the database.
• Responsible for optimizing data access and performance by tuning indexes.
• Upgrade and Migration of Databases from 10g R2 to 11g R1 and applying patches as per requirement.
• Troubleshoot performance issues for the RAC instances (GC events)
• Backup and Recovery issues related (loss of OCR, Voting Disk and Oracle clusterware) & also issues with corruption of individual disk data blocks, loss of OS configuration files, loss of net configuration files.
• Resolved/Diagnose Node Eviction.
• Upgrade of 10g R2 RAC to 11g R2 RAC