Ahmed Mohiuddin

Sr. Database Administrator

acyt5e@r.postjobfree.com

Ph. 973-***-****

SUMMARY:

. 16+ years of experience in the IT industry with over 12 years of solid

experience as an Database Administration, Database Projects Advisor

(DBA) in production & Development environments.

. 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,

Inter media, DG, RMAN and meets SLAs and timely project deliveries.

. Extensive experience in physical and logical database design, database

partitioning, performance tuning, database application tuning

analysis, database security, setting up policies for backup and media

recovery using RMAN and FRA, snapshot, snap clone and active standby

database server.

. Wide experience with FMW and products installations using RCA for OAM,

OID with ASR/LDAP replication servers and data warehousing.

. Ensure Oracle database systems operate efficiently and securely in the

IT & Cloud industries.

. Database Analysis and Full software life cycle development across

numerous software and hardware platforms in a variety of industries.

. Established best practices, internal infrastructure improvement and

knowledge of project management.

. Responsible for Software life-cycle support to include migration of

custom application changes through different instances to production

and database testing and defect recording.

. Solid experience in Oracle 11gR2 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 Exadata, Supercluster and Oracle12c tenant

management.

. Responsible for building, installations, upgrades & migrations of

Oracle DBMS (7-10g-11g-12c) products.

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

. In-depth understanding SOX, PCI & HIPAA database security compliance,

authentication, and backup procedures to ensure integrity of

databases.

TECHNICAL SKILLS:

Hardware AIX, HP, Sun E25K, EMC, Exadata, EVA, Dell PowerEdge, Compaq

Proliant, Intel, Gateway

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,

ASM, CLI, ACFS, RAC

Traditional Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i, RAC, Oracle 9i, 9i

RDBMS/Servers AS, Oracle 8x, OEM, Grid, SQL Server, MS Access, BI, My SQL, DB2,

Sybase IQ, AES, ADABAS, Cloud Control

Exposure Apache, Hadoop, Big Data, Postgress

Open Source

Appliance Netezza, Exadata, SuperCluster

Languages/Too SQL, PL/SQL, UNIX Shells, Cronjob, KSH, SED, AWK, BMC Patrol,

ls 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 & AWS RDS

Application Oracle 10g/11g Internet Directory (OID), OAM, SSO, Content

Servers Management, Oracle 11g Fusion Middleware, Weblogic, Tomcat,

PeopleSoft, SAP, WebCenter Portal, Oracle E-Biz (EBS) r12

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

Others

Certification Oracle 10g Database Administrator (OCA/OCP)

EXPERIENCE:

T-Mobile - Bellevue, WA Dec

2015 - Present

Database Project Advisor Administrator

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.

. 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.

. Implement table partitioning technique

. Tune 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 DBA in various platforms such as

Sun Solaris, Red Hat Linux

. Extensive performance tuning of database and management of databases.

. Implemented Oracle Advanced Queue Implementation for PH2.0

applications.

. Prepare Golden Gate parameter files for Extraction and Replication.

. Investigate, trace fixes and report replication failures using

LogDump

. 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,

Datapump, SQL*Loader.

. Monitored database for blocking sessions & scripts.

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

activities.

. Performed database management functions such as maintenance, access

issues and security.

. Writing SQL scripts to monitor Archive log gaps, monitor tablespace

and extent growth.

. 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.

Projects delivered: Device Configuration, Ph2.0 & Roaming

COMCAST - Mt Laurel, NJ Nov

2014 - Nov 2015

Database Administrator

Comcast is a United States-based cable company Head Quarters in

Philadelphia, PA

. Providing 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.

. Architect, 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

. Migrated Oracle 11gR2 RAC databases and nonRAC 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 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, 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

Projects delivered: Commercial Price Quote (CPQ)

Database Administrator, ASC. Apr 2014 -

Sep 2014

May 2014 - Sep 2014

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, Space management and

patches to single instance databases.

Apr 2014 - May 2014

Provided day to day database admin activities to stabilize database

automation and includes installation of Oracle 11g R2 Databases, and

administration of Postgress migrations and Patches to single instance

databases.

AARP - American Association of Retired Persons, Rockville, MD

Nov 2007 - Feb 2014

Database Administrator

AARP is a United States-based non-governmental organization (American

Association) and interest group founded in 1958 and based in Washington, DC

. Provided services to a diverse industry clients as a Database

Administrator continued contract of Tiny Planet at American

Association of Retired persons (AARP) and providing on-site and on-

call support to High Availability Oracle Database (VLDB - 24x7

support) on both Oracle 11gR2 RAC (Real Application Cluster) & Non RAC

(ASM) & File system based databases varying sizes and schemas having

more than 10-200 table objects over 24gb and max terabytes in sizes

. Support 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).

. 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.

. Expertise in Database conversions from multiple sources, SQL Server,

