Here's some of the high level duties I perform:1.Manage the Database team for the Enterprise Technology division2.Product owner for AWS Redshift data warehouse database platform.3.Manage Redshift warehouse solution implementation project4.Work with our team to manage and migrate databases to AWS RDS platforms like MSSql, PostgreSQL, MySQL and Redshift.5.Calypso – Payment system project – data modelling, physical database design, data migration.6.Sybase 16 upgrade… Show more Here's some of the high level duties I perform:1.Manage the Database team for the Enterprise Technology division2.Product owner for AWS Redshift data warehouse database platform.3.Manage Redshift warehouse solution implementation project4.Work with our team to manage and migrate databases to AWS RDS platforms like MSSql, PostgreSQL, MySQL and Redshift.5.Calypso – Payment system project – data modelling, physical database design, data migration.6.Sybase 16 upgrade project – working with project team on application/data migration.7.Provide production support.8.Performance tuning and assisting development team on Various project with sql coding.9.Day to day dba work – Database backup, update stats, dbcc etc..10.Write scripts to automate stats gathering using Sybase MDA tables.11.Work on automation of the daily database refreshes from production to test and development environments.12.Install replication servers and set-up table level replication between databases. Show less

Working on :1.Sybase 15 upgrade project – working with project to assist with testing, analysis of performance and data migration scripting.2.Setting up replication for Bermuda project.3.Performance tuning of existing application.4.Day to day dba work – Database backup, update stats, dbcc etc..5.Write scripts to fix the existing monitor problem.

Responsibilities:1.Work with the development team to Design and implement physical solution for their logical solution.2.Lead the FSG (Financial Services Group) DBA team.3.Manage the resources and allocate projects to the DBAs as required.4.Provide support required by the team members including trouble shooting and conflict resolution.5.Fine tune existing applications on various Sybase, Oracle and MSSql versions ( Sybase 11.5.X, 12.X, 15.0.2, Oracle 8i, 9i and 10g MSSql… Show more Responsibilities:1.Work with the development team to Design and implement physical solution for their logical solution.2.Lead the FSG (Financial Services Group) DBA team.3.Manage the resources and allocate projects to the DBAs as required.4.Provide support required by the team members including trouble shooting and conflict resolution.5.Fine tune existing applications on various Sybase, Oracle and MSSql versions ( Sybase 11.5.X, 12.X, 15.0.2, Oracle 8i, 9i and 10g MSSql 2000 and 2005).6.Write infrastructure for Oracle Backups, Export, Import, Analyse Schema and Table space growth and alerting using shell scripting and Perl.7.Perform day to day DBA type of work for all Sybase, Oracle and MSSql databases i.e. Install servers, Upgrade server, Backups, Monitor Performance, Monitor database growth, Create databases, create logins/users, drop logins/users etc.8.Assist developers with programming in sql. Assist developers with tunning of sql and if need be teach them how to write/tune sql.9.Perform upgrade/apply patches to databases servers as required.10.Implement Oracle grid control for managing Bank’s Oracle instances.11.Provide 24x7 on-call support for the Bank.12.Work in collaboration with central DBA team.Major Achievements:1.Successfully designed and implemented physical solution for various projects in the Bank.2.Successfully reviewed and finetuned Bank’s various applications.3.Setup infrastructure for Oracle Backups using RMAN, monitor and provide ongoing support for various database environment using Oracle Grid and management packs.4.Successfully migrated Bank’s various applications from Sybase 11.5.x to 12.X and lately 15.0.25.Successfully migrated Bank’ various application from Oracle 8i to 9i and lately to 10g6.Written scripts to automate the Sybase server build process based on the Bank’s DBA install standard.7.Define the Oracle database standard and get buy in from the DBA team. Show less