Santanu Das

• Attended training programs to deepen professional skillset and assisted in training fellow store associates on existing and new training programs.
• Followed all company policies and procedures to deliver quality work.
• Attended training programs to deepen professional skillset and assisted in training fellow store associates on existing and new training programs
• Followed all company policies and procedures to deliver quality work

Project 1: Media Material Management as PostgreSQL DBA (April 2023 – present)

Responsibilities so far:

• Migrate database objects from SQL server to Postgres on AWS platform.
• Convert/Re-write stored procedures / functions used in SQL server to migrate to PostgreSQL
• Test and deploy on lower env.

Project 2: Mobile Banking solutions as Oracle DBA (Aug 2021 – present)

Responsibilities so far:

• Worked with the engineering team to analyze, design, develop and test and then deployment starting from lower env., eventually to production
• Setting up guidelines to help developers write DB scripts with minimal errors.
• Review and release DB scripts for execution written / shared by developers.
• Refresh DB in various envs.
• Automating tasks using stored procedures as and when needed by developed functionality .
• Supporting management with different database related decisions.
• Developing various reporting capabilities for production database.
• Documented all activities performed at server level

Project 3: AI solutions as NoSQL DBA (April 2021 – Aug 2021)

Responsibilities were:

• Research and suggest suitable NoSQL database for developing the backend storage.
• Install, configurations on lower envs for development to progress.
• Helped developers to write AQL queries for backend interactions.
• Supporting management with different database related decisions.
• Documented all activities performed at server level

Project 4: eHealth and Fitness solutions as MySQL/Cloud DB (Nov 2019 - April 2021)

Responsibilities were:

• Performed databases configuration, backup, recovery, security, upgrade and schema changes, tuning.
• Worked with the engineering team to analysis, design, development and testing and then deployment.
• Migrating on premise DB to AWS cloud.
• Automating DB tasks using stored procedures.
• Reviewing existing DB size and load and then implementing DB server class selection to reduce cost and apply Autoscaling policies to distribute database load.
• Setting and updating DB parameters at different occasions through Parameter Groups.
• Managing/Troubleshooting MySQL in production, development and testing database servers.
• Written scripts to be used for back-end work management.
• Supporting management with different database related decisions.
• AWS setup with EC2 and RDS accessibilities with proper security configurations.
• Creating various reporting capabilities for production database using AWS Lambda.
• Other activities like SSL certificate update, Aurora engine upgrade etc.
• Documented all activities performed at server level
• Determined areas for improvement and implemented processes to alleviate problems
• Led the development of customized solutions for clients based on their unique business needs and requirements

Project 1: eCommerce solutions as MySQL/Aurora DBA(May 2017 – Nov 2019).

Responsibilities were:

• Performed MySQL database design, installation, configuration, backup, recovery, security, upgrade and schema changes, tuning and data integrity.
• Worked with the engineering team to implement new design systems of databases used by the company following SDLC phases like requirement analysis, design, development and testing and then deployment.
• Managing/Troubleshooting MySQL in production, development and testing database servers.
• Increased database performance by utilizing MySQL configuration changes & replication.
• Involved in sizing, query optimization, buffer tuning.
• Performance Tuning on a daily basis for preventing issues and providing capacity planning using MySQL Enterprise Monitor.
• Configured TDE to protect data at rest.
• Provisioned physical backup of production databases using MySQL Enterprise Backup.
• Written scripts to be used for back end work management.
• Supporting management with different database related decisions.
• AWS setup with EC2 and RDS accessibilities with proper security configurations.
• Creating various reporting capabilities for production database.
• Documented all servers and databases
• Set up and controlled user access levels across databases to protect important data
• Created and updated database designs and data models
• Modified databases to meet needs and goals determined during planning process

Projects 1: Annual Performance Appraisal Reporting System (APARS) for North Eastern Power Corporation (NEEPCO) as MySQL/PostgreSQL DBA (Feb 2017 – April 2017).

Responsibilities were:

• Installed, security, and maintenance of PostgreSQL configuration.
• PostgreSQL on both Linux and Windows.
• PostgreSQL database backup and recovery strategies

Projects 2: Assam State e-District project under National e-Governance Plan (NeGP) as Sr. MySQL DBA under Medhassu e Solutions India Pvt Ltd (Feb 2015 – April 2017)

Responsibilities were:

• Installed and configured MySQL on Linux environments.
• Performed new databases design, configuration, backup, recovery, security, upgrade and schema changes, tuning and data integrity.
• Worked with the engineering team to implement new design systems of databases used by the company following SDLC phases like requirement analysis, design, development and testing and then deployment.
• Managing/Troubleshooting MySQL in production, development and training database servers on Linux.
• Increased database performance by utilizing MySQL configuration changes & replication.
• Involved in sizing, query optimization, buffer tuning, backup and recovery, installations, upgrades and security.
• Performance Tuning on a daily basis for preventing issues and providing capacity planning using MySQL Enterprise Monitor.
• Proficiency in Linux shell commands.
• Written shell script to be used for some back-end work management.
• Supporting management with different database related decisions.
• Documented all servers and databases.
• Set up and controlled user access levels across databases to protect important data
• Created and updated database designs and data models

Project 1: Infrastructure Pvt Ltd. As MySQL DBA (Jan 2013-Jan 2015)

Responsibilities were:

• Key person in the team who was involved in developing the site using Java and MySQL.
• Development, testing and implementation.
• Database designing, development using stored procedures, views, joins etc and performance enhancement activities.
• Project flow was UAT to Production

Project 2: Hospital Management System Security & Maintenance Database as Oracle DBA (Jan 2012 – Dec 2013)

Responsibilities were:

• I was the main concerned person of this project who took the requirement from client and Involved in Database security design and application development with help of my group.
• Installing / Configuring Oracle DB Server
• Design and implement database as per the project requirement.
• Implement database security using audit policies.
• Define backup & recovery using RMAN.

Achievements

• Reorganized databases and sized database objects to meet standards and improved performance by 70%.
• Enhanced database accessibility by improving back-end queries of application, introducing proper user access, and increasing security and stability.
• Served as an internal consultant for application developers, providing guidance on query optimization techniques that improved application performance significantly
• Provided timely resolution of critical production issues, minimizing downtime and avoiding potential revenue loss.
• Served as an internal consultant for application developers, providing guidance on query optimization techniques that improved application performance significantly.
• Set up and controlled user access levels across databases to protect important data.
• Tested programs and databases to identify issues and make necessary modifications.
• Trained junior team members on best practices for database administration, promoting a culture of continuous learning within the organization.
• Created and updated database designs and data models.
• Created and implemented database designs and data models.

• Oracle and Java Global Certification Trainer - New Horizons Guwahati and Trendsetters Career Academy Guwahati
• IT Trainer in institutes like CMC Guwahati, CDAC Dimapur, Datapro Guwahati, .
• Improved trainee performance through targeted coaching sessions addressing individual skill gaps.
• Collaborated with fellow trainers to develop comprehensive lesson plans, ensuring consistent delivery of material.
• Provided technical support during training sessions, resolving issues promptly and effectively.
• .Supported company-wide technology initiatives by designing curriculum for cross-functional training sessions on relevant IT systems and processes.
• Maintained up-to-date knowledge on industry trends and emerging technologies, integrating relevant information into course content.