| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateMohammed Ahmed Mohiuddin Email: EMAIL AVAILABLEDatabase Administrator Lead Phone: PHONE NUMBER AVAILABLESummaryOver 15 years of experience, self-motivated with strong problem-solving skills on Database Administration and (DBA) in production & lower environments.Solid experience in Oracle Exadata, Oracle 21c 19c 12c 11gR2 RAC, NON-RAC databases.Solid experience in database migration, data masking, data encryption, advanced security (ASO).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 7/8i/10g/11g/12c/19c/21c (VLDB, support 24x7) including RAC Databases, Exadata DMA, ASM, Compression, ILOM, ITIL, Golden Gate, Flashback, TDE, VPD, Oracle Text, Intermedia, DG, RMAN and meets SLAs and timely project deliveries.Proficient and experienced in DB2 database administration, management, and support for DB2 LUW 10/11 standalone and HADR-enabled databases.Proficient in Implementing Oracle Applications and Programming in SQL, PL/SQL triggers, procedures, functions, packages for reporting, and other functions also proficient in system administration volume manager for OEL, RH Linux, Sun Solaris, HP-UX, and Windows Enterprise Servers.Extensive experience in physical and logical database design, database partitioning, performance tuning, database application tuning analysis, database security, and setting up policies for backup and media recovery using RMAN, DataGuard databases and FRA, snapshot, snap clone, and active standby database server.Administered Oracle Clusterware and resources on 11g 12g 19c 21c using CRSCTL/SRVCTL.Proactive monitoring and diagnosed symptoms using OEM (Enterprise Manager) to significantly increase the probability of success of production databases & applications.Experience in resolving complex restore and recovery issues using RMAN.Experience in Unix Shell Scripting for automating the DBA tasks like User Management, Performance Monitoring, Disk Management, Memory Usage, ExaCC, DCLI, CLI, TFA, Exachk and File system Monitoring.SQL Tunning, End-user tuning and troubleshooting using various tools like Explain Plan, SQL Trace, AWR, ADDM, ASH, V$ performance views and cloning of Databases.Hands-on experience in software and firmware full stack maintenance of Exadata database machine including upgrade and patching.Provide and implement performance tuning recommendations of all components in Exadata database machine.Integration of Exadata monitoring and escalation into existing IT monitoring and actionable events solutions.Worked on building and rolling out new 19c databases for TEST/DEV/QA/PROD environments.Migration of legacy databases to from 11gR2 -> 12cR1 -> 12cR2 -> 19cR13.Software and firmware maintenance of Exadata Storage servers & compute nodes including routine health check, patching and upgrades and co-ordination of Oracle advance support.In-depth understanding of SOX, PCI & HIPAA (PHI & PHII) database security compliance, authentication, and backup procedures to ensure the integrity of databases.Technical SkillsHardwareAIX, HP, Sun E25K, EMC, Exadata, EVA, Dell PowerEdge, Compaq Proliant, IntelOSSun 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, ASM, CLI, ACFS, RACTraditionalRDBMS/ServersOracle 21c, Oracle 19c, Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i, RAC, Oracle 9i, 9i AS, Oracle 8x, OEM, Grid, Flex, SQL Server, MS Access, BI, My SQL, DB2, Sybase IQ, AES, ADABAS, Mongo, PostgresSQL, Cloud ControlExposureApache, Hadoop, Big DataApplianceNetezza, Exadata, ExacloudLanguages/ToolsSQL, PL/SQL, UNIX Shells, Cronjob, KSH, SED, AWK, Ansible, Terraform, 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, PostgreSql, DCLI, TFAFlyway, ER-Studio, Advent Net SwisSql, Erwin, eProgessa, SqlNet, TOAD, Talend, Autosys, Embarcadero DBArtisan, ER Architect, Change Manager, VBnet, Rapidwiz, ASPNET, Visual Studio, Java JDBC, JQuery HTML CSS XML XSLT, MDM, SQLT,PgAdmin,SQLHP Quality Center QA testing, Precise, Confio, Visio, SSMA, Mongo Booster,Redis, ODSM, Directory Manager, Apache Studio, SQL*Plus, DCLI, IORM, EXAchk, TFA, RCA, RCU, OCI, DBAAS, Jira, SharePoint, Kronos, SQLways, Remedy, Wily & AWS RDS, EC2, Cloud Watch, VPC, S3, Exachk, Aurora, Delphix, SNOWApplicationServersOracle 10g/11g Internet Directory (OID), OAM, SSO, Content Management, Oracle 11g Fusion Middleware, Weblogic, Tomcat, JDBC, PeopleSoft, SAP, WebCenter Portal, Oracle E-Biz (EBS) r12SupportOracle High Availability Support, Oracle 19c 12c, AWS PostgreSql, Aurora, MS. SQL Server, DB2(LUW) & Other noSQL databasesCertificationOracle,10g Database Administrator (OCA/OCP)Skill SetOracle 14 Years ASM 14 Years Goldengate 5 Years EXADATA RAC 14 Years Dataguard 14Years OEM 14 Years AWS 5 YearsProfessional ExperienceWells Fargo, NC Mar 2023 - Feb 2024Sr. Database AdministratorWells Fargo is a major financial institution in the USA; I am serving as PDiLL infrastructure & remediation project in Charlotte, NCActivities:Oracle database management activities, including designing highly complex logical and physical databases over exacloud/exadata machines assisting, creating, cloning CDBs/PDBs environments.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.Providing technical leadership and recommendations for future directions of database technology and automations. Proficient in writing SQL, PL/SQL & UNIX Shell Scripting.Designing data moment DDL/DML policies to move the data & cleansed into multiple cloned environments.Developing management policies encryptions, partitioning, SQL*loader, Datapump activities, and best practices to preserve DB refreshes & cloning database schemas and used Ansible management tool for automation activities.Collaborating with APPS teams to troubleshoot various database queries performance and PL/SQL blocks.On-Call (24 x7) support performance tuning (SQL) Baselines & monitoring performance.Projects Delivery: PDiLL - 1AOR (Various)Quest Diagnostics, Norristown, PA Jun 2020 Feb 2023Sr. Database Administrator LeadQuest Diagnostics is a major clinical laboratory, that brings health technology for all, HQ in Secaucus, NJActivities:Worked on Lab Databases installation, configuration, and patching of on-premises Oracle 19C 21c on Exadata Excloud Machines management.Worked on Exadata X2, X3, X6 and X8M machines which included Quad, Half & Full Rack.Migrated 75+ 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 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 data masking activities by using PL SQL blocks.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, TDE, Oracle Networking, Multi-tenant CDB PDB Creations/Cloning, RMAN, compression and deployments.Database Admin for Exadata machines to keep the databases up to date by Firmware upgrade patches, creating new pdbs and cloning of pdbs. Storage Space management.Maintained legacy Oracle RAC databases daily deployments for applications schemas and migrating them into Exadata databases using GoldenGate and Datapump.Exadata QUAD, HALF & Full stack patching activities in X6 & X8 machines and co-ordinated with Oracle Adv support on performance recommendations of all components of Exadata machine.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 CPU allocations using resource manager plans.OEM client setup monitoring, ASM disk groups, space management and lift & shift DB operations of the data center. And other technologies.DevOps engineering, design & administration, leading information technology solutions for on-prem cloud environments and is not limited to Oracle (OCI) RDBMS databases, SQL Server, AWS EC2, RDS infrastructures and deployments using Ansible management & Terraform tools for automation. And POC on migrating Oracle on premise databases to Oracle Cloud Infrastructure.Consolidation of small RDBMS oracle database schemas into on-premises cloud application databases.On-Call (24 x7) support performance tuning (SQL) Baselines with Oracle Data Guard Databases, AWS EC2 RDS, OCI and Datacenter maintenance support.Projects Delivery: DLP (Various)Walgreens, Deerfield, IL Jan 2020 Mar 2020Sr. Infrastructure Engineer Database ArchitectWalgreens is the first major drugstore chain to put prescriptions into child-resistant containers, HQ in Deerfield, IL.Activities:Provided services to Oracle & NoSQL Databases MongoDB Instances, including architecting 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 data.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'sProjects Delivery: CCPAKaiser Permanente, Pleasanton, CA Aug 2018 Dec 2019Sr. Oracle Database AdministratorKP.org is a United States-CA State based Hospitals & Health Care Service provider, Head Quarters in Pleasanton, CAActivities: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.Provided services to kp.org databases applications performance tuning, and other applications.Provided services to Data Refresh activities and RMAN backups.Provided services to co-ordinate patch of databases.Provided services to co-ordinate upgrade & migration of databases.Provided services to dataloading and data management.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 support.Database deployment objects DML/DDL in the combination of Goldengate activities.Advanced database services included but not limited to: deployments, performance Tuning, root causeanalysis, 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, Oracle cloud maintenance and AWS RDS, EC2, S3 Backup storage implementations.Databases monitoring, troubleshooting, Exadata support, Oracle 13c OEM, RMAN, ERWin, TOAD, SQLDeveloper, OEM, BigBucket, Sharepoint, Jira, Teams & Day to Day (SLAs) activities.Provided 24x7 production Exadata support, Goldengate, Veridata, Oracle databases.Projects Delivered: WPP & WPPIState of California - Sacramento, CA May 2017 Feb 2018Database AdministratorDHCS is a United States-CA State based Health Care (MMIS) Service provider, Head Quarters in Sacramento, CAActivities: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 Databases.Provided services to COTS(EMPTORIS), MMIS HADR applications and Other applications.Provided Oracle Database Installation & Migration services to datacenter move and (lift & shift) services.Provided services to patch/upgrade/migration of Oracle databases.Migration and upgrade of Oracle Database 10g/11g on Rahat Linux platform to Oracle Database 12c on Exadata X6 by using GoldenGate and Oracle Datapump and basic machine administration.Provided 24x7 production HIPPA (PHI & PHII) compliance databases and applications support.Proficient in writing SQL, PL/SQL & UNIX Shell Scripting.Expertise design of 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.Max databases handles varies from 700GB to 20TB in Size.Provided services to 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 EMPTORIST-Mobile Bellevue, WA Dec 2015 Nov 2016Database Project Advisor AdministratorCOMCAST Mt Laurel, NJ Nov 2014 Nov 2015Oracle Database Administrator ArchitectGlobalNet, Rockville, MD Apr 2014 Sep 2014Database Administrator ArchitectAARP - American Association of Retired Persons, Rockville, MD Nov 2007 Feb 2014Database AdministratorAmerican Red Cross, Fairfax, VA Aug 2006 Sep 2007Oracle Technical DBA/ConsultantEducation And CertificationsMasters in mathematics, Osmania University, India, 1993Bachelors in mathematics, Osmania University, India, 1989PG Diploma in Computer Programming and Database Management, 1992Oracle 11g Internet Directory Certification, 2010Oracle 10g Internet Directory Certification, 2009Certification in Oracle Database Administration, 10g Oracle Certified, 2006AWS Solution Architect Certification Course Completed, 2023 |
