Rakesh Reddy B

Email: acgixs@r.postjobfree.com Phone: +91 – 805-***-****

ACHIEVEMENTS

Work Experience and Certifications:

* Having 4+ years experience and currently working as a Technical Lead SQLDBA Consultant in Cognizant (CTS) Chennai.

* Expert in automating the SQL regular tasks to reduce the team member’s efforts.

* Capability to handle the SQL shared services projects alone and can able to fix the issues as early as possible.

* Currently working as a Tech lead for 45 Projects in a SQL Shared Services project in CTS.

* As of now I have done 16 SIP (Service Improvement Plan) & 5 CIP’s (Customer Improvement Plans) and got a good feedback from the clients.

* Mentoring the team by providing the trainings in SQL Server and help the team to grab technical skills.

* Received “BEST SME” award twice in the career at the BU level in Capgemini.

* Having an experience in handling 4-8 TB databases in SQL Server.

* Automation Expert in automating the tasks and creating the reports.

* Experience on SQL performance tuning, database tuning parameters, memory management, statistics gathering, application audit logs, scheduling, administration, maintenance and monitoring.

* Certifications:

* Microsoft MCP 2008 R2 (MCP)

* Microsoft SQL server 2008 (70-432) MCTS

EDUCATION

Qualification

Institute

Year of pass

SSC

Montessori Public school, Amalapuram

April-2003

Intermediate

Sri Chaitanya Bharathi Junior College,Amalapuram

April-2005

BTech (ECE)

BVCITS, Batlapalem, Amalapuram

April-2009

SKILLS

* TECHNICAL :

Operating Systems

* MS Windows 2003 /2008 /2008 R2/2012

RDBMS

* SQL Server 2000/2005 /2008 /2008 R2/2012

Cloud

* VMware, AWS, Windows Azure & SQL Azure

Others & Scripting

* VBS Scripting

* SQL Scripting

Roles & Responsibilities :

* Responsible for the deliverables of the project.

* Handled many escaltions and got good appreciations from Clients and top level management for handling the SQL issues and resolving them as quicker as possible.

* Trouble shooting SQL Performance issues and ensure to fix the issues permenantly.

* Hands on Experience in installing, configuring, and monitoring, troubleshooting and managing SQL Server 2005/2008/2008 R2/2012 production environment issues.

* Identifying the Critical issues and time consuming issues and automate them to save the efforts.

* Having very good experience in Security (Logins/Users/Roles) and have done ample of automation reports for security audit purpose. Got good appreciation from the clients for the proactiveness.

* Experience in working with production (24 x 7) environments and handling muliple clients without any issues.

* Expertise in Installation, configuration and managing SQL servers to ensure better performance and application availability.

* Expertise in implementing MS SQL Server security and database permissions.

* Ability to perform all common Database Administration (DBA) tasks like performing database backups and recovery, security etc.

* Able to configure jobs for routine database maintenance activities and troubleshooting them in case of failures.

* Proficient in configure of SQL–Backup/Restore, Performance Tuning, DBCC &Trouble shooting.

* Upgrade from SQL Server 2000 to SQL Server 2005, SQL Server 2008 and SQL Server 2008R2. While applying the recommended way is Database server at latest Patch level.

* Solid experience and outstanding knowledge of high availability SQL Server solutions, including Log shipping, Database Mirroring, Replication and Failover clustering (Active/Active and Active/Passive).

* Establish and maintain sound backup and recovery policies and procedures.

* Rewrote and tuned long-running SQL queries using DTA to cut execution time, ease database load and improve scalability.

* Responsible for disaster recovery planning for SQL Servers. Implemented database mirroring for constant availability of sales force automation and product routing.

* Database tuning and performance monitoring.

* Implement and maintain database security (create and maintain users and roles, assign privileges).

* Creating database users, controlling access to SQL Server and making sure right people get access to right data and looking after the security issues.

* Expertise in performing in-place upgrade or a side-by-side migration from SQL server 2000 to SQL server 2005 and 2008.

