Granthana Biswas

Upgrade PostgreSQL from 9.1 to 9.3 on all staging and Live environments. Upgrade MySQL from 5.1 to 5.6 on all staging and Live environments. Build stored procedures to improve certain work flow. Create standard backup script for Postgres and mysql. Provisioning of backup scripts and cronjobs on all servers using Salt. Managing database configuration and installation using Salt. Troubleshooting issues and reporting. Data fix. Database deployments.

Design of database schema for high performance. Implementation of Connection Pooling using PGBOUNCER. Implementation of cascading replication using Slony-II & streaming replication. DB upgrade from 8.4 to 9.3 using Slony-II. Implementation of Rundeck job scheduler. Query optimisation & database tuning. Reporting & troubleshooting. Implementation of Zabbix monitoring system. Management of multi environment releases & git repository. Shell scripting for automating tasks & reporting.

Design of database schema for high performance. Implementation of database sharding using PLPROXY. Automation of cold & hot backups using shell script on Jenkins. Implementation of online backups & PITR. PostgreSQL upgrade from 9.1 to 9.3. Setup of Postgresql streaming replication. Implementation of DB load balancing using PGPOOL & PGPOOL upgrades. Implementation of DB monitoring using ZABBIX. Database benchmarking using PGBENCH. PL/SQL. Unit testing of DB schema & stored procedures using PgTap.

Database Backup and recovery. SQL query tuning. Optimising and tuning existing PL/SQL procedures. Database partitioning. Implementation of PITR in PostgreSQL. Shell scripting to automate monitoring, backups and restore. PL/SQL coding(procedures,functions&triggers). Data migration. Working on E-Discovery application.

Cold and hot backups on Oracle 11g. Troubleshooting Database issues. Oracle Argus administration training. E2B submissions and XML importing. Report generation through application.

Installation of Oracle 10g version 10.2.0.1 on Windows/Linux(RHEL4). SQL query handling. Managing tablespaces, datafiles and database objects. Managing users, roles and privileges. Backup & cloning in Oracle Apps 11i. Backup and recovery in 10g including hot and cold backup. ! Applying patches for upgrading and cloning in 10g. Conducted SQL, PL/SQL and Oracle Fundamental I training. ! Installation of R12.1.1 on RHEL 5.4 & WindowsXP. Following SRs on metalink