Candidates About

 

                  Anindita Basu                                               

Oracle DBA

Professional summary:

Energetic, curious and passionate with 9+ years of experience as an Oracle DBA (OLTP and e-commerce database) along with 7+ years of 24/7 production support and the following technology trends including NoSQL, MySQL database and WordPress. Managed medium to large size end to end project development lifecycle which included different challenges from choosing right candidates to create a multi national team to deliver project through change management, from capacity planning to post production support, from hardware to software. An organized, detail-oriented and conscientious self-starter, able to strategize and prioritize effectively to accomplish multiple tasks and stay calm under pressure.

 

 

Education:                                                                 

• Bachelor of Technology (B. Tech) in Computer Science and Engineering, 2008

 

Skills: Oracle E-Business Suite, Oracle Database, Project Management

 

Oracle Database: Versions: 12.1.0.2, 11.2.0.4 and 11.2.0.2

·         Designed and supported SOX compliant OLTP database following corporate standards, best practices, security.

·         Strong troubleshooting ability to solve Production Severity 1 issues within SLA and engage Oracle Support if require.

·         Implemented ASM for Oracle RAC for production database.

·         Proficient in Oracle 11g/12c – multitenancy                                            

·         Upgrading production database from 11g to 12c

·         Strong knowledge in supporting and maintaining Oracle Golden Gate for production                                                 

·         Production database full Backup and Recovery:

o    RMAN

o    NetApp Snapmirror/FlexClone

·         Strong in day to day production Database and SQL Performance Tuning:

o    ADDM, SQL Performance Analyzer, SQLT

o    AWR, ASH analysis                                                                                            

·         Automated production support DBA jobs through scripts

·         Implemented OEM Grid 12c/11g                                                                                              

·         Designed and implemented High Availability solutions (HA) for non-prod and production database

o    Data Guard/Active Data Guard (ADG)

o    Oracle Restart

·         Performed patch analysis, patching updates, security patching with application.

·         Performed single/multi-node cloning.                                                             

·         Production support - 24/7/365, off-hour, weekend call.

 

Oracle Applications: Versions: 12.2.4, 12.1.3, 12.0.3 and 11.5.10.2     

·         Design, installation and production administration of Oracle Applications R12

·         Managed full lifecycle Oracle Application implementations from capacity planning to post production support.

·         Upgrading Oracle Applications from 11.5.10.2/12.1.3 to 12.2.2/12.2.4

·         Implementing online patching (ADOP) utility in production instance

·         Managed full lifecycle Oracle Application implementations.

·         Strong knowledge in troubleshooting OC4J, OPMN                                                                                

·         Have done PCP Setup for production instance

·         Have setup DMZ for E-Business Suite R12 with Reverse Proxy                                                    

·         Proficient in application performance tuning:

o    Tuning AQs and WF configurations

o    CM queues, work shifts

·         Involved in end to end implementation cycle of 11i & R12                                                                                     

·         Expert in multi-node cloning, regular production support jobs, FNDLOAD                                                       

·         Configured Workflow and resolved related issues

WebLogic:  Versions: 10.3.3, 10.3.5, 10.3.6

·         Analyze, implementation, troubleshooting and administration of WLS 11g and 12c                      

·         Posses good knowledge about Cache coherence.

·         Enbaled TLS1.2 from SSL3.0

·         Implemented SSO/OID/Accessgate for wide ranges of applications for the entire company.                                                       

·         Done DMZ/SSL Setup for WebLogic using Reverse Proxy with SHA2 compliant Certificates.

·         Implemented OHS in front of weblogic.

·         Performance tuning for WLS:

o    Tuning parameters for data pool   

o    Finding Memory Leaks and JVM tuning      

o    Changing Garbage Collection parameters                      

·         Upgrading:                          

o    Upgrading WLS from 10.3.5 to 10.3.6

o    Upgraing JDK versions

o    Upgrading SOA and OSB       

o    Applying patches, PSU                             

o    Installing Service Packs                                                       

·         WLST scripting    

·         Deployment of various WAR, JAR, EAR to managed servers and in clustered environment.          

 

WordPress: Versions: 4.7, 4.8. 4.9

·         Install and configure WP single and multi-site along with MySQL cluster.

·         Upgrade and troubleshoot.

·         Integrate WP with reverse proxy and implementing latest mod security rules.

·         Installing certificate.

·         Implementing hardening rules for enhanced security.

·         Converting WP multi site to single site.   

·         Installing plugins, themes and editing the WP pages as per the requirement.

               

   

Environment:  

Oracle Tools:                      OEM (11g/12c), RMAN, RUEI and OATS

Scripting Language:         PL/SQL, Shell, Python

3^rd Party Tools:                  AppDynamics, Splunk, Kintana, Perforce, Application Lifecycle Management (ALM),

CHEF

