Associate Consultant, Apps DBA Lead and AWS Solutions Architect

AWS Cloud Implementation Project:

Client: AHCL (Abdullah Hashim Company LTD, Saudi Arabia)
Role: Oracle Apps DBA
Environment: Exadata X3-2 with Two node RAC EBS R12
Implementaion Migration of Oracle Database and EBS to AWS

Responsibilities
* On-premise to AWS Cloud migration of Oracle Database and ERP application to EC2.
* Worked on EC2 for compute and VPC & Route53 for network security. Created a network topology
in a secured way with public and private subnets.
* Configured two way tunnel VPN for accessing the ERP application.
* To maintain steady, predictable performance of the application and database, enabled Auto
Scaling for the EC2 instances.
* Enabled AWS CloudWatch to monitor the resources.

ORACLE Cloud Implementation Project:

Client: Transguard - Emirates Groups (Dubai HQ- UAE)
Role: Oracle Apps DBA
Environment: ODA X5, 2 Node RAC, Multi Node EBS R12.1
Implementaion Oracle EBS R12 migration from On-Premises to Oracle Cloud Infrastructure
(DBaaS & IaaS)



Support Project:

Client: Transguard - Emirates Groups (Dubai HQ - UAE)
Role: Oracle Apps DBA - Onsite
Environment: ODA X5, 2 Node RAC, Multi Node EBS R12.1

Client: ADNIP (Abu Dhabi)
Role: Oracle Apps DBA - Onsite
Environment: 2 Node - RAC on OVM 3.1 - EBS R12.1.3 & R12.2.8

Client: Honda Car India Pvt. Ltd., Greater Noida
Role: Apps DBA Consultant - Onsite
Environment: EBS R12.1.3 (IBM-Aix OS level Cluster Architecture)

Client: IHCC - Saudi Arabia: Jeddah
Role: Lead Apps DBA Consultant - Offshore
Environment: EBS R12.2.6 (Linux 6)

Client: 1800 Flowers
Role: Apps DBA Consultant
Environment: Support on 4 Node - RAC for EBS R12.2.5

Client: Forbes Marshal
Role: Oracle Apps DBA (11i & R12.1.3)
Environment: IBM AIX -6, EBS R12.1 & DMZ Node, RHEL 5.7

Client: Thermos
Role: Apps DBA (Associate Consultant)
Environment: Windows Server 2008-R2

Client: Sri Renganathan Industries
Role: Core DBA (Associate Consultant)
Environment: OEL 5.6 , Oracle Database 11g (2 Node RAC instance),OEM Monitoring


Project Roles & Responsibillities: ( Across all the above Projects)

