| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Email ID: EMAIL AVAILABLEContact: PHONE NUMBER AVAILABLEHaving 13+ years of experience (Onsite-6yrs and offshore) in TCS as Oracle DBA (9i, 10g,11g and 12c and AWS RDS and EC2)/Exadata Admin/Golden Gate Admin/Hyperion Admin/Peoplesoft Admin/Oracle Apps DBA which includes Installation, upgrade, network maintenance, UNIX Servers, Cloning, patching, user support, Trouble shooting, Performance tuning, Space management and Providing 24x7 support of Production, Development & UAT environments on Various Platforms.Professional Experience:Experienced in Planning, Installation, Physical Database Design, Cloning, Refreshing Databases on Oracle Applications.Installation of Oracle ASM and Filesystem 12c on Linux Servers.Experienced in Performance tuning of Applications & database using Oracle OEM, AWR, stats pack, SQL scripts.Experience in OCI(Oracle Cloud) administration for managing apps,databases and OS related activitiesSupporting 2 Node Exadata RAC system including Patching activities of Exadata software, Grid and Oracle home using PATCMGR utility.Exadata RACK components (ILOM,IB S/W, Compute Node, Storage Node) monitoring using OEM 12cWorking with Oracle to perform Exadata Disk replacement, Battery, CPU and Cache replacementsExadata QFSD patchingGolden Gate Monitoring, trouble shooting replication/extraction issuesExperience in Configuring, Monitoring, Patching, Cloning, maintenance on various oracle DB versions.Experience OCI Admin(server provisioning, VPN, Security list..)Provisioned EBS cloud manager VM from OCI Marketplace imageProvisioned DB systems on VM, associated DataGuard database instances in OCI environment.Creation of Users, managing schema and privileges, assigning quota on specific Table space, creation and managing roles, user profilesExpertise in Oracle applications e-Business Suite i.e., from 11.5.10.2 to 12.1.3, 12.1.3 to 12.2.5Experience in Troubleshooting Oracle DB in production environments on high volume DBExperience with Oracle DBA Activities and daily maintenance tasksExperience in AWS RDS and EC2 instance support(Version upgrades,daily support activities using AWS console)Experience in troubleshooting related to OS on database or application servers in productionHave good experience on applying patches using patchmgr,adpatch, opatch, adop and BSU utilities.Monitored database log files, data block corruption, segment fragmentation, performance issues, security threats, contention issues (deadlocks, I/O, memory, CPU, etc.WebLogic installation, configuration, upgradation, and administration (10.3.3,11g and 12c)Discoverer installation, configuration, and administrationExcellent communication, problem-solving and Client Management skillsExpertise in Coordinating with Other teams in getting the required work doneExperience in requirement gathering and working closely with Business UsersHaving good experience on Data Guard on Normal and RAC databases(Logical,Physical and Active Data guard)Have good experience on Shell and Perl scripting languages.CERTIFICATIONS:Introduction to Oracle 9i: 1Z0 007Program with PLSQL: 1Z0 147Oracle Certified Associate (OCA): 1Z0 052 Oracle Database 11g Administration11Z0-1085/997-21 Oracle Cloud Infrastructure CertificationsTECHNICAL SKILLS:Applications VersionsEBS 11i, R12, R12.2, Exadata X5 and X6, Golden Gate 12,AWS,Hyperion,Peoplesoft and Oracle Cloud AdminRDBMSORACLE 11g,12c, 19C, AWS RDS and EC2Languagesshell scripts, Perl, SQL/PLSQLTools and UtilitiesRMAN, OEM, SQL Loader, OEM GRID CONTROL, CONFIO(Solar winds), GOLDEN GATE,NETBACKUP, ACTIFIO, CyberArk, STAT, ServiceNow, BMC Remedy and JIRAOperating SystemLINUX, AIX,SUN SOLARIS,WINDOWS and HP-UXWebserversWebLogic, Tomcat,Oracle CloudQUALIFICATION:Masters in computer applications (MCA)Work ExperienceJ.C.Penney Company Co.Working as Oracle ERP (EBS, Hyperion and Peoplesoft) DBA from Jun 2018 to till nowMauricesWorked as Cloud ERP Admin from Jan 2018 to Jun 2018Cardinal Health Care -Dublin, OHOracle Exadata/AWS Admin from Nov 2016 to Dec 2017Sun Edison Energy - St Louis, MOOracle Apps (Ebs, Hyperion, GRCC,SOA) DBA from Jan 2015 to Dec 2016Omnitracs LLc - Dallas, TexasOracle Apps DBA(EBS upgrade) from May 2015 to Dec 2016Motorola Solutions Inc., - Schaumburg, IL, Chennai and HyderabadOracle DBA from Feb 2008 to May 2015PROFESSIONAL EXPERIENCE:Project#6Client: J. C. Penney Company, IncProject Duration: May 2018 till dateRole: Oracle ERP AdministratorProject Type: Production Support-Oracle ERP DBA (Exadata X8,R12.2 EBS,STAT, Panya and OATS)DescriptionJ. C. Penney Company, Inc. (NYSE: JCP) is a chain of American mid-range department stores based in Plano, Texas, a city north of Dallas. Its business consists of selling merchandise and services to consumers through its department stores and through its Internet Website at jcp.com. It sells family apparel and footwear, accessories, fine and fashion jewellery, beauty products through Sephora inside JC Penney and home furnishingsResponsibilities:Cloning of the Oracle EBS Applications of R12.2.5 Instances using rapid clone.Applying the patches of both data base and application as per requirement using OPatchand ADOP utilities.Implmentation of TLS1.2 in Oracle EBS Applications.Migrating the code using STAT tool from non-prod environments to production.Monitoring the DR database sync with production databaseMonitoring the Workflow notification mailer services and rebuild the workflow if it isnecessary.Troubleshooting the database performance issues such as long running queries etc.Resolving day to day user related issues.Apps and weblogic password change activity for every quarter.Perform the table re-org for highly fragmented tables.Applying the CPU Patches which are released by Oracle for every quarter.All schma password change activity for SOX/audit compliance.Tracking invalid objects, compiling and validating the invalid objects.Oracle Applications Trouble shooting on Apache (http Server) and Concurrent Manager.Supporting the development, Test and UAT instances.Project#5Client: Maurices, IncProject Duration: Jan 2018 Jun 2018Role: Oracle Cloud ERP AdministratorProject Type: Cloud Migration from On premises to Oracle Cloud(EBS,SOA,Hyp..)DescriptionMaurices Inc., stylized as Maurice, is an American women's clothing retail chain based in Duluth, Minnesota. Founded in 1931 in Duluth, the chain comprises more than 1,000 stores in the United States and Canada, primarily located in shopping malls and smaller towns.Responsibilities:Worked with network team on VPN compartment.Configured DRG, LPG, Route Tables and Security Lists for OCI VPN transit routing.Designed OCI architecture, compartments, VCNs and subnets.Provisioned EBS cloud manager VM from OCI Marketplace imageUsed IDCS for OCI authentication.Crtes IGW/NGW for public/private subnets and SGW for Object storage.Created Security Lists using Terraform code for third party whitelist.Provisioned DB systems on VM, associated DataGuard database instances.Created LBaaS with listeners, backend sets, path route set and rule set.Built compute instances with OCI Marketplace images with iSCSI attached volume.Created and configured DR environments, copied backup files to another region using OCI CLI.Configured remote peering between two regions.Customized SOACS/MFTCS cluster HA PaaS environments provisioning to allocate WebLogic serversand DB servers to private subnets.Defined network profile for EBS cloud manager.Provisioned customized EBS environments from backups in object storage.EBS infrastructure architecture design and with external application tier in DMZ, sizing servers andStorage for multiple apps servers and RAC DB servers.FMW SOA/OSB and ODI architecture design, domain selection and support for enterprise integration.Project#4Client: Cardinal Health Care -Dublin, OHProject Duration: Jun 2017 till dateRole: Oracle Exadata, Golden Gate and AWS DBAProject Type: Production Support-Oracle DBA (Exadata X4,X5,GG 12C,Oracle 9i,10g,11g and 12C and AWS RDS)DescriptionCardinal Health has many Oracle Database Server instances to support their hospitals & services operations throughout the World. These Oracle Database Server instances include many modules mainly pharmacies, hospitals and ambulatory care sites etc. There are around 250 databases are supporting which includes oracle 9i,10g,11g and 12c.Responsibilities:Exadata X2-2, X3-3,X4-2 and X5 Database Machine administration experience.Managing oracle databases in a EXADATA environmentExperience using Golden Gate for data replication and migrationSuccessfully utilized iLOMs for managing and troubleshooting storage cells and compute nodesManaged Oracle active data guard standby databaseInstalled ASR and activated Exadata ASR assets for hardware fault monitoringUsed OEM, SRVCTL, and CRSCTL commands extensively to maintain the RAC environment like add/remove node, start/stop clusterware app servicesInitiated media recovery, Instance and crash recovery using RMAN and performed database point-in-time recoveryImplementing and testing space optimization methodsManaging the gaps in archive logs to bring the standby in sync with primary database.Migrating the schemas using traditional exp/imp and Oracle Data pump utilitiesPrepared different recovery scenarios using Actifio backups.Setting up cronjobs for close monitoring of systems .Performs database re-organizations as required to assist performance and performed online re-org for DBFS filesystem to reclaim space.Experience in resolving table space issues for PRODExperience in various recovery scenarios.Experienced in maintenance of security infrastructure, identification/authorization security and maintaining Database Security using auditingSupporting AWS RDS and EC2 instancesExpertise version upgrades for RDS instances using AWS console.Daily DBA support activities forAWS RDS instances.Worked on various SOX compliance requestsCo-ordinated and implemented quarterly CPU PSU patchesPlanning and executing Quarterly Full stack patching with no downtime (100% availability)Environment:Exadata X4,X5,Golden Gate, Oracle 9i,10g,11i and 12C,AWS RDS and EC2Project#3Client: Sun Edison Energy - St Louis, MOProject Duration: May 2016 Jun 2017Role: Oracle Applications DBA support (EBS R12.2, SOA, UPK and Hyperion)Description:Sun Edison Energy Division currently has different ERP systems like Timberline, SAP, and Oracle R12 implemented across geographies. This project is to phase out all existing ERP systems and build single global ERP instance with Oracle EBS R12.2.4. I am responsible for design, plan and Production support of Oracle R12.2.4 instances, SOA, GRC, UPK and Hyperion environments.Responsibilities:Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of application and database issuesInstallation of Oracle EBS R12.2.4 instance on single node and multi nodes.Installation of Vertex OSeries Tax Link and integrate with Oracle EBS 12.2.4Install GRC(AACG) and configure multiple data sources and integrate with Oracle EBS 12.2.4Troubleshoot and fix GRC access synchronization, user provisioning issues.Install SOA 11.1.1.7 on RHEL 6 and integrate with Oracle EBS.Setup Database links with heterogeneous databases like SQLServer.Troubleshoot and remediate adworker failures during online patching.Extensively used adadmin, adctrl, adpatch, adsplice, ADOP,opatch,bsu etc.Cloning Development, QA, SIT etc. instances using different types backups and active database duplication.Experience in planning and implementing the maintenance activities to reduce fragmentation and improve performanceMaintaining passwords through CyberArk.Configure work mailer with SSL, office 365, import certificates and troubleshooting mailer is-sues.Identified and tuned poor SQL statements using EXPLAIN PLAN, Hints, SQL TRACE, and TKPROF. Analyzed tables, indexes to use Cost Based Optimizer (CBO) for improving the performance of the Query.Tuning database parameters relative to the EBS systemsConfigured ADOP sync driver and resolved sync, custom code issues between RUN and PATCH file systems.Installation of GL Wand financial reporting tool and integrate with EBS 12.2.4Installation of Noetix views, a pre-build BI coverage for Oracle E-Business Suite environment.Environment:EBS R12.2, WebLogic Administration, GRC, SOA, UPK, Manage Engine, CyberArk and SharePoint.Project#2Client: Omnitracs LLc - Dallas, TexasProject Duration: Apr 2015 May 2016Role: Oracle Applications DBA (R12.2)Description:Played a major role in database and application upgrade and support and build activities for Omnitracs LLC.Responsibilities:Involved in discussions with Omnitracs stake holders for gathering the requirements.Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issuesUpgraded database from 11.2.0.2 to 11.2.0.4Upgrade EBS from 11i to 12.2.4Discoverer installation and configurationApplying Minimum Baseline, AD TUMS and GDF patchesRegistering schemas using edition based redefinitionWeblogic installation and configurationApply ADOP readiness report patch and running Readiness report.Installing and configuring ILINK, Excel for Apps.Disable and Enable auditing.Noetix Generator installation, configuration and upgraded noetix views.Applying WebLogic security patches using BSU(Bea Smart Update)Running ETCC report to verify DB patchesRunning GSS with GATHER_AUTOTroubleshooting Upgrade issuesExtensively worked on cloning of single and multi-node database and applications.Provided database support for applications like FMW, AGILE, Vertex and DEMANTRA.Had experience in 11g and 12c OEM (Oracle Enterprise Manager) for monitoring applications and databases and to schedule reports.Manages concurrent programs and reports.Configure and monitor workflow mailer.OAF and Form customizations and migrations.Performing Tuning of applications Concurrent Manager.Environment:EBS 11i,R12.2,Oracle 11.2.0.4,Discover Server, Weblogic Administration, Demantra, Noetix, Kintana, QC and JIRAProject#1Client: Motorola Solutions Inc., - Schaumburg, ILProject Duration: Mar 2008 Apr 2015Role: Oracle Applications DBADescription:Played a major role in database support and build activities of Motorola Solutions Trilogy transformation project along with a team containing 4 members headed by TCS. Trilogy Project was for data transformation from many different systems/Applications running on SAP (ERP) and older versions of oracle to Oracle R 12 (ERP).Responsibilities:Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issuesAdded/removed nodes to/from a RAC cluster.Had good experience in troubleshooting ASM disk related issues, RAC VIP and local listener issues.Extensively worked on cloning of single and multi-node database and applications.Worked on ASM and Non-ASM databases/ troubleshoot ASM issuesAdding and dropping of ASM disks online.Provided database support for applications like FMW, AGILE, OBIEE, GRCC, Vertex, IAM/OAM, EPM, DEMANTRA and ODI.Involved in Implementation of Database Vault and Audit Vault.Extensively worked on Import/export of schemas, tables and complete databases.Works with users developers and DBAs to coordinate the implementation and integration of new Oracle e-Business applications.Coordinating and supporting the Business users during CAT (Customer Acceptance Testing).Provide support for code movement using kintana and manual to production/development/Stage Implementation.Environment:EBS 11i,Oracle 11.2.0.4,Kintana, BMC Remedy, QC and Service NowProject#1.AClient: Motorola Solutions Inc., - Schaumburg, ILProject Duration: Mar 2008 Apr 2015Role: Oracle Applications DBADescription:Played a major role in database support and build activities of Motorola Solutions Trilogy transformation project along with a team containing 4 members headed by TCS. Trilogy Project was for data transformation from many different systems/Applications running on SAP (ERP) and older versions of oracle to Oracle R 12 (ERP).Responsibilities:Had good experience in troubleshooting ASM disk related issues, RAC VIP and local listener issues.Worked on ASM and Non-ASM databases/ troubleshoot ASM issuesAdding and dropping of ASM disks online.Involved in Implementation of Database Vault and Audit Vault.Had experience in 11g and 12c OEM (Oracle Enterprise Manager) for monitoring applications and databases and to schedule reports.Participated in High availability Testing and Disaster recovery drills.Extensively worked on Import/export of schemas, tables and complete databases.Works with users developers and DBAs to coordinate the implementation and integration of new Oracle e-Business applications.Coordinating and supporting the Business users during CAT (Customer Acceptance Testing).Environment:Kintana, BMC Remedy, QC and Service NowProject#1.BProject: SETUPCustomer: Motorola SolutionsRole : Oracle Application System AdministratorResponsibilities:Manages concurrent programs and reports.Configure and monitor workflow mailer.Works with users developers and DBAs to coordinate the implementation and integration of new Oracle e-Business applications.Creation of Responsibilities.Performing Tuning of applications Concurrent Manager.Creation of users and assigning the Roles and responsibilitiesCreation of custom responsibilities as requested/discussed with client.Creation of New Profile Options as requested by ClinetCreation of Menu's, Forms and functions as requested by client.Value sets and DFF creationsRegistering to data group and assigning the profiles.OAF MigrationsForm PersonalizationOracle Applications patches analysisProvide support for code movement using kintana and manual to production/development/Stage Implementation.Project#1.CProject: TrilogyCustomer: Motorola SolutionsRole : Oracle Apps DBAEnsure service availability by proactively monitoring log entries, disk usage, memory usage, CPU utilization.Handling SRT calls for Critical tickets and providing RCA to management.Performing Backups and Restoration on Database and applications.Managing Database alerts as for Table space, Listeners, CPU Utilization, Blocking sessions, etcApplying Patches in Development/Testing/Production instances.Creation of users and assigning Roles.Completion of incidents (tickets) in SLA with priority.Manages concurrent programs and reports.Works with users developers and DBAs to coordinate the implementation and integration of new Oracle e-Business applications.Provided 24x7 on-call technical supports.Project#1.DProject: Schedule SharingCustomer: Motorola MobilityRole : Production SupportDescription:The Project involves Design, Development and Maintenance & Enhancement project of business critical Supply Chain system Schedule Sharing (SS) which enables the facilities to share their forecast and the up-to date receipts and Inventory details with the suppliers on regular basisSS is a System of communications and guidelines which allows a material consuming organization ("facility") to represent their needs and communicate them to their material providers ("suppliers") who respond and react with the goal of shipping material quantities that achieve the facility target inventory levels.Responsibilities:Development, Enhancement and maintenance of the above System and provided end to end support.Many business critical production bugs have been identified and fixed single handedly.Worked in SS System replication into two instances and it went live successfully.I have also involved in Data Base Re-org Activity to improve the Performance of our Batch Scripts which runs on a weekly basis.Solving the tickets raised by the users through MONET (client application)Analyzing the Design document thoroughly for feasibility studyUnderstanding the User Requirements and coming up with a proposed solution for the tickets raised by the customer in MONET.Working of data from transactional system to Oracle Database by using TCS Specific Tool.Production maintenance, respond to queries for the project and report to Motorola and TCS Management onsiteDocument the changes in standard procedures & methodologies and upload the latest in COMPASS.Programming Shell scripts for space/processes/listener/oracle alerts monitoringUsing TCS Web IPMS tool for tracking the status of work requests and overall project monitoring in accordance with TCS iQMS |
