Souparno Roy Choudhury

• Lead a team responsible for the administration of mission-critical SQL Server, Sybase, and PostgreSQL database environments.
• Implemented performance tuning strategies, resulting in a 20% improvement in query response times.
• Developed and maintained backup and disaster recovery plans, ensuring data availability and compliance with industry regulations.
• Conducted regular security audits, enhanced database security protocols, and implemented encryption measures.
• Collaborated with application development teams to optimize database schema and queries, reducing application downtime.
• Oversaw data migration projects between different database platforms, ensuring data integrity and minimal downtime.
• Introduced automation scripts, reducing routine administrative tasks and improving operational efficiency.
• Managed database capacity planning and scaling activities to accommodate data growth.
• Played a key role in the successful migration of legacy databases to modern platforms.
• Resolving SQL Server AG out of Sync issues.
• Fixing SQL server DB Replication issues.
• Restoring SQL Server and Postgresql databases hosted on RDS instances.
• Providing user permissions and roles in SQL,Postgres and sybase instances .
• Fixing replication threads down issues of sybase databases.

• Install SQL Server and configure the SQL Servers as per the best practices. Installing SQL patches and upgrade the SQL servers to new versions.
• Perform DB refresh activities. Verify the Database consistency errors, disk space errors and fix the issues.
• Creation of Logins, Roles and Granting permissions as per the request.
• Monitor the maintenance jobs and fixing the issues if any.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
• Configure and maintain high availabilities solutions (Like Log Shipping, Mirroring, Replication,
  Clustering) as per the project requirement.
• Perform DR and Failover activities to maintain the readiness during disaster recovery situation.
• Worked with customers on Application rollouts and server migrations.
• Using tools SQL Profiler and Windows Performance monitor to troubleshoot SQL performance issues
  if necessary.
• Perform Health check of Sybase databases.

• Diagnose and troubleshoot the Production Server on the fly.
• Installation of Sybase 12.5.4 and Sybase 15.0.3
• Responding to alters received via mail & calls
• preparing reports of sysmon, system growth, forward and deleted rows and deadlock information.
• Creating user logins and adding users to the respective databases and managing the Security tasks like granting and revoking permissions.
• Creating named caches and binding objects to the cache, multiple tempdbs.
• Handling Database dumps and Load issues.
• Defragmentation of tables as and when required.
• Monitoring memory, processor, Disk I/O, user connections, locks.
• Transferring Data using 'bcp'.
• Checking database consistency periodically.
• Helping the project team during UAT’s & final rollout in production.
• Performing changes in crontab as well as scheduling jobs as and when required.
• Alters the test databases to make it same as production.
• Dealing with issues like segment space shows –ve value.
• Daily database maintenance activities.
• Handling tempdb issues.
• Handling dump and load issues.
• Creating devices and databases as when required.
• Bypass recovery
• Shutdown and Restart the server for maintenance activity.
• Ensuring dump tran to a file is happening and the log segment never gets full.
• Implementing maintenance activities.
• Gathering defragmentation report and providing recommendations.
• Monitoring syslogshold.
• Running Update Statistics.
• Setting different db options.
• Generating DDL for database and database objects.
• Clearing the tempdb by Truncating the tables as when required.
• Creating new tempdbs as when required.

⦁ Binding tempdbs to a login
⦁ Creating aliases

• Daily monitor the database health and error-logs for critical errors if any. Generating and sending
  daily monitoring reports.
• Prepare POA and Rollback plan for each database activity along with downtime estimation.
• Configure the database mail to send the critical notifications. Manage Database security by Creating Users, logins and by assigning Roles and permissions.
• Data migration (import & export - BCP) from Text to SQL Server.
• Perform Switch Over – Switch Back activities periodically.
• Integrity checks on every month. Regularly update statistics, index rebuild, dbcc check-db on periodic/scheduled basis. Track index rebuild operations.
• Using of BCP, Import/Export to upload data.
• Managing the VERITAS/Symantec net backups.
• Working with local server administration teams to address and resolve NetBackup

with 58.7 %

with 73%

with 73%