Sudheer: Professional Summary

Sudheer Email : sudheer.sqldbanow@gmail.
com
Mobile : +91- 8340033054
Professional Summary:
 I have 4+ Years of experience in SQL Server Database Administration in 24*7 Production

Support environments.
 Good experience with SQL server 2017, 2016, 2012, 2008R2 and 2008 Installations,
Configurations.
 Protecting the databases by taking different kinds of Backups such as Full, Differential, and
Transactional log backups.
 Good experience with deploy the SSIS, DTS packages, SSIS package migration,SSIS
troubleshooting and SQL server agent jobs and scheduling the jobs in SQL Server Agent tool.
 Experience in implementing SQL Server security and Object permissions like maintaining
creation of users, configuring permissions and assigning roles to users.
 Verifying and resolving the SQL Server blocking issues and Finding and fixing the root cause.
 Resolving the Disk space issues and finding the root cause and permanent fixes.
 Hands on Experience in applying the Service packs and Cumulative packs for servers.
 Experience in using Performance Monitor, SQL Profiler and optimizing the queries, tracing
long running queries and deadlocks.
 Extensive experience in Creating and Administering the SQL Server Databases like data and log
file placements and managing the growth parameters and database options.
 Good experience with implementing and Troubleshooting High Availability of database servers
using Replication, Log Shipping, Database Mirroring and Always on Technology.
 Good experience on Failover and Failback operations in the cluster environment and adding
the new Disks and troubleshooting activities.
 Migration of SQL server databases from one server to another server.
 Provided support on 24x7 shift rotation basis and monitor trouble ticket queues to attend user and
customer calls.
 Strong interpersonal skills, with the ability to easily and effectively interact with technical, non-
technical, support, and business staff at all levels.
 I have good experience on MySQL database migration from one to another server in Linux envi...
 I have experience on Azure(PAAS) environment.
 Good experience on migrating the database from on-premises to Azure cloud.
Work Experience:
Currently working with PFSweb, Inc., Bangalore as SQL server DBA since April 2019 to till date.
Previously worked with Mphasis, Bangalore as SQL Server DBA since Jan 2017 to April 2019.
Education Qualification:
Completed M.C.A from JNT University, Anantapur in 2016, Andhra Pradesh.
Technical skills:
Operating Systems : Windows Family (2008\2012R2\2016)

Languages : T-SQL
Tools : Query Analyzer, SSMS, DBCC
Databases : Microsoft SQL Server 2017, 2016/2012/2008R2/2008
Support Tools : Lite Speed and Fog light (PA) and DPA.
Projects Summary:
Project # 1
Client : PFSweb, Inc. USA.

Role : Database Administrator
Team size : 05
SQL Version’s : Microsoft SQL Server 2012, 2008R2, 2005.
Duration : April 2019 to till date.
Description:
PFSweb, Inc., leads brands to commerce success. Across two key business units – LiveArea
for professional services and PFS for order fulfillment services – we focus on smooth operations and
intelligent technologies to drive conversions, empower brands, and deliver outstanding customer
experiences. From creating unique, seamlessly designed flagship sites to picking, packing, and
shipping orders, our teams are experts in all areas of digital commerce. Major brands and other
companies turn to PFSweb to optimize customer experiences and enhance traditional and online
business channels, creating commerce without compromise.
Responsibilities:
 Installation and configuration of SQL Server 2005, 2008 R2, SQL Server 2012 and SQL Server
2016.
 Creating the databases and managing the data and log files.
 Backup the Database on a daily basis.
 Creating jobs as per user requirement.
 Implement and maintain database security as per business rules and requirements.
 Restoring databases from production to UAT environment.
 Updating Service packs and Security patches for the Servers.
 On Call 24/7 Support to databases on weekly rotation.
 Trouble shooting blocking, space issues.
 Resolving Tickets which include creating and maintaining databases, monitoring Disk Space,
database integrity.
 Configuring and monitoring the Database Mirroring and Log Shipping.
 Executing the scripts in Production environment.
 Creating Logins and Users and providing proper permissions.
 Ensuring Data consistency in the database through DBCC commands.
 I have knowledge on Linux and MY SQL Server.
 I have worked on SSIS package deployments and package migration.
 Migrating databases from SQL Server 2005 to 2008r2 and SQL Server 2008r2 to 2016.
 Good experience in Cluster buildings and troubleshooting the issues.
 Good experience on MySQL database migration in Linux environment.
 Knowledge on PowerShell scripting.
Project # 2
Client : La Quinta, USA.

Team size : 07
Duration : Jan 2017 to April 2019
Description:
La Quinta Inns & Suites is a chain of limited service hotels in the United States, Canada,
Mexico, and Honduras. La Quinta Holdings Inc first sold shares to the public in April, 2014, and is
listed on the New York Stock Exchange under the symbol LQ.
Responsibilities:
 Installation and configuration of MS SQL Server 2005 and 2008R2 and SQL Server 2012.
 Deploying DTS packages and creating jobs as per user requirement.
 Creating and managing the Maintenance plans as per the requirement.
 Resolving blocking processes related issues and Database Decommissions.
 Maintain database security as per business rules and requirements.
 Configuring and troubleshooting high availability scenarios like Log Shipping and Mirroring.
 Maintained & Monitored Alert/Schedule to make smooth replication process.
 Applying the Service packs and Cumulative packs for servers.
database integrity, identifying missing Indexes.
 Database performance monitoring and tuning when required as per application and business
requirements.
 Migrating databases from SQL Server 2000 to 2005 and SQL Server 2005 to 2008.
 Configuring and troubleshooting high availability scenarios like Log Shipping and replication,
mirroring, clustering and Always on Technology.
 Database up gradations from lower to higher versions.
 Responsible for refreshing databases as per client request.
Project # 3
Client : ESH, USA.
Team size : 07
Duration : Jan 2017 to July 2017
Description:
Extended Stay America, Inc. is the operator of an economy, extended-stay hotel chain
consisting of 629 properties in the United States and Canada.
Responsibilities:
 Installation and configuration of MS SQL Server 2008 R2, SQL Server 2012 and 2014.
 Creating jobs as per user requirement.
 Implement and maintain database security as per business rules and requirements.
 Restoring databases from production to test environment.
 Updating Service packs and Security patches for the Servers.
 Trouble shooting blocking, space issues.
database integrity, identifying missing Indexes, handling blocking.
 Executing the scripts in Production environment.
 Deploying SSIS packages.
 Applying the Service packs and Cumulative packs for servers.
 Ensuring Data consistency in the database through DBCC commands.
Personal Profile:
Date of Birth : 22-01-1992

Gender : Male
Place : Bangalore
Sudheer T

Sudheer: Professional Summary

Uploaded by

Copyright:

Available Formats

Sudheer: Professional Summary

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Sudheer: Professional Summary

Uploaded by

Copyright:

Available Formats

Sudheer Email : sudheer.sqldbanow@gmail.

Mobile : +91- 8340033054

 I have 4+ Years of experience in SQL Server Database Administration in 24*7 Production

Completed M.C.A from JNT University, Anantapur in 2016, Andhra Pradesh.

Operating Systems : Windows Family (2008\2012R2\2016)

Client : PFSweb, Inc. USA.

Client : La Quinta, USA.

Date of Birth : 22-01-1992

You might also like