Ahmed Mohammed Email: ahmed.dbaoracl@gmail.

com
Senior Oracle DBA Phone: 972-338-9099

PROFESSIONAL SUMMARY:

 Over 8+ years of experience as Oracle DBA, providing support of development

to production 12c/11g/10g/9i/8i databases on UNIX/LINUX, Sun Solaris, AIX and
Windows environments.
 Proficient in Database Administration activities such as Migrations, Upgrades,
Patches, Cloning, Backup and Recovery, Performance Tuning, capacity
planning, script development, and documentation.
 Excellent experience in OLTP/DSS database systems, implementing and
managing very large Oracle databases (VLDB) as huge as 160 TB.
 Excellent experience in Oracle database installations 12c, 11g, 10g, 9i, 8i in
Linux, HP-UX, SUN Solaris, AIX environments with hands-on experience in
upgrading the Oracle databases.(10gR1 to 10gR2,9i to 10gR1,10gR2 to 11g, 11g
to 12c ).
 Experienced in Installation of high availability RAC environment (6 node clusters)
and upgraded standalone databases to 10g/11g/12c RAC environment.
 Installation, configuration, upgrade and performance tuning of Oracle RAC.
 Experience in configuring oracle data guard and streams.
 Experience in applying oracle database patches using opatch utility.
 Implementation of High Availability solutions with Oracle 12c, 11g, 10g RAC,
Standby Database Data Guard, Replication using Golden Gate
 Expertise in propagation of information using Golden Gate
 Experience in GoldenGate Install, Configuration, Maintenance, Trouble
Shooting and Upgrade.
 Experience in Configuring error handling for restart, logging, production
support and status reporting in GG.
 Experience working with Oracle Golden gate for performing database upgrades,
Cross platform migrations and Replications.
 Expertise in identifying and resolving issues related to Golden Gate.
 Experience in installation and configuration of Oracle 12c with RAC using ASM,
configured user log on load balancing and failover (TAF) on RAC database for
high availability.
 Extensive experience in performance tuning of database, memory & I/O using
tools such as AWR, ADDM, SQL Tuning Advisor and analyzing queries using
EXPLAIN PLAN, SQL-TRACE, TKPROF.
 Extensive experience in performing backups and tested crash recoveries using
conventional hot, cold backups and RMAN.
 Hands on experience of daily monitoring of Oracle instances and maintenance of
databases using Oracle Enterprise Manager(OEM), Oracle GRID, and
SQL*Plus Command line scripts.
 Experience with Data Guard, creation of physical standby and resolving the
physical standby database gap.
 Worked on distributed database configuration, creation of database links
between oracle databases and oracle to other technology databases using
heterogeneous service.
 Experience in shell scripting for various CRON jobs to be run.
 Proficient in SQL, PL/SQL, stored procedures, packages, triggers, forms and
reports, DBMS_* and UTL_* packages.
 Efficient in security administration by creating and maintaining users with
appropriate profiles, roles and privileges to access network resources.
 Experience with data modeling, logical and physical database design.
 Experience in instance cloning and code migration processes.
 Excellent knowledge in Hot/Cold Backup and Recovery and Cloning of
databases using RMAN, VERITAS NetBackup.
 Management of schemas, objects & partitioning the tables & indexes.
 Involved in different scenarios of OLTP as well as DSS databases.
 Experience in Database Security and Auditing.
 Proficient in using OEM and RMAN.
 A self-starter with a positive attitude, willingness to learn new concepts and
acceptance of challenges, strong listening, interpersonal and analytical skills.
 Demonstrated ability to work well with a wide variety of people at various levels,
foster cooperation and collaboration among individuals in the work unit, help
team resolve conflicts constructively and ability and willingness to communicate
when help is needed.
 Result oriented, self-motivated, team player, ability to work independently.

Technical Qualifications/Skills List

