Pushpak Dutta Dwary

MS SQL Database Administrator at IBM India pvt. Ltd

• India - Bengaluru
• My current job since July 2014

Backup and Restore, Configuring & Monitoring SQL Server Jobs, Installing,
Configuring database servers
 SQL Version upgrade, Server migration -InPlace/SideBySide
 Building and maintaining SQL server cluster, Troubleshooting SQL Server
production/Test/Dev issues. Capacity planning and monitoring database growth
 Configuring log shipping, mirroring, replication, cluster, managing log shipping,
managing transaction log back-ups and implementing backup plans
 Managing SQL Server security.
 Established standards for SQL installations, maintenance, tuning, and coding
standards. Worked in Production & App support DBA, Based on the Developer
requirement implemented changes in the Production database & also staging
database, Restoring databases in various servers from one server, worked with
maintenance plan & SQL Server jobs
 Got trained in SQL server 2012 and 2014
 Database Monitoring & Daily production DBA Tasks
 Created Database Maintenance Plans for the Performance of SQL Server, which
covers Database Integrity. Debugged the T-SQL queries for performance tuning.
 Checked & updated Database Statistics and Re-indexing.
 Created Users and Roles, and managed security and permission of database.
 Monitoring the server for High availability of the servers.
 Solving the request raised by user support.
 Worked with database design team and development team for database design
and implementation
 Documentation of process involved while upgrading SQL Server .
 Prepared Documentation for Disaster Recovery plan
 Enhanced query performance with modification in TSQL queries, removing
unnecessary columns, creating useful clustered index and non-clustered
indexes.
 Monitoring SQL Server logs to ensure whether the backup operations, batch
commands, scripts have completed successfully.
 Performance tuning and testing stored procedures, indexes and triggers
using SQL server profiler.
 Monitoring SQL server performance using profiler to find the performance
and dead locks.
 Created Maintenance Plans for Regular Backups and Rebuilding of Indexes.
 Monitoring SQL server performance using SQL Profiler to find performance and
dead locks. Documented different Stages of data transformation, procedures and
scripts involved in the database.