MySQL, Access to Oracle

. 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 (GG).

. 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 &

disaster recovery management.

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

. 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.

. Projects code migrations, Streamlined and applied best practices to

have smart work accomplishments.

. Database physical & logical modeling design and implementation.

. Informatica (ETL) architectural table design for data warehouse and

related ETL processes to transport data to Netteza appliance. Involve

in Supporting Safetynet System, Spatial and maintained mostly all the

database environments of various sizes.

. Implemented performance improvement changes to nightly ETL processes

using Informatica from DB2 to Oracle databases and Netteza appliance.

. Solid Implementation & management skills on OEM, Grid Control, Cloud

Control, RAC DBMS, 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 & ER Architect.

. Solid Monitoring and troubleshooting of Database performance using

Cloud Control 12c, Grid Control 11g, OEM, DB Artisan, SQLT, AWR, SPM,

ADDM, ADRCI, TKPROF, SQL Advisories, Optimizer, Flashback, Plans,

snapshots AWR, ASH reports, MVs, undo management, DRA and Shell

scripting

. Attended DBA Workshops of Oracle Database 10g Administration, Oracle

Database 11g Administrator, Advanced Oracle DBA, Oracle Advance

Security 11g, Intro to Oracle Pluggable Databases 12c

. Excellent communication skills, day to day (SOP) maintenance

activities, automation, presentation, reporting, risk control,

positive problem solving skills and documentation

. A Team player and work well with all levels of business & Oracle

support

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

American Red Cross, Fairfax, VA

Aug 2006 - Sep 2007

Oracle Technical DBA/Consultant

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

. Installation of Oracle 10g RAC and 10g Non RAC Databases, CRS, RDBMS,

DB and Applying Patches.

. Worked on Databases Refreshes and Cloning in Oracle environments.

. 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

. Created and managed of Oracle Database Objects and Schema's.

. Configured Streams to capture, propagate, apply changes in multiple

databases and environments.

. Application support to user creation policies / responsibilities.

. 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 experience in using Oracle Real Application Server Utilities

like SRVCTL and CRSCTL.

. Very well in performance tuning of Applications and Databases.

. Very well verse in monitoring Failovers, Connection Load Balancing,

Dedicated Servers.

. Monitoring and Following up in SR's raised with Oracle Support.

. Support activities collaboration with System Administrators and

provided 24/7 Support.

. Taking customer requirements to design databases & Architect and on

time deliveries.

. Customized PL/SQL package procedures, code migrations, and strategic

database directions.

. Extensive use of remedy Built, Test Director, SharePoint, ER-Studio

and CR's Tools for monitoring and troubleshooting of high and low

priority calls during 24/7 Support.

. Monitored Oracle performance using Grid Management tools and provided

support in day to day activities and Shell Scripting.

. Implemented and delivered core edge technologies of Oracle 10g

(Streams, EM Grid Control, RAC DBMS).

Projects delivered: eProgessa Donor Management

State Highway Administration MD, Hanover, MD

Sep 2005 - Aug 2006

Sr. Oracle DBA/Consultant

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

. 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, and monitoring, preparing and implementing security plan for

databases to meet SHA policies, and maintains database performance,

Oracle Text and intermedia.

. Supported Automatic Hauling Permit system and maintained staging

databases.

. Performed database upgrades/migrations and scripts writing to automate

backup jobs, database Backup and Recovery plan to minimize data loss

and downtime.

. Involve in Supporting Safetynet System, Spatial and maintained mostly

all the database environments of various sizes.

. Implemented and Setup CDC environment for data warehousing and data

cleansing.

. Analysis design and minimum code modification of Unix & C programming.

. Problem resolution techniques, Bug fixes and work around solutions to

rectify Oracle 10g Issues.

. Data guard implementation as a disaster recovery solution, performed

capacity planning and taken preemptive action regarding available disk

space, memory, I/O.

. Applied load balancing techniques and performed various tests to

maintain the standards and policies, and application

upgrade/migrations, Grid Control implementations by review logs, and

sequences.

. Data Guard Gap management, sync up activities by applying archive

logs.

. Max databases handles varies from 20 to 750 GB in Size.

. Implemented Oracle 10g Enterprise Grid Control, apply patches and 24x7

support.

Projects delivered: MSCAN, COP, SIGNAL, and SAFETYNET

Metropolitan Washington Airport Authority, Washington DC

May 2005 - Aug 2005

Database Administrator

. Worked as a Database Administrator, the BMC Patrol Project for the

Metropolitan Washington Airport Authority (MWAA), installs,

configures, and manages BMC Patrol to monitor the availability of

systems to ensure system resources are performing acceptably in real-

time, during the proof-of-concept of the product.

. Provided 24x7 support for Oracle 8i and 9i Windows based Oracle

Databases.

