SUMMARY:

• 10 years of Total experience in IT Industry
• 9 Years of experience in Production Environment on Microsoft SQL Server 2000, 2005, 2008, 2012 and 2014.
• 4 Years of Experience as Project Lead in Mphasis an HP Company.
• Having Good knowledge and hands on experience in maintaining databases. Involved in Configuring Log
• Shipping, Database Mirroring, Replication & Clustering.
• Good understanding of SQL server architecture. Experience in performing regular Backups and scheduling tasks.
• Expertise in installing, configuring, managing, monitoring and troubleshooting SQL Server 2000, SQL Server 2005, SQL 2008, SQL 2012 & 2014.
• Hands on Experience as SQL Server Database Administrator with proven track record of Administration experience, competent team member and technical skills.
• Apply ITIL process when working on Incident Management / Change /Problem Management.
• Activities include monitoring, Troubleshooting & Fine tuning databases. Also has an overall good exposure to all IT Audit procedures.
• Administering SQL Server Production database.
• Monitoring SQL Server Jobs, disk space issues & trouble shoot SQL Server Production issues.
• Handle Weekday/Weekend On - call. Apply ITIL process when working on Incident Management / Change /Problem Management.
• Applying Service Packs/Hot Fixes on a regular basis.
• Database monitoring & Deploying MON SQL scripts on all the SQL servers.
• Database migration across development/test/production environments.
• Monitoring and Troubleshooting SQL Server database performance issues for maximum availability.
• Administering High availability servers & maintaining SQL Always-on Technology.
• Installing Standalone and Cluster Environment.
• Maintain highly secure SQL Server databases using SQL Transparent Data Encryption
• To analyze & fine tune performance issues.
• Conduct Security Audit on every Half-yearly to ensure malicious updates are not being made and Configure database security.
• Planning and implementing Backup and Restore and Recovery strategies
• Troubleshooting failed jobs and any SQL related issues.
• Maintain documentation for maintenance processes, server configurations.
• Installing & configuring Sharepoint 2010 & 2013 on SQL Server.
• Guiding / Mentoring new joiners for smoother transition into the team.
• Responsible for Overall Team Performance.
• Monitor Individual Performance of the Team Members on regular basis in consultation with the Delivery Manager.
• Formulate IDP (Individual Development Plan for all Team Members)
• Formulate Goal Setting Exercise for all Team Members
• Conduct Internal Team meetings on a regular basis.
• On time submission of Metrics on Daily, weekly and Monthly basis with inputs from Team Members & Weekend Change reports.
• Service Innovation techniques and implementing on test environment and sharing with the DBA Org.
• Pro-actively seek feedback from the corresponding sending side organization to ensure that every member is meeting or exceeding the expectations.
• Ensure the team member practices knowledge sharing amongst his team members and with the SQL team as a whole.
• Proactively working on Project activities with On-site Project Management team
• Ensure the Service Delivery is taken care of during Team Members absence.
• Ensure the team member takes advantage of the monthly calendar s published to improve his/her Process / Technical / Soft Skills by enrolling to take 40hrs .
• Supporting Production implementations, Service Improvement plans for every Quarter.
• Handling Weekday/Weekend on-call support. (24*7 On call Support)
• Ensuring SLA compliance and Quality audit is done on daily basis.
• Performing Security audit on half-yearly basis on all the projects.
• Handling people care management for 5 member team, Escalation calls and High Severity Bridge calls.
• Proactively involving in Project activities with on-site Project management team and delivering on time and received many client appreciations.

PROFESSIONAL EXPERIENCE:

Confidential

Environment: WINDOWS 2000/20 /Database MS- SQL Server 2000/2005/20

Senior SQL Database Administrator

Responsibilities:

• Supports 150 SQL Servers with 207 SQL Instances handling a huge database size of 3 - 4 TB.2) Backup strategy is as follows - Weekly full backup, Daily differential backup with hourly Transaction log backup.
• Has overall 30 Boxes of clustered Environment and remaining Standalone environment.
• Managing High Availability & recoverability of MSSQL Server.
• Fine tuning Performance issues at server level & database level Using profiler.
• Service Improvement plans for every Quarter.
• Handling Weekday/Weekend on-call support. (24*7 On call Support)
• Installing Always-on High availability in SQL 2012 Servers.
• Ensuring SLA compliance and Quality audit is done on daily basis.
• Performing auditing on regular basis.
• Ensuring environment is stabilized and automate the Process.
• Maintain highly secure SQL Server databases using SQL Transparent Data Encryption
• Apply ITIL process when working on Incident Management / Change /Problem Management.

Confidential

Environment: WINDOWS 2000/2003/2008 (File / Print Active Directory, Lotus Notes, ILM and SCCM.) MS- SQL Server 2000/2005/20 08/2012

Team Lead

Responsibilities:

• Supports 251 SQL Servers with 296 SQL Instances handling a huge database size of 2 TB.
• Backup strategy is as follows - Weekly full backup, Daily differential backup with hourly Transaction log backup.
• Has overall 20 Boxes of clustered Environment and remaining Standalone environment.
• Supports Blackberry, ILM, Microsoft Operations monitor, System Center Configuration Manager and card and Travel server applications.
• Handling Escalation calls and High Severity Bridge calls.
• Proactively involving in Project activities with on-site Project management team and delivering on time and received many client appreciations.
• Service Improvement plans for every Quarter.
• Ensuring SLA compliance and Quality audit is done on daily basis.
• Performing auditing on regular basis on all the projects.
• Ensuring environment is stabilized and automate the Process.
• Apply ITIL process when working on Incident Management / Change /Problem Management.

Confidential

Environment: Windows 2000/2003 MS- SQL Server 2000/2005

Database Administrator

Responsibilities:

• Handled 40 SQL servers with 48 Instances, Handling a huge Database size of 1 TB.Configuring log shipping, replication and database mirroring.
• Fine tuning performance Monitor and troubleshooting any SQL issues.
• Apply ITIL process when working on Incident Management / Change /Problem Management.
• Handling Weekday/Weekend on-call support. (24*7 On call Support)

Confidential

Environment: Windows 2000/2003MS- SQL Server 7.0/2000/2005

Team Member

Responsibilities:

• Handled 30 SQL Servers with 45 Instances, handling a huge database of 1 TB.Backup client databases and perform database restore as required.
• Effective implementation in running consistency checks from SQL Server and application. Perform and monitor daily database operations and set-up backup schedules.
• Monitor the Server and fine tune to obtain optimal performance by advising and assisting testing and development teams.
• Monitor the status of Maintenance jobs - schedule to run daily and on weekends (tasks like rebuilding indexes, defragmenting Databases, Shrink Database, and Database complete backup).
• Creating users and giving appropriate permissions.

Confidential

Environment: Windows 2003 / Windows 2000 / Windows NT / XP / 98

Windows Admin

Responsibilities:

• Assembling computers and peripheral devices servicing for the customers under Annual Maintenance Contract. Management and maintenance of servers.Trouble shooting Printers, motherboard, CPU.