Resume

Sign in

Oracle DBA Ahmed Mohiuddin

Location:
Germantown, Maryland, United States
Salary:
1
Posted:
June 13, 2018

Contact this candidate

Resume:

Mohammed Ahmed Mohiuddin (L) Sr. Database Administrator

ac5u0u@r.postjobfree.com 240-***-****

Professional Summary:

Fifteen (15) + years of experience in IT industry as a Database Administration, Database Projects Advisor (DBA) in production & development environments. Skilled in gathering, documenting Agile Waterfall project requirements, managing and reporting on project executions. Possess a track record of success delivering quality databases work on time.

Experience in Oracle 11g 12C RAC, NON-RAC databases, including database migration, data movement, data integrity, data redaction, data masking, data encryption, advance security (ASO) and database performance and exposure to AWS, Exadata, Supercluster, OEM12c 13c and Oracle12c multitenant management.

Expertise in Database Project Security Compliance Analysis, negotiating timelines requirements, Installation, Upgrade, Migrate, Convert and administration of Oracle Database versions starting from 7-10g/11g/12c (VLDB, support 24x7) including RAC Databases, Exadata DMA, Compression, ILM, ITIL, Golden Gate, Flashback, TDE, VPD, Oracle Text, Intermedia, DG, RMAN and meets SLAs and timely project deliveries.

Implemented Oracle Applications and Programming in 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.

Developed Oracle PL/SQL Packages to Scrub Data to refreshes internal lower environment databases. Transferred database Schema's to and from databases; Writing PL/SQL Stored Procedures, Packages and Triggers.

Implemented table partitioning technique and tuned performance of SQL queries used in reporting real-time statistics. Tuned Performance of SQL queries used in Oracle, Informatica & reporting Cognos and CTRL+M.

Architected, Built & maintained Oracle 11.2G RAC (ASM Real Application Cluster), Non-RAC (ASM) and File System based databases of varying sizes. Migrated Oracle 11gR2 RAC databases and non RAC databases to in-house Datacenter.

Involved on installation & configuration of SQL Server, monitoring database in Production, Staging & Development environments. Performed production support and on Call duties & involve in migrations from Oracle Databases to SQL Server vice versa.

Monitored backups, exporting/importing data, Data Pump, database full backup, incremental backups and recoveries, Flashback, Transportable Tablespaces, Partitioning, Streams, Advance Replication and applying security patches and patch sets on all database servers.

In-depth understanding SOX, PCI & HIPAA (PHI & PHII) database security compliance, authentication, and backup procedures to ensure integrity of databases. Provided 24x7 production HIPPA (PHI & PHII) compliance databases and applications support.

Technical Skills:

Hardware:

AIX, HP, Sun E25K, EMC, Exadata, EVA, Dell PowerEdge, Compaq Proliant, Intel, Gateway.

Operating Systems:

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, ASM, CLI, ACFS, RAC.

Traditional RDBMS/Servers:

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, MongoDB, Cloud Control.

Exposure:

Apache, Hadoop, Big Data, Postgress.

Appliance Exposure:

Netezza, Exadata, SuperCluster.

Languages/Tools:

SQL, PL/SQL, AWS RDS, UNIX Shells, Cronjob, KSH, SED, AWK, BMC Patrol, Informatica, CRS, Scan, Smart Scan, Storage Index, CLI, OEM, Wallet Manager, RMAN, EUS, ERP, FRA, Data Guard, Streams, Golden Gate, ORAPKI, Flyway, 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, HP Quality Center QA testing, SQLT, Precise, Confio, Visio, SSMA, SQL Developer, ODSM, Directory Manager, Apache Studio, SQL*Plus, DCLI, IORM, RCA, RCU, Jira, SharePoint, Kronos, SQLways, Remedy, & Wily.

Application Servers:

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

Support Oracle High Availability Support, POC to Oracle 12c, MS. SQL Server & Others.

Educations:

Masters in Mathematics from Osmania University, Hyderabad India in 1993.

Bachelors in Mathematics from Osmania University, Hyderabad India in 1989.

Professional Certifications:

Oracle 10g Database Administrator

Oracle 11g Internet Directory Certification 2010

Oracle 10g Internet Directory Certification 2009

Certification in Oracle Database Administration, 10g Oracle Certified, Year 2006.

Professional Work Experience:

DHCS - State of California, Sacramento, CA

Database Administrator

05/2017 – 02/2018

Projects Delivered: HE MMIS ORR COTS EMPTORIS.

