Experience

• 

  Rafai technologies pvt. ltd

  Mar 2017 - Dec 2018

  Sql server database administrator

  MS SQL & MY SQL Server 2000,2005,2008,2016 Designed Table structure With Windows and Linux Platform. Design And supported High Availability such as clustering, Mirroring, Replication Always on In SQL 2016.Tuning Performance of SQL Server.Core Database Activities like Shrinking database. Attach detach Database, import export database, Database Tuning Ad visor Graphical Execution Plan SQL Profile.Deployment SSRS Reporting Server With encryption KeyCreate views, stored procedure, trigger, Cursor Show less

• 

  Ibm

  Jan 2019 - Oct 2022

  Sr.pl/mssql - dba

  I specialised in SQL Server Performance Tuning and Optimisation.SQL Replication P - Familiar with unstructured databases such as Cosmos Db.P - Familiar with J SON and XML.P - Familiar with Red gate ToolsE - Familiar with Power shell,Installation, Patching & up-gradation of SQL- SERVER on stand alone as well as on cluster With latest SP, Knowledge of Different GUI tool like SSMS, SSCM, DBTA, SQL-Server Profiler.Good Knowledge of different High Availability option like Database Mirroring, Log Shipping, and Failover clustering.Good knowledge of various DBCC Commands.Creating Jobs and Sending Alerts Using Database Mail and SQL Mail. Tuning SQL Queries and improving the performance of the Database.Good to have Azure SQL DB knowledge and Good to have Azure SQL DB knowledge.Design and modernise clients' mission-critical OLTP and OLAP for performance, availability, latency, and reliability.Performance tuning applications and servers through baselines, DMVS, and traces. Propose fixes including indexes, code re-writes.Scripting and Programming in T-SQL, Power Shell, SQL, PL/SQL, Unix shell, VB, Java, HTML, ASP, VB COM,C#.Special ties:• Database Implementation and Administration• Database Modelling and Design• Performance Tuning• Low concurrency problem resolution• Disaster Recovery• High Availability• Migration• Consolidation• Consulting Show less

• 

  Tata consultancy services

  Aug 2022 - now

  Sr.software analyst

  Expert in code deployment tools (Puppet, Ansible, and Chef)Possess a strong command of software-automation production systems (Jenkins and Selenium)Knowledge of full SDLC and basic understanding of technologies like Java/J2EE, WAS/Tomcat, Apache/IHS, MQ, TibcoConfiguration tools like GIT, SVN, Wiki, etc.Knowledge in using build tools like Jenkins, Maven, Ansible, Liquibase & NexusKnowledge of packaging & deploying Java/J2EE applications.Microsoft SQL Server Migration Assistant (SSMA) for Access is a tool to automate migration from Microsoft Access database(s) to SQL Server.Installs, maintains, administers, and tunes MS SQL Server databases. Completes database back-ups and maintains backup procedures.Maintains database high availability and the upkeep and availability of other Database systems as required.integrity, recovery and scalability of the SQL Server, Azure SQL Database and Cosmos DB database environments.Job Responsibilities.Maintain the high availability and disaster recovery (HADR) systems including performing fail over and fail back. Show less