VEERANJANEYULU

Mobile : +91-800*******

E-mail ID : admcll@r.postjobfree.com

Career Objective:

Seeking a position to utilize my skills and abilities in the IT industries that offers professional growth while being resourceful, innovative and flexible. Willing to work as a key player in challenging and creative environment.

Professional Summary:

8+ years of experience as SQL Server Database Administrator.

Experience on Installing, configuring, managing, monitoring and troubleshooting SQL Server.

Configured on-premises SQL database backups to Azure using Microsoft Azure Backup tool.

Creating logins, users and assigning the permissions to the users in Azure.

Experience in moving on premises SQL Server databases to Azure using backup files.

Experience in creating the database maintenance tasks using Azure Automation.

Experience in upgrading and migration of SQL Server to new versions.

Experience in applying service packs, CUs, hot fixes.

Experience in Security such as creating, managing logins and roles.

Implemented successful backup strategies based on recovery models.

Maintaining the servers and databases keep up and running.

Implementation of maintenance plans and jobs.

Experience in instance level high availability Failover clustering.

Experience in database level high availability like Log shipping and database mirroring.

Experience in object level high availability like replication.

Troubleshoot performance problems, fine-tuning of databases and index Analysis.

Extensively worked on DBCC commands and Dynamic Management Objects.

Having Experience on Data center servers and handling 4 TB databases.

Implemented Always On in SQL 2016.

Experience in Database performance monitoring.

Proactive monitoring and maintenance of databases.

Documenting issues and tickets, preparing SOPs.

Knowledge on Linux and Python.

Providing 24x7 supports.

Having good communication skills and willingness to learn new technologies.

Professional Experience:

Currently working with Wipro technologies, Hyderabad from Mar 2017 to Till Date.

Worked with Innodata India Pvt. Ltd, Noida from Nov 2014 to Mar 2017.

Worked as a SQL Administrator in Speridian technologies, Bangalore from Aug 2012 to Nov 2014.

Scholastic Credentials:

MCA from Anna University, Chennai.

IT Skills:

Operating Systems : Windows 2003, 2008, 2012, 2016 and Linux

RDBMS : MS SQL Server (2005, 2008, 2008 R2 and 2012), SSRS

Languages : T-SQL, Core java and Python.

Performance Monitoring Tools : Windows PerfMON, SQL Profiler, Activity Monitor.

Backup and Recovery Tool : Red Gate.

High Availability Techniques : Log shipping, Mirroring, Replication, Always On and Clustering.

Ticketing Tools : REMEDY and SNOW.

Monitoring Tools : SCOM, Tivoli.

Cloud platform : Azure SQL

Projects Handled

Project Title: Credit Suisse

Client: CS, USA

Duration: Sep 2019 to Till Date.

Description: Credit Suisse Group AG is a global wealth manager, investment bank and financial services firm founded and based in Switzerland. Headquartered in Zürich, it maintains offices in all major financial centers around the world and is one of the nine global "Bulge Bracket" banks providing services in investment banking, private banking, asset management, and shared services. It is known for strict bank–client confidentiality and banking secrecy. The Financial Stability Board considers it to be a systemically important bank.

Roles & Responsibilities:

Installation and Configuration MS SQL Server 2008, 2012 and 2016 on windows servers.

Hands on experience Installing, configuring and administering MS SQL server Failover Clustering and Always ON Availability Groups.

Experience in alerts and rules preparation for SQL to configure severity in SCOM tool.

Having experience to support and provide solution for various accounts issues in Wipro.

Configured on-premises SQL database backups to Azure using Microsoft Azure Backup tool.

Creating logins, users and assigning the permissions to the users in Azure.

Experience in moving on premises SQL Server databases to Azure using backup files.

Experience in creating the database maintenance tasks using Azure Automation.

Ensure all database servers are backed up in a way that meets the business’s recovery point objectives.

Writing SQL joins to build and fetch the reports based on client requirement using reporting tool.

Experience in Index Maintenance Index tuning, Rebuild Reorganizing according to Index fragmentation, running DBCC checks and Update Statistics.

Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.

Performed Query Optimization to increase the performance by tuning SQL queries using Profiler and Execution Plans

Having good experience in daily database maintenance and administrative tasks like Space issues, transaction log file size growth, connectivity issues and regular monitoring of SQL Server error logs and Windows event viewer.

