Sql Server Manager

N.Amarnath

E-Mail : ********.**********@*****.***

Mobile : +91-953*******

JOB OBJECTIVE

Assignments in MS SQL Database Administration with an organization of high repute, preferably in IT industry

PROFILE SUMMARY

8+ years of IT experience in AWS, Windows Web Server, MSSQL Administration.

Expert in on premises to AWS cloud SQL RDS migration

Design Development and Support of MS SQL Server 2012/2008R2 in Production, Test, Development and Cluster Server Environments.

Experience in RDBMS database design, performance tuning, optimization, backup and recovery in SQL Server 2012/2008.

Experience in Disaster Recovery Planning, Execution and Testing at remote side.

Experience in using SQL Server Tools like DTS, Import/Export Wizard, SQL Server Enterprise Manager, SQL Profiler and SQL Query Analyzer.

Migration experience from MS SQL Server 2005 to MS SQL Server 2008, MS SQL Server 2008 to MS SQL Server 2012.

TECHNICAL SKILLS

Operating Systems : Windows Server 2003/2008/2012

Virtualization : AWS, VMware

Amazon Web Services : EC2, VPC, S3, Auto-scaling, RDS MSSQL, SQS, SNS

Database : MS SQL Server 2008R2/2012

SQL Server Tools : Enterprise Manager, Query Analyzer, SSMS, Profiler

Web Server : Internet Information Server

Third Party Tools : Remedy, HP SM7, Lite speed, SQL Idera.

ORGANISATIONAL EXPERIENCE

Since May’11 Wipro Technologies, Bangalore Senior System Administrator

Aug’07 – May’11 Zylog Systems Ltd., Chennai System Administrator

CLIENTS: NESTLE BUSINESS SERVICES, SHELL

Role:

Expertise in core DBA tasks like Installation, Maintenance, Configuration, Backup & Restore, DR, Database Security and, Database designing.

Extensive experience in managing MS SQL Server on Windows 2003, 2008 and 2012 Servers.

Creation and maintenance of Databases, creating Roles and managing user permissions, resolving Blocks and Deadlocks

Experience in using tools like SQL Profiler, Windows Performance monitor and performance counters for Monitoring and Tuning MS SQL Server Performance, Idera Diagnostic Manager

Creation of Jobs Schedules, Alerts using SQL Server Agent and Notifications using SQL Mail and Database Mail.

Implemented Database Mirroring in SQL server 2008 & 2012 with a witness server to configure automatic failover

Implemented log shipping for SQL Server 2008 and 2012.

Expert in implementing different types of Replication Models such as Transactional, Snapshot, and Merge.

Knowledge in installation and configuration of SQL Server 2005/2008 cluster server in active/passive and active/active mode.

Expertise in upgrading (In-place Upgrades) and migrating databases from MS SQL Server 2005 to 2008 and SQL Server 2008 to 2012.

Extensive knowledge in Tuning SQL queries & improving the performance of the Database.

Expert in working with Third party backup tool like SQL Lite Speed, Idera SQL Safe to improve performance of backup and recovery

Expert level knowledge in Server Consolidation and Data Center migrations.

Expert in developing Stored Procedures, views, appropriate functions, and views on index to facilitate efficient data manipulation and data consistency.

Experience in upgrading SQL server software to new versions suggested by Microsoft and applying service pack and hot fixes

Experience in contacting Microsoft and other vendors for product and technical support.

Performed Database consistency checks with DBCC, Defrag, Index tuning and monitored error logs

Experience on database design for large databases.(terabyte databases)

Managed the use of disk space, memory and connections.

Performed DBCC utilities and fixed data corruption in application databases.

Created jobs, alerts, activity logs, error logs to capture any possible errors.

Created documentation to install SQL Server, apply service packs, hot fix and clustering installation.

Database refreshes from prod to stage, test and development environment

Good understanding of change control process

Available for 24*7 production support in mission critical environment.

Good interpersonal, analytical and communication skills.

Highlight:

Carried out the application migration activities while testing and rendered suggestion to the business to migrate the MS SQL Server 2008 R2 and bagged recognition for the same

Recipient of Feather in Cap Award for the successful migration of ACORN application

Received appreciation for successful implementation of Smart Card Project for Karnataka State Government

Leadership, Communication and Project Management

Leading the project team responsible for the migration of database to the cloud.

Managing a blended team responsible for a major server upgrade, this significantly enhanced system performance.

Coordinating with vendor technical team to restore the services in-case of system failure and escalate issues in timely manner.

EDUCATION & CERTIFICATION

Master of Technology in IT & Networking

Bachelor of Engineering in Electronics and Communications Engineering

Microsoft Certified IT Professional (MCITP)- Database Administrator 2008

Microsoft Certified Technology Specialist (MCTS)- SQL Server 2008,Implementation and Maintenance

Microsoft Certified Technology Specialist (MCTS)- SharePoint Administration 2010

NetApp Certified Data Administrator (NCDA)

TRAINING

Microsoft Certified System Administrator

Amazon Web Services.

Chef Training

MS SQL 2008 Administration

Contact this candidate