Mohammed. S. Ali – Sr. Oracle DBA

adwz6u@r.postjobfree.com

847-***-****

US Citizen

SUMMARY:

Professional experience as Oracle DBA; proficient in Oracle 9i/10g/11g/11gR2/12c Software installation, upgrade, Migrations, Database Capacity Planning, Automated Backup Implementation, Oracle 11g/10g/9i on Unix and Windows NT platform and Oracle Financial Application 10.7, 11i, 11.5.9. Including RAC, VCH (Standby), HP UX (Standby) Dataguard, Enterprise Manager Grid Control 12c.

Highly motivated goal oriented team player with interpersonal skills

Experience of working in 24x7 Production Environment.

Oracle Data Guard (standby db, both logical and physical).

Configuring data guard, standalone & RAC databases.

Experience in Oracle Enterprise Manager (OEM), Erwin.

Worked mostly with but not limited to Production servers along with development and testing servers.

Expertise in installation and configuration of Oracle Financial and large databases on Linux Operation System.

Usage of Datapump of oracle 10g,11g & 12c for exporting and importing logical data of the databases.

Taking Hot and Cold backups using RMAN, along with Online and Offline backups and recovery

Significant experience in using the RMAN and Flashback technologies for backup and recovery purposes.

Proficient in use of Oracle Tools such as AD Utilities, SQL*Plus, SQL*Loader, SQL*Net and Enterprise Manager and utilize data warehouse planning and management knowledge.

Involved in multiple projects that required installing, upgrading and quarterly patching with the help of Opatch utility for the databases assigned under my applications.

Experienced in taking cumulative and Incremental backups.

Extensive experience in handled data migrations with the aid of expdp, impdp and RMAN utilities.

Dealt with performance issues in previous projects, which involved managing the size of table spaces, redo log files and archived redo log files according to the production environment.

Successfully delivered resolution ideas for critical database conflicts involving user roles and privileges, database network connectivity etc.

Strong experience in creating user, roles, privileges, accounts and profiles in the database.

Authoritative grasp on Oracle database architecture.

Experienced in upgrading Oracle databases from 9i to 10g and from 10g to 11g.

Experienced in upgrading Oracle Financial Applications 10.7 to 11.5.10, 11i to 11.5.9.

Technical knowledge of AP, GL, HR, iProcurement, OPM and Purchasing.

Experienced in effectively troubleshooting issues concerning network problems, instance startups, taking backups and recovering database files etc.

Hands on experience in implementing 11gr2, 12c & Oracle Golden Gate.

Experience working on Oracle Exadata Machine for the extreme performance of the database.

Worked with PL/SQL procedures, cursors, functions, triggers, arrays.

Excellent communication skills, a good team player and punctual in meeting project deadlines.

Accountable for leading the team for performance tuning of existing production Databases along with monitoring the activities of database and perform proactive role to solve the issue before it effect users.

• Good experience in Transportable Table spaces, SQL Tuning Advisor, Data Pump, Flashback Table, Table space Management, Virtual Private Database, Materialized Views, and Oracle Streams.

Worked on multi platforms AIX, HP-UNIX, Sun Solaris, and Windows.

Knowledge over SQL Server 2000/2005/2008.

Manage RAC environment for Day to Day Database administration, Performance Tuning.

Add or Remove Node from RAC.

Resolved/Diagnose Node Eviction.

TECHNICAL SKILLS:

Hardware Platform : SUN Sparc Series, HP9000, IBM 7040-681, Pentium Servers and various PC.

Operating systems : Red Hat Linux, UNIX (SUN Sparc Solaris 2.6/2.7/2.8,9, HP-UX 9.x, AIX 4.3, 5.1, 5.2, 5.3)

Windows XP/2000/NT/98

Languages : SQL, PL/SQL, UNIX shell programming.

RDBMS : Oracle 9i, 10g, 11g, 12c Servers, SQL Server. Golden Gate

Tools / Utilities : ER Win, RMAN, OEM, Export/Import utility, expdp/impdp, SQL Developer, SQL *