Environment: Oracle 10g/11gR2, DB2 Databases, Oracle Golden Gate, SQL queries, Oracle, Informatica & reporting Cognos, Oracle 12c Enterprise Grid Control (OEM), Oracle13c (OEM), Oracle12c, ASM COTS(EMPTORIS), MMIS HADR, HIPPA (PHI & PHII), UNIX Shell Scripting, Oracle Schemas, Tables, Triggers, Packages, Procedures.

Scope:

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

Contribution:

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 Database services to datacenter move.

Provided services to Data Refresh activities and services to patch/upgrade/migration of databases.

Provided services to Oracle Goldengate.

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

Proficient in writing 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. Implemented table partitioning technique.

Tuned Performance of SQL queries used in Oracle, Informatica & reporting Cognos and CTRL+M

Max databases handles varies from 700GB to 4TB in Size.

Maintained Oracle 12c Enterprise Grid Control (OEM)and apply database patches.

POC to Oracle13c (OEM), Oracle12c upgrade and migrated from normal ASM to Flex ASM.

Provided services to maintenance activities, RMAN, user management, triage, troubleshooting & (PTO) performance tuning & optimization.

Provided 24x7 production support to Goldengate, DB2, Oracle databases.

T-Mobile, Bellevue, WA

Database Project Advisor Administrator

12/2015 – 11/2016

Projects Delivered: Device Configuration, Ph2.0 & Roaming.

Environment: Oracle Golden Gate v10/v11/v12, Oracle Golden Gate, Oracle 12c OEM, SQL queries, Oracle RAC, Non RAC DB, Sun Solaris, RHL, Oracle Schemas, tables, triggers, packages, procedures, Oracle Advanced Queue Implementation for PH2.0, (OOS), EXPORT/IMPORT, Data pump, SQL*Loader, SQL Scripts, Jira, OEM, PIER, WO, MOP.

Scope:

T-Mobile is a United States-based mobile messaging communication company Head Quarters in Bellevue, WA. Providing services to Device Configuration & Roaming clients as an Oracle Database Administrator, contract project, providing on-site and on-call support to High Availability Roaming Oracle Databases.

Contribution:

Expertise in Database Administration activities such as installation, database creation, sizing, backup and recovery, performance tuning and capacity planning.

Expertise in cloning, patches, up gradation, migration, troubleshooting, space management.

Proficient in writing 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.

Implemented table partitioning technique and tuned performance of SQL queries used in reporting real-time statistics.

Control User access and monitor space consumption.

Extensive performance tuning after migration of web based Ph2.0 applications databases and recommendations of code enhancements and implemented best practices.

Excellent experience as an Oracle RAC, Non RAC DB in various platforms such as Sun Solaris, RHL.

Extensive performance tuning of database and management of databases.

Implemented Oracle Advanced Queue Implementation for PH2.0 applications.

POC’s to Open Source databases and supported MySQL MongoDB databases in the maintenance windows.

Investigate, trace fixes and report replication failures using Log Dump.

Identify risks involved with replicating highly volatile tables (OOS) with large data volume.

Upgraded Oracle Golden Gate v10 to v11 & v12.

Configured Golden Gate to achieve unidirectional and bidirectional replication

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

Monitored database for blocking sessions & scripts.

Databases monitoring using Oracle 12c OEM, Day to Day (SLAs) activities.

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

Writing SQL scripts to monitor Archive log gaps, monitor tablespace and extent growth.

Scrum, Large scale, high volume, systems in Commercial environment online transaction processing (OLTP) 24x7 production database and applications support.

Excellent communication skills, day to day maintenance activities, automation, Jira, OEM, PIER, WO, MOP documentations, positive problem-solving skills and team building.

Comcast, Mt Laurel, NJ

Oracle Database Administrator

11/2014 – 11/2015

Projects Delivered: Commercial Price Quote (CPQ).

Environment: Oracle 11.2G RAC, Oracle PL/SQL, RMAN Backups, Data Pump, WebCenter Portal, Linux uDEV, ASM, Oracle 11gR2 Golden Gate, RAC

Scope:

Comcast is a United States-based cable company Head Quarters in Philadelphia, PA.

Contribution:

Provided services to Commercial Price Quote clients as an Oracle Database Architect/Administrator, short contract project, providing on-site and on-call support to High Availability Databases.

Architected, Built & maintained Oracle 11.2G RAC (ASM Real Application Cluster), Non-RAC (ASM) and File System based databases of varying sizes.

Architect, Built & maintained Oracle 11gR2 RAC Cluster Physical Standby active databases and Data Guard