Project Title: LLOYDS Banking Group

Client: LBG, UK

Duration: Mar 2017 to Sep 2019.

Description: Lloyds Bank is a British retail and commercial bank with branches across England and Wales. It has traditionally been considered one of the "Big Four" clearing banks. The bank was founded in Birmingham in 1765. It expanded during the nineteenth and twentieth centuries and took over a number of smaller banking companies. In 1995 it merged with the Trustee Savings Bank and traded as "Lloyds TSB Bank plc" between 1999 and 2013.

Roles & Responsibilities:

Installation and Configuration MS SQL Server 2005, 2008, 2012 and 2016 on windows servers.

Ensuring that all databases are backed up on a regular basis by monitoring full, differential, transaction log backups, Fixing backup failures, address and implement resolutions

Backup and recovery of databases, Attaching and detaching the databases.

Creation of Logins, Roles and granting the permissions.

Troubleshooting database availability issues including issues with high tempdb or transaction log file growth issue

Hands on experience Installing, configuring and administering MS SQL server Failover Clustering and Always ON Availability Groups.

Experience with monitoring, tuning and analyzing database performance and creating rebuilding indexes to achieve optimum database performance

Actively involved in Supporting, Maintenance, Monitoring and Testing

Creating jobs, schedules, steps and monitoring jobs and also creating maintenance plan for databases

Moving of user and system databases when required.

Checking the status of backup, troubleshooting the failed backups and restoration of databases.

Participating in weekly meetings and bridge calls.

Maintaining documentation for issues and tickets.

Providing On-Call support during weekends.

Project Title : DocGenix

Client : DocGenix

Duration : Nov 2014 to March 2017.

Description : DocGenix is a web-based derivatives contract analysis and risk management suite that enables financial services firms to easily generate OTC derivatives contracts, extract critical data points, centrally store critical clauses and provide analytics to comply with increasingly stringent regulations like Dodd-Frank, EMIR, New Margin Rules etc. DocGenix is a web-based derivatives contract analysis and risk management suite that enables financial services firms

to easily generate OTC derivatives contracts, extract critical data points, centrally store critical clauses and provide analytics to comply with increasingly stringent regulations like Dodd-Frank, EMIR, New Margin Rules etc.

Roles & Responsibilities:

Installation, administration and maintenance of SQL Server Instances.

Ensure all database servers are backed up in a way that meets the business’s recovery point objectives.

Performed database refreshes.

Performed migration of instances.

Creating new database upon requests.

Monitoring available disk space and plan for the future.

Manage security, creating logins, user and granting permissions on instance, database and object level.

Monitor all SQL Agent jobs.

Installing latest service packs, hot fixes upon request.

Managing Backups on a daily basis and Recovery as per request.

Resolving blockings.

Monitoring and optimize performance of SQL Server.

Troubleshooting various problems that arise.

Recovering the databases from backup in disaster situations

Monitoring/Maintaining HA options being used in servers Log Shipping, Clustering and Mirroring

Performing shrink operation when there are space issues.

Creation jobs, alerts, operators.

Monitoring the Logs for successful execution of all the specified jobs.

Reviewing SQL Server and SQL Server Agent Error Logs.

Implemented and Maintaining Log shipping High Availability option, Replication.

Implemented Active-Active cluster and maintaining the environment.

·

Project Title : IHG

Client : IHG (InterContinental Hotel Groups), US

Duration : Aug 2012 to Nov 2014.

Description : IHG is a global company with 9 hotel brands. With over 4,600 hotels in nearly 100 countries around the world, IHG know hospitality. IHG’S family of hotel brands has a powerful heritage that guests know and love, with hotels that are instantly recognized by millions around the world. Over the last decade, IHG has worked relentlessly to build its brands, talented people and delivery systems and underpin it all by responsible business practices.

Roles & Responsibilities:

Installation, administration and maintenance of SQL Server Instances.

Creating new database upon requests.

Installing latest service packs, hot fixes upon request.

Monitor all SQL Agent jobs.

Creation jobs, alerts, operators

Managing Backups on a daily basis and Recovery as per request.

Managing logins, roles, assigning rights and permissions.

Backup and restore databases.

Migrating SQL Server 2005 data bases into SQL Server 2008 R2.

Maintaining documentation for issues and tickets.

Solving the request raised by user support.

Providing 24x7 supports.

Contact this candidate