Oracle Database On-Site

Mohammed Ahmed Mohiuddin Email: *********@*****.***

Senior Database Administrator Ph. +1-301-***-****

Summary

•Over 15+ years of experience, self-motivated with strong problem-solving skills on Oracle Database Administration along with DB2, PostgreSQL in AWS & OCI cloud environments.

•Solid experience in Oracle Exadata, Oracle 21c 19c 12c RAC, NON-RAC databases.

•Solid experience in data masking, data encryption, advanced security, database auditing, wallet management and knowledge of OKV.

•Solid experience in on-premises Exacloud (OCI) Oracle21c 19c 12c multi-tenant management.

•Subject Manager Expert in Oracle Database (nonRAC RAC), Active Data Guard, and on-premises Oracle cloud (OCI) and AWS EC2 RDS single instance database cloud environments.

•Expertise in Database Project Security Compliance Analysis, negotiating timelines requirements, Installation, Upgrade, Migrate, Convert, and administration of Oracle Database versions starting from 9i/10g/11g/12c/19c/21c (VLDB, support 24x7) including RAC Databases, Exadata DMA, ASM, Compression, ILOM, ITIL, Key Management, Golden Gate, Flashback, TDE, TLS, Data Masking, VPD, Vault, Oracle Text, Intermedia, DG, RMAN and meets SLAs and timely project deliveries.

•Proficient and experienced in Sybase ASE, DB2 database administration, management, and support for DB2 LUW 10/11 standalone and HADR-enabled databases.

•Proficient in installation, configuration, migration, monitor, upgrade of AWS EC2 RDS, Aurora, Dynamo, PostgreSQL, Redshift, Glu data modeling for ETL processes. PostgreSQL Tuning to meet the client expectations (Auto Vacuum) to release space, up to date table stats. Maintenance of cloud databases, master slave clusters utilizing streaming replication, WAL management, snapshots, schema management, tables, indexes, views, partitioning and implementation of backup & recovery. Database sizing, hardening of user accounts & privileges including automation.

•Proficient in managing standby & read replicas and used log analysis tools i.e. pgfouine and pgbadger.

•Proficient in web connectivity, physical structure Implementations of various Cloud Databases Applications and Programming in SQL, PL/SQL triggers, procedures, functions, packages for reporting, and other functions also proficient in system administration DIMM, Storage, volume manager, Oracle OEL, RH Linux, Sun Solaris, HP-UX, NFS, SAN and Windows Enterprise Servers.

•Develop project plans and configure physical database cloud environments in AWS migration & OCI on-prem ExaC&C environments. Provided inputs to projects and oversees the tactical aspects of all databases related tasks by developing modules Infrastructure as Code (IaC) using Ansible & Terraform.

•Migration of on-premises legacy Oracle databases to PostgreSQL databases in AWS cloud.

•Performance monitoring and optimization tools used Nagios for PostgreSQL and Oracle.

•Proficient in maintaining DB2 database and manage HADR and ensure the integrity of IBM DB2 LUW.

•Maintenance custom vacuum strategies at table and database level to release unused space.

•Proactive in applying Oracle & PostgreSQL latest security patches and performing minor & major updates using minimal downtimes with timely notification and approvals.

•Diagnose and resolve and implement preventive measures to prevent problems for availability, recoverability and performance of all supported database environments.

•In-depth understanding of SOX, PCI & HIPAA (PHI & PHII) database security compliance, authentication, and backup procedures to ensure the integrity of databases.

•Working closely with Oracle & PostgreSQL community group for troubleshooting the performance issues and used Query Plan Management (QPM) & OEM and AWS cloud charts & performance tools.

•Participating in weekly maintenance decision making, long weeklong 24 x7 on-call rotations & activities.

Technical Skills

Hardware

AIX, HP, Sun E25K, EMC, Exadata, EVA, Dell PowerEdge, Compaq Proliant, AMD, Intel, Bare Metal

OS

Sun Solaris E25K, HP-UX, Mobile Laptop, SFRAC, Exadata, Linux, EMC, EVA, XP Storages, OEL, Red Hat Linux Advance Server, Windows NT/2000/2003/2008; AIX (IBM) Unix, Raid 10 Raid 5, VMs, Raw Devices, ESXi, ASM, CLI, ACFS, RAC

Traditional/Cloud

RDBMS/Servers

