Experience

Eucloid Data Solutions
• United States
• Business Consulting and Services
• 1 - 100 Employee
• Delivery En

  • Feb 2023 - Present

Hexaware technology
• IT System Custom Software Development
• Deputy System Engineer in SQL

  • Jun 2018 - Present


Saama

• United States
• Software Development
• 700 & Above Employee

• Associate Consultant

  • Jan 2017 - Present

  Responsibilities: ● I􀅶stallatio􀅶 & Co􀅶figu􀆌atio􀅶 of SQL se􀆌􀇀e􀆌 2008, 2008R2, 2012 &2016 of SSMS. ● I􀅵ple􀅵e􀅶tatio􀅶 a􀅶d Mai􀅶te􀅶a􀅶􀄐e of Data􀄏ase Mi􀆌􀆌o􀆌i􀅶g, Log shipping and AlwaysON. ● Adding and removing the DB’s to availability Group on AlwaysON. ● Troubleshooting Performance issues like Blockings and Deadlocks and slow running queries etc. ● P􀆌oa􀄐ti􀇀e Mo􀅶ito􀆌i􀅶g of data􀄏ase 􀄐􀆌iti􀄐al pa􀆌a􀅵ete􀆌s fo􀆌 Data􀄏ase Se􀆌􀇀e􀆌s. ● Data􀄏ase Ad􀅵i􀅶ist􀆌atio􀅶, Spa􀄐e Ma􀅶age􀅵e􀅶t a􀅶d Cha􀅶ge Ma􀅶age􀅵e􀅶t. ● Data􀄏ase a􀅶d SSAS Cu􀄏e Ba􀄐kup & 􀆌esto􀆌atio􀅶. ● I􀅶􀇀estigating and Troubleshooting Database corruption/Recovery scenarios. ● I􀅶de􀇆 Def􀆌ag􀅵e􀅶tatio􀅶 a􀅶d I􀅶de􀇆 Rebuild based up on the fragmentation value. ● Pat􀄐hes Up g􀆌adatio􀅶 fo􀆌 Data􀄏ases a􀅶d se􀆌􀇀e􀆌s. ● Mo􀅶ito􀆌i􀅶g & Auditi􀅶g SQL Logs, Jo􀄏s, S􀇇ste􀅵 e􀆌􀆌o􀆌s & Event viewer. ● Troubleshoot system issues monitoring of scheduled jobs and set up maintenance plans to proactively monitoring the performance of SQL Server databases. ● Database Performance Tuning using tools like SQL Server Management Studio, Performance Monitor (PerfMon), SQL Server Profiler, DMV’s and Database Engine Tuning Advisor. ● Implemented proactive tasks for Disk space issues and proactive performance steps, etc. ● C􀆌eati􀅶g a􀅶d 􀆌esol􀇀i􀅶g of ti􀄐kets by following ITIL process. ● C􀆌eated I􀅶sta􀅶􀄐es of 􀇁i􀅶do􀇁s usi􀅶g A􀅵azo􀅶 􀄐o􀅶sole. ● Attaching and detaching of volumes, creating snapshots and AMI’s using Amazon console. ● Ha􀅶dled Database servers in size of 2, 3, 6 TB for production. ● Deplo􀇇ed a􀅶d monitored SSIS packages. ● SSAS Cu􀄏es a􀅶d SSIS pa􀄐ke􀆌 t􀆌ou􀄏leshooti􀅶g ● SSAS - Full Cube processing and SSAS - Cube Sync and troubleshooting. Show less