Summary
Overview
Work History
Education
Skills
Dancing, I do hand crafting in my spare time . Cooking is my hobby
Software
Certification
Timeline
Generic

SUBINITA BHKATA

Database Developer
Kolkata

Summary

Experienced PL/SQL Developer with over 5+ years of experience in TCS. Excellent reputation for resolving problems and improving customer satisfaction.

Overview

6
6
years of professional experience
4
4
years of post-secondary education
5
5
Certifications
1
1
Language

Work History

Database Programmer

Subinita Bhakta
Kolkatta
09.2016 - Current
  • Having 5+ Years of experience as Senior PostgreSql Database Administrator involved in backup and recovery methodologies, monitoring database performance.. etc.
  • Having support & troubleshooting experience in 24x7 environments.
  • Built databases and table structures for web applications.
  • Developed and updated databases to handle customer data.
  • Designed and developed analytical data structures.
  • Planned and installed upgrades of database management system software to enhance database performance.
  • Creating and dropping schemas and users in PostgreSQL.
  • Killing an unwanted and specific session in PostgreSQL.
  • Logical and physical backup and recovery of all databases in PostgreSQL.
  • Configured and Database installation creating tables, schemas, roles and accessed POSTGRSQL.CONF files using client Request.
  • Monitoring the production PostgreSQL alert logs for database errors.
  • Check Alert Log errors and make necessary actions to rectify them.
  • Monitoring the database for Index, partitioning Memory and I/O utilization.
  • EXPLAIN and EXPLAIN ANALYZE to identify and fine tune sql queries for performance improvements.
  • Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).
  • Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
  • Developed materialized views for data replication in distributed environments.
  • Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.
  • Worked extensively on Ref Cursor, External Tables and Collections.
  • Expertise in Dynamic SQL, Collections and Exception handling.
  • Experience in SQL performance tuning using Cost-Based Optimization (CBO).

Education

Bachelor of Engineering Technology - Electrical And Instrumentation Engineering

DR.B.C Roy Engineering College
Durgapur, Westbengal
08.2012 - 06.2016

Skills

    Solution development

Report generation

Teamwork and Collaboration

Multitasking Abilities

MS Office

Software Proficiency

Dancing, I do hand crafting in my spare time . Cooking is my hobby

  • I learned dance bharatanatyam and rabindranritya professionally.
  • I do hand crafting in my spare time.
  • Cooking is one of my hobby.

Software

Pl/SQL

JAVA

HTML

Certification

Foundation : PostgreSQL Intermediate

Timeline

Foundation : PostgreSQL Intermediate

05-2020

Foundation : Oracle PL/SQL_Foundation

04-2017

Foundation : Fundamentals of PostgreSQL_Foundation

03-2017

ILP : Java Programming Essentials V2.0

02-2017

Foundation/IT IS : Oracle 11g PL/SQL_Foundation

02-2017

Database Programmer

Subinita Bhakta
09.2016 - Current

Bachelor of Engineering Technology - Electrical And Instrumentation Engineering

DR.B.C Roy Engineering College
08.2012 - 06.2016
SUBINITA BHKATADatabase Developer