Migrated Oracle 11gR2 RAC databases and non RAC databases to in-house Datacenter.

Developed Oracle PL/SQL Packages to Scrub Data to refreshes internal lower environment databases.

Developed RMAN Backups, Data Pump and disaster recovery management policies.

Implementation of WebCenter portal on Oracle +ASM Databases on Linux uDEV drives.

Created & Modified ASM disk groups and allocate space on devices & space management.

Expertise design of Oracle Schemas, tables, triggers, packages, procedures, db links, views, sequence, Materialized views, constraints, and indexes.

Extensive performance tuning after migration of web-based price quote applications databases and recommendations of code enhancements and implemented best practices.

Management of web applications safety and sensitive PII information including confidential sensitive information and media Information protection policies.

Worked on Oracle 11gR2 Golden Gate replication to propagate tables & schema-based replication.

Extensive performance tuning of database, and node management.

Provided Support to other Oracle Databases on rotation basis to maintain & configure RAC cluster and non-cluster databases including monitoring, Day to Day (SLAs) activities.

Excellent communication skills, day to day maintenance activities, automation, WebCenter portal, SharePoint, kronos, bruha, documentation, positive problem-solving skills and team building.

A Big Team member and work well with all levels of business & Oracle Advance Technology Team

GlobalNet Services, Inc. ASC, Rockville, MD

Database Administrator

04/2014 – 09/2014

05/2014 – 09/2014

Environment: Oracle 11g R2 Databases, EMC Documentatum Development, Oracle 11gR2 RAC (Exadata), PostgreSQL, AWS (EC2).

Scope:

Contract to Global Services Inc. of Federal Food Administration to implement Oracle Database, EMC Documentatum Development, Oracle 11gR2 RAC (Exadata), ADO historic data policy implementation, PostgreSQL, Space management and patches to single instance databases.

Contribution:

Provided day to day database admin activities to stabilize database automation and includes installation of Oracle 11g R2 Databases, and administration of Postgress migrations, AWS (EC2) managing Oracle Databases and Patches to single instance databases.

AARP - American Association of Retired Persons, Rockville, MD

Database Administrator

11/2007 – 02/2014

Projects Delivered: CTG, CCM, DSP, LCE Morris, OMQ, Tax Aide, VMIS and WAM

Environment: Oracle 11gR2 RAC, Oracle 10gR4 (OID), Oracle 11g Fusion Middleware, RAC Databases, Golden Gate, SQL Server 2005/2008, Oracle E-Biz r12, Oracle Internet Directory (OID/OVD), Oracle Databases (ODA), ASR, LDAP, Golden Gate (GG), Oracle Advance Security (ASO), SOX, Load Balancing, Observer, FSFO, Flashback, (TAF), RMAN, ASM, SSO, CRM, ERP, OEM, Grid Control, Cloud Control, AWS, RAC DBMS, Bulk load, LDAP, OIDCTL, OIDMON, DP IMP, DP EXP, SQL* Loader, VPD, TDE, Data Mining, RMAN Auxiliary, Compression, CRSCTL, SRVCTL.

Scope:

AARP is a United States-based non-governmental organization (American Association) and interest group founded in 1958 and based in Washington, DC.

Contribution:

Supported not limited to various large size databases, Virtual Machines and Oracle 11g Fusion Middleware products & Oracle Internet Directory

Installation, Configuration, Maintenance and Documentation of Oracle High Availability RAC Databases and Golden gate but not limited to SQL Server (2005/2008).

Involved on installation & configuration of SQL Server, monitoring database in Production, Staging & Development environments, Performed Production support and on Call duties & involve in migrations from Oracle Databases to SQL Server vice versa.

Installation, Configuration, Maintenance and Documentation of Oracle Databases and Fusion Middleware's Oracle E-Biz r12, Oracle Internet Directory (OID/OVD).

Expertise in conversions of single instance Oracle 10gR4 (OID) databases to Oracle 11gR2 RAC databases.

Provided 24 X 7 Support for Oracle Databases (ODA) on rotation and carried blackberry.

Expertise in maintaining & configuring RAC clustered and non-cluster databases.

Worked on cross platform Oracle Database Migrations, Conversions, Upgrades and Patching.

Worked on multi-master replication technologies using ASR, LDAP and Golden Gate (OGG).

Worked on Oracle Advance Security (ASO) using SOX compliance Transparent Data Encryption (TDE).

Worked on Data guarded Physical Standby Databases and explore Active Data Guard.