Loader, ADI, Alerts, MS Office, TKPROF, WINSCP/PUTTY (UNIX), VMware Tools.

Software : Oracle Web Server, Oracle form Server, Oracle report, EMC SAN Storage.

EDUCATION:

B. S in computer Science. Campbell University, NC

PROFESSIONAL EXPENIENCE:

Chase Columbus, OH Nov 2013 – Till Date

Oracle DBA Lead

Perform DBA task such as Database Administration on Oracle 9i,10g, 11g,11gR2 and 12c environments, Upgrading databases from 11g, 11gr2 to 12.1.0.1, Performance tuning, Schema creation, maintenance, and trouble shooting.

Oracle Data Guard (standby db, both logical and physical).

Configuring data guard, standalone & RAC databases.

Setup RMAN solutions for all Oracle Databases – created RMAN repository, wrote scripts for backup, integrated RMAN with OEM and GRID, provided best practices, optimizations and data guard and cloning techniques – restore and recovery.

• Creating and refreshing materialized views.

Serve as a Lead Resource to all teams in evaluating and proposing technical alternatives for resolving project issues.

Reporting to the Database Architect and supervising offshore resources for administration and support of database & applications

Resolves database performance issues, database capacity issues, backup, replication, and other distributed data issues.

• Creating and refreshing materialized views.

Setup and manage RAC environments for our customers, Monitor, recommend and implement changes to database applications ensuring satisfactory end-user response time with reliable database connectivity.

Implement physical database changes, and performance reports.

Maintain Oracle SQL and PL/SQL scripts, UNIX shell scripts, debugging and tuning.

Ability to pro-actively understand and manage end user/customer expectations.

Provide best practice on new technology and implementations.

Provides expertise and makes recommendations for physical database design, testing, performance tuning, and implementation of DB.

Performance issues (track and trend overall database performance and database area, index, and drive performance).

Great experience applying patches and performing DB Migrations.

Plan and Design Backup/Recovery solution using Shell scripting and RMAN.

Ensure that the database software infrastructure is in place and up to date to support other infrastructure components (e.g., operating system and hardware) and application development.

Installed Golden Gate for real-time uni-directional replication.

Migrating the databases from non Exadata environments to Exadata environments using dataguard switchover.

Used Oracle Exadata for DBA activities and advanced queuing while replication.

Installation, Administration and Maintenance of SQL Server Instances. (Installing SQL Server)

• Good experience in Transportable Table spaces, SQL Tuning Advisor, Data Pump, Flashback Table, Table space Management, Virtual Private Database, Materialized Views, and Oracle Streams.

Setup Test, Dev, Staging and Production Environments. (Installing SQL Server)

Create Users and assign permissions based on the level of database access the user would need. (Security)

Create Linked Servers to SQL Servers and other databases such as Oracle, Access, Informix etc. (Security and General Administration)

Design database Backup and Restoration Strategy. (Database Backups and SQL Server Agent)

Once created the database Backups, monitor those backups are being performed regularly. (SQL Server Agent)

From time to time recover the databases to a specific point of time, as per the requests. (Database Backups and Recovery)

Troubleshoot various problems that arise in a day-to-day work and fix the issues. (Monitoring SQL Server Error Logs and checking your email alert (if there is one configured))

Documenting major changes to the SQL Servers. (General)

Sargent & Lundy, Cincinnati, OH Apr 2012 – Nov 2013

Oracle DBA

Installed & Configure of Oracle 10g, 11g, 11gR2 on Linux (RHEL 3, 4). Upgraded databases to 11g (dev).

Upgrade Oracle Applications 10.7 to 11.5.10, 11i to 11.5.9 – migrate from windows to Linux. Migrated all

Oracle 9i and 10g databases to 11gr2. Platforms include Windows, Linux, AIX, Solaris and HP-UX itanium.

Setup RMAN solutions for all Oracle Databases – created RMAN repository, wrote scripts for backup, integrated RMAN with OEM and GRID, provided best practices, optimizations and data guard and cloning techniques – restore and recovery.

