Somnath Chatterjee

· Optimized performance of production and non-production databases, significantly reducing operational costs for Azure PaaS SQL databases through efficient DB tuning and resource management.

· Developed complex business queries and stored procedures tailored to business requirements, facilitating improved data access and manipulation.

· Set up SQL Server environments, created databases, and configured necessary user logins to ensure business readiness.

· Conducted ad-hoc backups and participated in database restoration activities using the Point-In-Time Restore (PITR) feature as per business needs.

· Engaged in creating a Database Disaster Recovery (DR) site and implemented our database to run in DR as part of DR drills.

· Automated database maintenance tasks such as index rebuilding and table statistics updates using stored procedures and Azure Data Factory (ADF) pipelines, enhancing DB health and minimizing manual intervention.

· Engaged in deep architectural discussions to foster customer confidence and ensure successful application development and migration on the Power Platform.

· Created and managed Azure alerts to meet specific business requirements.

· Assisted in analyzing and resolving performance issues related to Azure infrastructure and applications.

· Supported application teams in reducing database sizes and implementing archiving strategies to lower storage costs.

· Collaborated with cross-functional teams to identify and implement performance enhancements for critical business applications.

· Provided training and mentorship to junior team members on database management best practices and performance tuning techniques.

· Developed and maintained comprehensive documentation for database configurations, processes, and procedures, ensuring knowledge transfer and operational continuity.

Senior Cloud Database Administrator, KFC OrderServ

· Participated in deep architectural discussions to build confidence and ensure customer success when building new and migrating existing applications, software and services on the AWS platform.

· Designed and implemented RDS instances and read replicas for Database read throughput and used Multi AZ deployment for high availability.

· Analyzed, developed, and executed a plan to migrate eligible applications from on premise to a cloud solution .

· Developed PL/SQL packages, DML, DDL, tables, Stored Procedures,functions, cursors, triggers.

· Designed and implemented archiving of Database .

· Proficiency and Expertise in SQL Server Replication,Backup/Recovery,Disaster Recovery and Planing .

· Designed and implemented high-availability solutions using AWS Multi-AZ .

· Conducted database performance testing and provided recommendations for optimization and scalability

· Worked with development teams to implement database best practices for query optimization, index creation, and database design optimization.

· Designed and implemented disaster recovery plans using AWS S3 and Glacier

· Implemented database monitoring and alerting using AWS CloudWatch .

ETL Developer, KCI USA, Inc. Kinetics Adv.Center

· Designed integration tools to combine data from multiple, varied data sources such as RDBMS, SQL,flat files etc .

· Engaged in designing, developing, testing, support and debugging of new ETL processes.

· Interpreted data models for conversion into ETL diagrams and code.

· Cooperated with developers, data architects, DBAs, project managers, & client business users to develop specifications.

· Developed ETL (Talend) jobs to migrate & transform data from the main source system to staging area that is compatible with pega pyWorkPage structure.

Pega Application DBA, Centene-CenPAS DevOps Services

· Troubleshooting & performance tuning of PRPC applications using Clipboard, Tracer.

· Performance tuning of Pega OOTB queries .

· Monitoring the servers' health of different PEGA environments, Agents, Listeners .

· Involved to take the PAL readings for the improving the application performance.

· Reviewing the PEGA Log files, Rule logs and Technical design documents which are prepared by the team members.

Database Administrator & Performance Specialist BT-Billing & Payment

· Administered, supported and monitored databases by proactively resolving database issues and maintaining servers.

· Tested programs and databases to identify issues and make necessary modifications.

· Set up and controlled user profiles and access levels for each database segment to protect important data.

· Created and implemented database designs and data models.

· Monitor and fully analyze performance issues in production Oracle databases by using AWR/ADDM/OEM 13c .