Sql Server Ms

Syed Anees S

Contact : +91-739*******

Email-id : ***********@*****.***

Summary:

Over 10 years 8 months of total experience in which 5 years and 4 months of experience as MS SQL Server core DBA.

Technical Skills in MS SQL Server 2005, 2008, 2008 R2, 2012, 2014, 2016 & 2017 (Database Administrator)

Quality - oriented IT professional with notable success in Banking, finance, Electricity Power, Logistics & Insurance Projects.

Having good knowledge in SSIS, SSAS, SSRS, Clustering, etc.

Good Knowledge in Verint application & Cognos Reporting tool.

Career Chronology

Working as SQL SERVER DBA Consultant in KAHRAMAA, QATAR through Arita Solutions from May 2016 till now.

Worked as Senior Database Administrator (SQL DBA) in GOCONTEC from Jul 2015 to Mar 2016

Worked as a Database Consultant (MS SQL Server DBA) in Mphasis an HP Company from Feb 2013 to Jul 2015

Worked as HR Consultant in Repute Infotech & Enterprises Limited from April 2009 to Feb 2013.

Worked as Admin Officer in PACL India Limited from October 2007 to March 2009

Professional Strengths:

Extensive experience in installing, configuring, managing, monitoring and troubleshooting SQL Server.

Implementation of security, maintenance and database consistency checks.

Expertise in planning and implementing MS SQL server security and database permissions.

Implementation of SQL Logins, Roles and Authentication modes as a part of security policies for various categories of user support.

Experience in upgrading SQL Server software to new versions and applying service packs and hot fixes.

Experience in Database Backup and Recovery procedures.

Scheduled and maintained routine Jobs, Tasks, Alerts and Maintenance Plans.

Using Performance Monitor/Profiler to solve Slow/Long running queries.

Experience in implementing Snapshot and Transactional replication

Successfully planned and implemented SQL Server 2005, 2008, 2008 R2 Database Mirroring & Log-Shipping.

Configuring ALWAYSON HIGH AVAILABILITIES.

Configuring Window failover clustering,

Providing technical database supports for SQL Database production systems.

Experience in using EMC & HP backup tools.

Good interpersonal skills, committed team player with team driven skills.

Good communication skills, written and verbal presentation skills.

EDUCATIONAL QUALIFICATION:

MBA (Finance & Marketing) from Anna University in 2007.

Bachelor of Business Administration from University of Madras in 2005.

Successfully completed the Microsoft Certified IT Professional Exam (MCTS).

Exam Code: 70-432 (Server :MSSQL SERVER 2008).

Work Experience:

Organization : ARITA SOLUTIONS WLL, QATAR.

Project : Electricity and Water -Kahramaa

Duration : 01 May 2016 to 31 May 2018

Environment : MS SQL 2005, 2008, 2008 R2, 2012, 2014, 2016,2017, Windows 2008 R2, Windows 2012, 2012 R2

Skill/Tools : MS SQL 2005, 2008, 2008 R2, 2012, 2014, 2016, 2017 DBA, Windows 2008 R2, 2012 R2

Roles:

Performing SQL server daily health check and preparing a report based on it.

Monitoring Alerts, disk Space of all the Servers and freeing up space as per SQL Server i.e. Older Backups, Unused Files etc.

Handling creation of new SQL Server databases as per the request.

Scheduled and maintain routine Jobs, Alerts and Maintenance Plans.

Monitoring the Log Space for successful execution of all the specified jobs.

Reviewing SQL Server and SQL Server Agent Error Logs.

Implementation of SQL Logins, Roles and Authentication Modes as a part of Security policies and also preparing Auditing Reports for following auditing standards.

Setting Perform counters for monitoring the server as per request about degraded performance from Application Team.

Configuration and Maintenance of ALWAYSON HA, MIRRORING & Log-Shipping.

Organization : GOCONTEC, CHENNAI

Project : Satellite, Chipset, Cinema entertainment

