HEMADRI

Database Administrator

CAREER SNAPSHOT

• Competent and result-driven IT professional with 13+ years of experience in SQL Server DBA, AWS Cloud DB Administration,performance tuning and testing and expertise with database administration (Microsoft SQL Server 2012, 2014, 2016, 2017, and 2019)
• Hands-on experience in developing performance monitoring dashboard utilising PowerBI; proven knowledge of computer technology, including T-SQL, SSIS, SSRS, and visual studios and basic knowledge of NOSQL DB’s as well as handling AWS Cloud Services like EC2, RDS, S3Buckets, and EBS Volumes
• Proficiency in executing new SQL Server concepts like data partitioning, snapshot isolation, database mirroring, database snapshot, DDL triggers, try-catch blocks, online indexing, DMV’s, DMF's, Mail setup, jobs and alerts, SQLCMD, dedicated admin connection, and hosting the SQL Instances on AWS cloud
• Adept at designing, installing, and configuring large and complex databases with high availability and offsite disaster recovery, utilising Microsoft clustering, fault-tolerant SAN storage for database, and NAS for backups
• Demonstrable experience in managing all aspects of the support of SQL databases, including software installation, planning and creation of databases, using existing ITIL processes, and working with service management functions

 

CORE COMPETENCIES

• Database Administration

• Performance Tuning and Testing

• Project Management

• BI Development

• Data and Application Architecture

• Customer Requirements

• SQL Administration

• Database Design and Development

• Application Support

• Team Management

• Requirement Gathering and Analysis

• Cloud Administration

 

TECHNICAL COMPETENCIES

Databases

SQL Server Version (2000 to 2019), MongoDB, Cloud DBs

OS

Microsoft Windows Servers, ubuntu

Programming Language

T-SQL, JSON

Third-Party Tools

Lite Speed, Idera, Load Complete, Neo Load

BI Tools

Cloud Technologies

SSIS, SSRS

AWS Cloud

 

EDUCATIONAL QUALIFICATION

• Master of Technology (Computer Science), Indian Institute of Industry Interaction Education & Research, Chennai, India 2019
• Master of Business Administration (Information Management Systems), Bharathiar University, Coimbatore, India, 2010
• Bachelor of Technology (Information Technology), Anna University, India, 2005

 

CERTIFICATIONS

• AWS certified solutions architect - Associate
• Microsoft Certified Technology Specialist (MCTS SQL Server 2008)
• Microsoft Certified Professional (SQL SERVER 2000)
• Microsoft Certified Professional (.NET Framework)
• Microsoft Certified Professional Querying Microsoft SQL Server 2012/14
• Microsoft Certified Professional Administrating Microsoft SQL Server 2012/14 Databases

 

CAREER PROGRESSION

Designation

Company

Duration

Principal Consultant

Confidential

Jan 2016 – Ongoing

Senior SQL DBA

Confidential

Feb 2014 – Jan 2016

Senior SQL DBA

Confidential

Oct 2011 – Jan 2014

Module Lead

Confidential

Oct 2010 – Oct 2011

IMS - DBA

Confidential

May 2010 – Oct 2010

DBA

Confidential

July 2006 &nda