Wasi Uddin Email & Phone Number

United States

Florida, United States

• Installed configured and administered Oracle databases on 11g, 12c,18c,19c databases on AIX, Linux and Windows.• Installed and cloned oracle home binaries on several servers and documented procedure for installing/cloning oracle binaries and developed automated clone script.• Installed configured Oracle 12c and 18c Multi-Tenant Container Database, Pluggable Databases and converted many standalone databases to PDB’s.• Experienced in creating Users and providing required level of grants to USER in pluggabledatabase to avoid any excess access to users and to safeguard the database.• Experience working in Amazon Web Services (AWS) RDS migration from on-prem to cloud servers• Migrated database from on-prem Oracle database to AWS RDS Postgres and Oracle databases • Extensively worked on database Upgrades from 11g ,12c, 18 and 19c and documented procedure for DB upgrades along with Standby databases. • Implementing new database refresh processes in coordination with Unix, Storage and Application teams to support PURE storage snapshots of critical databases, effectively reducing operational recovery from 15 hours to 2 hours• Installing and configuring 13c Oracle Enterprise Manager Cloud Control and configured management agents on different targets.• Cloning/duplicating/restore database for creating testing and training environments using DD Boost for RMAN.• Expertise in troubleshooting and performance tuning for optimal performance by Query tuning, memory tuning using tools like AWR, ADDM, SQL Tuning advisor, OEM Cloud control and analyzing OS memory and CPU utilization. • Worked on in-depth query tuning like analyzing explain plans, using hints, setting baselines, profiles, creating indexes, histograms, generating SQL trace, if necessary, etc.• Performed yearly Oracle Patching (PSU, CPU and bug-fix patches) on databases that i supported.

Chevy Chase, Maryland, United States

• Responsible for administration and supporting Oracle 19c,18c,12c,11g and 10g databases in DEV, QA, UAT and Prod environments.• Pro-Active Monitoring of the Databases using 11g and 12c Enterprise Manager and fixing the issues, also working on Root Cause Analysis and documenting the issue resolution steps for future reference.• Migrating Oracle Databases from Solaris Environment to Linux Environment.• Implemented Golden Gate and unidirectional replication on RAC using ACFS file system.• Setup Golden Gate between oracle databases for active-active 2-way replication.• Installed and configured 5node 19cRAC database on Linux.• Performing cut over activity on critical oracle databases on every month• Involved in adding a node to a 3 node RAC cluster and supported the database after the post implementation.• Involved in installation and maintained the Oracle Data guard Setup for a production environment and did support the Data guard related issues till date.• Maintained databases of around 9TB.• Developed Database Provisioning Automation Tool using Python/shell scripts. Created scripts with python and YML in ansible.• Created and managed database objects such as tables, indexes, partition tables and views. • Created and managed users, roles, privileges, profiles, schemas using OEM.• Performing day-to-day database administration tasks like tablespace usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc.• Involved in configuring and setup of oracle 11g Data guard using RMAN duplicate method.• Worked on Automatic Storage Management (ASM) for managing data in SAN.• Setup notifications (various levels for Cluster activities, tablespace utilizations, Listener alerts) using OEM.• Manage data architects, data administrators and client enhancement requests.• Have setup snapshot replication database for reporting purpose.

Michigan, United States

• Maintaining of Oracle 11g and 12c on RHEL 5.1 and 7.3 Versions.• Upgrade/ Migration of Databases from Oracle 11.2.0.3, 11.2.0.4 to 12.1.0.2 version.• Documenting, creating POC on testing newer versions of Oracle Releases 18c.• Successfully upgraded 12c (12.2.0.1) GRID and databases to 19c (19.0.0.3) on a standalone system. • Worked on upgrades of the engineered systems (ODA). • ODA (Oracle Database Appliances) upgrades include the oak version (12.1.2.5 to 12.2.1.4) and also DB home. • Actively been part of consolidating 2 datacenter’s and migrating them to national dc centers depending on the application request. • Create Best practice documents for all the ODA upgrade by educating Team members to follow standard process during maintenance.• Gathering business requirements and designing, implementing multiple projects along with production support.• Creation, Configuration and Setting up of RMAN Catalog databases and registering target Databases with the Catalog. • Setting up and managing Hot and Cold Backups, Exports, Imports.• Migrating huge database from 11.2.0.4 to 12.1.0.2 via export and import data pump utility.• Recovered a database which was completely decommissioned using tape backups.• Refresh the test and development databases from the source production databases on a regular basis using export/import utility.• Successfully maintained multiple databases. Implemented Grid Control for managing databases.• OEM setup for Monitoring and Alerts Management.• Generated AWR reports from Oracle 11g/12c database and analyzed the reports for Oracle wait events, time consuming SQL queries, tablespace growth, database growth.• Used Explain Plan, Oracle hints and creation of new indexes to improve the performance of SQL statements.

India

• Installation, Configuration, Designing and Maintaining of Oracle 11g, 12c on RHEL 5.1 and 6.1 Versions.• Installed and Configured Oracle 11g (3 node RAC) CRS using ASM, 11.2.0.3 RAC (2 node cluster) using GI setup.• Upgrade/Migration of Databases from Oracle 11.2.0.2 to 11.2.0.3.• Implemented ASM on RAC and stand-alone databases. Managing disks and disk groups with ASM.• Setup Integrated Extracts, replicates and convert them to coordinated replicates as per need basis.• Implemented 12c Grid control (Multi OMS architecture) on 11.2.0.3 database, Standby OMS architecture is under progress.• Refresh the test and development databases from the source production databases on a regular basis using export/import utility.• Worked at conceptual logical physical data model level using Erwin according to requirements.• Successfully maintained multiple databases. Implemented Grid Control for managing databases.• Involved in Performance Planning and Tuning, using baselines and proactive monitoring, bottleneck elimination and the wait event interface to identify issues. • Performed production database maintenance and modifications to ensure databases are operational, as well as diagnosed and corrected any database environment problems; monitored database usage, and reported on database performance and system availability.• Worked with developers to diagnose database related application problems, provided development support to maintain application schema and distribution of data. • Performed large batch jobs, and tuning of SQL queries and database systems.• Involved in capacity planning and resource planning.

Master'S Degree, Information Technology

Bachelor'S Degree, Bachelor Of Science