Operating Systems:          Red Hat Linux(6.x, 5.x), HP-UX, AIX, Solaris 10

 

 

Professional Experience:

 

Fujitsu Inc., Sunnyvale, CA                                                                                                                             May 2016 – Current

Senior Oracle DBA/Dev-Ops

 

Responsibilities:

·         Install, configure and upgrade Oracle Database from 11.1.0.7 to 11.2.0.4 to 12.1.0.2.0

·         Install, configure and upgrade Oracle Applications EBS from 12.1.1 to 12.1.3

·         Install, configure and upgrade Weblogic from 10.3.5 to 10.3.6 and SOA/OSB application from 11.1.1.5 to 11.1.1.7

·         Enabling TLS1.2 for SOA/OSB from SSL3.0 resolved related challenges.

·         Installing and configuring WordPress single and multi-site along with MySQL database for an e-Commerce site.

·         Installed SSL certificate, attached WP to the reverse proxy, added mod security rules and other hardening rules.

·         Converted WP multi-site to single site, installed themes, plugins and edited the site per requirement.

·         Troubleshooting all the reverse proxy and the mod security issues including whitelisting IP addresses.

·         PPM Kintana upgrade from 9.10 to 9.30.

·         Performing SQL tuning and database tuning with AWR/ASH/ADDM/SPA/SQLT for production database.

·         Monitoring and supporting 24/7 mission critical databases.

·         Creating DR using DataGaurd from non-prod and Production servers.

·         Solving different types of certificate, specially JAR signing issues for R12 EBS and Weblogic.

·         Analyzing and applying CPU and PSU patches across all the instances.

·         Migrated all the Oracle and non-Oracle instances from physical box to M10 VM box.

·         Build Alerting mechanisms for EBS in areas of failed CM jobs, SOA WSDL transactions, AQs.

·         Troubleshooting EBS production instance problems with Apache errors, Forms server, Cloning issues and concurrent managers, and database for support activities.

·         Configured and administered JDBC Connection pools and JMS Connection Factories and implemented other services like JNDI and SNMP.

·         Excellent working knowledge in finding Memory Leaks and adjusting JVM Heap Size and Garbage Collector parameters during performance monitoring and performance tuning of WebLogic server.

·         Working closely with Functional/Developers, vendors and helping them in production related issues.

 

Environment: Oracle Applications EBS R12.1.3, Oracle Database 11g, RAC, PCP, Weblogic 11g (clusterd), Webcenter, SOA 11g, DMZ, SSO, OAF, OHS, OID, OIM, Reverse Proxy

 

Jacksonville Electric Authority, Jacksonville, FL                                                                            Dec 2015 – May 2016

Senior Oracle DBA

 

Responsibilities:

·         Install and configure EBS 12.2.4 with Oracle 12.1.0.2 (12C) RAC OLTP Database for Production.

·         Managing database related different projects, which include performing upgrades, migration, cross-functional teams interactions distributed across nation and multi Geo-locations.

·         Planning and implementing RMAN for production database.

·         Controlling migrations of programs, database changes, reference data changes and menu changes through the development life cycle and controlling version through Kintana and Perforce.

·         Implemented 12c OEM in production for performance monitoring.

·         Achieved zero downtime patching for instances.

·         Achieved out-of-box analytics Data Warehouse by creating near real time Active Data Guard.

·         In-charge of scheduled DBA related maintenance activities along with weekend and off-business-hours releases.

·         Setup PCP for production EBS R12.

·         Applied R12.2 online patches using ADOP.

·         Created robust alert mechanism to take care of easy fallouts and sensitized data to act as important pointers for potential fallouts.

·         Created predictive models for large metrics data as DB wait events and I/O throughputs leveraging ‘R’ language

·         Actively participating in change management and taking care of all the communications to technical and business stakeholders in terms of identification of LOEs by DBA teams to GO-NO-GO calls and publishing of release calendars and Release Documents.

 

Environment: Oracle Applications EBS R12, Oracle Database 12c/11g, RAC, PCP, SSO, Active Data Guard, ADOP

 

NetApp Inc., Sunnyvale, CA                                                                                                                        July 2014 – Dec 2015

Lead Oracle Apps DBA

 

Responsibilities:

·         Design, implement and maintaining multi-terabyte SOX compliant e-commerce Oracle database and Weblogic server under heterogeneous environments like UNIX, RHEL etc.

·         Managed full lifecycle Oracle Application implementations which included but not limited to performing upgrades, application and database cloning, patching, troubleshooting.

·         Performed SQL tuning and database tuning with AWR/ASH/ADDM/SPA/SQLT for production database.

·         DMZ/SSL implementation with Reverse Proxy for E-Business Suite R12 with SHA2 compliant Certificates.

·         Successfully implemented the huge data purging and partitioning project to maintain the large terabyte production database.

·         Slashed man-hours by 30% by automating Change management tasks like auto restarts and auto heap management for Java OOM errors.

