Harshul Shah
Cell: 713-***-****
Email: ad5d2d@r.postjobfree.com
www.linkedin.com/in/harshul-shah
PROFESSIONAL SUMMARY:
●Oracle Certified Professional with over 15 years of experience in Oracle Database Administration, specializing in supporting Oracle 9i/10g/11g/12c
●Strong knowledge in Oracle RDBMS and all areas of Database Administration with environment sizes up to 15 TBs.
●Experienced in Installation, Configuration and Administration of Oracle RAC and Non-RAC 10g/11g databases.
●Proficient in configuring and troubleshooting Oracle Data Guard for disaster recovery purposes and Goldengate for replication purpose.
●Extensive experience in performing backups and testing crash recoveries using hot/cold backups and utilizing Recovery Manager (RMAN).
●Proficient experience in Monitoring, Performance tuning, Managing Devices and Database (Indexing, Normalization) also effective in using Oracle Enterprise Manager (OEM)
●Performance Tuning using SQL Tuning Advisor, Explain Plan, Rebuilding Indexes
●Experienced on AWS database Technologies.
TECHNICAL SUMMARY:
Databases: Oracle 9i/10g/11g/12c/19c
Operating System: Windows 98/2000/XP/2003/2008/2012, Linux, RedHat Linux RHEL 5, 6, 7
Other Technologies: Toad, DBArtisan, SQL developer, PL/SQL Developer, Oracle Enterprise Manager (OEM),s3, AWS RDS, aws DMS,AWS IAM.
EDUCATION AND CERTIFICATIONS:
●Bachelor of Administration from Gujarat University
●Oracle Certified Associate 12g (OCA)
●AWS Cloud Quest : Cloud Practitioner
PROFESSIONAL EXPERIENCE:
Sr Oracle DBA / AML(Anti Money Laundering) DBA
Santander Bank, Dorchester, MA Oct 2018 – Till now
●Supported the development team for their releases and worked with the team to create best practice documents.
●Setup and documented process to refresh/restore an environment from prod to different databases.
●Provided expert advice for queries and with test cases to fix the performance issues.
●Report directly to the Sr Director and provide full assistance for the overall of project.
●Setup physical Standby (Dataguard) and Step by step document process for DR.
●Step by Step documented process of installation and configuration of oracle 12c database.
●Migrate Oracle database from Onprimise to RDS using expdp.
●provided support for ETL process to ingestion of the data into data warehouse env for application using SQLLDR.
●Knowledge of AWS technologies.
●knowledge of MSSQL server backup/recovery, postgres backup/recovery using inhouse tool.
Environment: MSSQL server, postgress, oracle 12c,19c,21c(in POS), AWS.
Sr Oracle DBA
BNY Mellon, Boston, MA July 2015 – Sept 2018
●Supporting over 300 client and the 10TB databases for performance issues.
●Expertise to review the code and provide the suggestion where the bottlenecks for the performance of the query.
●Collaborated with cross-functional teams to gather requirements, define data models, and design ETL processes for data ingestion.
●Optimized data warehouse performance by fine-tuning SQL queries, indexing strategies, and database configurations.
●Conducted data profiling, analysis, and quality assurance activities to ensure accuracy and consistency of data in the data warehouse.
●Extensive experience in Oracle DBA, Oracle Golden Gate, OLTP design and implementation.
●Extensive experience in configuration of TDE for master Encryption key, Compliance, backup encryption and Data masking.
●Working knowledge with different team for SSL/TLS certification for oracle TDE authentication with monitoring and audit vault.
●Extensive experience in ASM configuration and Maintenance.
●Monitored the databases using trace file, alert log files, v$views, AWR, ADDM and OEM.
Sr Oracle DBA Feb 2014 – Jun 2015
Crunchtime, Boston, MA
●Upgraded the environment from 11.2.0.2 to 11.2.0.4 using dbua and silent upgrade.
●Documented step by step for upgrade process.
●Created, configured and monitored Oracle 11g RAC environment and documented.
●Extensive experience in ASM with RAC configuration, Maintenance, Restoring ASM.
●Setup oracle 12c multitenant database and documented steps for future installation as guide.
●Setup performance stats for the environment to gather statistics of the database.
●Backup and recovery of the database using RMAN.
●Experience with the handle 24x7 support, system monitoring, performance tuning, and analysis of database.
●Monitored the databases using trace file, alert log files, stats pack, v$views, TKProf, TRCA, AWR, ADDM and OEM.
●Expertise in resolving performance issue by setting up the oracle parameters, indexes, hints and/or locking the plan.
●Maintained OEM grid control on Linux to monitor enterprise Oracle databases.
Environment: Oracle 10g, 11g, 12c, RAC, RHEL Linux 5 Servers, RMAN
Lead Oracle DBA/ Operations Manager May 2012 – Feb 2014
Cognizant Technologies (As contractor at John Hancock Financial), Boston, MA
●Responsible for leading a team of 5 DBA’s including offshore and onsite for upgrade project from 8i, 9i to 10g 11g, supporting databases up to 5 TBs in size.
●Documents Playbook for Upgrade production database going live.
●Communicates with all offshore and onsite DBA’s for status reports.
●Documents for upgrading database from different platforms and also database version.
●Regularly sets up physical standby (DR) for all production databases utilizing DataGuard
●Documents all the logs and errors for resolution at production cutover.
●Provide support to Development team by reviewing the awr for the bad sql and helped to reformat in the manner where query can provide result fast.
●Responsible for troubleshooting and resolving any database and application issues or errors that occurred in production environment.
●Extensive knowledge of resolving application code issues using awr, addm, tkprof, explain plan.
●Performs RMAN Backup and Recovery using without catalog database and with catalog database.
●Extensive experience with RMAN, responsible for cloning the database for production testing purposes.
●Expertise in resolving performance issue by setting up the oracle parameters.
●Week to week presentation for DBA meeting with client for project as reference.
●Responsible for creating, configuring and administering Oracle database using OEM Single instance and recently Real Application Clusters (RAC) on ASM.
Environment: Oracle 10g, 11g, Sun Solaris 9 and 10, RAC, RHEL Linux 5 Servers, DataGuard, RMAN
Lead Oracle DBA/ Project Manager May 2011 – Apr 2012
TCS (As consultant at 21st Century), Wilmington, DE
●Documented for upgrading 10g to 11gR2 in Data warehouse.
●Created and maintained Document for all issues or errors.
●Supporting team of 2 offshore DBA’s and team of developers as needed on different time zones.
●Communicated with 3rd party companies for support as needed.
●Supporting 10g Data warehouse as needed for production release and development.
●Configure and managed backup locations and files.
●Backup and recovery of the database using RMAN.
●Experience with the handle 24x7 support, system monitoring, performance tuning, and analysis of database.
●Monitored the databases using trace file, alert log files, stats pack, v$views, TKProf, TRCA, AWR, ADDM and OEM.
●Install and configure new database and server in OEM.
●Working knowledge on Ebuisiness Suites based on client’s requirements.
●Extensively worked with the data modeling team to understand the requirements and provide the best solution to data migration project.
●Responsible for troubleshooting and resolving any database and application issues or errors that occurred in production environment.
●Modified database structures table spaces and storage allocation to support application enhancement.
●Created new databases and users: set up backups, export.
●Implemented database refresh using full export for Schema level and full database, schema stats resulting in improved performance and effective space management.
●Knowledge of Golden Gate Technologies.
Environment: Oracle 10g, 11g, Sun Solaris 5.9 and 5.10, Linux 5 Server, Erwin, informatica
Oracle DBA Feb 2011 - Apr 2011
GE Healthcare, Milwaukee, WI
●Created physical standby and configure Data Guard on 10g database environment.
●Configure and managed backup locations and files.
●Backup and recovery of the database using RMAN.
●Experience with the handle 24x7 support, security, system monitoring, reliability, performance tuning, and analysis of multiple version of Oracle.
●Created and maintained schema objects like tables and indexes, triggers, procedure, function, synonyms and sequence.
●Used to export and import of different databases using Oracle Exp/Imp and Data Pump utilities.
●Setup and support of replication using oracle streams (Physical standby database).
●Automating database daily operation and backups using Shell scripts.
Environment: Oracle 10g, Linux 5 Server, DataGuard, Oracle Streams, Shell Scripting, Grid Control.
Oracle DBA Sept 2010 – Dec 2010
Stats LLC, Chicago, IL
●Created, configured and monitored Oracle 11g RAC environment.
●Involved with database backup concepts and options: user-managed backup, RMAN-managed backup with or without catalog, cold and hot backup, full backup, and incremental cumulative and differential backup.
●Implemented physical standby database Oracle DataGuard and DataGuard Broker feature.
●Set up and maintained Oracle disaster recovery site using Data Guard.
●Proficient in performance tuning using Explain Plan, STATSPACK, AWR, TKPROF and TRCA.
●Tuned and diagnosed database performance by query optimization and trace facility.
●Created and maintained schema objects like tables and indexes, triggers, procedure, function, synonyms and sequence.
●Experienced with Oracle Database Upgrade Assistant (DBUA) for migration of databases.
●Experienced with 24x7 support, security, system monitoring, reliability, performance tuning, and analysis of multiple versions of Oracle.
●Installed, configured and maintained OEM grid control on Linux to monitor enterprise Oracle databases.
●Involved in export/import of different databases using Oracle Exp/Imp and Datapump utilities.
●Applied Oracle flashback technology for high availability and different recovery procedures for complete and incomplete recoveries depending on the type of failure.
●Tuned UNIX/Linux kernel for optimizing memory management, capacity planning and change management with help of system admin.
●Installed, configured and maintained Oracle 11g Database and OEM grid control on Linux to monitor enterprise Oracle databases.
●Monitored performance & tuned the databases using trace file, alert log files, stats pack, v$ views, TKProf, TRCA, AWR, ADDM and OEM.
●Created and maintained different database entities included tablespaces, data files; redo log files and renaming and relocating of data files on servers.
●Responsible for troubleshooting and resolving any database and/or application issues or errors that occurred in production environment.
Environment: Oracle 9i/10g/11g, RAC, Linux 5 Server, Data Guard, Streams, Shell Scripting, Grid Control, SQL*PLUS, VMS Systems.
Oracle DBA Jun 2006 - Jan 2010
SAR Enterprises, San Antonio, TX
●Set up and maintained Oracle disaster recovery site using Data Guard.
●Implemented backup and recovery solution for Oracle databases using RMAN.
●Installed, configured and maintained OEM grid control on Linux to monitor enterprise Oracle databases.
●Monitored performance and tuning of the databases using trace file, alert log files, stats pack, v$ views, TKProf, TRCA, AWR, ADDM and OEM.
●Created and maintained different database entities included tablespaces, data files; redo log files and renaming and relocating of data files on servers.
●Responsible for troubleshooting and resolving any database and application issues or errors that occurred in production environment.
●Applied Oracle flashback technology for high availability and different recovery procedures for complete and incomplete recoveries depending on the type of failure.
●Setup and support replication using Oracle streams (physical standby database, downstream replication).
●Automated database daily operation and backups using shell scripts.
●Modified database structures with DDL and DML changes including tablespaces, tables, views, triggers, stored procedures as well as configuration and storage allocation to support application enhancement.
Environment: Oracle 9i/10g, OEM, Linux AS 4 Server, DataGuard, Streams, Shell Scripting, Grid Control, SQL*Loader, SQL Analyzer, SQL*PLUS, VMWare, TOAD, SQL server 2005/2008.