Database Administration Oracle Apps

Saleem

E-Mail: *******@*****.***

linkedin.com/in/saleem-syed-mohamed-49056114

Phone No.: 347-***-****

Profile Snapshot

Around 18+ years of experience in Oracle apps and core DBA experience and other databases, cloud

Extensive knowledge on database administration for Oracle (10g,11g,12c and 19c) with experience in very largescale database environments.

Involved with Installation and maintenance of ORACLE 11g, 12c, 19C RAC and standby database for High Availability and Disaster Recovery purpose.

Extensive experience in Peoplesoft 8.12/8.46

Extensive experience in the system administration of PeopleSoft of Webserver, Application Server and Process scheduler

Extensive experience in implementing, upgrading, and supporting PeopleSoft database administration (DBA)

Extensively used utilities – adadmin, adctrl, ad patch, admrgpch, adclone.pl, adconfig.sh, adident,FNDCPASS, FNDLOAD, WFLOAD .ADOP etc.

Experience in Patching, AD utilities (adpatch, adadmin, adctrl,adident)

Proven experience in Oracle E Business Suite 11i,R 12.1.3,R 12.2.0

Proven experience in Oracle golden gate

Proven experience in performance tuning(Database, Infrastructure and SQL tuning)

Significant expertise in cloning and applying patches (one-off, mini pack, maintenance pack, family pack).

Managing databases on Engineer systems (Exadata). Good Experience in RAC Cluster ware administration, configuration and Patching.

Hands on experience in Multiple cloud technologies like AWS, Oracle and Azure cloud technologies.

Hands on experience in Multiple databases DBA like PostgreSQL., MS SQL, My SQL,MONGO DB, Cassandra etc

Hands on experience in Upgrading 10g, 11g, 12c databases to 19c databases on different operation systems.

Extensive experience in database administration, database installation, upgrade, migration, applying patches, performance tuning, RAC installation and maintenance, setting up and configuring Data - guard, performing all kinds of backups and recoveries, cloning databases, auditing and product support.

Hands on experience in Performance Tuning, tuned various large critical databases of Terabytes size using various tools like STATSPACK, AWR, SQL-Trace, TKPROF, Analyze, ADDM.

Hands on experience on Deploying and schedule jobs and in production and monitoring job.

Extensive Knowledge on Oracle Cloud and Autonomous databases.

Good understanding about Automated Storage Management (ASM), Recovery Manager, Data Guard and RAC.

Monitored and managed production, Development/QA/UAT Databases.

Creating and managing database objects, users, roles, privileges, and profiles.

Creation and maintenance of databases, space management and configuring database listeners.

Experience on backup and recovery strategies using RMAN and Logical backups (Import/Export/Data pump).

Generating and analyzing reports using AWR utility for optimizing the performance of the Database.

Storage management during day-to-day administration tasks.

Build Data Guards and performed Switch over and Fail overs.

Experience in configuring Oracle Enterprise Manager (OEM) and monitoring it through third party tool such as Nagios.

Strong communication, collaboration & team building skills with proficiency at grasping new technical concepts quickly and utilize the same in a productive manner.

Affiliations / Certifications

Oracle Certified Professional (OCP)

Information Technology Infrastructure Library (ITIL) Foundation

AWS certified solution architect

Azure certified solution architect

Academic Detail

BE (Electronics and Communication) from Madurai Kamaraj University

IT Skills

Application: Oracle Applications 11i, R12.1.1/12.1.3, Peoplesoft 8.14/8.46,Oracle Fusion Middleware, OBIEE, Demantra,

Brainware, Gem Services, Agile

Databases: Oracle 7/8i/9i/10g,11g,DB2V8.2/9, MS SQL Server, My SQL,Mongodb,Cassandra etc

Utilities: Oracle Enterprise Manager (OEM),Oracle Grid Control, Quest Central for Oracle, Oracle Applications Manager (OAM),AMP, Toad, SQL Navigator/Developer, Mercury, Clear quest, Cyber Ark, Grid Control, Perforce, Remedy, Pmsmart, AWR, ADDM,ASH Replication Manager(EMC)-DMX-CX4,IBM Tivoli,NetApp

Operating Systems: Windows, IBM AIX 5.2, Linux (Susee and Redhat), Sun Solaris, Unix, VMS,HP-UX, Linux Redhat 5,VMWARE(Vsphere)

Storage: IBM Tivoli, EMC Storage, Veritas and Netapp

Work Experience

Since Apr’22-till date HCL America Inc