Oracle EBS R12 & R12.2:
* Upgraded EBS R12.13 to EBS R12.2.6
* Provided 24*7 Support to Oracle 2 node RAC with multi tier EBS R12 on Exadata X3-2.
* Provided support to Oracle Database Appliance ODA X5 with 2 node RAC and Multi node EBS R12.
Provided very secured support for the Number 1 security company of UAE Emirates with signing
the DBA agreement.
* Performig all Database Provisioning tasks, such as Creating infrastructure for the
development, technical and functional team. Cloning, Patching(DB and AD), Troubleshooting,
Performance tuning etc.
* Administering oracle Database in 24*7 and troubleshooting issues with applications deployed on
Oracle EBS
* Applying patches in all the modules of EBS R12.2.6 and very good knowledge of working with
ADOP Phases.
* Performing Oracle MWA installation/configuration and configuring the Dispatcher
* Troubleshooting MWA issues
* Configuring the hand held devices for the scanning the material's LPN using Oracle Telnet
Services
* Troubleshooting issues with Oracle apps r12 and Apex 4.2, 5.0 and providing apps DBA
* Performing the Cross Platform Migration of E-Business Suite R12 and Database 11.2.0.1 from
HP-UX(Big Endian) to RHEL 7(Little Endian)
* Working on the implementation and support of Goods & Service Tax (GST) set-up.
* Cloning the EBS instances for the DEV team
* Resolving major issues
* Block corruption recovery
* Workflow notification and Approval issues
* OPP issues(concurrent program does'nt generate output)
* All types of Concurrent request issues(Long running, Error, etc)
* Worked on Database and Application, storage and Server Migration from IBM Aix - Power 7 to
Power 8 processor
Patching done in adpatch,opatch and other OS patches also


Oracle Database 11g & 12c, 19c Weblogic, GRC :
* Installation of Oracle Governance Risk and Complaince (GRC) in 12c Database and Weblogic
12.1.3 on Solaris SPARC 11.2 64 bit Server.
* Installed Application Access Control Governance.( AACG 8.6.6)
* Installed Transaction Control Governor .(TCG 8.6.6)
* Installed Preventive Control Governor. (PCG 7)
* Developing automated shell scripts
* Configuring and Monitoring RAC and Dataguard instances.
* Monitoring Database through Oracle Enterprise Manager(OEM).
* Installing OEM 11g Agent and integrating DB with OEM grid
* Driving automation for instance monitoring through Shell and batch scripts and scheduled in
crontab and windows task scheduler.

Microsoft SQL Server :

* Support provided for Microsoft SQL Server 2012, 2014, 2016(Standard and Enterprise).
* Worked on planning and implementing Disaster Recovery for 5 physical Servers using 'Always on
availability groups'. (Primary site in Dubai and Secondary in Abu Dhabi)
* Worked on log shipping and mirroring.
* Having good working skills on SQL Server Management Studio.
* Good skills on monitoring all the SQL servers using DBWatch and troubleshooting the issues log
size, disk spaces, blocking sessions, performance degradation.
* Creating link servers between Oracle and SQL Server using DG4ODBC

* Worked on AWS services like IAM, VPC, EC2, ELB, S3, CloudFront, RDS, Route 53, CloudWatch etc.
* Created and configured VPC, Subnets, NACLs and security groups.
* Created S3 buckets, stored DB backup files, log files and other flat files to S3 and assigned
lifecycle policies.
* Launched and configured Amazon RDS for MySQL.
* Hands on experience on creating/Managing AMI, Snapshots and EBS Volumes.
* Configured Autoscaling.
* Upgraded / downgraded AWS resources like CPU, Memory, EBS volume size etc.
* Enabling Cloud watch monitoring for various services likeS3, EC2, RDS, etc
* Launched RDS instance, configured security groups, launched an EC2 instance and installed
Message Queues software on it for a project.
* Setup/Managing VPC, Subnets and Security groups.
* Create/Managing buckets on S3 (CLI) and store DB and logs backup.
* Hands on experience on ELB Configuration.
* Hands on experience on troubleshooting connectivity issues between different servers/Services.
* Experienced in creating multiple VPC's and public, private subnets as per requirement and
distributed them as groups into various availability zones of the VPC

Significant Accomplishments:
* Collaborated with end-users and department managers for capacity planning and development
* Worked with application support staff in developing database architectures, coding standards, and
quality assurance policies and procedures
* Designed and implemented policies and procedures for disaster recovery and data archiving to
ensure effective protection and integrity of data assets
* Mentored a diverse Database Administration (DBA) team of personnel with resources in multiple
locations
* Optimized system/database operations and resource utilization. Performed system capacity analysis
and planning


NOTABLE ACCOMPLISHMENTS ACROSS CAREER


* Installed and Configured all the modules of Oracle Governance Risk & Compliance(AACG, CCG, PCG
and TCG) within project duration. Provided solutions for product level issues.
* Appreciated for successfully resolving critical 'Telnet Mobile hand-held device hanging issue in
6 warehouses across India'. This device was used for inbound & outbound scanning transaction.
This helped in revenue augmentation, increment in transactions per day and decrease in delivery
time & labor charges
* Appreciated for offering excellent customer service in all the projects & earned customer trust.
* Enrolled users, maintained system security, controlled and monitored user access to the database
operating in 24*7 with 450-500 concurrent users at any given time
* Successfully eliminated months of production server issues by systematically troubleshooting and
resolved the problem with no further downtime

Growth Path:
* May'13 - Aug'13 3 Months Internship

Role:
* Providing guidance to junior members of the team including second and third tier support
* Ensuring that active and effective backup policies were in place; resolving database maintenance
and corruption issues
* Developing and implementing shell scripts
* Managing the change control & testing processes for modifications to databases
* Testing routine system backups and restores
* Managing end-user accounts, permissions, access rights, and storage allocations in accordance
with privacy, security, and regulatory best practices
* Assisting with network and security audits; recommending software and hardware improvements,
upgrades, patches, reconfigurations, and purchases