Having 8+ years of experience in Implementation and Administration of Database system using MSSQL 2005/2008/2008 R2& 2012, 2014,2016,2017,2019.
Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities for Microsoft SQL Server 2000/2005/2008/2008R2/2012.
Configure and Managing SQL Server in Azure IAAS.
Configure and Managing SQL Server in AWS RDS.
Involved in SQL Server technologies like Backup / Recovery, Indexing and Reorganization.
Good backend skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers and Functions.
Good T-SQL Programming skills. Experience in query optimization & performance tuning.
As SQL Server DBA, I have extensive knowledge in database maintenance, Automation and High Availability.
Hands on experience in SQL Server agent Job configuration, Alerts and SQL mail configuration.
In conjunction with development teams, define and maintain database and code standards and naming conventions for the organization to ensure consistency in database.
Run the Database consistency to check the logical and physical integrity.
Providing highly available database and application infrastructure according to Business Continuity requirements using SQL Server Always On Solution.
Configuring and maintenance Replication, Clustering, Database Mirroring and Log shipping.
Hands on experience in SQL Sentry Query Plan Explorer /Red Gate SQL Monitoring and Backup Tools.
Hands on experience in SQL Server Partitioning/File Stream & DMV’s for Memory trouble shooting.
Having a basic knowledge about SSRS.
Upgrade/Migration SQL Server from lower to higher version.
Installing and patching the SQL Server.
Hands on experience in DR activities on the SQL servers.
Handling TB size of databases.
Hands on experience about Performance tuning the SQL server.
Experience in upgrading the SQL Server database instances with latest service packs and hot fix
SQL server DB mail and linked server creation on request from the users
Experience in assigning, updating and revoking privileges, roles & profiles to database users
Capable of Planning and work to an imposed structured timetable to meet deadlines, ability to learn new skills rapidly and work well with wide range of people, ability to identify and resolve problems, disciplined, communication and presentation skills
Have done automations using PowerShell Forms/scripts and scheduled Windows tasks
Strong knowledge on Transactional Replication. Able to fix the replication errors(PK Violation, Row not found etc..) using code.