Recommend best practices for partitioning, scalability and monitoring.

Served as Technical for Oracle 10g iAS environment consisting of Oracle core technologies including Oracle Portal, Oracle Application Server 10.1.2.3 and 10.1.3. Performed tasks in administration of databases including capacity planning, instance creation, performance tuning, storage management, backup and recovery and general troubleshooting.

Configured shell scripts for job/process automation. Hands on experience in implementing 11g Oracle Golden Gate

• Creating and refreshing materialized views.

Installation, Administration and Maintenance of SQL Server Instances. (Installing SQL Server)

Setup Test, Dev, Staging and Production Environments. (Installing SQL Server)

Create Users and assign permissions based on the level of database access the user would need. (Security)

Create Linked Servers to SQL Servers and other databases such as Oracle, Access, Informix etc. (Security and General Administration)

Design database Backup and Restoration Strategy. (Database Backups and SQL Server Agent)

Once created the database Backups, monitor those backups are being performed regularly. (SQL Server Agent)

From time to time recover the databases to a specific point of time, as per the requests. (Database Backups and Recovery)

Troubleshoot various problems that arise in a day-to-day work and fix the issues. (Monitoring SQL Server Error Logs and checking your email alert (if there is one configured))

Documenting major changes to the SQL Servers. (General)

Waukesha County, Wisconsin Feb 2011 – Mar 2012

Oracle DBA

Upgrading database to Oracle 12.1.0.2 from Oracle 10.2.0.2, 11.2.0.4 Creating.

Configuring data guard, standalone & RAC databases.

• Creating and refreshing materialized views.

Installation, configuration of grid including ASM to provide shared storage to RAC databases. ASM administration including creating diskgroup, adding, dropping disks.

Worked in 24x7 production environment and provide on-call and day-to-day support.

Backup and recovery using Oracle’s RMAN software; used offline/online for recovery in a production environment via shell scripting.

Ongoing proactive database-level performance tuning, with a good working knowledge of Oracle internals.

Helped team to use existing infrastructure to achieve Maximum benefit to reduce cost and maximum performance.

Changes were made dynamically whenever possible to fulfill high-availability requirements. Enforced need of regular data purging processes from production, design and fail-over purposes.

Installation of RAC and Managing RAC Environment efficiently. Proficient in RAC Performance Tuning. Implementing and maintaining security (create and maintain users, role and assign privileges). Database tuning, application Tuning & performance monitoring.

Fine tuning Initialization parameters, I/O, Memory.

Managed appropriate use of freespace within tablespaces, reclaimed space whenever possible.

Reorganized tables and indexes within databases when needed. Monitored the production Oracle alert logs for database errors. Monitored system resource availability and responded to system memory and data issues.

Pactiv/Rank Groups, Lincolnshire IL Jan 2008 – Feb 2011

Oracle DBA (Oracle Consultant)

Installed and maintained Oracle Applications in complex environments such as Single-node and multiple-node installations.

Upgrade of Applications from 11.5.9 to 11.5.10 on test servers successfully.

Applied latest releases of patches to resolve few applications issues.

Cloning the instances from production to test, development instance to test and simulate few technical challenges, coordinate with testing and development teams.

Participate in a team to maintain and support for multiple oracle database and applications in high availability 24x7 heterogeneous environment.

Worked closely with team including Applications development, database development, Oracle support, and business community.

Installation of RAC and Managing RAC Environment efficiently. Performance tuning the RAC environment.

Refreshing the test databases to a point in time as per the developer’s request using RMAN Duplicate.

ASM to NON-ASM datafile conversion using Transportable tablespaces.

Creating services names for the newly created databases and updating the TNSNAMES.ORA file in other database with the entries of the newly created database.

Monitoring the log file shipping for the physical standbys and to make sure the dataguard environment is up to date with the primary.

• Good experience in Transportable Table spaces, SQL Tuning Advisor, Data Pump, Flashback Table, Table space Management, Virtual Private Database, Materialized Views, and Oracle Streams.

Contact this candidate