Oracle 8/8i/9i/10g/11i/11g, 10g/11g/12c RAC, 10g/11g/12c Data guard, OEM, SQL
server 2008R2, MySQL, LINUX (OEL, Red hat), AIX, Sun Solaris 5.6/5.8/5.9/10/11,
MangoDB, Golden gate, Perl Scripting, Shell Scripting, SQL Loader, Export/Import,
Expdp/Impdp, tkprof, statspack, RMAN, SQL*Plus, F-Secure FTP, Oracle
Performance Pack OEM, TOAD, Hummingbird, Exceed, Transportable Tablespaces.

EMPLOYMENT HISTORY:
Veeva Systems, Columbus, OH Jan 2017 – Present
Senior Oracle DBA

Responsibilities:
 Provided 24x7on call support for all the production and development Oracle
databases.
 Responsible for Database Administration of Oracle RAC 10g/11g/12c and non
RAC databases on ASM with size of databases varying from 10GB to 160TB.
 Managed Physical & Logical standby databases in RAC and non-RAC
environments
 Designed, configured and maintained backup and recovery policies including
RMAN backups
 PL/SQL, Performance Tuning, Application Tuning and Monitoring
 Implemented 11gR2 Data Guard using RMAN duplicate.
 Implemented and configured of Oracle Enterprise manager OEM 12C and Oracle
Management Server for maintenance and monitoring of production and non
production databases.
 Performed Oracle database upgrades ( In place and out of place ) from 11g
lower versions to 11g higher version and from 11gR2 to 12c both cross
platform ( Solaris,AIX to Linux ) and same platform
 Performed Cross platform database upgrade/migration using transportable
table spaces and RMAN.
 Performed legacy database’s upgrade from 8i,9i,10g, to 12c with different
charactersets to AL32UTF8, good at handling data conversion Errors
 Extensively worked on Data Masking over very large databases, Involved in
masking planning meetings, requirement gathering, well aware of masking
techniques and very good in supporting from database perspective.
 Configured and Setup Database Servers with Sun Solaris, AIX, Linux Platform,
installed Agent, Grid Infrastructure, Oracle Binaries and Oracle Databases both
RAC and NON RAC
 Good at using OEM Golden Imaging to push or generate software binaries.
 Extensively used AWR, ADDM for database performance statistics.
 SQL query tuning using tools like Explain Plan, SQL*Trace, TKPROF and
Statspack.
 OEM / GRID installation and configuration for monitoring and performance tuning.
 Configured and monitored RMAN backups in 11g/12c OEM grid control
 Implemented and supported Oracle RAC10gR2, 11gR1, 11gR2 and 12c
 Utilized Oracle Streams to capture, propagate, and apply the transfer of data,
transactions, and events within managed databases
 Responsible for GoldenGate Install, Configuration, Maintenance, Trouble
Shooting and Upgrade.
 Configure and build Golden Gate Extracts for multiple stores using parallel
execution
 Configuring error handling for restart, logging, production support and status
reporting in GG.
 Installed, configured and maintained ASM enabled RAC 11gR2/12c databases
 Implemented streams and Logical standbyreplication
 Responsible for configuring Streams.
 Performed Range Partitioning as a cause to improve the performance of the
database.
 Configured schema level logical backups (datapump) in 12c OEM Grid Control
 Extensively worked on configuring OEM grid control agent on new servers,
Installing Oracle and Grid Infrastructure binaries, registering new databases in
12c OEM Grid Control
 Handled all standard database administrative tasks, such as: proactive
performance tuning and monitoring, trouble-shooting, back-up and
recovery, installations and configurations on an as needed basis.
 Performed Oracle Database upgrades from 10gR2 to 11gR1, 11gR1 to 11gR2,
11gR2 to 12c in RAC and Non RAC environment
 Build and implement test, quality assurance, and production databases and
environments; Coordinated strategies to move data between databases;
Monitored database space requirements and adjusted for future needs
 Used Automatic Workload Repository (AWR) & Automatic Database Diagnostic
