Shiva Prakash

To work and grow in an environment where my performance is rewarded with new Responsibilities and challenges to prove myself to be an asset to the organization and team.

• Having 11 years of experience in IT and 8 years of experience as a SQL Server DBA.

• Understanding client requirements and providing support.

• Clarifying user doubts.

• User creation and assigning roles.

• Helping users for smooth transactions.

• Experience in Installation, Configuration, Maintenance and Administration of SQL Server 2008/2005/2008R2/2012/2014/2016/2019/2022.

• Skilled in creating databases and maintaining and performing all db activities.

• Configuring and maintaining all types of Database Backups and Recovery operations.

• Configuring and monitoring SQL Jobs and doing Job Failure Analysis.

• Experience in implementing SQL Server security and Object permissions like maintaining Database authentication modes, creation of users, configuring permissions and assigning roles to users.

• Experience in implementing HA technologies Logshipping,Always on,SQL failover cluster mirroring and replication.

• Experience in creating Jobs, Alerts.

• Created linked server among production servers as per the project requirements.

• Configured DB mail and created operators to send automated alert when the jobs fail.

• Having good knowledge of cluster architecture and being involved in cluster failover activities.

• Experience in implementing high availabilities like Log shipping and having good exposure on Clustering.

• Applying service packs on production server as per the project requirements
• Configured DB mail service and operators on production server to get automated mail when jobs are failed
• Created linked servers among production servers
• Establish and maintain backup and recovery policies and procedures
• Responsible for implementation and release of database changes according to agreed timescales and cost
• Handling disk alerts on regular basis by shrinking the log files to the required sizes when the log files grown too big
• Monitoring jobs on production servers and troubleshooting on daily basis
• Performing database restore on daily basis from production to development and to testing environments
• Performing Health Checks of all the servers in Support Environment
• Resolving Tickets which include creating and maintaining databases, monitoring Disk Space, database integrity, identifying missing Indexes, handling blocking
• Creating and maintaining Databases
• Experience in performing regular Backups and scheduling tasks
• Checking the status of Backup troubleshooting the failed backups and Restoration of databases
• Managing Security (Creating users, logins and roles, granting permissions)
• Implementing Update stats
• Rebuilding the indexes at regular intervals for better performance
• Good experience in resolving blockings by using SQL commands
• Providing connectivity and troubleshooting of connectivity problems
• Providing 24/7 On-Call support for critical production database

I hereby declare that the information provided by me is true to the best of my knowledge.