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