SUMMARY:

• Dear RecruiterAs a person who builds a career through challenges, me is confident in my ability to become a key member of the organization. As a highly skilled IT professional, me have extensive experience of 10+ years of exposure as a SQL server DBA
• me have solid expertise in SQL server consulting, installation deployment, performance tuning, configuring and managing HA solutions and have managed the estate end to end.
• me have noledge of Informatica, T - SQL and used it for different clients. me also have noledge in SSIS, DWH concepts. me have sound understanding of RDS for AWS, Azure SQL server and Azure SQL Managed instance, Azure d Confidential base migration service, Azure D Confidential Factory, performed lab and created documents on them for use in my current organization. me have also presented a tech talk on SQL server in my previous organization.
• me is currently learning Azure d Confidential engineering (DP-200) and SAS d Confidential engineering(A00-260) and pursuing s on the same.
• me would love to learn new technologies and adapt with organisation’s culture and vision by collaborating with my skill and experience.
• me have attached my resume highlighting my professional skills and academic background and look forward to hearing from you in due course.
• As a highly skilled IT professional, me have extensive experience of 10+ years as a SQL server DBA, have
• me have solid expertise in SQL server consulting, installation, deployment, performance tuning, configuring and managing HADR solutions on physical and SQL server on Hyper V, and have managed the estate end to end. me also gained working experience in Informatica administration, SQL programming.
• me have sound noledge on Azure SQL sever, Azure SQL Managed instances, Azure d Confidential base migration services, Azure D Confidential Factory, DWH concepts, RDS for AWS, SSIS, SSAS, SSRS.
• me also have noledge on Azure d Confidential lakes, Azure SQL server and Azure SQL Managed Instance, also learned about IaaS, PaaS, and SaaS.
• me is currently learning Azure d Confidential engineering (DP-200) and SAS d Confidential engineering (A00-260) and pursuing .
• Participated in program for different Azure streams - Azure D Confidential Factory, Azure fundamentals, Azure for SQL server, SQL Managed instances and Security in Azure SQL server and collaborated towards learning modules in previous organization.
• Strong business and technical vision with TEMPeffective people skills, ability to manage multiple complex projects, proactive and result oriented, and has aptitude for learning and can maximise resources while possessing a sense of urgency.

TECHNICAL SKILLS:

Operating System: Windows 2000/2003/2007/2008 R 2/2012/2014/2016, Windows XP.

Database Server: SQL 2019, SQL 2017, SQL 2016 on Unix and Windows, SQL 2014, SQL 2012, SQL 2008R2, SQL 2008, SQL 2005, SQL 2000.

Cloud: Azure for SQL server, Azure SQL Managed Instance, Azure D Confidential Engineering, RDS for SQL server, AWS

Language: T-SQL

Pursuing: Azure D Confidential Engineering (DP 200) and SAS D Confidential Engineering(A00-260)

ETL and Database warehouse tools and technologies: Informatica Administration, SSIS.

Database Tools: SSMS, SP Blitz, SQL scripting, Power BI, Profiler, Tuning Advisor, Perfmon, DTS, Management Studio/Enterprise Manager, SSRS, BCP utility, SQL Monitor, Performance dashboard, Tuning Advisor, Powershell.

Third Party Tools: IDERA, BMC Patrol, Sitescope, SQL Sentry, Avamar, Commvault, TSM Net Backup, Tivoli Enterprise Console, Manage Now, Remedy, HPSM, Service Manager, ServiceNow, Hyperic, VrOps, AXIS, Redgate DB compareDomain Knowledge: IT, Banking, Healthcare, Retail, Oil & Gas

PROFESSIONAL EXPERIENCE:

Integration Consultant

Confidential

Responsibilities:

