SQL DBA

Suryanarayana Bevara

Phone No: +91-996*******

E-Mail: *************.*********@*****.***

Career Summary:

Having 3.8 years experience in IT industry as SQL Server Database Administration and Azure DBA.

Installing and updating the Mandatory Patches in SQL Servers.

Experience in installation, Upgrades, Server Migrations, Backup and Recovery, Implementation, Security and Maintenance.

Experince on Migrating databases from OnPrem to Azure PaaS using DMA and DMS tool.

Migrated databases from On-Prem to Azure IaaS using backup/restore thorugh Azure containers.

Specific hands-on experience includes Administering large and complex databases, Replication, Mirroring, Log Shipping and Security Management.

Having experrience in Performance Tuning.

Have Experience on SQL Server High-availability Hardware solution Clustering and AlwaysOn

Have experience on large size production Databases and providing 24*7 Production support for Databases and Applications.

Professional Experience:

Currently working as a SQL Database Administrator for Accretion Info Systems Pvt. Ltd, Bangalore from June 2017 To Till date.

Technical expertise:

Databases: MS SQL Server 2008R2/2012/2014/2016, Azure PaaS DB, Azure Managed Instance

Operating System: Windows 2008/2012/2016 Servers

Languages : T-SQL, PowerShell.

Ticketing Tools: ServiceNow, BMC Remedy

Backup Tools: Idera Sqlsafe.

Monitoring Tools: SentryOne, Solarwinds DPA

As a database administrator, my responsibility includes handling the production servers. Following are the activities which defines my key responsibilities:

Installing and configuring SQL 2008R2, SQL 2012, SQL 2014 and SQL 2016

Installing and updating the Mandatory Patches in SQL Servers.

Tuning objects, queries to improve the response time and Optimization of server performance.

Good understanding of SQL Server security and transaction management.

Worked on Change Request like Installation, Refreshes from Test to Production and Production to Test and Dev.

Implemented Log-Shipping and Mirroring as a high availability solution, automated backup and recovery processes throughout the client environment.

Performing DR test on a Quarterly/Semi-Annually basis and also ensuring the Primary and standby databases are intact.

Monitoring and Troubleshooting the Transactional and Snapshot replication issues

Implementing and configuring Database Mirroring and troubleshooting the issues

Assigning user permissions like Granting, Denying and revoking permissions

Good experience in resolving blocking and deadlock Issues by using SQL commands

Handling problem tickets on a regular basis and responding/resolving them as per SLA.

Monitor available disk space on database servers.

Monitor database size and free space for capacity planning.

Address and Resolve Technical Issues related to Databases and provided High availability of Servers.

Project #2:

Client : NCR Corporation(Retail and Hospitality)

Platform : Windows Server 2008/2012/2016

Tools& Sofware used : MSSQL Server 2008R2/2012/2014/2016. Azure PaaS and Azure Managed Instance

Responsibilities

Installation and Configuration of SQL Server 2005, upgrading the SQL Server 2005 to SQL Server 2008 through in place in test environment.

Effective Disaster Recovery planning and strategy implementation by minimizing the data loss.

Efficient backup planning and regular monitoring

Creating logins, roles and granting rights assigning permissions and mappings user data based on the abstract solutions

Migrated databases from OnPrem to Azure using DMA, DMS and backup/restore methods.

Assigning appropriate permissions to the users as required following the principle of least privilege

Created backups to Azure blob storage

Experience in creating Geo-Replication for PaaS databases.

Implemented and Administrated AlwaysOn and SQL Clustering.

Creating and Monitoring SQL Server agent jobs and troubleshooting as required

Monitoring, Troubleshooting and Administering Log shipping

Building disaster recovery systems by mirroring.

Monitoring SQL Server Performance using profiler to find performance and locks and blockings

Migrating databases from one server to another server and fixing the orphaned users

Performing Health checks of the Production servers

Backup and restore using native backup

Rebuilding the indexes at regular intervals for better performance

Monitor SQL Server services status, Jobs, SQL Server Logs, Dead locks/Blocking.

Monitoring of Disk space where physical databases are stored.

Project #1:

Client : Perficient

Environment : SQL Server 2008R2/2012,Win 2008/2012

Responsibilities

SQL server daily health check.

Making database level changes like creating & altering, adding & resize data files

Administering the SQL Server by Creating User Logins with appropriate roles, creation of groups, granting the privileges to groups and creating users and assigning roles for data access

Designing, developing & implementing automated data backups and Restoration procedure

Implementing Server level, database level security

Automating and monitoring database maintenance plans

Configuring Log Shipping, Maintain and troubleshoot Log shipping issues by continuous monitoring Transaction Log Update’s

Migration of databases to different servers

Resolving ticket’s and sending feedback

Back up master & system databases and restoring them when necessary

Configuring and implementing disaster recovery plan

Checking the Fragmentation percentage and running the Defragmentation procedure

Working as a part of Environment team providing support to entire project

Monitoring the Disk Space of all the Servers and Log Space for successful execution of all the specified jobs

Assist and advises developers regarding performance, stability and security of databases and application development

Giving support to the client and provide knowledge Transfer sessions at the client’s place.

Involved in trouble shooting and fine-tuning of databases for its performance

Monitoring SQL Server and Windows server Performance through Performance Monitor to find bottlenecks and diagnose potential problems

Regular checking of the database consistency using DBCC commands

Education :

M.Tech. in Computer Science and Engineering from Vishnu Institute of technology affiliated to JNTU-K, A.P.

B.Tech in Computer Science and Engineering from Swarnandhra Institute of Engineering and Technology affiliated to JNTU-K, A.P.

Personal Details:

Address: Narsapur, West Godavari, A.P. – 534275

Father’s Name: Adinarayana

Date of Birth: 4 July 1990

Marital Status: Single

Nationality: Indian

Declaration:

I hereby declare that the information provided is true to the best of my knowledge.

( Suryanarayana Bevara )

Contact this candidate