. Supported Windows based Oracle 8i and 9i databases tuning and

optimization.

. Implemented RTServer, and managed the system and Patrol console server

to monitor SQL Server and Oracle databases.

. Performed troubleshooting using the Patrol Knowledge Module with

Windows 2000 (this includes user profiles in Active Directory and

history retention policies).

. Configured Advance Replication and has provides weekly performance

reviews of all critical production systems on deployed database

projects.

. Administration of Oracle 9i databases Installation and management of

Oracle 8i/9i databases, and has also managed SQL Server along with

Oracle databases.

Zegato Solutions, New Carrollton, MD

Nov 2004 - Apr 2005

Database Administrator [Lead Architect]

Zegato Solutions provides travel assistance to Federal employees through

approval, travel arrangements, and expense voucher preparation.

. Installed, configured and implemented Oracle 9i databases, and

provided 24x7 supports after migration of data from different sources

such as XLS, CSV, TXT, XML, and other database files.

. Responsible for managing SQL Server 2000 and Oracle 9i databases and

have restructured databases and performed normalization on database

tables.

. Reorganized database objects and implemented a Database Growth Plans.

. Performed Database Migration from Oracle 9i to Oracle Database 10g.

. Degraded SQL query performance tuning by implementing Parallel

Execution, query rewriting, and tuned queries using Explain Plan, SQL

Tracing, optimizing Cost based parameters.

. Implemented automated scripts to perform Physical/Logical Backups and

added new features of Oracle 9i.

. Best Policies implemented to load mass volume of data using SQL*

Loader and data cleansing.

. Existing RDBMS custom applications modifications to maintain high

levels of operating standards.

Lancesoft Systems Inc,

Feb 2004 - Oct 2004

Oracle RAC Database Administrator

Lancesoft Systems are leading provider of compliance information, tools,

and technology to Client Companies. The primary company focuses on helping

financial services organizations to better manage their compliance

requirements and work flow management.

. Responsible for understanding and analyzing existing systems of Oracle

8i/9i, database design, and Oracle 9i RAC software design and

implementations.

. Installed, configured Oracle 9i RAC and implemented RH Linux Advance

Server on SMP-based servers.

. Provided space management, backup, and recovery and performance

tuning.

. Installation of 2 node RAC and a shared disk subsystem in a DAS/SAN

environment and created raw partitions and symbolic links on raw files

to work RAC infrastructure for the company.

MPO Company Jed, KSA

until Dec 2003

Lead Systems & Database Architect

MPO is a financial investments company provides custom solutions to pension

plan sponsors, retail, collective investment funds, banks, and

corporations, commercial and not-for-profit organizations.

. Managed and administered Great Plains software's, Counter Point (POS),

Pervasive DB, Oracle 8i/9i Databases and SQL Server 2000 for testing,

development, and production environments.

. Installed, configured databases repositories, data management and

supervision of computer department.

. Indexing strategies to improve query performance.

. Wrote and maintained Shell scripts for running daily routine jobs,

backups and employed user access levels roles, privileges, and

password verification utility to manage database security and

performance tuning.

. Generated Database Reports on Windows 2000 server.

. Configured 2 instances on a two-node Oracle 9i RAC.

. Performed an Apps Oracle 11.5.7 install in the next phase.

. Handled multipurpose sized pervasive databases, estimated sizing

information for large objects and segment extents to minimize

fragmentation.

. Installed Oracle products, patched, migrated and upgraded Oracle

databases (Oracle 9i to SQL Server 7)

. Used OEM to monitor database critical events, potential space

problems, alert logs.

. Schedule data replication and export/import jobs for retail

applications support.

Projects: MTI, Financials, Premaman, IDdesign, Colr4Kids, Graphics and

Communications

EDUCATION:

. Masters in Mathematics, Osmania University, India, 1993

. Bachelor in Mathematics, Osmania University, India, 1989

. PG Diploma in Computer Programming and Database Management, 1992

CERTIFICATIONS:

. Oracle 11g Internet Directory Certification 2010

. Oracle 10g Internet Directory Certification 2009

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

Year 2006

TRAININGS:

. Oracle 12c Pluggable Databases Cloud Training 2013

. Oracle 11g Web Logic Training 2013

. Oracle 11g OAM Training 2013

. Oracle VMWARE Training 2013

. Oracle 11g RAC Training 2009

. Oracle 10g RAC Training 2006

. Oracle 9i RAC Training 2004

. Microsoft SQL 2000 Server Training, Year 2001

. Microsoft Great Plains Financial Application Software Training, Year

2001

. CounterPoint (POS) Application Software Training, Year 1999

. Real World Accounting Software Training, Year 1995

. Novell Networks, GlassPro Application Training, Year 1994

. Oracle Database Administration Training, Year 1993

REFERENCES:

Upon request

Contact this candidate