SUMMARY:

• Have 11+ years of focused experience in IT Industry in various fields like Energy, utilities, automobile, retail and manufacturing as Oracle database administrator.
• Worked in Oracle database versions 9i, 10g, 11g and 12c versions in Linux, AIX, Solaris and Windows environments.
• Migrated the on premise database to AWS Amazon cloud EC2 database through transportable tablespaces.
• Architecting, planning, designing, developing, deploying and supporting two - node RAC/ASM environment 10g/11g.
• Configured schema level unidirectional golden gate in 12c in production database environments and troubleshoot the day to day issues.
• Configured the 2 Node RAC Clustered environment end to end in oracle 11g that includes requirements gathering, Hardware planning, OS installation, CFS configuration, configuring ASM disks, GRID installation, configuring Scan, Virtual and Public IPs and network architecture for clusters and RAC database installation.
• Experienced in database recovery/ restore with Delphix tool, EMC snapshot based database refresh with AppSync.
• Proficient in setting up Physical/Logical standby database, SRDF replication, rebuilt the standby database rebuild using Cold backup, rebuilt standby using RMAN, switchover and failover the standby databases.
• Expert in performing Backup/Recovery strategies using RMAN and without RMAN.
• Worked on table partitioning, range & interval partitioning on heavy loaded tables. Automated the range partitioning through scripts. Good in maintenance like exchange partitioning of tables.
• Experience in Oracle 12c/11g/10g - Installation, Migration and implemented new features. Installation includes requirement gathering, licensing, database storage planning, memory planning, storage allocation, database installation, configure database as per company standards.
• Good knowledge with Oracle streams replication in 10g and materialized views.
• Trained on Exadata database server hardware architecture.
• Expertise in doing Manual Oracle Upgrade, using DBCA from 10g to 11g or 10g to 12c.
• Applying the PSU/CPU Patches the 10g/11g Oracle home through Opatch utility.
• Worked on DR testing by opening the physical standby database and reconfigure the DR after the testing. Also on the failover testing of physical standby databases.
• Experience in Migration of Oracle 10g to Oracle 11g, from windows to UNIX environment.
• Expertise in Performance tuning, memory tuning, SQL tuning based on reports generated by SQL Trace, TKPROF, STATSPACK, Explain Plan, AWR, ADDM and monitor the database performance on daily basis.
• Implemented weekly backups with expdp through OEM.
• Supporting Data Warehouse Database i.e. over 20 TB in size.
• Strong trouble shooting, problem solving, analytical and design skills.
• Expertise in Oracle Enterprise Manager (OEM), TOAD, DB Artisan, SQL Developer, ODBC configurations.
• Good knowledge on SHELL Scripting, UNIX Commands to identify the OS level database parameters and resolve issues.
• Worked in 24x7 production support environment and provided on-call and day-to-day support.
• Creating and maintaining logins, Profiles, synonyms and access privileges using roles, controlling access to the database using operating system and Oracle security features.
• Have impeccable communication and interpersonal skills, leading the offshore team and managed conflict situations.

TECHNICAL SKILLS:

Databases and Version: Oracle 12c, 9i, 10g, 11g and Microsoft SQL Server 2014, 2012 & 2008

Operating Systems: IBM AIX 5.1 to 7.3, Oracle LINUX, Windows Server 2000 till 2012 R2, red hat LINUX and SUN Sparc Solaris.

Tools: Delphix, AppSync, SRDF, Oracle Warehouse builder, Quest TOAD, Remedy, DB Artisan, ICD, VMware, DBverify, Exp/Imp, expdp/impdp, OEM 12c.

Scripting and Languages: PL/SQL, UNIX Shell script, Windows batch programming & Excel macros

PROFESSIONAL EXPERIENCE:

Confidential - Miami, FL senior Oracle database consultant

Responsibilities:

