Sunny Kumar Singh

SQL SERVER DBA SUNNY KUMAR SINGH SQL DBA AT SAAMA TECHNOLOGIES PVT LTD PUNE Phone: - Mail to:-SQL DBA at Saama Technologies Pvt Ltd Pune OBJECTIVE A challenging position with an expanding and dynamic assignment/project where I can implement skills that I have developed through my education and past experience as well as enhance my knowledge by dedication and hard work. SKILLS SQL Server Database Administration for 2005, 2008, 2008R2 and 2014. Core Skills Monitoring Tools like Solarwinds, SQL Sentry, IDERA and Opswise. ITIL based SLA model using tools like BMC Remedy, Salesforce, JIRA and Service Now. Secondary Skills Writing scripts using T-SQL , PL/SQL and Windows Power Shell. Devops Tools like Ansible, Chef, Puppet, Docker , Jenkins, Grafana, Kubernetes. CURRENT ROLES AND PAST ROLE DESCRIPTION Saama Saama Technologies CURRENT ROLE DESCRIPTION(Feb 2017 to Current) ● Working as Consultant L-3 in Saama Technologies. Roles and responsibilities include: ETL jobs monitoring and troubleshooting and working very closely with development team for deploying quick fixes, helping fine tune SQL queries and PL/SQL codes using SQL Profiler and DTA. Managing daily data deliverables to multiple clients. Troubleshooting DB and server level performance issues. Hands-on experience of Migration activity. Writing T-SQLs for troubleshooting and data delivery related issues. Have also hands-on with writing MDX queries, Powershell Scripts and PL/SQL. Good experience with installing and managing SQL Server Clusters and configuring log shipping and Always On. Also involved in a project for Performance tuning of SAP BO queries writing PL/SQL for Data Segregation. PAST ROLE DESCRIPTION(4 years 3 Months) ● ZS Associates Worked as a SQL Database Administrator with ZS Associates Pvt Ltd India for 1 year and 3 months. It includes administrating, configuring and troubleshooting SQL Server databases of production servers for internal client. Have experience in patching SQL Server in Clustered environment, Mirrored and Log Shipped environment. Automating DBA tasks like Migration, application of SQL Server patches and hotfixes and backup monitoring using PowerShell and SQL Scripts. Troubleshooting SQL query performance issues using SQL DMVs, SQL Profiler, and various other tools like IDERA, SPLUNK. Have worked closely with Development team for their testing related requirements. Active role play in performing RCA recommending permanent fix for the same. and Page 2 TCS Kolkata o Have experience of working with Retail based Project(KITS) and insurance based(Hartford) client in TCS Kolkata, the activities include(2 years and 10 months): ● Configuration and Maintenance of the database server which also includes applying hotfixes and patch in both stand alone and clustered environment. ● Performance tuning of Inefficient SQL queries. ● Responsible for resolution of daily issues related to CPU usage, memory usage and disk space in form of Service Now tickets and analyze the same to provide permanent fix. ● DB backup and restore activities. ● Troubleshooting DB connectivity and access issues. ● Troubleshooting DB Corruption issues. ● Performing various change activities on Server and DB perspective as per ITIL process. EDUCATION DETAILS 2012 B.Tech from NIT SILCHAR. 2007 Higher Secondary from Vivekananda Kendra Vidyhalaya. CERTIFICATIONS AND TRAININGS Microsoft Certified Technology Specialist in MS SQL Server 2008 implementation and maintenance. ITIL V3 foundation certified. Done DevOPs training with Ethans Tech which includes training in tools like Ansible,Docker,Chef, Jenkins ,Kubernetes and Puppet. Page 3 PERSONAL INFORMATION Date of Birth: 13/02/1988 Gender: Male Nationality: INDIAN Marital Status: Married Languages known: English, Hindi, Punjabi and Assamese Address Flat B703, Dreams Rachana, Kalepadal, Hadapsar Pune ,411028 Page 4