Oracle APPS DBA
Resume:
SKILLS
Analytical : Adroit at analyzing infrastructure system needs, evaluating architectural requirement, proposing solutions, server sizing for EBS application & database for presales and RFP responses Performance : Experience on Performance Optimization of EBS and database system, development and deployment of script based modules for system availability and failure detection. Automation of several time-consuming DBA tasks for effecting EBS support and maintenance. In depth understanding of AWR,ASH,wait events, execution plan, optimizer. Technical : Experience on Azure cloud Subscription, resource group, VCN, interfaces, VM, scale set, gateway, powershell Experience in Oracle RAC/ASM installation, administration, patching and EBS advance topology configuration (DMZ, SSL,TLS, java keystore, PCP, Dataguard, Apps Guard ) and troubleshooting on various platform Knowledge on SaaS model for app/web deployment on Azure ASE, Dockers, ADLSG2, file storage and Kubernetes. Experience in 11g OID, SSO, Weblogic, Apex/tomcat/ORDS and OAM installation & Administration, 10g/11g Golden gate administration and troubleshooting
RDBMS: Oracle (9i,10g,11g,12c,19c), Postgres
Operating Systems: AIX/HP-UX/Linux/Solaris/windows Applications: Oracle E-Business suite 11i/R12/R12.2, OGG 10g/19C, QLIK replicate, APEX/Tomcat, Weblogic, OHS adl5r7@r.postjobfree.com
Boston, USA
https://www.linkedin.com/in/nitin-deshmukh-4067b75 4067b75?lipi=urn%3Ali%3Apage%3Ad_flagship3_profi
le_view_base_contact_details%3BA3Asst1JRGuwcWiO
tAt5ig%3D%3D
Working with Hexaware Technologies from April 2012 as Sr Technical Architect 14+ Years of Experienced with 5 Oracle Database upgrades & Application, 3 implementation and 7+ Database/EBS support projects. Extensive experience and proficiency in upgrades, migrations, large data management, Installations, enhancement, Advance configuration, evaluating architectural requirement, Solution designing and support of Oracle EBS
& database (10g/11g/12c/19c). Deft at Database project delivery of various sizes, team management & client coordination, Database and application support activities
NITIN DESHMUKH
WORK EXPERIENCE
Major projects with Hexaware
Parexel International - Billerica, USA Sep 2015 – Present Lead Oracle DBA – EBS 12.2.4/12c Database, Solaris supercluster
• Experience as On-Call 24x7 production DBA support, application/development DBA
• Extensive knowledge on database administration for Oracle 8i/9i/10g/11g/12c & 19c with experience in very large scale database environment and mission critical large OLTP and OLAP systems.
• Hands on experience in Oracle 10g/12c RAC implementation & administration (Oracle Clusterware setup and configuration, RAC installation using ASM, Grid Installation & Patching
• Extensive experience in Dataguard configuration, implementing and maintaining standby databases.
• Knowledge in installation and administration of Grid control, GoldenGate Replication.
• Experience in Performance Tuning using EXPLAIN PLAN, SQLTRACE, TKPROF, STATSPACK, AWR and ADDM
• Hands on experience on cross platform migration of oracle database using expdp or transportable database feature
• Setup OEM 10g & Grid Control (12c) for database monitoring/performance/diagnostics, Extensive experience in Database Backups RMAN (Full/Incremental backups) and in traditional hot/cold backups.
• Experience in LOGICAL BACKUPS and Database migration tools with DATA PUMP, Export/Import and Transportable Tablespaces.
• Good Knowledge in writing/editing UNIX Shell Scripts
• Good Knowledge on other Technology products such as Commvault, JIRA,Assist, Apex,Tomcat,EBS application 11i/R12, ORDS,OAM,OID,UCM
• Experience in Database Refresh and patch management and in Database cloning with RMAN and manual methods.
• Experience in Capacity Planning and Bench Marking.
• Developed database monitoring/health check alert scripts for database uptime/downtime status, and sizing issues using grid control (OEM)
• Experience on Azure cloud Subscription, resource group, VCN, interfaces, VM, scale set, gateway, powershell. Working knowledge on Postgres install and administration.
• Responsible for offshore DBA task co-ordination and meeting Customer SLA, showed great degree of ownership in handling problems and issues.
TELE2 - Amsterdam, NL/IND Sept 2014 to Aug 2015
Lead Oracle DBA – Telecommunication
• Customer is leading mobile network provider in Netherlands, Hexaware was awarded for support and performance tuning project for EBS application system. Assessment of existing infrastructure, database and application from performance standpoint and deployment of performance tunning strategies within stipulated timeframe
• Identifying database performance issues tuning database by hanganalyzer, system state dump,tracing, EXPLAIN PLAN, SQLTRACE, TKPROF, STATSPACK, AWR and ADDM
Apollo University - Phoenix, USA Jan 2013 – Sept 2014 Lead Oracle DBA – Education institution
• providing support to customer to upgrade and maintain internal databases and EBS financial applications, Co- ordinating with network, hardware and security team to prepare RAC environment, Configuration of Dataguard/standby along with RAC on Development, QA and production environment. CIMLI identification and upgrade of EBS application & Database from 9i to 11g
• Worked on Oracle database Cloning, Patching, tunning, Oracle Clusterware setup and configuration, RAC installation using ASM, Grid Installation
• Maintenance of Oracle Production, Development, Testing and QA databases, Installation and configuration of Oracle 9i, 10g databases.
• End-user requests in terms of assisting them in effectively create tables, views, packages, sequences, schema refreshes.
• Worked with developers to provide queries and tuning the queries for better performance. EDUCATION
University of Mumbai Mumbai, India BCom, Finance and accounting - 2004 OCA & OCI foundation certified & Experience on Azure cloud Andhra University Visakhapatnam, India BSc, Computer Science Jun 1999 – May 2002
PREVIOUS WORK EXPERIENCE
Sept 10 – Mar 12 with Capgemini India Pvt Ltd., as Sr. Consultant (Oracle DBA & APPS DBA) Aug 08 – Aug 10 with ManSoft Systems Pvt. Ltd., as Consultant (Oracle DBA & APPS DBA) Jun 06 – Aug 08 with Clover Infotech Pvt. Ltd., as Oracle DBA NOTABLE ACHIEVEMENTS
• Release Database from 8i to 10g for Qatar Vinyl Company, Qatar
• Release Database upgrade from 9i to 11g for Fine Organics, Mumbai.
• Release Database Upgrade from 10g to 11g for Fairpoint Communications, US.
• Oracle 11g RAC implementation for Ajman Bank, Ajman, UAE
• Database Upgrade from 9i to 11g & RAC implementation at Apollo University, Phoenix, AZ
• Oracle Data upgrade & Migration on Solaris supercluster platform from 10g to 12c at Parexel International inc. Billerica, USA
IDFC ltd - Mumbai, IND Jun 2012 to Dec 2012
Oracle Apps DBA/Webcenter/Weblogic admin – Banking
• Customer is India's leading integrated infrastructure finance player, Scope was to implemented Oracle Webcenter to serve the enterprise portal need which has been tightly integrated with OID, UCM, Portal, PSHR and multiple interfaces and software’s.
• Oracle 10g/11g Golden gate installation and administration, troubleshooting replication, administration, and upgrade issues
• Load data using SQL*Loader, Alert monitoring and Ticketing
• Coordinating Backup and Recovery operations over all databases.
• Creation of users and Granting them privileges and roles.
• Export and Import Data according to the users request
Contact this candidate