OCI, AWS, Oracle 21c, Oracle 19c, Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i, RAC, Oracle 8x, OEM, Grid, ASM, Flex ASM, SQL Server, MS Access, MySQL, DB2, Sybase IQ, AES, ADABAS, BI, Arora DB, Dynamo DB, MSSQL, Mongo, PostgreSQL, Casandra, Cloud Control (OEM)

Exposure

AWS,EC2,RDS,GLU,RedShift,ETL,CloudWatch,Apache,Hadoop,BigData

Appliance

Netezza, Exadata, Exacloud

Languages/Tools

UNIX Shells, Cronjob, KSH, SED, AWK, Ansible, Terraform, Database Auditing, Apex, SQL Developer, BMC Patrol, Informatica, CRS, Scan, Smart Scan, Storage Index, CLI, OEM, Wallet Manager, RMAN, EUS, ERP, FRA, Data Guard, Streams, Golden Gate, ORAPKI, Oracle Key Vault, Wallets, MKSTORE, PostgreSQL, PGSQL, PGPOOL, PGBouncer,DCLI, TFA, DBAASCLI, DCLI, ILOM, Patchmgr, datapatch, Flyway, ER-Studio, Advent Net SwisSql, Erwin, eProgessa, SqlNet, TOAD, Talend, Autosys, Embarcadero DBArtisan, ER Architect, Change Manager, OBIEE, CI/CD, Rapidwiz, ASPNET, Visual Studio, Java JDBC, jQuery HTML CSS XML XSLT, MDM, SQLT, PgAdmin, SQL,HP Quality Center QA testing, Precise, Confio, Visio, SSMA,Redis, ODSM, Directory Manager, Apache Studio, SQL*Plus, SQL, PLSQL, DCLI, TDE,IORM, EXAchk, TFA, RCA, RCU, OCI, DBAAS, SoS, Jira, SharePoint, Kronos, SQLways, Remedy, Wily & AWS RDS, EC2, Lamda, Cloud Watch, Performance Insight, GitHub/GitLab, CI/CD,VPC, S3, Aurora, Delphix, SNOW, Visual Studio

Application/Middleware

Servers

Oracle 10g/11g Internet Directory (OID), OAM, SSO, IAM, S3, Content Management, Oracle 11g Fusion Middleware, Weblogic, Tomcat, JDBC, PeopleSoft, SAP, WebCenter Portal, Oracle E-Biz (EBS) r12

Support

Oracle High Availability Support, Oracle 19c 12c, AWS PostgreSql, AWS Aurora, MS. SQL Server, DB2(LUW) & Other noSQL databases,

Certification

Oracle,10g Database Administrator (OCA/OCP)

Skill Set

Oracle RAC 15 Years ASM 15 Goldengate 5 Exacloud/EXADATA CDB/PDB 8 Data guard OEM 14 DB2 LUW 5 AWS 5 Red Shift 1 PostgreSQL 5 MsSQL 1 Aurora 1 Dynamo 1 Performance insight 1

Professional Experience:

Installation, Configuration, Replication, Migration, Cloning, Duplication, Upgrade, Patching Single & Clustered (RAC), CDB, PDB, Active Standby, Goldengate Replication, Datapump, Sql*Loader, TLS, TDE, Wallet, RMAN, OEM, backup recoveries, Read-Replica, Cell Disk/Dimm provisioning, Storage and user/space management in Oracle, PostgreSQL, Dynamo, Aurora & DB2 databases

Proficient in AWS EC2 & RDS cloud databases

Proficient in RDS & EC2 Databases full stack management & connectivity

Proficient in PostgreSQL Red Shift OLAP & Glu Data Modeling & data Loading

Proficient in OCI (Oracle ExaCC) on-premises multi-Tenant databases

Proficient in DMA (Exadata Machine Administration)

Proficient in Sybase and DB2 Databases

Sr. Database Administrator

Wells Fargo, NC Mar 2023 - Feb 2024

Wells Fargo is a major financial institution in the USA, I am serving as PDiLL infrastructure & remediation project in Charlotte, NC

Activities:

Oracle 19c database management activities, designing highly complex RAC CDB/PDB multi-tenant architecture database and physical standby databases over exacloud/exadata machines assisting, creating, cloning of CDBs/PDBs environments.

Assisted in the migration of databases systems during upgrades, achieving a seamless transition with zero downtime recorded and consolidated client database infrastructures using multi-tenant architecture.

Leading highly complex data modeling, mapping, integration, and capacity planning efforts.

