Administrator Dba

SATHEESH VEERAMANI

Email: *************@*****.***

Mobile: +91-965*******

OBJECTIVE:

I would like to pursue my career in a work environment that will utilize and reinforce my technical skills and abilities and also to apply and gain new cutting edge skills and experience in a rapidly changing field.

WORKING EXPERIENCE:

5+ Years of professional experience with SQL Database for Windows based Servers

Professional Experience:

Working as a SQL Database Administrator in Resolve IT solutions, Chennai from May 2015 to March 2018.

Working as a SQL Database Administrator in Easy Design Systems Private Limited, Coimbatore from April 2018 to till date.

TECHNICAL SKILLS:

Environment : Windows 2012 and 2008 Servers

Databases : SQL MS Server 2005/2008/2008 R2/2012/2012 R2, 2016, 2017

Programming Language : Web Design on ASP.NET, SQL,TSQL, BASIC, Css, VBscript, HTML, VB.Net

Company Name : Easy Design Systems Private Limited

Role : SQL Database Administrator

EDUCATIONAL QUALIFICATION:

MCA from Arul Anandar College, Karumathur, with an aggregate 70% (Year of Passing 2015).

BCA from Best and arts Science College, Sirkali, with an aggregate 71% (Year of Passing 2012).

DTEd from Sairam TTI, Sirkali, with an aggregate 80% (Year of Passing 2009).

Technical Records:

(A) Working as a MS SQL DATABASE Administrator at Easy Design Systems Private Limited

Period : April 2018 to till date.

Role : MSSQL DBA.

Environment : SQL Server 2005, 2008 r2 2012, 2012R2, 2016, SSIS, SSRS

Roles and Responsibility:

Monitoring and troubleshoot CPU,Memory utilization, Blocking, Deadlock & read write operations.

Creating table, View and stored procedure as per requirement.

SQL DBA administrative tasks.

Monitoring SQL Error log, Event Log for error and issues.

SQL Server jobs monitoring, Job failures and root cause analysis.

Installation, configuration and Upgrade of SQL server.

Recovering the databases in case of disaster.

Scheduling Backup and Restoring of Databases.

Managing Database Users and security

Identify the Missing indexing through Query execution plan

Check for SQL Jobs scheduled completion status

Check the database Consistency using DBCC, Shrink the Log files and Update statistics

Check for space utilized in transaction log space Drive

SQL mail Profile Configuration

Executing Backup restoration drill

Database backup schedule check daily report

Table and DB Movement

Rebuild Index and update statistics in DB servers

Managing Microsoft clusters.

Performance optimization, regular health checks on servers and Systematic Troubleshooting of problems.

AWS Cloud computing

DBA and Code review

Data Transfer(One/Multi Direction Replication, SSIS/SSRS)

SharePoint Server:

SharePoint installation and configuration 2012R2.

SharePoint SQL DB migration

SharePoint Backup for APP and DB .

Tuning SharePoint SQL Databases.

(B) Working as a MS SQL DATABASE Administrator at Resolve IT solutions

Period : May-2015 to March 2018

Role : MSSQL DBA.

Environment : SQL Server 2005, 2008 R2, 2012, 2012R2

Roles and Responsibility:

Check utilization for DB disk space by running SQL cmd.

SQL failover cluster

Disaster recovery in sql server

SQL server log shipping

Database Replication and Mirroring in sql server

Review SQL server services status and Check for scheduled tasks completion

SQL Mail Trigger configuration.

Check for SQL Database Backup Successful completion

Check Database Replication status and table count match with Replication server

Capturing the Long running queries

Database DATA Archival plan and activity.

Maintained Database authentication modes, creation of users, configuring permissions and assigning Roles to users.

Installing, configuring, administering and securing clients' production and non-production servers.

Configured SQL 2012 AlwaysON Availability solution for PROD environment.

Identify and resolve SQL Server Database locks and hardware-related issues, using SQL Server Profiler And SQL Server Query Tuning where necessary, to resolve Performance slow-downs due to blocking and Other index issues, etc.

Working SSRS and Designed reports using SSRS as per business requirements

Backup and restoration of database.

oMaking a Strategy, planning and policy for DB backup

oManaging FULL, Differential and Transaction backup

oRecovering system and user databases

IIS Administration:

IIS Installation and configuration IIS6 and IIS7

Creating Virtual Directory and configuration.

Add a Web Site, Virtual Directory and applications.

Add an Application Pool and Start – stop the Application pool.

Configuring Recycling Settings for an Application Pool

ADDITIONAL STRENGTHS:

Flexibility with hours

Attention to detail and accuracy

Excellent attendance

PERSONAL DETAILS:

Father’s name : Veeramani K

Date of birth : 05.02.1990

Marital Status : Married

Sex : Male

Languages Known : English, Tamil

Address : South Street, Periyakattalai, Peraiyur (TK),

Madurai, Tamil Nadu, Pin cod: 625527

DECLARATION:

I hereby declare that the above-mentioned information is correct up to my knowledge and I bear the responsibility for the correctness of the above-mentioned particulars.

Place: Yours truly,

Date: (Satheesh V)

Contact this candidate