EXPERIENCE AND JOB SUMMARY:

Having total 6.8 Years of experience (IT & NON - IT) working as Oracle Apps DBA (R12.1.3& R12.2.4)/Core DBA & Oracle DBA RAC(11g) and Weblogic Administrator(10.3.6.0) with AWS Engineer and 12 months in NON-IT experience.

SKILLS PROFILE:

ERP: Oracle Applications E-Business Suite R12,1,3/12.2.4, Weblogic (10.3.6.0)

Tools: Toad, sql Loader, Sql Developer, Docker, Packer, Terraform

Languages: SQL,Pl/SQL

Operating System: OEL 4.5/5.5, 6,5, Sun Solaris AIX, Windows

RDBMS: Oracle 10g and 11gR2, 12.1.0.2, RAC11g

PROFESSIONAL EXPERIENCE:

Weblogic Administrator Maintenance/Support, AWS Engineer

Confidential

Responsibilities:

• Hands on experience in EC2, VPC, Subnets, Routing Tables, Internet Gateways, IAM, Route53, VPC Peering, S3, ELB, RDS, Security Groups, Cloud Watch, SNS on AWS.
• Ability to identify and define technical requirements for an AWS - based application.
• Experience of recommended best practices for building secure and reliable applications on the AWS Platform.
• An understanding of the basic architectural principles of building on the AWS Cloud.
• An understanding of network technologies as they relate to AWS.
• Experience on the AWS platform services such as Amazon EC2, Auto Scaling, Elastic Load Balancing, AWS Elastic Beanstalk, to provide opportunities to design and build cloud ready applications.
• Build systems using AWS compute (EC2), Storage (S3, EBS) and Database (RDS, DynamoDB, Redshift).
• Manage Security, Identity with AWS IAM.
• Management of multiple AWS VPCs across regions.
• Experience with AWS Elastic Cloud Computing (EC2), S3 Storage.
• Management of multiple AWS VPCs across regions.
• Ability to use problem solving techniques such as root cause analysis to resolve issues.
• Knowledge of DevOps such as Docker, Packer, Install GIT using choco command.
• Configured Elastic Load Balancers with EC2 Auto scaling groups.
• Create AMI images of critical EC2 instances as backup.
• Setup and manage security groups, VPC specific to environment.
• Manage Red Hat Linux and Windows virtual servers on AWS EC2.
• Manage availability, configuration and compliance with AWS Management tools - CloudFormation, Autoscaling, Cloudwatch.
• Creating and Login to Windows Instance (by using EC2).
• Configure IIS in Windows Instance
• Configuring Apache Web server in Linux instance
• Creating Amazon Machine Image (AMI) using Linux instance
• Configure Elastic Beanstalk
• Configure EBS Volumes, Snapshot and creating AMI
• S3 Basic configuration, Versioning & Static website hosting
• Experience on configuration of VPC
• Experience on configuration of Route53 with Linux EC2 instance and Windows server
• Use internet gateway to access public network from Public subnet and access Public subnet from Public network
• Familiar with AD Utilities adadmin, adpatch, admrgpch, adctrl, adsplice and adautocfg etc
• Maintenance of Oracle ERP R12 and Oracle Database 11gR2 on Linux and AWS (Amazon Web Service).
• Cloning, Patching, Code Migration, Database monitoring, User Management, Backup/Recovery Management, TAR Management, Monitoring Applications and its services.
• Providing Oracle Apps/Database support & services, documenting resolutions or best practices.
• Having excellent exposure in monitoring and trouble shooting of Apache, Forms, Concurrent manager, servers, Networking and database related issues.
• Killing run away Oracle Apps processes, resolving table locking conflict.
• Also using OAM - Oracle Application Manager for reporting on Patch History Information.
• Using all AD utilities Ad admin, AD patch, Adctrl etc.
• Involved in system Administration Tasks like creating responsibilities and assigning them to Users.
• Troubleshooting the Applications servers (web server, forms server, concurrent processing server etc.)
• Managing the Concurrent Managers and its operations like starting, stopping the concurrent managers, re-schedule the requests, purging the concurrent requests historical data, tuning of concurrent managers and monitoring of the concurrent manager operations.
• Performed System Administration Tasks.
• Managing front-end application users, responsibilities, and data groups.
• Creation of new scripts to automate the procedures to generate statistics on database space management, performance and for proactive monitoring.
• Managing and administering users, profiles, roles and privileges according to requirement.
• Monitoring and controlling the user access to the Database.
• Troubleshooting Clustering, Deploying Applications, Performance Tuning and Maintenance.
• Create, configure and tune weblogic domains/applications for performance.
• Work with vendors and developers for application related issues.
• WebLogic Administration, Monitoring and Troubleshooting using Admin Console.
• Server Performance Tuning - Thread Dump Analysis, Core Dump Analysis when Server crashed.
• Creating security roles, group policy, user authentication, aduting and authorization.
• Work on Web Security tools- LDAP Server, SSL Certificates and client authentication.
• Node Manager Configuration - remote managed server start and stop.
• Working with WebLogic utilities - WebLogic.Admin, WebLogic.Deployer.
• Monitoring WebLogic server health and security.
• Tuning JVM heap size to maximize the number of clients accessing the applications.
• Installation and configuration of WebLogic server (10.3.6.0) on TEST environment.
• Analyzing the Log Files, Thread Dumps, JVM Dumps.
• Excellent remote systems support and troubleshooting capabilities.