Designing and implementing database security solutions including auditing.

Coordinating and advising multiple clients on high impact data & database management issues.

Providing database design direction & solutions in DB reorg, account preservation, tokenized, de-tokenized accounts. Monitored database for blocking sessions & long running scripts.

Optimized Oracle database bulk data processing and tunned billions of records increased 30% efficiency.

Providing technical leadership & recommendations for future directions of DB technology and automations using Terraform. Proficient in writing SQL, PL/SQL & UNIX Shell Scripting and used CSV system.

Designing data moment Oracle provisioning, datapump and DDL/DML procedure, policies & functions to move the data into multiple cloned environments.

Developing management policies encryptions, TDE, Data Masking, partitioning, SQL*loader, Datapump activities, and best practices to preserve DB refreshes & cloning database schemas and used Terraform automation management tool to design various automation activities, database auditing and recoveries.

Collaborating with APPS teams to troubleshoot various database queries performance and PL/SQL blocks.

Daily schema (DDL/DML) deployments operations, metadata, masking data loading, validations and report.

Ensure optimum performance at all times., On-Call (24 x7) support performance tuning (SQL) Baselines & monitoring.

Projects Delivery: PDiLL - 1AOR (Various)

Quest Diagnostics, Norristown, PA Jun 2020 – Feb 2023

Sr. Database Administrator Lead Apr 2024 – July 2024

Quest Diagnostics is a major clinical laboratory, that brings health technology for all, HQ in Secaucus, NJ

Activities:

Worked on Lab Databases installation, configuration, and patching of on-premises Oracle 19C 21c on Exadata Excloud Machines management X2, X6 and X8M machines which included Quad, Half & Full Rack.

Migrated databases from old Exadata X2, X3 to Exadata X6 and X8M machines.

Configuration and modification of Exadata X6 & X8M machines per oracle recommendations after handed over the Exadata machines. Worked with Oracle storage team in setting up networker & Datadomain backups on Exadata. Worked on setting up agents on Exadata machines for monitoring. Monitoring for 24 x 7 all the environments specially in production environments.

Exadata maintenance activities on Cells Disks & Memory DIMMs and replacement of Cell storage servers.

Refreshed the databases of Lab from production to lower environments and masking by using datapump and involve TDE wallet, data masking, auditing activities.

Conducted Quarterly Patching Oracle 19C on the following databases- development, test, and stage.

Worked extensively on all the security areas of the HIPAA compliance Oracle 11g 12c 19c databases, (Multi- tenant Container/PDB), storage (ASM), AWS, Active Data Guard, User management, OWM, database auditing, Wallet management, TDE, Data Masking, Database Auditing, security hardening, Oracle Networking, Multi-tenant CDB PDB Creations/Cloning, RMAN, compression, NFS mount and deployments.

For modernization project, analysis of legacy on-prem databases to Install, configuration, migration, monitor to AWS Aurora, Dynamo, PostgreSQL, and Redshift, Glu data modeling for ETL processes.

Tune to meet the exclusive client expectations PostgreSQL (PSQL & PGAdmin) client connectivity, replication. Auto Vacuum to release space, up to date table statistics. Maintenance of cloud databases master slave clusters utilizing streaming replication, schema, WAL management, tables, indexes, views, partitioning and implement backup & recovery. Database sizing, hardening of user accounts & privileges.

Created and managing standby & read replicas and used log analysis tools i.e. pgfouine and pgbadger.

Provided web connectivity, physical structure Implementations of various Cloud Databases Applications and Programming in SQL, PL/SQL triggers, procedures, functions, packages for reporting, and other functions also proficient in system administration DIMM, Storage, volume manager for AWS, Oracle OEL, RH Linux, Sun Solaris, HP-UX, and Windows Enterprise Servers.

Developed project plans and configure Oracle Goldengate to migrate large databases with no downtime.

Provided inputs to the team members & oversees the tactical aspects of all the targeted database’s related tasks and developed modules, consistent provisioning, repetitive tasks on IaC using Terraform.

Migration of on-premises legacy Oracle databases to PostgreSQL databases in AWS cloud and created new cloud databases Microsoft SQL Server, PostgreSQL & NoSQL databases.

Pretty flexible on adaptable to changing environments, proactive in learning and a team player exceptional verbal, writing analytical and possesses problem solving skills in Oracle, MySQL, PostgreSQL & redshift.

