HIMANSHU ANAND

Contact: 098********

E-Mail: adn4va@r.postjobfree.com

A focused, Dedicated and knowledgeable Microsoft Certified professional aiming for assignments in SQL SERVER DBA / Developer/Database Manager & Administration with an organization of good repute.

SKILLS SET

PROFILE SUMMARY

Project Execution

Performance Tuning

Troubleshooting

Memory management

Backups Management

Execution Plans Check

Index Maintenance

Team Coordination and Management

An Innovative and dedicated professional with over 11.5 yrs of experience in SQL Server/ MongoDB/ PostgreSQL DBA Level Activities, Configuration, Database and Query Performance Tuning, Optimization & Mgmt.

Proficient in completing projects with responsibility within budget by proper planning of activities and deploying resources

Hands-on experience in managing complete range of activities right from conceptualization, to installation, testing, maintenance and troubleshooting of Servers.

Check Execution Plans in order to find expensive operators and loopholes in the queries.

Experience in managing system configuration, directing system installation, documenting & enforcing system standards

Sound knowledge of various technologies and implementing them for increasing the efficiency of the work

An Innovative, Loyal & result-orientated professional with strong communication, team management, interpersonal & negotiation skills

CORE COMPETENCIES

●Looking after end-to-end management of multiple Servers / programs, monitoring progress of SQL SERVERS as per schedule and ensuring timely completion & delivery of project to the client

●Ensuring compliance with set standards to manage projects through project lifecycles of planning, execution & closure

●Documenting backup & recovery procedures; enhancing usage of business operational systems; ensuring reliability and availability of systems for the users

●Undertaking activities like Installation, configuration, administration, backup & recovery, up gradation, patching etc.

●Reviewing / evaluating support plan for business indicators and map to service solutions

●Extending high-end technical support for various VM and servers and ensuring high customer satisfaction levels through prompt solutions of their problems

●Responsible for monitoring and performance tuning activities and ensuring prompt troubleshooting of issues.

●Designing backup strategy & ensuring scheduled / unscheduled backups as per the backup plan.

●Configuring maintenance plans for backups, database optimization & administration of SQL Server

WORK EXPERIENCE

10 Sep 18 – Till Date in WIPRO Limited as Sr. SQL Server DBA

Responsibilities:-

●Engaged in Project Execution and Implementations of SQL Databases and Maintenance activities.

●Proactive Monitoring and SQL jobs for Backups and other maintenance activities.

●Created and configured Linked Servers between SQL Server and Oracle for getting oracle data in SQL Server.

●Experience of Migration of SQL Databases from on-premises to Cloud Microsoft Azure.

● Setup Prerequisites and perform Database Upgradation and Migration.

●Perform Backups verification and configure Database Settings like fill factor, Autogrowth, MAXDOP.

●Hands On Experience of Azue Cloud Services and Migration of SQL Server Databases On-premises to Azure Cloud.

●Prepare Prerequisites and configure for High availability solutions Like Log shipping and Always ON.

●Responsible for configuring Stored procedures, Triggers and Functions as per the requirements.

●Administration and good Understanding of SSIS and SSRS Services.

●Good Knowledge of NOSQL or MongoDB / PostgreSQL Databases.

16Jun’ 16 – 26Sep’ 18 : Thomson Digital Ltd as SQL Server DBA

●Engaged in maintaining 57 SQL servers including Production Server as Database Administrator and Maintenance activities.

●Worked with Oracle Toad and Heidi SQL in order to maintain Oracle and MYSQL Databases Respectively.

●Check Execution Plans in order to find expensive operators and loopholes in the queries.

●Check Database Tuning Advisor and Execution Plans for query optimisation.

●Independently Perform Oracle Databases to SQL Server Migration through SSMA and other tools.

●Ensure timely backups of Critical databases and verify backups at weekly basis.

●Perform Regular Tasks and Maintenance required for TIS (Thomson Integration System).

PREVIOUS EXPERIENCE

Dec’14 – Jun’16 : Amtek Auto Ltd as Senior Engineer

Role:

●Engaged in Handling 70 SQL servers including Production Server as database Administrator and Maintenance activities.

●Ensure Resolution of Escalated issues within SLA.

●Resolve Blocking and Deadlocks issues through DMV and profiler Trace.

●Experience in administering Virtualized Environment with VMware.

●Good Knowledge of High availability solutions, Mirroring and Replication.

Aug’13 – Nov’14: I Energizer for Electronic Arts as Sr. Executive

Role:

●Provided Troubleshooting and support for EA games like The Sims, NFS, FIFA etc.

●Salesforce management and worked through Nucleus Software system..

●Provide Chat support to customers for PS3, XBOX 360 and other game consoles.

●Providing Support to US Clients and across globe for EA gaming and related issues.

Jan’10 – Jul’13: HCL Infosystems Limited as System Engineer

Project: EBPL Data Centre

Role:

oOptimize and Execute stored procedures at the specified timings on SQL Server 2008 AND 2012.

oUsing various Utilities Tools like Limit Upload, EO_ Job_Utility, Aggregator Upload, EC Corrector Upload, etc.

Project: Business Continuity Plan (BCP) – DR based project

Tools: Unicenter Agent DSM & ITCM by CA, SQL Server 2000-2008, FTP, Remote Desktop, AD, IIS,Windows.

Role:

●Maintenance of Enterprise & Staging Servers along with the process flow at Datacentre in Banking Domain.

●Installation of Oracle Database 9i & 10g on Window XP and configuration of Oracle & Java Apps like Finacle.

●Project execution & maintenance and handling Team of 25 members.

●Administration and Management of ITCM and BCP software among Domain Mangers & branches remotely

●Maintain Enterprise Server of BCP along with 27 Scalability (DM) with Remote DSM (CA) & Remote Desktop.

●Eliminated Blocking processes and suspended Users sessions

●Perform troubleshooting for all Windows, SQL Server or BCP Application related issues.

ACCOMPLISHMENTS

●Merit of receiving first prize in “Kaun Banega Corporatepati Competition" of CSI

●Holds the distinction of and being awarded by Executive Director of Indian Oil Corporation Ltd. for excellence in academics in High School and Intermediate

INTERNSHIP

●Underwent 6 weeks summer training in MIS Department with Indian Oil Corporation Limited, Mathura

EDUCATION

●B.Tech. (Computer Science & Engineering) from GLA Institute of Technology & Management, Mathura in 2009 from UPTU.

●Intermediate from D.P.S. CBSE Board with 69% in 2003

●High School from D.P.S. CBSE Board with 80% in 2001

EXTRACURRICULAR ENGAGEMENTS

●Served as Active member of Computer Society of India and Organizing Committeein GLA Institute of Tech. and Mgmt.

●Merit of receiving various prizes in various Tech Events & Annual Tech Festival

PERSONAL DETAILS

Date of Birth: 8th October, 1985

Address: Mayur Vihar phase-1, New Delhi-91

Language Known: Hindi & English

Contact this candidate