Sr Software Engineer
Harbinger Systems
Total years of experience :5 years, 1 Months
Providing day-to-day Support and Maintenance for SQL Server databases in 24*7 support model.
Involved in Installation and configuration of MS SQL Server 2014, 2016, 2017 and 2019 in Windows environment.
Involved with team to resolve Performance issues for SQL Servers.
Backups and Recovery operations.
Configuring and monitoring SQL Jobs and doing Job Failure Analysis related to DB.
Performing Database Maintenance Activities like rebuilding/reorganizing indexes and update statistics, checking database integrity and clean up history on regular intervals.
Executing the scripts in different environments as per client request.
Resolving Space Management issues like Temp DB contention, Data, and log file space issues.
Identifying and Resolving Blocking and Deadlock issues by using System Stored Procedures, DBCC, Activity Monitor and SQL Profiler.
Identifying and Resolving fragmentation and index performance issues.
Enrolling users, controlling, and monitoring User Access to the database, and maintaining system security.
Experience in having calls with Clients and Business Analysts (BAs).
Monitoring the growth of the databases, as a part of capacity planning.
Identifying the Blocking\deadlock issues and kill the processes according to the client’s request.
Providing 24*7 on call support.
Installation of SQL Server2012/2014/2016 and applying respective Service Packs. And changing of port numbers for security purpose once installation is completed.
Created Scheduled maintenances and backup procedures to the database as a disaster recovery method.
Worked on Backups of Database and Restored the Database from Disaster Recovery.
Good experience with installing Database Mirroring Environments.
Maintained the database consistency with DBCC at regular intervals.
Used tools like SQL Server Management Studio, SQL Server Profiler and SQL Server Agent.
Implementing and administering database replication between SQL Server databases.
Replicating the SQL Server to transfer and update data at remote servers, setting up of Transactional replication, created publisher database, distributor database and push & pull subscriber databases
Creation of user databases and ensuring file group creations and placing files in appropriate locations.
Creating Database Maintenance Plans for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
Creating and mapping the logins to the database and grant the appropriate permissions.
Day-to-day activities like resolving the backup failures, integrity and optimization jobs, handling suspect mode databases, analyzing error logs, database refresh activities from PROD to DEV/STG.
Involved in Migration of Databases from SQL Server 2014.
Verifying SQL Server Error Logs and SQL Server Agent logs on a constant day to day basis.
Performing database refresh across different versions. Creating Jobs/MPs for most frequent tasks like checking the integrity of database, rebuild index.
Handled system and user database corruptions and their restorations with minimal downtime.
Created Scheduled maintenances and backup procedures to the database as a disaster recovery method.
Worked on Backups of Database and Restored the Database from Disaster Recovery.
Involved in the migration of SQL Server 2014 databases to SQL Server 2016.
Good experience with installing Database Mirroring Environments
Used tools like SQL Server Management Studio, SQL Server Profiler and SQL Server Database installation and administration of MS SQL Server 2014, 2016.
Experience in database migration from SQL Server 2012 to 2014 and SQL Server 2014 to SQL Server 2016.
Daily checking the issues like backup failures, failed logins and resolve the issues.
Resolving disk space issues and data base growth issues.
Changing the recovery models whenever necessary.
Providing 24*7 on call support.
BSc Computers