Client otsuka pharmaceutical,Google LLC

Role Senior Database Administrator

Provide proactive recommendation,implement for Oracle Databases, Applications and

Infrastructures(Storage and Networking)

Provide Root cause analysis for Sev1 issues and provide short and long term solutions

Provide 24/7 Production support for Prod and Non prod environments

Manage and monitor work distribution within the team and provide guidance on issue resolution

Monitor Support Incidents to ensure compliance with SLAs

Manage High priority production Issues

Establish and manage the bug fix and continuous improvement process

Support Director/System manager on metrics covering Incident status, team utilization, SLA

compliance reporting, any other reporting.

manage continuous improvement process followed by client

provides support both internally and externally to ensure high satisfaction levels and works to improve the quality of systems,

Researching and recommending new technologies and solutions to meet business needs

performance tuning of Core databases

mentor and deliver advanced training for Information Technology staffs.

Automate backup using export and import from prod to archive database for month end process

Installing, configuring and monitoring Cassandra

Creating key spaces,tables and secondary indexes in Casandra

Troubleshooting Cassandra login issues

Installing, configuring and monitoring MongoDB

Troubleshooting MongoDB login issues

Upgrade MongoDB from 4.0 to 5.0 Successfully

Successfully completed POC upgrade from 12.1.3 to 12.2.4

Successfully upgraded databases from 12.1.0.2 to 19c for Dev,Test and Prod environments

Cloning of oracle applications using rapid clone

Involved in all kinds of db activities refreshes, patches, performances issues etc

Nov2014 –Mar2022 HCL Technologies Ltd

Client NetApp Inc,otsuka pharmaceutical

Role Senior Oracle Apps DBA

Description:

These systems serve the database production support for their global operations

Oracle Apps DBA,core DBA leading a team of 4 in 24X7 environment at Onsite.

Cloning Oracle Apps instances 12.1.3 multiple times using Rapid Clone utility.

Applying Major and Minor enhancement releases/patches such as HR- H,K Family pack,CU2 patches etc

Installed and Configured oracle Applications R12 with oracle 10g database on Linux servers

Providing on-call support for production databases and Oracle applications.

Configured and Implemented Bidirectional Golden gate and Troubleshooting

Administration, maintenance and Troubleshooting of Oracle 10g RAC databases for Non prod and PROD

Administration, maintenance, and tuning of concurrent managers, monitor operations, schedule and purge requests.

Refreshing development database from production for testing using datapump

Application System administration tasks such as Defining Responsibilities, User session Limits, Managing Concurrent programs and requests Purge Obsolete workflow data, Organizing Programs into request groups, Managing concurrent Programs by defining managers, scheduling requests to run at regular intervals, Cost based Optimization in applications, gather schema statistics, gather table statistics, administration of workflow to administer the workflow enabled processes.

Migrated oracle databases from on premises to AWS with Zero downtime using data guard

Migrated oracle RAC databases to OCI invironment

Responsible for research and installation of Critical patch updates every quarter.

Administrating Oracle Golden Gate v11 or higher PROD environments

Troubleshoot problems in areas such as extraction, replication, missed transactions, mapping, synchronization, SQLEXEC, file maintenance and more.

Monitor lag and statistics.

Experience in the system administration of PeopleSoft system including deploying/maintaining application servers, process schedulers, and web services

Performing applying patches for Peoplesoft

Installing, configuring and monitoring Apache Cassandra

Create key spaces, tables and indexes in Cassandra

Help dev team to perform DML statements in Cassandra

Troubleshooting Cassandra login issues

Monitoring read and write latency for Cassandra

Implemented cloud services IaSS,PaSS in AWS,Azure and OCI

Proficient with container system like Docker and container orchestration like EC2 container service, Kubernetes

Responsible for installing, configuring and backup,recovery,upgrade for Postgres and MYSQL databases

Feb 2012- Oct2014 Deloitte Consulting

Client Gilead Life sciences

Role Senior Oracle Apps DBA

Responsible for system administration functions: setup executables, users, responsibilities, concurrent programs, monitoring, patching, cloning, and upgrades.

Oracle Database Administration activities including monitoring, schema management, space management

Using AD utilities to maintain applications by compiling Apps Schema, Maintain Application Object menu, maintaining snapshots of the application using adamin and adpatch utilities for application of patches

Monitoring CPU,IO,Memory Utilization using Topas and Grid control

Database backup and recovery using RMAN

Coordination with Infrastruture and Applications team(DEV,QA,UAT,LT) and Client