Duration : 28 Jul 2015 to 29 Feb 2016

Environment : MS SQL 2005, 2008, 2008 R2, Windows 2008 R2, Windows 2012

Skill/Tools : MS SQL 2008 R2 DBA, Windows 2008 R2,

Roles:

Performing SQL server daily health check and preparing a report based on it.

Monitoring Alerts, disk Space of all the Servers and freeing up space as per SQL Server i.e. Older Backups, Unused Files etc.

Handling creation of new SQL Server databases as per Application Team request using Build Sheet Template.

Scheduled and maintain routine Jobs, Alerts and Maintenance Plans.

Monitoring the Log Space for successful execution of all the specified jobs.

Reviewing SQL Server and SQL Server Agent Error Logs.

Implementation of SQL Logins, Roles and Authentication Modes as a part of Security policies and also preparing Auditing Reports for following auditing standards.

Setting Perform counters for monitoring the server as per request about degraded performance from Application Team

Configuration and Maintenance of Mirroring, Log-Shipping & Replication.

Organization : Mphasis an HP Company

Project : AIG(Banking and Finance), IT, Software, Insurance, Education

Duration : 22 Feb 2013 to 24 Jul 2015

Environment : MS SQL 2008 R2, MS SQL 2012, Windows 2008 R2, Windows 2012

Skill/Tools : MS SQL 2008, 2008 R2, 2012 DBA, Windows 2008 R2, Cognos Reporting

Roles:

Performing SQL server daily health check and preparing a report based on it.

Monitoring Alerts, disk Space of all the Servers and freeing up space as per SQL Server i.e. Older Backups, Unused Files etc.

Scheduled and maintain routine Jobs, Alerts and Maintenance Plans.

Monitoring the Log Space for successful execution of all the specified jobs.

Reviewing SQL Server and SQL Server Agent Error Logs.

Implementation of SQL Logins, Roles and Authentication Modes as a part of Security policies and also preparing Auditing Reports for following auditing standards.

Configuration and Maintenance of Mirroring, Log-Shipping & Replication.

Works on Verint Application support and IBM Cognos for Reporting

Organization : Repute Infotech & Enterprises Limited

Project : Logistics and Shipping

Designation : HR Consultant

Duration : 01 April 2009 to 09 Feb 2013

Environment : MS SQL 2005, 2008, Windows 2008 R2

Skill/Tools : MS SQL 2005, 2008 DBA, Windows 2008 R2,

Roles:

Preparing the employee’s salaries.

Calculation of ESI and submission of ESI

Filing ESI returns

Preaparing EPF and submitting online and manual forms.

Filing EPF returns.

Applying for holidays to Labour welfare board.

Handling with employee gratuity.

Handling labour wefare activities.

Performing SQL server daily health check and preparing a report based on it.

Monitoring Alerts, disk Space of all the Servers and freeing up space as per SQL Server i.e. Older Backups, Unused Files etc.

Handling creation of new SQL Server databases as per Application Team request using Build Sheet Template.

Scheduled and maintain routine Jobs, Alerts and Maintenance Plans.

Monitoring the Log Space for successful execution of all the specified jobs.

Reviewing SQL Server and SQL Server Agent Error Logs.

Implementation of SQL Logins, Roles and Authentication Modes as a part of Security policies and also preparing Auditing Reports for following auditing standards.

Organization : PACL India Limited

Duration :15 Oct 2007 to 31 Mar 2009

Designatiion : Admin and HR Officer

Roles:

In charge of supervising, monitoring and managing the branch staff.

Accountable in handling recruitment. Hiring new personals based on the need.

Expertise in Customer Relationship Management. Deal with the customers and their queries.

Responsible in tracking and managing the accounts.

Held responsible in handling cash and in charge of the same.

Responsible for Professional tax payment

Responsible for preparation of Bank Reconciliation Statement

Preparation Various MIS Reports.

Developing new business.

Responsible to achieve branch target.

Contact this candidate