·         Troubleshooting knowledge of OAF/ADF tuning.

·         Maintaining and troubleshooting issues related to Data Guard like log file syncs, DG broker issues.

·         Proficient in scheduling jobs, patches, alerting for databases, hosts and also database administration through OEM 12C.

·         Maintaining and supporting Golden Gate for production OLTP database.

·         Built MongoDB- version 3.2 POC on a sharded cluster.

·         Configuring and performance tuning of multiple WebLogic domains including machines, manage servers, node managers and cluster environments.

·         Deployed various WAR, JAR and EAR to managed servers and in clustered environment using Console or auto deployment scripts in stage and production.

·         Planned and actively participated in monthly and weekend releases which involved coordination with different teams.

 

Environment: Oracle Applications EBS R12, Oracle Database 12c/11g, RAC, PCP, Weblogic 11g (clusterd), Webcenter, DMZ, SSO, OAF, OHS, OID, OIM, Reverse Proxy.

 

Stellar Inc, Jacksonville, FL                                                                                                           March 2014 – July 2014

Lead Oracle DBA and Oracle Apps DBA

 

Responsibilities:

·         Design, installation, configuration and upgrading of Oracle Applications Database and related products for production.

·         Installing and building R12 (12.1.3) new features in production database which includes multi-node RAC on Linux and multi-node applications servers with PCP

·         Supported AR, AP, GL, OM, iProc, Quoting and Service Fulfillment Manager, Order to Cash and Quoting.

·         Supported Financials and applied all related patches.

·         Creating the Customized Menus, Responsibilities, Request groups, Request sets and Application Users as part of sysadmin.

·         Performed SQL tuning and database tuning for production database.

·         Resolved Backup and Recovery issues related to loss of OCR, Voting Disk and Oracle clusterware & also issues with corruption of individual disk data blocks, loss of OS configuration files, loss of net configuration files. Also used the Merge backup for backing terabyte databases. Issues with block change tracking & also flash recovery area.

·         Creation, configuration and administration of:

·         WebLogic domains and managed servers for internal and external clients

·         JDBC and multi data-source connections with Oracle 10g and 11g databases

·         FTP, File, Database and AQ adapters connections

·         Web-service securities through OWSM.

·         Controlling migrations of programs, database changes, reference data changes and menu changes through the development life cycle.

 

Environment: Oracle Applications EBS R12, Oracle Database 12c/11g, RAC, Weblogic 11g, 

 

Tata Consultancy Services, Kolkata, India                                                                      November 2010 – December 2012

Oracle DBA and Oracle Apps DBA

 

Responsibilities:

·         Installing and building of production Oracle EBS database and Weblogic Server.

·         Implemented and maintained Data Guard and standby databases, Snapshot maintenance and creation for Production database.

·         Have done capacity planning, space management, database upgrades/migration for production.

·         Done production server Performance Tuning - Thread Dump Analysis, Core Dump Analysis when Server crashed unevenly.

·         Worked with customer for different RAC related issue: (hangcheck timer, split brain, RAC recovery, ASM, OCR corruptions, Voting disk loss & so on)

·         Used LTOM and SQLT for tuning queries.

·         Used OSW for troubleshooting RAC Cluster waits.                             

·         Involved in solving Identity Management issues with the provisioning and access issues involving Oracle Access Manager, OID and OIM console.

 

 

 

 

 

Conacent Consulting Pvt. Ltd., Kolkata, India                                                                    November 2009 – October 2010

Oracle DBA and Oracle Apps DBA

 

 

Responsibilities:

·         Database tuning, Application Tuning & performance monitoring. Fine tuning Initialization parameters, I/O, Memory and Operating System kernel parameters for production system.

·         Installed Oracle Cluster File System (OCFS) and created partitions.

·         Integrated Oracle E-Business Suite 11.5.10 configuration and setup connect-time failover and JDBC load balancing.

·         Administering the Indexes as there is fragmentation of the indexes rebuilding indexes as and when necessary.

·         Applied and documented patches that included mini-patch sets, standalone patches and upgrade patch sets.

·         Used AWR and ASH to monitor and tune database performance.

·         Changing and tuning TCP/IP buckets and other database parameters for faster performance.

·         Administered security (create users and responsibilities) and provided end-user support.

·         Provided support to development and implementation groups for all application instances.

 

A. K. Industries, Kolkata, India                                                                                                        June 2008 – Oct 2009

Oracle DBA

 

Responsibilities:

·         Implemented various Database Backup Strategies like export backups, cold backups and RMAN backups.

·         Monitoring alert log, trace files, locks, sessions for database problems.

·         Creating users, allocation to appropriate table space, quotas with necessary privileges and roles for all databases.

·         Managing physical structure of Oracle database Data files, Redo log files, Control files.

·         Monitoring & managing the tablespaces and data files growth.