Monitor (ADDM) in RAC for Performance Tuning
 Performed version upgrades and patch installs.
 Develop custom utilities to automate manually intensive tasks including mass
schema changes, departitioning tables and rewinding/restarting Golden Gate to
recover from trail file corruption.
 Implemented Data Guard and Golden gate for high-availability and replication.
 Setup a working model for Golden gate for both DEV and QA environments.
 Checking databaseperformance on a regular interval, which includes checking
various log files.
 Addition of users, objects etc as and when required and granting proper
privileges for Database access.
 ASM implementation & maintenance.
 Created standby database using data guard on testing server.
 Extensively worked on Oracle 11g, 11g grid control (OGC), Putty, sql*plus,
RMAN, Data Pump
 Configured and automating RMAN backups through Grid Control
 Automate Logical Backups using export/import, datapump on applications
through grid control
 Maintenance and monitoring of table spaces, data file, control files etc.
 Implement and maintain database security (create and maintain users and
roles, assign privileges)
 Configured ASM and handled issues and suggested feasible workarounds for
ASM Metadata corruption
 Extensively worked with ASMCMD for managing ASM environment.
 Database monitoring and maintenance activities which include checking alert
logs, space management, undo management, gathering database statistics,
database locking issues, scheduling of jobs, creation of users, schemas,
tablespaces and other database objects.
 Implemented scripts, which monitor database health check at regular interval,
upon error, send email to the concerned person.
 Creating table spaces, tables, indexes, users, etc.
 Importing of dumps using impdp/expdp utilities.

Environment:
Oracle 10g/11g/12c RAC and Non RAC, Data Guard, Data pump, Export/Import,
Red Hat Linux, HP-UX v11i, Solaris 9.0/10.0/11.0 , AIX, Shell Scripting, Oracle
Enterprise Manager(OEM),Oracle Golden Gate,11g/12c Grid Control, Autosys,
DBArtisan, RMAN Backup and Recovery, RMAN Duplicate,Heterogeneous
Database Services.

West Corporation, Omaha, NE Oct 2014- Dec 2016

Oracle DBA

Responsibilities:
 Responsible for providing 24x7support for production Oracle databases
 Installed and upgraded the database server and application tools.
 Cloning the databases for TEST, DEVP and PROD and regularly refreshing the
databases.
 Installation, Configuration and Maintenance of 10gR2/11gR1 RAC.
 Implemented 10g/11g RAC consisting of 2 to 6 nodes.
 Performance tuning for optimized results using tools like Explain Plan,
SQL*Trace, TKPROF and Statspack.
 Setup of Standby database for faster disaster recovery and data guard setup
for high availability.
 Built and implemented Oracle RAC10gR2&11gR1 on Red hat Linux environment
 Migration of database from 9.2.0.6 and to 10.2.0.2.
 Extensively used ADDM, AWR, ASSM, AMM features of 10g.
 Extensively used 10g Grid monitoring for proactive monitoring of databases.
 Implemented Hash and Range Partitioning.
 Developed scripts to proactively monitor the databases and alert the DBA on
events such as running out of extents, disk space etc.
 Configured and supported 10gR2, 11gR1 databases in RAC environment.
 Creating and managing tablespaces and rebuilding of indexes.
 Taking periodic backups of the database and the software using cold, hot and
RMAN strategies.
 Responsible to capture, propagate, and apply the transfer of data, transactions,
and events within managed databases using Oracle streams.
 Responsible for implementing streams and Logical standby replication.
 Reading Alert. log and user trace files and diagnosing the problem.
 Scheduling jobs through Oracle job Scheduler.
 Created a DB link between two Oracle servers.
 Sql tuning for performance of objects.
 Migrated single instance databases to 11gR1 RAC environment for high
availability and load balancing
 Install, configure, setup of 10g RAC and add new node to RAC cluster to
