Nizamudheen Attiri
+971 508432495
nisamudheen@gmail.com
17+ years of experience in Oracle Database, Oracle Cloud Infrastructure(OCI), Oracle EBS on Cloud, Oracle E-Business Suite, DevOps tools, Oracle WebLogic, Oracle Application Server, Oracle Access Manager and various Operating System flavors including Redhat Linux, UNIX (Solaris, HP-UX) and Windows.
- Expert in Oracle9i/10g/11g/12c/19c database administration, upgrade, configuration and tuning.
- Experience in Oracle E-Business Suite technological stack, including architecture, installation, configuration, maintenance, tuning, cloning and patching procedures.
- Expert in Oracle Cloud Infrastructure(OCI), Oracle EBS On Cloud and Oracle EBS Cloud Manager
- Experience with Oracle Cloud Solution and Expert of Oracle ERP/Oracle HCM Cloud deployment
- Experience in Terraform, JSON and chef cloud infrastructure automation framework
- Knowledge of ASM, Data Guard, Real Application Cluster, Exadata and Exalogic
- Knowledge of Oracle Enterprise Manager(OEM) Grid Control, Oracle WebLogic, Oracle Internet Directory, Oracle Access Manager and Apache
- Ability to analyze problem, develops solutions and bring program/project execution to completion.
- Responsible for the design and development the project using relational database.
- Knowledge of Shell script, Perl, SQL, T-SQL, PL/SQL, Forms, Reports, XML Publisher and Discoverer
- Exposure to DevOps tools like Docker, Jenkins, Git etc
- Knowledge in SAP Basis and Oracle Databases administration using BR Tools and MOPATCH utility
- Good knowledge of System Administration with Red Hat Linux, UNIX(Solaris, HP-UX), Windows
Education
Masters of Computer Applications (MCA)
Bachelor of Science (Bsc Physics)
Certification
Oracle Certified Professional – DBA (OCP)
Oracle Autonomous Database Architect Specialist
Oracle Cloud Infrastructure Foundations
Oracle Cloud Infrastructure Architect Associate
Oracle Cloud Infrastructure Architect Professional
Experience
Etisalat by e&, Abu Dhabi, UAE
www.etisalat.ae, www.eand.com
Working as Team Lead – Oracle Cloud Solution Architect & Oracle Apps DBA
(Jan 2012 to Present)
Job Responsibility
- Installation, Configuration, Maintenance and upgrading Oracle R12 E- Business Suite and Database
- Regular Application and Database Server clone from production servers
- Oracle E-Business suite Application and database clone using Rapidclone (adpreclone.pl&adcfgclone.pl)
- DMZ Configuration of iSupplier and iRecruitment in Oracle E-Business suite
- Lift and Shift Oracle EBS Suite using Oracle Cloud Manager tool
- Provisioning Oracle Cloud infrastructure (Virtual Network, Load Balancer, Storage, Database, Firewall Security Rules, VM Compute instance etc.)
- Cloud adoption plans, cloud application design, and cloud management and monitoring.
- Application architecture and deployment in cloud environments
- Creating compartment to organize jobs responsibility and control access to the Oracle Cloud Infrastructure (OCI) Resources (Compute, Storage, Network, Load Balancer etc.)
- Managing and ensuring database availability 24x7
- Tuning and Troubleshooting of VLDB used for Oracle ERP/Telecom Billing/CRM Applications
- Database health checkup, ensuring safety, confidentiality and integrity of data
- Protecting the database from failures
- Performs regular physical, RMAN backups and ensure the backup process are fool proof
- Diagnose and resolves performance problems
- Detect and resolve latch and lock contention problems, Identify and resolve I/O, storage and database configuration problems
- Database objects access security management
- Performs capacity planning activities [space utilization and growth monitoring]
- Shell / Perl / Terraform / Chef / JSON / SQL / Command scripting for auto management processes.
- Data extraction and transformation activities
- Perform data archiving activities
- Prepare technical documentation of Etisalat databases
- Interfaces with Oracle Support and other vendors for database related issues
- Ensures 24 hours database Tier 2 support for the users.
- Ensures compliance with RDBMS vendor license agreement
GBM (for IBM WTC), Doha, Qatar
www.gbm4ibm.com, www.gbmme.com
Worked as Oracle Apps DBA (July 2011 to Dec 2011)
Job Responsibility
- Applying the latest patches to Oracle Database, Oracle EBS suite and SAP systems
- Do the server clone from production to test environment
- Give access to the development team to deploy customization on the test and production server after finalize the testing phase.
- Do the technical steps to configure oracle components
- Managing Oracle RAC Database, Instances and ASM Instances
- Maintain Site log for the production system
- Follow up with Oracle Support for technical issues SRs
- Respond to all SRs in the technical part
- Do the regular backup for the production and test environment.
- Do the regular tuning for database
- Oracle Database SAP Bundle patch update using MOPATCH utility
- SAP Database Maintenance using BR Tools
- SAP Router Configuration and OSS administration
- SAP User and RFC administration
- SAP Transport Administration
- SAP HANA 2.0 DB installation and SAP S4HANA Application installation
- Trace any problem and errors which are related to database or application servers.
Pharmatrade LLC, Dubai, U.A.E
www.pharmatradeuae.com
Worked as Oracle Apps DBA (May 2008 to July 2011)
Job Responsibility
- Installation, Configuration, Maintenance and upgrading Oracle R12 E- Business Suite and Database
- Applying the oracle application and database patch sets, Setup and configure Data Guard.
- Establish and maintain sound backup and recovery policies and procedure
- Perform general technical trouble shooting and give consultation to development team
- Design, Setup and implement Oracle Application Server in multi servers environment
- Allocating storage space and planning for future storage requirements
- Patch management and version control
- Interface with Oracle Corporation for technical support
- Troubleshooting and regular checking of alert log file.
- Application and database cloning using Rapid clone (adpreclone.pl and adcfgclone.pl)
- Setup and configure Oracle Workflow Notification Mailer (outbound and inbound notification mailer).
- Creating and managing Responsibility, menus, users, value sets, alerts, descriptive flex field and performing other system administrator responsibilities.
- Registering Printer, custom application, tuning of concurrent programs
- Performance monitoring and optimizations of database and application.
- Troubleshooting in Web/forms, Installing NLS/MLS and setup MWA/MSCA in Oracle Apps
- Administrating oracle HTTP server and SSL Configuration
- SSL environment setup and Configure Apache for SSL Connections using AutoConfig
- Monitoring & managing the tablespaces and data files growth
- Maintaining data integrity also managing users, profiles, resources and password security.
- Maintenance and managing oracle database, instances and application servers using Oracle Enterprise Manager
- Installation, configuring and upgrading Oracle Enterprise Manager Grid Control
- Installation, configuring and upgrading Oracle Application Management Pack(AMP)
- Install Oracle Application Express(APEX) and Configure Oracle server
- Data Masking and Scrabbling the sensitive data from the cloned instance using AMP and custom scripts.
- Installation, upgrading and maintaining BI Web Discoverer server, Discoverer Administrator, Discoverer Plus and Discover Viewer.
- Creating and maintaining EUL and Business areas.
- Performing backup and recovery using Oracle user managed backup such as automated or manual cold backup and hot backup procedures.
- Performing periodical Backup and Restoration using RMAN (full & incremental).
- Create, configure and utilize Recovery manager catalog (RC).
- Performing Export & Import operations using EXP/IMP, SQL Loader.
- Mass Loading of Data using Oracles Apps API and Custom Scripts
- Deployment of custom forms and Reports to Oracle Apps, Support to developers for developing Reports using XML Publisher, Report Builder and Discoverer.
- Evaluate Oracle features and Oracle related products
ASSYST International Pvt Ltd (CMMI-3 Level), Cochin, Kerala, India.
www.assyst.net
(W.O.S of Advanced Software System (ASSYST), Inc, VA, USA).
Worked as Database Administrator (March 2005 to May 2008).
Job Responsibility
- Installation, upgrading and maintaining the Oracle Database and its applications.
- Plan growth and changes (Capacity Planning)
- Creating and maintaining Oracle Database, instance and its objects.
- Performing Export & Import operations using EXP/IMP, SQL Loader.
- Perform database cloning and re-location activities.
- Setup and configure Oracle Data Guard.
- Applying the Oracle Database patch set.
- Managing tablespaces, data files, redo logs, tables and segments.
- Create, configure and utilize Recovery manager catalog (RC).
- Monitoring and eliminating Row chaining and Row migration issues.
- Maintaining data integrity also managing profiles, resources and password security.
- Monitoring locks and various sessions using OEM and views.
- Analyzing Tables & Schemas, collecting system statistics, reorganizing tables and rebuilding indexes.
- Performing backup and recovery using Oracle 10g's user managed backup such as automated or manual cold backup and hot backup procedures.
- Performing periodical Backup and Restoration and recovery using RMAN (full & incremental).
- Providing support to developers for the smooth functioning of the Database.
- Development of several shell scripts used for both hot and cold backups.
- Controlling and monitoring user access to the database.
- Managing Users, Privileges and Roles.
- Enhanced the performance of the database by providing advanced performance tuning and coding standards.
Project Summary
- Oracle E-Business Suite ERP Implementation and upgrade
- Oracle E-Business suite migration to Oracle Cloud Infrastructure (OCI)
- Installation, Upgrade and migration of Oracle Database
- DMZ Configuration of iSupplier and iRecruitment in Oracle E-Business suite
- Oracle Discoverer, Oracle OBIEE Installation and configuration
- Design, Setup and implement Oracle Middleware Server in multi-server environment
- Setup and configure OID / Oracle Access Manager with Oracle E-Business Suite