Pl/SQL
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
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