distribute the load.
 Implemented Data Guard and Golden gate for high-availability and replication.
 Architected the Golden gate based HA solution
 Providing solutions to the problems faced by end users or programmers.
 OS level activities like space monitoring of mount points.
 Automation of startup shutdown on all production and development databases.
 Load balancing, databases/schema/table re-organization for faster
performance.
 Scripts for startup and shutdown, cold backups, health check of databases,
to check oracle errors in alert log file and send mails.
 Scripts for analyzing the tables and rebuilding the indexes.
 Configured, implemented 10g RAC with ASM disk on Linux servers.
 Planned and implemented for backup and recovery of database.
 Responsible in Managing and optimizing transactional replication in OLTP
environments.
 Controlled and monitored user access to database; monitor and optimize the
performance of database
 Oracle Cluster ware installed to provide infrastructure for RAC and configured 3
node Oracle 10g RAC with ASM.
 Responsible for ASM migrations and tuning on all platforms.
 Setting up SAN, ASM disks, used mercury load runner to test performance.
 Migratedoracle 10g databases to oracle Automatic Storage Management
(ASM), increasing database performance and disk-space utilization.
 Worked with Oracle Streams and Golden Gate to sync the data real time from
source to target.
 Responsible for downsizing and defragmenting the Very Large Databases by
export / import, cloning them using RMAN Duplicate features and then
upgrading them to Oracle 10g
 Applied patches using opatch.
 Applied the CPU patches.
 Database cloning using RMAN and hot backups.
 Allocated system storage and plan for future storage requirements for the
database system
 Provided technical resolution to Oracle database related problems
 Enrolled users and maintain system security and integrity, ensuring compliance
with database license agreements
 Implemented Standby Database and Database Replication to realize database
high availability. Created partitions for large table to improve performance
 Performed system enhancements, including SGA, memory tuning and SQL
Tuning, hardware and software modifications.
 Assisted developers in application performance tuning and evaluation of vendor
supplied software packages.

Environment:
Oracle 9i/10g/11g, Toad, SQL*Loader, TOAD, OEM, RAC, Oracle Streams,
Statspack, tkprof, AIX, SQL, RMAN, Windows XP/NT/2000, Sun Solaris, Red Hat
Linux 4.
Walgreens, Deerfield, IL Jun 2012 – August 2014
Oracle Database Administrator / Oracle Developer

Responsibilities:

 Oracle Production Database Administration.

 Build and managed critical billing system databases
 Installation, Configuration, Upgrade, patching of Oracle RDBMS.
 Refresh/Cloning of Database for development, testing
 Performance Tuning of the database (Memory Allocation Tuning, I/O Tuning,
Tuning Contentions
 Create table spaces, tables, and users for custom applications.
 Maintain user security.
 Assist Programmers and Developers with Oracle problems.
 Write UNIX shell scripts to monitor and maintain the Oracle database.
 Answer users' questions on an ongoing basis.
 SQL and PL/SQL Programming. Involved in developing PL/SQL functions,
procedures, packages, and triggers. Involved in creating tables, views etc.
 Cloning databases and partitioning tables.
 Define process and procedures for uploading legacy data to interface tables.
 Write SQL, PL/SQL to load legacy data to interface tables
 Backup of Database (Making Backup Schedules depending upon Business
Strategy: Daily Backup, weekly Backup etc.)
 Recovery of Database (Recovering from Media Failure, Recovering tables
dropped accidentally, Recovering data files, Recovering from Block Corruption).
 Partitioning strategies for very large tables. Partitioned large objects to improve
the query performance and manageability
 Implementing range, list partitions, hash partitions.
 Creating and refreshing materialized views.
 Writing PL/SQL procedures for Extraction Transformation and Loading of data.
 Monitoring and performing backups and recoveries.

Environment: Oracle 9i/Oracle 10g, Red Hat Linux, Sun Solaris , TCP/IP Protocols

Education History

Bachelor of Engineering from Osmania University, India