Coordinating with Oracle Technical assistance Team to resolve any issue

Mentoring Trainess and Junior DBA’s

Attending DBA team meeting and business meeting for providing solutions

Troubeshooting performance related issues using AWR report in Nonprod and PROD databases

Frequent Monitoring of alert log, trace, for information or errors and resolve the same based on the logs

Applying oracle recommended proactive patches for Eg CRS patch,Streams patch,Rollback patch,

PSU(Oracle critical set patch update) /CPU(Oracle Critical Patch Update)

performance tuning of the databases using AWR,ADDM,ASH and advisor

Administrating Oracle Golden Gate v11 or higher PROD environments

Oct’10 to Jul’12 SoftLabs NA Inc, US

Client Wells fargo Bank

Duration: Oct 2010 – Jan2012

Platform: Oracle 10g/11g, Streams, Goldengate, Oracle RAC10g/11g, ASM, Weblogic, Sun Solaris

Description: It aimed to serve the database production support for their global operations

Roles & responsibilities

Led/support in the technical implementations of projects to develop and grow the Boards Infrastructure or improve its operations

Managed Oracle (24 x 7) technology infrastructure which includes Oracle Databases including RAC, DG, Streams, Goldengate

Managed and provided proactive recommendation to Senior management for Oracle Databases, Applications and Infrastrutures(Storage and Networking)

Trained Junior Database and Storage admin to Implement best practices

Knowledge sharing across the team members to avoid dependency

Manage Audit enquiries and resolve any issues with high priority

Designed team structure that meets the needs of the business customers, with team leaders and technical leads as appropriate

responsible for coordinating activities and resources in support of technical projects for the various teams in multiple technology environments.

Perform delivery management functions (development, support and maintenance services) in an on-shore off-shore model

Ensure staff completion of Policy & Control related trainings (e.g. Risk & Compliance training)

Ensure compliance to policies mandated by regulatory guidelines

Ensure redundancy of Database systems, maintain Disaster Recovery plans which are tested regularly by participation in IT Failover tests for every 6 months

Ensure that every team member participation on oncall and Release Management

Jul’04 to Sep’10 HCL Technologies Ltd., US as Senior Consultant

Achievements

Successfully managed database and application EBS upgrade project

Designed and Implemented Business Continuity Plan using Dataguard

Implemented Proactive shell script to take necessary action for e.g. Java out of memory and JVM issues

Led the conversion of Non RAC to RAC

Successfully Estabilished COE for oracle Practice and Implemented Best practices for Multiple Clients

Title: Production support for Global IT

Client: EMC Corporation, Teradyne Inc, Symantec via HCL Technologies Limited

Duration: Jan 2006 – Sep 2010

Platform: Oracle Applications (E-Business Suite) version 11.5.10., oracle grid control 10gRAC, 9i, ASM, EMC DMX/ Clarion, Sun, AIX, Linux

Description: It aimed at serving the database production support for their global operations

Roles & responsibilities

Designed, configured and implemented Oracle RAC database for optimal performance, availability and reliability

Implemented faster backups with RMAN and incremental backups and hot backup using EMC replication manager Configured Block Change Tracking on multiple databases to improve backup performance.

Managed Oracle 10g RAC databases on Linux, IBM AIX, gigabyte Ethernet multiplexed, ASM and EMC DMX/Clarion SAN environment.

Title: Production Support

Client: Deutsche Bank, KANA, NASDAQ, Elsevier Oxford, UK via HCL Technologies Ltd

Duration: July2004 –Dec 2005

Platform: People Soft 8.13, 8.46., Oracle OEM, 9i RAC, IBM AIX, Sun, AIX, Linux, IBM Tivoli

Description: It aimed at serving the database production support for their global operations

Roles & responsibilities

upgraded the UAT and PROD database from oracle 8i to 9.2.0.3 and oracle 10g

Involved in people soft upgrade from 8.12 to 8.46

Performed basic system administration tasks such as applying patch, software installation, user creation, privilege setup, NFS setup, SAN on SUN SOLARIS.

Installation and upgradation of oracle databases and Applications

Implemented

Backup procedures using RMAN and Audit of database.

Standby Database and setup basic replication

Disaster Recovery Plan (DRP) and performed DRP for Deutsche Bank

Establised COE for database and Infrastruture

took initiatives to build client new Infrastruture to reduce cost cutting

Recognized for executed multiple projects within time frame(Database upgrade and Storage upgrade)

Received Multiple Awards for Performance and Project Lead in 2006,2007,2009

Contact this candidate