About Me

• Having 6.1 years of experience in SQL Server Database Administration in production support in 24X7
• Experience in Installation and, Configuration of SQL Server 2005/2008/2012/2014.
• Skill...
• Experience in Installation and, Configuration of SQL Server 2005/2008/2012/2014.
• Skilled in creating the databases.
•   Resolving disk space issues, Data and log file issues.
• Identifying and Resolving Blocking and Deadlock issues
• DDL, DML, DCL languages (Create, Insert, Update, Drop, Select, Alter).
• Different types of Constraints (Primary, Not Null, Unique, Foreign key).
• Joins, Functions, Views, Triggers, Stored procedures.
• Have experience in moving databases in SQL Server 2008/2008R2/2012/2014.
• Have experience with implementing High Availability of database servers using Database mirroring.
• Have experience in implementing and configuring log shipping.
• Have experienced in implementing and configuring Replication.
• Configuring and maintaining all types of Database Backups and Recovery operations.
• Configuring and monitoring SQL Jobs and doing Job Failure Analysis.
• Experience in usage of DBCC commands and DMV’s for troubleshooting.
• Experience in query optimization & performance tuning Using performance tools like SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands.
• 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 creating Jobs, Alert.
• Experience in implementing different types of Replication Models like Snapshot, Merge and Transactional on basis of business specification.
• Experience in applying patches and service packs to keep the database at current patch level.
• SQL AZURE and AWS cloud migrations.
• SSIS, SSRS, MSBI tools.