Performance monitoring and optimization tools used Nagios, cloud watch for PostgreSQL and Oracle.

Maintenance custom vacuum strategies at table and database level to release unused space.

Proactive in applying full stack Oracle Exadata firmware patching and PostgreSQL latest security patches and performing minor & major updates using minimal downtimes with timely notification and approvals.

Working closely with Oracle & PostgreSQL community group for troubleshooting the performance issues and used Query Plan Management (QPM) & OEM.

Database Admin for On-Prem Exadata/ExaCloud machines to keep the databases up to date by applying Firmware upgrade patches, ACFS, ASM, creation of new database homes, pdb’s and cloning of pdb’s. Storage Space management, memory management and RMAN Backup & Recoveries.

Maintained legacy Oracle RAC databases daily deployments for applications schemas and migrating them into Exadata databases using Goldengate and Datapump.

Exadata Full stack patching activities in X6 & X8 machines and coordinated with Oracle Adv support (ASR) on performance recommendations of all components of Exadata machine and Cell management.

Scheduling access to datacenter activities including software & firmware maintenance of Exadata storage servers including routine health check for pre/post-patching and co-ordination with Oracle Adv support.

Tuned of SQL queries baselines, explain plans, profiles, blocking sessions, deadlocks and on demand memory & CPU allocations using resource manager plans and Cell administration & management.

OEM client setup monitoring, ASM disk groups, space management and lift & shift DB operations of the data center. And other technologies supporting DevOps engineering operations, design & administration, leading information technology solutions for on-prem cloud environments and is not limited to Oracle (OCI) RDBMS databases, DB2, Sybase, SQL Server, AWS EC2, RDS infrastructures and deployments using management of Terraform tool for automation. And POC on migrating Oracle on premise databases to OCI.

Data consolidation from DB2, PostgreSQL, Oracle, JSON, Text, XML & CSV formats into local NFS drives & AWS S3 Buckets Storage and processed into Redshift DWH processes.

Consolidation of small RDBMS oracle database schemas into on-premises cloud application databases.

Pretty flexible on adaptable to changing environments, proactive and team player exceptional verbal, writing analytical and possesses problem solving skills in Oracle, MySQL, PostgreSQL & redshift.

On-Call (24 x7) support performance tuning (SQL) Baselines with Oracle Data Guard Databases, AWS EC2 RDS, OCI, Datacenter maintenance support, Deployments using SNOW tickets and documentations.

Projects Delivery: DLP, ECQ, MDM (Various)

Walgreens, Deerfield, IL Jan 2020 – Mar 2020

Sr. Infrastructure Architect

Walgreens is the first major drugstores to put prescriptions into child-resistant containers, HQ in Deerfield, IL.

Activities:

Provided services to Oracle & NoSQL (MongoDB) Instances, including architecting Oracle 19c Databases.

Ensured that the databases achieve maximum performance and availability & designing indexing strategies.

Advises on the configuration, monitoring and deployment of replica sets.

Optimization of Oracle, PostgreSQL, Aurora & MongoDB queries and improved performance.

Implementation of best practices for Rest API integration framework/model.

Optimized insertions and retrieval of large amounts of xml data using Python(psycopg2) into PostgreSQL.

Working on designing systems that deal with large data sets and a huge volume of transactions.

Knowledge of best patterns and practices for designing document & collections.

Beside Oracle Databases performance tuning, Working on MongoDB driver, Mongo Shell, Mongoose, Compass, and API's

Projects Delivery: CCPA

Kaiser Permanente, Pleasanton, CA Aug 2018 – Dec 2019

Sr. Database Administrator

KP.org is a United States-CA State based Hospitals & Health Care Service provider, Head Quarters in Pleasanton, CA

Activities:

Provided Database service to Oracle RAC 11g 12c databases and Oracle Exadata 11g 12c databases on contract CTS project as an Oracle Performance Tuning enforcing standards and on-call support to High Availability Databases.

Creation & implementation of Oracle & PostgreSQL AWS RDS, EC2, S3 Backup storage and migration of data using CSV files from multiple customers.

Provided services to kp.org databases applications performance tuning, and other applications. Services to Data Refresh activities and RMAN backups. Services to co-ordinate patch of databases. Services to co-ordinate upgrade & migration of databases. Services to data loading, data management and DB auditing.

Proficient in using various database Utilities like EXPORT/IMPORT, Datapump, SQL*Loader & RMAN.