• Migrate the on premise database to AWS Amazon cloud EC2 database through transportable tablespace.
• Configured Golden Gate 12c feature in production database end to end, Replication and Extracting data and applying on production using Golden Gate.
• Key member of the team for designing a solution with the use of Oracle Goldengate, which replicates the important energy related data within databases present in different states.
• Configured the streams replication unidirectional to maintain the data integrity between 10g databases.
• Analyze clustered/non-clustered index allocation and included columns, and optimization of query plans.
• Expertise in Oracle 12c/11g/10g - Installation, Upgrade, Patching with Opatch, Server Migration, licensing, storage planning, memory planning, storage allocation, configure database as per company standards.
• Set up Physical/Logical standby database, rebuilt the standby database rebuild using Cold backup, rebuilt standby using RMAN, switchover and failover the standby databases.
• Performance tuning, Memory tuning, SQL Tuning based on reports generated by SQL Trace, TKPROF, STATSPACK, Explain Plan, AWR, ADDM and monitor the database performance on daily basis.
• Maintained the databases of more than 20TB size, and databases with high end traffic
• End to End database creation for new application projects - includes requirement gathering, database storage planning, memory planning, storage allocation, database installation, configure database as per company standards.
• Partitioning tables with, range partitioning, interval partitioning and supported large partition tables. High knowledge in doing exchange partitioning of tables.
• Provide 24/7 support for the production and non-production database environments in AIX, LINUX, Solaris and windows environments.
• Handling production errors in remedy raised by users and auto managed Tivoli administrator, DB health analysis weekly, backup errors resolution, file system management and user management

Confidential

Oracle DBA

Responsibilities:

• Planning, designing, Licensing and implementing of the Cluster node, Networking setup, OS configuration and analysis was done. Involved in complete end to setup of cluster.
• End to End setup of two node RAC production and non-production environment was done. The setup was done completely in the datacenter.
• Proficient in troubleshooting RAC related issues, Node eviction and got experience in configuring stretched RAC nodes.
• The Project includes end to end from Hardware readiness, VMWare setups, IP Configuration for RAC oracle servers, OS installation, Cluster ware configuration, Grid Installation, RAC database installation, configure Shared storage ASM disks, ASM Installation and troubleshooting issues.

Confidential

Oracle DBA

Responsibilities:

• Prepare a plan for upgrade which includes downtime, hardware and software requisites.
• Migration involves partitioned tables both range partitioning and interval partitioning and supported large partition tables.
• Written SHELL Scripts in UNIX for performing this cross-platform migration.
• Export/import the database using data dump from target to source database.
• Test the upgrade by manually written PL/SQL scripts and cross-verifying the tables count and data.
• Communicating with the client and prepare DB upgrade document.

Confidential

Oracle DBA

Responsibilities:

• The dataload process done with oracle warehouse builder was re-written. Includes understanding and writing complex PL/SQL queries.
• The efficiency and performance of Data load was tremendously improved by implementing the Oracle Concept Offline data load and partition exchange.
• Create offline non-partitioned tables for the data to be loaded during non-peak hours similar to that of partitioned online tables. Modify the PL/SQL Packages which actually loads the data to the database. Create mappings and process flows in Oracle warehouse builder to make use of the packages and offline tables down under it.
• Tuning the database parameters, rebuild indexes wherever necessary and segment space management.
• Memory tuning of the database includes SGA, PGA and virtual memory tuning.
• Tuning the SQL queries based on the long elapsed time using AWR and ADDM reports.
• Experiment the different dataload and observe the time taken to improvise it more.
• Daily meeting on technical implementation with experts and weekly meeting with clients.

Confidential, Troy - MI

Database Administrator

Responsibilities:

• Created Oracle database manually and through dbca.
• Responsible for taking Incremental hot daily backups and cold backups weekly.
• Configured RMAN target db and Recovery catalog db and taken incremental hot backups.
• Taken logical backups, export/import of tables, schemas and full database.
• Datapump directory creation and logical backups using datapump.
• Cloning the production database into test database.
• Hands on experience in data-guard, creating a physical standby database.
• Listeners and TNS Services configuration for remote servers.
• Regular checking of alert log files, udump and bdump trace files and solved various db related issues.
• Oracle database Up-gradation from 10g to 11g through oracle home shifting and through DBUA.
• Monitoring & managing the tablespaces and data files growth.
• Parameter file, Archive log file and control file management.
• User account management: Creating users, managing user accounts, profiles, granting roles and privileges to users.
• Multiplexing control files and archive destinations and managing it.
• Worked with Cluster table, partition table, temporary table creation and management.
• Knowledge transfer to new joiners and assist co-workers in technical issues.