* Experienced in designing, developing, deploying, executing and monitoring DTS / SSIS Packages

* Solid experience and good knowledge of high availability SQL Server solutions, including Log shipping, Database Mirroring and Replication

* Good knowledge on Backup, Recovery, creating and scheduling Jobs and maintenance plans.

* Experience includes interaction with client in requirement analysis, implementation and user training.

* Participated in conceptual, logical and physical design of databases and good knowledge in following best practices

* Good communication and interpersonal skills and have the ability to work both individually and as a part of a team. Quick to learn and adapt new technologies and ability and complete tasks with minimal direction.

* Good knowledge on SSIS,TSQL Scripting,automation the daily/weekly/Monthly and Audit SQL Servers tasks.

ACHIEVEMENTS

* Received “Pat on Back” award thrice for my performance in the project and nominated for “Star Brigade” award at the organization level from Valuemomentum.

* Provided solutions for many complicated problems in the team and received many appreciations from Clients and Top level Management.

* Received “BEST SME AWARD” from BU for providing excellent support for many typical issues at the Capgemini organization level.

* Received 2 “BEST Performer Quarterly AWARDs” from Capgemini.

* Automated Daily/Weekly tasks and reduced team efforts.

WORK EXPERIENCE

Current Employer:

* 1st Jul 2014 – Till Date

Organization

Cognizant (CTS) – CHENNAI

Designation

Technical Lead

Environment

* Win-2003/2008/2008 R2/2012 & VMWare

* SQL Server 2000/2005/2008/2008 R2/2012

* Batch/VBS/SQL Scripting

Project Name : Computer Shares

Role

Senior Database Administrator

Organization

Cognizant – Hyderabad

Duration

5th July 2013 – Till Date

Projects

2

Team Size

7

Project Description:

Daily there is file processing from one region to another region we have work on Stored Proc’s ensure all file s are transfer from one region to another region, and replication alerts and all adhoc tickets raised by system, user and customer.

Previous Employer:

* 28th Oct 2013 – 23rd May 2014

Organization

Primus Global – HYDERABAD

Designation

Database Administrator

Environment

* Win-2003/2008/2008 R2/2012 & VMWare

* SQL Server 2000/2005/2008/2008 R2/2012

Project Name : Shared Pool

Role

Database Administrator

Organization

Primus Global – HYDERABAD

Duration

28th October 2013 – 23rd May 2014

Projects

45

Team Size

10

Project Description:

Working as a Senior SQL DBA & Leading SQL team (40 – 45 different projects – SQL Shared Services) projects in our account.

Previous Employer:

* 23rd April 2012 – 26th October 2013

Organization

Valuemonentum

Designation

Software Engineer Testing

Environment

* Win-2003/2008,

* SQL Server 2005/2008,

* IIS 6.0/7.0/7.5

* Batch Scripting

Project Name : OMA (Microsoft)

Role

Database Administrator, IIS admin, Build engineer & Infra admin

Organization

Valuemomentum Software service Private Limited

Duration

23rd April 2012 – 26th October 2013

Team Size

4

Project Description:

OMA is an Order Management Automation project, which is migrating one of the old application to a new application with the newer technologies i.e., SQL azure, windows azure and silver light.

Previous Employer:

* 2nd August 2010 – 21st April 2012

Organization

CaprusIT

Designation

Test Analyst

Environment

* Win-2003/2008,

* SQL Server 2005/2008,

* IIS 6.0/7.0/7.5

* Batch Scripting

Project Name : EmpowerMX

Role

Associate Joinee

Organization

CaprusIT Private Limited

Duration

2nd August 2010 – 21st April 2012

Team Size

6

Project Description:

It is aircraft maintenance for local services like AA, AE and SWE

Personal Profile

Name

Rakesh Reddy Balireddy

DOB

05 June 1988

Phone

91-805*******

E- Mail

acgixs@r.postjobfree.com

Address

Mettukuppam,Hyderbad - 500019

Contact this candidate