Experience with ASM, OEM, UNIX, RMAN, DATA GUARD, SKYTAP and Goldengate.

Performed database management functions such as maintenance, access issues and security.

Provided and analyzed TOP SQL queries, AWR, ADDM and providing solution to enhance performances.

Provided 24x7 production HIPPA (PHI & PHII) compliance databases and daily deployment support.

Database deployment objects DML/DDL in the combination of Goldengate activities.

Advanced database services included but not limited to deployments, performance Tuning, root cause

analysis, system monitoring, problem troubleshooting, capacity planning, application workload analysis, Replay testing, data quality and validation, incident, FCAB reviews, approvals and release management, security review, database upgrade and migration, patching system hardening, patch analysis and bug escalation with product development, HA/DR planning, 24 x 7 management.

Databases upgrading, cloning, monitoring; Exadata support on Ora12c RAC CDB, PDB; Oracle 13c OEM, RMAN, TOAD, SQL Developer, OEM, BigBucket, GiT, SharePoint, Jira, Teams & Day to Day (SLAs).

Provided 24x7 production Exadata support, Goldengate, Veridata, Oracle databases.

Projects Delivered: WPP & WPPI

State of California - Sacramento, CA May 2017 – Feb 2018

Database Administrator

DHCS is a United States-CA State based Health Care (MMIS) Service provider, Head Quarters in Sacramento, CA

Activities:

Provided Database service to DB2 databases and Oracle 10g 11gR2 replacement project databases on Infinite contract project as an Oracle Database Administrator on-site and on-call support to High Availability RAC Databases.

Provided services to COTS(EMPTORIS), MMIS DB2 HADR applications and Other applications.

Provided Oracle & DB2 Database Installation & Migration services to datacenter move and (lift & shift).

Provided services to patch/upgrade/migration of DB2 & Oracle databases.

Migration and upgrade of DB2 11.5 LUW & Oracle Database 10g/11g on Redhat Linux platform to Oracle Database 12c on Exadata X6 by using Goldengate & Oracle Datapump and basic machine administration.

Provided 24x7 production HIPPA (PHI & PHII) compliance DB2 & Oracle databases and applications support.

Proficient in writing SQL, PL/SQL & UNIX Shell Scripting.

Expertise data modelling design of DB2 LUW HADR & Oracle Schemas, tables, triggers, packages, procedures, DB links, views, sequence, constraints, and indexes.

Oracle Golden Gate implementation for Site-to-Site Replication, ASO, Data Masking, Encryption, table partitioning, ReORG technique.

Architect, Deployed, and Maintained ad-hoc databases, handles vary from 700GB to 20TB in Size.

Provided services to development & production activities, user management, triage/bridges, troubleshooting & performance tuning. And Provided 24x7 production Exadata support, Goldengate, DB2, Oracle databases.

Projects delivered: HE MMIS ORR COTS EMPTORIS

T-Mobile – Bellevue, WA Dec 2015 – Nov 2016

Database Project Advisor Administrator

Activities:

Provided Oracle Database & Oracle Goldengate replication services using Oracle RAC 11g 12c databases

COMCAST – Mt Laurel, NJ Nov 2014 – Nov 2015

Oracle Database Administrator Architect

Activities:

Provided Oracle Database using Oracle RAC 11g databases

GlobalNet, Rockville, MD Apr 2014 – Sep 2014

Database Administrator Architect

Activities:

Provided Oracle Database services using Oracle RAC 11g databases

AARP - American Association of Retired Persons, Rockville, MD Nov 2007 – Feb 2014

Database Administrator

Activities:

Provided AWS EC2, RDS, Oracle, Dataguard, Physical standby databases, Goldengate replication services, RAC, Installation, upgrade, patching, cloning, migration, data movement, RMAN backup, Networking, NFS & OEM activities from Oracle 9i/10g/11g/12c databases and Fusion Middleware (OID) stack.

Worked on seasonal consulting basis.

Education And Certifications

Master’s in mathematics, Osmania University, India

Bachelor’s in mathematics, Osmania University, India

PG Diploma in Computer Programming and Database Management

Certification in Oracle Database Administration, 10g Oracle Certification, 2006

Oracle 10g Internet Directory Certification, 2009

Oracle 11g Internet Directory Certification, 2010

AWS Solution Architect Certification Course Completed, 2023

Oracle 23ai Database Administration Course Completed, 2024

Contact this candidate