Bijoy Konwar
Etterbeek
Summary
Dynamic Senior Consultant with extensive experience at HCL, specializing in Oracle database management and automation. Proven track record in risk analysis and mitigation, enhancing database resilience, and optimizing performance. Adept at leading teams and fostering collaboration, driving significant improvements in database environments while ensuring high availability and disaster recovery.
Overview
21
21
years of professional experience
Work History
Senior Consultant
HCL
10.2021 - Current
- Currently working as Domain manager leading team of RDBMS DBA’s, Data architects, NoSQL DBA’s Couchbase, Teradata, Bigdata (HDP & CDP) & Datastax Cassandra.
- Directly involve with client for ongoing database projects and upcoming projects.
- Focusing on automation and improvement in Database environment.
- Analyzing RISK in environment and providing mitigation plan to customer and implement accordingly.
- Focusing on Problem Management and providing RCA and reduce P1/P2 in environment.
- Migrating on premise non-RAC and non-CDP database to EXACC Cloud@Customer with RAC and Dataguard.
- Doing resilience testing for all critical databases with application team for HA/DR.
- Supporting all Oracle PROD/UAT/DEV databases, handling critical incident, and providing RCA for the same.
04.2019 - 09.2021
- Leading Database Track (Oracle, MS-SQL) for both Luminus projects.
- Directly involve with client for ongoing database projects and upcoming projects.
- Focusing on automation and improvement in Database environment.
- Migrated DWH Oracle database 11g (Windows) to 19c (Oracle Linux 8.3).
- Analyzing RISK in environment and providing mitigation plan to customer and implement accordingly.
- Involving multiple upgradation projects 12c to 19c and upgrading OMS 13.2 to 13.4.
- Installation and setup OEM monitoring in Luminus environment.
- Focusing on Problem Management and providing RCA and reduce P1/P2 in environment.
- Supporting all Oracle PROD/UAT/DEV databases, handling critical incident, and providing RCA for the same.
- Planning DR and successfully implement in Luminus environment.
- Successfully did transition/migration for both projects Luminus & Borealis.
- Involved LIFT and SHIFT for one DC to another DC and supported for Database side.
04.2019 - 08.2021
- Leading Database Track (Oracle, MS-SQL & MY-SQL) for both Borealis projects.
- Involved transition Oracle database in Borealis projects and supports BAU as well.
- Analyzing RISK in environment and providing mitigation plan to customer and implement accordingly.
- Involving multiple upgradation projects 12c to 19c and upgrading OMS 13.2 to 13.4.
- Installation and setup OEM monitoring in Borealis environment.
- Focusing on Problem Management and providing RCA and reduce P1/P2 in environment.
- Supporting all Oracle PROD/UAT/DEV databases, handling critical incident, and providing RCA for the same.
12.2017 - 04.2019
- Setup backup and monitoring using OEM 12C with other WebLogic Middleware environment as well.
- Doing setup Oracle Coherence Cluster Setup by using OEM 12C.
- Performing database migration and upgradation to 12c in cross platform as well.
- Performing backup and recovery of the databases using RMAN.
- Disaster Recovery setup & maintenance.
- Build new database environment as per projects request by client.
- Supporting all Oracle PROD/UAT/DEV databases, handling critical incident, and providing RCA for the same.
PepsiCo
05.2014 - 11.2017
- Implement problem/change tickets through HP Service manager.
- Handlings team members and coordinate with clients and application users and support 24
- 7 databases.
- Supporting multiple Projects in PepsiCo and directly communicate with client and gather requirements and working accordingly.
- Working in RAC environment with ASM and provide Disaster Recovery (HA) with DATAGUARD (Physical Standby database).
- Database cloning/refresh through manually, Export/Import and RMAN.
- Monitor and optimize performance of the database using AWR/ADDM/ASH report (SQL tuning, Memory tuning).
- Performing database migration and upgradation to 12c in cross platform as well.
- Performing backup and recovery of the databases using RMAN.
- Disaster Recovery setup & maintenance.
- Handling critical incidents (P1/P2) and later providing RCA and documenting details using Problem Management tickets.
- Worked in client side (UK) with Application team and supporting whole ESSA region for PepsiCo.
Dowjones
07.2012 - 04.2014
- Implement problem/change tickets through Remedy (Symphony).
- Working in RAC environment with ASM and provide Disaster Recovery (HA) with DATAGUARD (Physical Standby database).
- Database cloning/refresh through manually, Export/Import and RMAN.
- Patch analysis and applying patches.
- Troubleshooting performance related problems.
- Monitor and optimize performance of the database using AWR/ADDM/ASH report (SQL tuning, Memory tuning).
- Performing backup and recovery of the databases using RMAN.
- Disaster Recovery setup & maintenance.
Principal Infrastructure Engineer
Mphasis
02.2012 - 06.2012
- Support multiple clients (NIKE, ADIDAS, FOXSPORTS, CABLEVISION, XIGN, GSK, BIOGEN).
- Implement problem/change tickets through Remedy.
- Tablespace management and Space management.
- Proactive monitoring of different databases.
- Performing backup and recovery of the databases using RMAN.
- Disaster Recovery setup & maintenance.
- Working in RAC environment with ASM and provide Disaster Recovery (HA) with DATAGUARD (Physical Standby database).
- Database cloning/refresh through manually, Export/Import and RMAN.
- Database reorganization.
- Monitor and optimize performance of the database using AWR/ADDM/ASH report (SQL tuning, Memory tuning).
- Patch analysis and applying patches.
- Troubleshooting performance related problems.
- Creating users and roles for different modules.
- An HP company.
Senior DBA
Wipro Technologies
04.2010 - 02.2012
- Performing backup and recovery of the databases using RMAN.
- Disaster Recovery setup & maintenance.
- Working in RAC environment with ASM and provide Disaster Recovery (HA) with DATAGUARD (Physical Standby database).
- Regular database administration including develop user profile, maintained security and authorization.
- Monitored user access to database, management of system and application tablespaces.
- Managed data files, Redo logs and control files.
- Monitored storage settings by altering tablespaces.
- Monitor and optimize performance of the database using AWR/ADDM/ASH report.
- Re-organization of tables / index rebuilding as part of performance measures.
- Managing space usage.
- Data Migration activities (Export/Import).
- Installation and cloning of Oracle database environment.
- Patch analysis and applying patches in different development.
- Troubleshooting performance related problems.
- Creating users and roles for different modules.
- Logical Backup through Data Pump(EXPDP/IMPDP).
- Greater Noida.
DBA
TCS
07.2008 - 04.2010
- Database Administration, Troubleshooting, Installation & upgradation on UNIX.
- Installed and Configured Oracle Real Application Cluster (RAC) and ASM with 2 nodes on Solaris.
- Allocating system storage and planning future storage requirements.
- Modifying the database structure (Erwin, Toad).
- Managing database users with all access and security implications.
- Performing backup and recovery of the databases using RMAN.
- Disaster Recovery (Data Guard) setup & maintenance.
- Database Cloning.
- SQL & Database tuning using AWR Reports, Explain Plans, SQL Trace and TKPROF.
- Administer all database objects, including tables, clusters, indexes, views, sequences, packages and procedures.
- Deciding partition strategy to maintain tables with large number of records.
- Creating users and roles for different modules.
- Logical Backup through EXP/IMP (Parfile) Dump.
- Logical Backup through Data Pump(EXPDP/IMPDP).
- Gurgaon.
DBA
Cybex Exim Solution Pvt Ltd
10.2006 - 07.2008
- Database Administration, Troubleshooting, Installation & Upgradion on Windows NT.
- Allocating system storage and planning future storage requirements.
- Modifying the database structure.
- Managing database users with all access and security implications.
- Performing backup and recovery of the databases using RMAN.
- Disaster Recovery setup & maintenance.
- Database Cloning.
- SQL & Database tuning using Statspack Reports, Explain Plans, SQL Trace and TKPROF.
- Administer all database objects, including tables, clusters, indexes, views, sequences, packages and procedures.
- Setting up and maintaining warm standby databases.
- Database analysis & design for business needs in cooperation with various levels of business and systems personnel.
- Provide technical expertise and lead junior developers in writing SQL.
- Optimize SQL & PL/SQL packages using oracle various Oracle optimizer, PLAN_TABLE & DBMS_XPLAN. DISPLAY, Indexes, Table partitioning & PL/SQL optimizer.
- Data loading using SQL
- Loader and Oracle external tables.
- Noida (U.P.).
Junior DBA
Infodrive India Pvt Ltd
01.2005 - 09.2006
- Installation, upgrade Oracle Software, creating roles & privileges, Backup / Recovery through RMAN and User managed i.e. backed up manually by executing commands specific to the user's operating system.
- Monitoring Database Growth, creating tablespace, add new datafiles if required.
- Performance tuning through STATEPACK, TKPROF, ULBSTATE-ULESTATE and Execution Plan etc.
Education
2 Years Post Graduate Diploma - Computer Software Technology
ET&T
New Delhi, India12.2002
B.Sc. - Phy, Chem, Math
Dibrugarh University
01.2000
One-year Diploma Course - Computer Application
Dibrugarh University
01.2000
H.S.S.L.C. -
A.H.S.E.C.
01.1996
H.S.L.C. -
S.E.B.A.
01.1993
Certificate in Computing -
Indira Gandhi National Open University
OCA - 10g on DBA Track
Oracle
OCP - 11g on DBA Track
Oracle
OCP - 10g on DBA Track
Oracle
Skills
- Linux and UNIX systems
- IBM AIX and Sun Solaris
- Windows operating systems
- Oracle database management (9i, 10g, 11g, 12c, 18c, 19c)
- MySQL and PostgreSQL
- Datastax Cassandra
Languages
- English
- Hindi
- Assamese
References
- Ajoy Sonowal, IIS, ERP-Basis, IDC, BHARAT PETROLEUM COP. LTD., ajoys@bharatpetroleum.com, 9999597997
- Naveen Verma, Associate Consultant, Tata Consultancy Services, Gurgaon, naveen.verma@tcs.com, 9810599314
Personal Preferences
Personal interview, IT, Negotiable, Any
Personal Information
- Passport Number: S5475118
- Passport Date Of Issue: 08/08/18
- Passport Expiry Date: 07/08/28
- Date of Birth: 03/01/78
- Gender: Male
- Nationality: Indian
- Marital Status: Married
Timeline
Senior Consultant
HCL
10.2021 - Current
04.2019 - 09.2021
04.2019 - 08.2021
12.2017 - 04.2019
PepsiCo
05.2014 - 11.2017
Dowjones
07.2012 - 04.2014
Principal Infrastructure Engineer
Mphasis
02.2012 - 06.2012
Senior DBA
Wipro Technologies
04.2010 - 02.2012
DBA
TCS
07.2008 - 04.2010
DBA
Cybex Exim Solution Pvt Ltd
10.2006 - 07.2008
Junior DBA
Infodrive India Pvt Ltd
01.2005 - 09.2006
2 Years Post Graduate Diploma - Computer Software Technology
ET&T
B.Sc. - Phy, Chem, Math
Dibrugarh University
One-year Diploma Course - Computer Application
Dibrugarh University
H.S.S.L.C. -
A.H.S.E.C.
H.S.L.C. -
S.E.B.A.
Certificate in Computing -
Indira Gandhi National Open University
OCA - 10g on DBA Track
Oracle
OCP - 11g on DBA Track
Oracle
OCP - 10g on DBA Track
Oracle