Agra Programmer

To prove myself as an indispensable part of my organization through loyalty, dedication and perseverance, nurturing my skills and talents and exploring myself in the process and thus walking up the corporate ladder, proving at every step, a key player of my organization.

Experience Summary

Overall 10+ years of experience as SQL Database Administrator.

Total approx. 15 years of work experience in the IT Industry.

1 year onsite (client site) experience in UK.

Education

Bachelor of Engineering (B.E.) in Computer Science from Dr. B. R. Ambedkar University (Agra University), India with 70%.

Professional Experience

Sept 2020 – Sr. SQL DBA

Present HCL Technologies Ltd, Noida

Support end to end of the SQL database environments (SQL 2005/2008/2012/2014/2016), including database creation, backups, refreshes and application upgrades.

Manage, monitor and maintain the overnight server processes, including database backups and scheduled maintenance tasks which are written in PowerShell and windows batch programming.

Review and run SQL scripts into live production environments.

Install and patch SQL Server software, including disaster recovery management.

Deploy application upgrade scripts for internal (Development, QC, Implementation) and external clients.

Assist developers with complex query tuning and schema refinement as required.

Troubleshoot Sybase and SQL server errors and performance issues.

Monitor the helpdesk call queue, picking up and resolving calls in a timely fashion

Configuring/Managing Sybase and SQL Replication and other HA solutions like Always ON and Clustering

Liaison with Vendors, 3rd Party Suppliers, IT Development and Business Users

Managing security for databases/servers including SSAS and SSRS

Creating and maintaining accurate and up-to-date documentation.

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

Complete documentation about the database. Recovering the databases from backup in disasters.

Dec 2011 – SQL DBA

Sept 2020 NIIT Technologies Ltd, Gurgaon

Support end to end of the SQL database environments (SQL 2005/2008/2012/2014/2016), including database creation, backups, refreshes and application upgrades.

Manage, monitor and maintain the overnight server processes, including database backups and scheduled maintenance tasks which are written in PowerShell and windows batch programming.

Review and run SQL scripts into live production environments.

Install and patch SQL Server software, including disaster recovery management.

Deploy application upgrade scripts for internal (Development, QC, Implementation) and external clients.

Assist developers with complex query tuning and schema refinement as required.

Troubleshoot Sybase and SQL server errors and performance issues.

Monitor the helpdesk call queue, picking up and resolving calls in a timely fashion

Configuring/Managing Sybase and SQL Replication and other HA solutions like Always ON and Clustering

Liaison with Vendors, 3rd Party Suppliers, IT Development and Business Users

Managing security for databases/servers including SSAS and SSRS

Creating and maintaining accurate and up-to-date documentation.

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

Complete documentation about the database. Recovering the databases from backup in disasters.

Sept,2006 – SQL DBAand Application Support Analyst (Client SHL)

Dec,2011 Dell Services, Noida

Perform business analysis, technical analysis, systems design, application software programming.

Restructuring the stored procedure, designing, coding and developing the same using the T_SQL Programming.

Worked on Dynamic Management Views in SQL Server 2005.

Installed, authored, and managed reports using SQL Server 2005 Reporting Services.

Monitoring SQL server performance using SQL Profiler to find performance and dead locks.

Developed, deployed and monitored SSIS Packages.

Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.

Rebuilding the indexes at regular intervals for better performance.

Monitored and modified Performance using execution plans and Index tuning.

Expertise in SQL Server Reporting Services and SQL Server Analysis Services.

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

Complete documentation about the database. Recovering the databases from backup in disasters.

To analyze long running slow queries and tune the same to optimize application and system performance.

Jan,2006 – Application Programmer

Sept,2006 Dreamsoft Solutions Pvt. Ltd, New Delhi

Developed and implemented applications using VB.Net and SQL Server.

Review – self and peer to peer review

System testing, integration testing, unit testing

Design and coding of different modules.

Worked closely with clients to establish problem specifications and system designs.

Oct,2004 – Application Programmer

Sept,2006 Sapient Informatics Pvt. Ltd, New Delhi

Developed and implemented applications using VB and SQL Server 2000.

System testing, integration testing and unit testing.

Requirement Analysis, Coding, Testing.

Worked closely with clients to establish problem specifications and

system designs.

Jan,2004 – Application Programmer Trainee

Oct,2004Infowaves Solutions Pvt. Ltd, Noida

Development and testing the different modules.

Documentation and implementation.

Worked closely with clients to establish problem specifications and system

designs.

Personal Information

Address:

P-502, Homes121, Sector 121, Noida -201301

Phone:987*******

Email :

************@*****.***

DOB : 18June,1981

Marital Status : Married

Language: Hindi, English

Certificates

Microsoft 70-764: Administering a SQL Database Infrastructure

Microsoft 70-765: Provisioning SQL Databases

Technical Expertise

Database Administration:

MS SQL Server 2000,2005, 2008, 2012,2016,2019

Programming Languages:

Visual Basic 6

C

C++

SQL

VB.NET

Operating System:

Windows 2008/2003 Advanced Server, NT & Windows 9x

SQL Backup Tools:

MS Backup Utility

LiteSpeed,

Redgate.

Cloud Environment :

Microsoft Azure

Scripting Language:

VB Script

PowerShell

Incident Management:

IvantiLanDesk

TouchPaper

BMC Remedy

Contact this candidate