• Created indexes for ODS in MS SQL Server 2016, which improved the performance greatly.
• For enhanced and optimal performance, me performed analysis on the server and provided recommendations on d Confidential base configuration and other issues with SQL server like - Tempdb configuration, maintenance jobs for recovery and optimal performance, SQL memory configuration, Max degree of parallelism, d Confidential base recovery models, high availability options, autogrowth, log files optimization.
• On OS level, identified disk slowness and me/O stalls and provided recommendation for further analysis also advised to patch the server.
• Provided support in Informatica administration.
• Performed administration task like, Login creation, access provisioning to informatica and informatica cloud, job rerun and analysis and other administration task
• Provided analysis and recommendations for index optimisation - index tuning (missing index, unused index of MS SQL Server 2016 and 2012
• Requested the client to perform a run down on a DWH server which was slow and had performance issues and several failed jobs. me performed analysis and presented the client with detailed report on recommendations on SQL server optimisation, which included tempdb optimisation, slow running queries, query plan analysis, bottlenecks and recommendations on rewriting them in DWH server and, analyzed recurring deadlocks in SQL server and provided recommendations towards them.
• Provided analysis and recommendations towards best practices for optimal performance in SQL server 2012 like- Memory configuration, backups, SQL server files, maintenance jobs in SQL server, SQL server tempdb files and their location, d Confidential base recovery model and other best practices, deadlock and ways to trace them for further analysis.
• Analyzed and provided recommendations on slow running queries, bottlenecks and recommendations, expensive queries in terms of me/O, CPU and other resources in SQL server.

Infra Technology Specialist

Confidential

Responsibilities:

• As a DBA was responsible for project and production support of d Confidential base environment including on call. Was responsible for consulting, design, development and support of MS SQL Server 2016/ 2014/2012/2008 R 2/2008/2005/2000 in Route to Live environment.
• Worked on installation, migration and upgrade of various system to latest version. Also installed SQL 2016 on Unix server, me have also worked on SQL server on virtual server - Hyper V.
• Proactively performed RCA on 6 months old tickets related to memory and CPU issues, fine tuned the performance of various system with different applications on them, in conjunction me also analyzed indexes, long running queries, and other bottlenecks thereby optimized multiple critical systems.
• Worked on performance/load testing with different teams and optimized SQL servers as necessary.
• Presented ideas under CSI themes in Cognizant in Feb 2018 in line with GDPR relevant to d Confidential base security which was showcased during client visit.
• Worked on capacity planning, sizing and adhered to the best practices for d Confidential base servers.
• Was responsible for on call support and provided quick resolution for issues, provided RCA and documented them in noledge base.
• Provided consultation on SQL design and HADR solution, tested them and troubleshooted issues where necessary.
• Managed SQL server health via reports and automated alerts from Central management server and in house powershell scripts, managed the codes, troubleshooted in case of issues.
• Managed SQL Servers on Hyper-V environment, also troubleshooted SQL performance issues related to Hyper-V
• Was responsible for consulting, configuration, managing and troubleshooting of various HADR solutions like Always On, Replication, Mirroring, Log shipping.
• Used SP blitz, inhouse scripts, BMC Patrol, DMVs and other SQL commands to troubleshoot issues.
• Worked on threshold setting and customization of BMC patrol for monitoring of SQL server.
• Performed analysis of SQL server, contributed towards service improvement plans and ideas, enabled many best practices for better performance, troubleshooted complex performance issues which was greatly appreciated by client.
• Responsible for administration of all Microsoft SQL components including SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), and SQL Server Integration Services (SSIS).
• As part of Service improvement plans provided ideas to enhance the performance of SQL servers like - Tempdb best practices, Sizing of d Confidential bases, enabled jobs for d Confidential collection to analyze and optimize performance issues.
• Provided support whenever required and was very flexible with time and need of the client. Was greatly appreciated by Client and Cognizant management.
• Contributed towards documentation of multiple process and technical solutions and best practices for SQL server.
• Built great rapport with the client and was instrumental towards transition of the project contract to change from T&M (Time and Material) to Managed services. It was ongoing when me left Cognizant.
• Was ed as ‘Star of India’ across Service lines and vendors for John Lewis Partnership for resolving deadlock issue related to important migration of an application.

Senior SQL Server DBA

Confidential

Responsibilities:

• As a project L3 DBA was responsible for design, development and support of MS SQL Server 2014/2012/2008 R 2/2008/2005/2000 in Production, Pre-production, Test, Development environments while working in Route to Live deployments.
• Liaise between application and other technical teams to build new SQL environments as per technical specification and project requirements.
• Worked on migration and upgrade of SQL servers from P2V and V2V, supported NFT functional test, soak and Load tests and coordinated with QA team for the implementation and optimization of SQL server, fine tuned indexes, worked on CPU, memory and me/O related issues provided RCA and implemented solution.
• Managed SQL Servers on Hyper-V environment, also troubleshooted SQL performance issues related to Hyper-V
• Responsible for installing, configuring and managing SQL server on Hyper V.
• Responsible for migrating SQL server from physical to Hyper V SQL servers.
• Worked on performance tuning of the server before live, analysis using load, soak test with baseline defined using profiler, DMVs, dbcc commands, tuning advisor, performance dashboard, Sitescope, SQL Sentry and other inhouse tools.
• Was responsible for creating handover documents and other operational supporting documents to handover to BAU team.
• Worked on configuration, troubleshooting, managing of HADR solutions - replication, mirroring, always on and log shipping, was also responsible for DR testing for physical and virtual servers and troubleshooting.
• Performed d Confidential base comparison using Redgate DB compare tool and fixed d Confidential base differences by applying missing indexes and other d Confidential type differences during migration of a project which enhanced the TPH greatly.
• Worked on SSIS and SSRS deployment and troubleshooting, enabled export of d Confidential using SQL agent and SSIS jobs, also performed import export using DTS.
• Helped Application teams to find issues related to code and fixed them.
• Responsible for administration of all Microsoft SQL components including SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), and SQL Server Integration Services (SSIS)
• Responsible for creating support document for builds and provided warranty support post live.
• Was responsible for supporting changes during out of business hours, incidents and service requests.
• Aug to Oct 2015 - was involved in performance tuning of a project in SQL server for Lloyds Bank, which helped in smooth migration and cost reduction by going to Virtual from Physical servers.

Microsoft SQL Server DBA

Confidential

Responsibilities:

• Implementation of SQL Logins, Roles and Autantication Modes as a part of Security Policies for various categories of users and troubleshooting the same in case of issue.
• As L2 DBA worked on SQL server 2008R2, 2008, 2005, 2000 and responsible for installation, patching, and creation of d Confidential base maintenance plans and troubleshooting related to it. Deployed new code base release to UAT and Production servers
• D Confidential base refresh upon request, rebuilding the indexes, analyzing long running queries and other d Confidential base slowness issue and troubleshooting.
• Worked on Log shipping, mirroring, replication and clustering configuration and troubleshooting.
• Used IDERA for capturing long running queries and other troubleshooting.
• Has Sound noledge of ITIL concepts and had done internal of Confidential of ITIL V3 Foundation.
• Participated in Tech talks between pools/team of Confidential and presented paper.