B Gangadhara

Email: [email protected]
Mobile: +91-9652954892

Career objective

To work in a dynamic learning environment where I can contribute my innovative skills

towards the growth and success of the organization and achieve work satisfaction and personal
growth, by applying the best of my knowledge and abilities.

Professional Experience

 Over 4.5 years of experience as MS SQL Server Database Administration in Production,

Test and Development environment.
 Expertise in installing, configuring, managing, monitoring and troubleshooting Microsoft
SQL Server standalone and SQL Failover cluster.
 Expertise in Always-On Availability Groups (AOAG) and HA/DR Troubleshooting.
 Experience in DB Migrations and Upgradations.
 Experience in Implementing and Problem solving of high availability solutions like
 Log Shipping, DB Mirroring, Clustering and Replication.
 Experience in Migrations from on-premise to Azure IAAS and PAAS servers
 Identifying and Fixing Orphaned users through Stored Procedures.
 Configuring and maintaining all types of Database Backups and Recovery operations.
 Checking the general health of the servers and the databases.
 Monitoring the status of Maintenance plans as per scheduled.
 Experience in creating the database, maintaining, and performing all database activities.
 Experience migration activities like side-by-side migration of SQL Server
 Experience in scheduling and troubleshooting Alerts and Jobs.
 Having experience in maintaining of large size production Databases.
 Experience in database refresh in different environment.
 Solving the suspect state when database went to recovery pending.
 Performing the shrink operation on log file.
 Good knowledge on SQL Server architecture and SQL Server memory architecture.
 Utilization of Dynamic Management Views and DBCC commands for knowing Blocking
issues, Fragmentation information, user information etc.
 Monitoring the slow running queries, when query running slow situations.
 Extensive Experience in identifying and troubleshooting of Locking, Blocking and Deadlock
issues.
 Creating the indexes and identifying the unused and missing indexes.
  Experience of Identifying Fragmentation levels and improving efficiency of databases by
Re-organizing and Re-building indexes.
 Worked on SQL Server Tools: Profiler and Performance Monitor and DTA.
 Experience with CDC to track the DML changes at database and table level.
 Experience working with production and 24 x 7 on call environments.

EMPLOYMENT SUMMARY

 Working as Database Administrator in CGI from Sep 2018 to till date.

TECHNICAL SKILLS

 RDBMS : SQL Server 2008R2/2012/2014/2016/2017/2019

 Operating Systems : Windows 2003, 2008,2008 R2,2012,2016 and 2019
 Languages : T-SQL
 Ticketing Tool : Service-Now, Remedy
 Backup Tools : Symantec Net backup, NETWORKER
 Monitoring Tool : SCOM, SQL Diagnostic Manager (IDERA)
 ETL and Others : SSRS, SSIS, Microsoft Azure SQL DBA

PROJECTS SUMMARY

Project #1:
Client: Bell Canada (Aug 2018- Till Date)
Project Name: Bell Canada

Bell Canada (commonly referred to as Bell) is a Canadian telecommunications company

headquartered at 1 Carrefour Alexander-Graham-Bell in Montreal, Quebec, Canada.

Historically, Bell Canada has been one of Canada's most important and most powerful
companies and, in 1975, was listed as the fifth largest in the country. The company is named
after the inventor of the telephone, Alexander Graham Bell, who also co-founded Bell
Telephone Company in Boston, Massachusetts. Bell Canada operated as the Canadian subsidiary
of the Bell System from 1880 to 1975. However, unlike the other regional Bell operating
companies, Bell Canada had its own research and development labs.

MICROSOFT SQL SERVER DBA FUNCTIONS:

 Installation, Configuration, Maintenance of SQL Server 2008/2012/2014/2016.
 Daily checking the tickets assign the tickets and resolve them as per priority levels using
Tool
 Providing and revoking access to users.
 Troubleshoot various problems that arise in day-to-day work and fix the issues
  Monitoring Clusters and troubleshooting Cluster Issues, Performing failovers.
 Sync up with the users through Microsoft Teams meetings to know the user problems
based on the ticket priority.
 Constantly checking functionality of the environment and taking necessary action when
an alert is thrown from alerting mechanism by taking a prompt action based on its
severity and considering the resolution of the issues as most primitive tasks.
 Checking OS, SQL Server, Security, and other logs for unusual events.
 Refreshing the data as per client to the client requirement.
 Investigate the reported issues, keep the ticket records and ensure resolution of issues
and close the requests within SLA.
 Upgrading the Server and applying the Service Packs and Hot fixes
 If is there any production changes, we required RFC from users as per change
Management
 Daily interact with customers is there any performance related issue, and work with
them, troubleshoot accordingly through ticket numbers
 Creation of SQL Logins, Roles and Authentication as per the user request
 Providing Security by giving access permission to users at various levels
 Moving database files from source to destination place
 Identifying and Resolving performance issues of the server based on the priority
 Ensuring high availability of the databases with Replication & its topologies
 Monitoring SQL Server performance by finding deadlocks and blocking
 Monitoring the performance of the servers as per checklist.
 Maintaining & involving HA that includes Log shipping, database mirroring, clustering
and Always ON.
 Migrations from on-premise to Azure IAAS and PAAS servers

EDUCATION AND CERTIFICATIONS

 Completed MCA from Sri Venkateswara University.

PERSONAL DETAILS

Father’s Name : Uttamaiah B

DOB : 01/08/1988
Marrital Status : Married
Nationality : Indian
Languages Known : English & Hindi and Telugu

Gangadhara