Oracle Database Administration
Resume:
ANGSHUMAN CHATTERJEE
***********@*****.***
Professional Summary
Experienced database professional, predominantly in SQL, PL/SQL, Oracle Database Administration, Database performance tuning, Data Warehousing, ETL, Hadoop and other expertise – Systems Analysis, Design, Development and Implementation of application software. Experienced in multiple RDBMS (Oracle, DB2, MSSQL, PostgreSQL, MySQL/MariaDB), No-SQL database (Impala, Hive, Hbase, MongoDB), Time Series database (Timescale, Elasticsearch) and scripting language (bash, python).
Achievement Played a key role in designing and implementing many projects both in OLAP and OLTP database.
Worked in various domains like Telecom, Banking and Finance etc.
Experience in Logical and Physical Design of Databases for OLTP and Data
Warehouse.
Work History Current: Lund University, MaxIV Laboratory (Jan’2022-Till Date)
Previous: TEOCO Software Pvt. Ltd. (Dec’2016-Jan’ 2022)
Mobile2Win India Pvt. Ltd (Formerly Connectiva Analytics and
Insights (I) Pvt. Ltd.) (Dec’2013-Dec’2016)
Euphoria Infotech (I) Pvt. Ltd. (Jul’2001 – Nov’2013)
Magnum Infotech Pvt. Ltd. (Oct’1999 – Jun’2001)
Sascon Pvt. Ltd. (May’1998 – Sep’1999)
Skill and Expertise
OS : UNIX, Linux (RHEL), Ubuntu, Debian, CentOS, MS-Windows
RDBMS : Oracle (8-19c), IBM DB2 (9.x), MSSQL, MySQL/ MariaDB,
PostgreSQL
Hadoop : Cloudera
NoSQL : Hive, Hbase, Impala, MongoDB
Language/Tools : SQL, PL/SQL, Visual Basic, Toad, SQL-Developer
Development Tools : Oracle Developer 2000/IDS 10g (Forms & Reports)
Scripts : UNIX Shell script, Dos Batch script, Python, Perl
Others : Crystal Reports, Birt, SVN, Jira, Perforce, Gitlab
Work Experience – Current
Organization: Lund University, MaxIV Laboratory
Location: Sweden
Role: Database Administrator
January-2022 to Till Date
Responsibility Overview:
Setting up and maintenance of database clusters (Oracle, MSSql, PostgreSQL, MySQL, MariaDB, MongoDB and Timescale database)
Interfacing with different teams to understand requirements related to the DB environment
Address issues of performance, reliability, scaling
Backup and recovery of database environments
Periodical code review to mitigate the trends in increased cyber security threats in the organisation.
Work Experience – Previous
December-2016 to January-2022
Organization: TEOCO Software Pvt. Ltd
Location: India
Role: DBA Expert
Responsibility Overview:
Oracle Database (11g, 12c, 18c, 19c) Installation, patch installation, Database performance tuning
SQL and PL/SQL performance optimization
Resolving issues in production database
Shell scripting
Hadoop Cluster Installation & management (Cloudera) and developing scripts for Impala
December-2013 to December-2016
Organization: Mobile2Win India Pvt. Ltd (Formerly Connectiva Analytics and Insights (I) Pvt. Ltd.)
Location: India
Role: Senior Associate
Responsibility Overview:
Involved in issue fixing, modification and development of Revenue Assurance and Fraud
Management product.
Performance tuning of the production database towards optimal performance.
Migration of product scripts from Oracle to Db2/Hadoop (Hive)/PostgreSQL/MySQL.
Developed Procedures/Functions/Triggers to perform data loading, error handling and logging.
Optimized lot of SQL statements and PL/SQL blocks to enhance the performance of data loading and KPI generation.
Involved in PL/SQL code review and modification for the development of new requirements.
Collaborate and communicate with BA and ETL teams to correctly implement the projects.
July-2001 to November-2013
Organization: Euphoria Infotech (I) Pvt. Ltd.
Location: India
Role: Project Manager
Responsibility Overview:
Successfully managed a development team and developed/implemented a number of projects in various Domains (Telecom, Banking, Finance etc.).
October-1999 to June-2001
Organization: Magnum Infotech Pvt. Ltd.
Location: India
Role: Programmer Analyst
May-1998 to September-1999
Organization: Sascon Pvt. Ltd.
Location: India
Role: Systems Executive
Education
1996-1998 Advance Diploma in Software Engineering from Brainware consultancy Pvt Ltd
1993 Bachelor of Science from Calcutta University
1991 Higher Secondary (West Bengal Council of Higher Secondary Education)
1989 Secondary from (West Bengal Board of Secondary Education)
Personal Information
Name Angshuman Chatterjee
Date of Birth 17th of January 1973
Nationality Indian
Marital status Married
Address (current) Lund, Sweden
Address (permanent) Kolkata, India.
Skype angshuman.ch
LinkedIn https://www.linkedin.com/in/angshuman-chatterjee
Passport Validity till October 27, 2031
Contact this candidate