Application Implementation and Support/Maintenance

Confidential

Responsibilities:

• Experience in Application implementation from Confidential env. to Confidential env. and also supported to Confidential
• Troubleshooting issues while implementation such as active user running and not ending, Concurrent Manager related issues, adding tablespaces, Forms issues, database link issues, permission issue
• Troubleshooting for slow running on concurrent request, Forms related issues, database memory related issue and performance, Apache, Networking and database related issues
• Experience in performing cloning and maintaining Instance management activities
• Experience in applying Oracle Applications patches, monitoring concurrent managers, resizing of tablespaces, monitoring of disk space and resolution of contention
• Custom top creation on R12 Instance
• Involved in system Administration Tasks like creating responsibilities and assigning them to Users
• Experience of using Oracle Applications utilities like adadmin, adpatch, admrgpch, adctrl, fndload and adrelink
• Resolved various issues during patching, autoconfig and up gradation
• Experienced in Upgrading Oracle 10g to 11g
• Working with FNDCPASS to change Passwords of APPLSYS, APPLSYSPUB and SYSADMIN
• Adding OACORE on application node and increase java memory and Garbage Collection on PROD env.
• Applying CPU and HRGLOBAL vulnerability Patches to secure production env.
• Familiar with ADOP, applying online patches in R12.2.4 and troubleshooting with minimum down time.
• Familiar with architecture and file system of R12.2.4.
• Experience and proficient in Application Patching using AD Utilities, ADOP(R12.2.x) and strong analytical and problem solving skills in Patch Management.
• Extensive use of Oracle Apps AD Utilities, ADOP.
• Experienced in Application Cloning, and troubleshooting Post - Clone issues and documenting.
• Cloned the installation to the test system by using Rapid Clone
• Having excellent exposure in monitoring and trouble shooting of Apache, Forms, Concurrent manager, servers, Networking and database related issues.
• Providing the 24X7 production support to all the instances
• Experience in large number of production, development and test database
• Supporting Development and Functional teams.
• Experience in RAC 11g
• Adding Node and Deleting Node in RAC Environment
• Converted Single Instance Oracle Apps Database to two node RAC instance using RCONFIG
• Administration of Oracle RAC setup including patching of CRS and database

Confidential

Responsibilities:

• Active member for application upgradation from 11.5.10.2 to 12.1.3
• Successfully completed the application upgradation activity in PREPROD environment
• Applied patches on 11.2.0.3 home
• Applied R12.1.1 patched in pre - install mode
• Monitor backup while upgradation and copying it to local machine
• Upgrade database from 9.2.0.6 to 9.2.0.8 and then from 9.2.0.8 to 11.2.0.3
• Apply AD 12.1.1 upgrade driver (7461070)
• Run the American English upgrade patch driver (u6678700.drv)
• Application upgradation from 11.5.10.2 to 12.1.1 and then from 12.1.1 to 12.1.3
• Troubleshooting the issues such as perl, Concurrent Manager, clear cache, forms issue
• Resolving the workers failing issue while applying the American English upgrade patch driver
• Closely worked with Developer and Functional team
• Prepared and maintain the documents
• Applied application and database patches

Confidential

Responsibilities:

• Installed and configured Oracle Database 9i on Linux.
• Take backup using Symantec backup exec 2010
• Daily monitoring NAS Storage space, connection and status
• Installation and Configuration of system equipment like barcode reader, Thermal Printer
• Monitoring Oracle database status through Oracle Enterprise Manager
• Coordinating with HP and Dell for server and backup devices issues
• Provide the grant to user to connect to Database
• Troubleshooting toll related issues such as printer issues, Keyboard is not working, barrier issues