Worked on Load Balancing, Observer, FSFO, Flashback, (TAF) Transparent Application Failover.

Worked on Database Partitions, Transportable Database, Tablespaces, moving reorg objects.

Worked on RMAN Backups, Data Pump, Logical, Physical Backups, Tape NetBackup’s & disaster recovery.

Worked on created & Modified ASM disk groups and space management.

Linux/ UNIX operating system, Bash shell scripting experience for database tasks & reporting.

Extensive performance tuning of web-based Database applications, partitioning and recommendations of code enhancements includes Large objects (LOB) and secured files.

Management of web applications safety and sensitive PII information including confidential License, Credit, SSO, CRM, ERP accounts and social media Information.

Agile (Scrum) Projects code migrations, Streamlined and applied best practices to have smart work accomplishments.

Database physical & logical modeling design and implementation.

Solid Implementation & management skills on OEM, Grid Control, Cloud Control, AWS, RAC DBMS, Dataguard, Bulk load, LDAP, OIDCTL, OIDMON, DP IMP, DP EXP, SQL* Loader, VPD, TDE, Data Mining, RMAN Auxiliary, Compression, CRSCTL, SRVCTL, Storage Indexes, Smart Scan, WEB Logic, Remedy & ER Architect and DB2 databases.

American Red Cross, Fairfax, VA

Oracle Technical DBA/Consultant

08/2006 – 09/2007

Projects Delivered: eProgessa Donor Management.

Environment: Oracle 10g RAC, CRS, RDBMS, RDBMS, VERITAS, Oracle 9i, RMAN, FRA Backups, SQL*Loader.

Scope:

Oracle Technical DBA/Consultant at the American Red Cross JP Complex, continued contract, a member of Chimes team at American Red Cross USA Provided on-site and on-call support of Oracle Databases 24x7 on Solaris (64-Bit) and Windows (32-Bit) Platforms and ARC is world best charitable and nation's premier humanitarian organization, support lifesaving services and programs and founded in Washington, DC.

Contribution:

Involved in installation of Oracle 10g RAC and 10g Non RAC Databases, CRS, RDBMS, DB and Applying Patches.

Worked to Apply Oracle 10g CRS, RDBMS and VERITAS Point Patches.

Worked on Database migrations from Oracle 9i to Oracle 10g.

Worked on Oracle 10g Streams and database Partitioning.

Created many RAC & Non-RAC database instances for development and production of numerous ranges used high-end Sun-E25 K, Mobile Laptop machines. Involve in Supporting SafetyNet System, Spatial and maintained mostly all the database environments of various sizes

Very proficient in taking backups using traditional logical backups, Data Pump, Hot, Cold, Transportable Tablespaces, RMAN, FRA Backups, database security and maintain data integrity.

Handled Databases of 2-4TB in size, used dpexp/dpimp and SQL*Loader for data movement.

Very well in performance tuning of Applications and Databases.

Very well verse in monitoring Failovers, Connection Load Balancing, Dedicated Servers and Remedy.

State Highway Administration MD, Hanover, MD

Sr. Oracle DBA/Consultant

09/2005 – 08/2006

Environment: Oracle Databases RAC, PL/SQL, Stored Procedures, Packages and Triggers, HIPAA.

Scope:

Senior Oracle DBA/Consultant at the SHA Hanover Complex, State Highway Administration for State of Maryland on a short-term contract of 1 year, a member of CNSI team at SHA OOTS, and provides on-site and on-call support of Oracle Databases 24x7.

Contribution:

Oracle database Administration and Installation of Oracle databases RAC and non-RAC and management system software's Creating/maintaining various databases objects and maintaining SGA parameters and Net files; designed databases, database objects, referential integrity, views, materialized views, security access policies.

Transferred database Schema's to and from databases; Writing PL/SQL Stored Procedures, Packages and Triggers.

Monitored backups, exporting/importing data, Data Pump, database full backup, incremental backups and recoveries, Flashback, Transportable Tablespaces, Partitioning, Streams, Advance Replication and applying security patches and patch sets on all database servers.

Ensured performance meets the standards of SHA and following the policy procedures defined by SHA.

Oracle DBA HIPAA compliance support including backups, recovery, tuning, optimization, and monitoring, preparing and implementing security plan for databases to meet SHA policies, and maintains database performance, Oracle Text and intermedia.

Performed database upgrades/migrations and scripts writing to automate backup jobs, database Backup and Recovery plan to minimize data loss and downtime.

Lead Systems & Database Architect.



Contact this candidate