To implement innovative ideas in an efficient way

Experience

Over 13+ years of experience in Database Administration, Solution Architect, System Analysis, Design, Development and Support of MS SQL Server 2018/ 2016/ 2014/ 2012/ 2008 R2/ 2008/ 2005 / 2000 in Production, Test, Development and involved in Delivery Management process, people Management process & Stakeholder management.

Contribution

Done complete Health Check Automation for SQL server using SSAS, SSRS and SSIS [ETL] . –Reduced manual work 7 hours

Using ad hoc reports available online report

SSAS,SSIS

Formatted data available across OLAP.

Data analytics with CUBEs and Data Modeling.

Identify all manual process and automate with SQL features

Comparing data manually

Repeated system activity

Reconciliation in flat files

Robotic Process Automation [RPA]

Performance Tuning

Maintenance on Index and Statistics

Understand Response Time vs. Total Time, Rewrite Sub queries to Use JOIN, Use Parameterized Queries and Query Only When You Must.

Table Partition, Inline Memory OLTP, SQL configure, Column Stored Index, data masking.

Wait stats, Query Stats and SP stats.

SSRS reports

All ad hoc reports available online report

Create Activity monitor on multi SQL server as a report

High availability, Always On, Replication and Mirroring

Data will be available to all without impact the system

Performance Disaster Recovery on SAN to SAN replication.

Certifications

Administering a SQL Database Infrastructure (70-764)

Microsoft, License MS0609755514

February 2018 – Present

SQL server Administration in SQL 2012 (70-462)

Microsoft, License 10666536

January 2014 – April 2014

BI Certification in SQL 2012 (70-463)

Microsoft, License MS0609755514

Microsoft certification on SQL 2012 (70-461)

Reduces all operational manual work

Have done ad hoc reports available online report and SSIS packages & SSAS Data analytics on OLTP develops CUBEs and Data presentation to reduce the 4 hour’s manual works

Tools Known

BI Tools (SSRS, SSAS, SSIS), Toad, Lotus 123, Developed on Fox-pro, .Net, SQL*PLUS, SQL Developer, VM Ware, Windows Task Scheduler.

Backup Tools.

Lite Speed, Avamar, SQL Safe, Red Gate, Azure Backup.

Education

GANDHIGRAM RURAL UNIVERSITY

oMaster of Science (M.Sc.), Mathematics and Computer Science

oDissertation on Indian Space Research Organization simulation system of a space launching vehicle

oPapers present on Numerical Analysis, Operation Research and Graph theory

ARUMUGAM PILLAI SEETHAI AMMAL COLLEGE

oBachelor of Science (BSc), MATHEMATICS

Projects Handled

October 2012 to till date

Role : DB Manager/ Solution Architect

Client :

Team size : 3 [24*5]

Nov 2009 to Sep 2012

Role : Sr. DBA /Solution Architect

Client :

Team size : 4 [24*5]

Aug 2005 to Nov 2009

Role : Sr. SQL DBA

Client :

Team size : 4 [24*7]

KARTHIKEYAN GANESAN

Sr.SQL DBA Solution Architect

Personal Information

9/2 SSL Brindavan, Andal Nagar 4th Cross Street, Adambakkam, Chennai – 600088.

Phone:

+91-944*******

e-mail

ac7zto@r.postjobfree.com

linkedin

www.linkedin.com/in/karthikeyan-abirami-2228b256Twitter

Skills

Operating System

Flavor

Rating

Linux

RHEL 6

Centos 7

Solaris

Windows

WIN server 2008

WIN Server 2016

WIN 7,8,9

Technology

Version

Rating

SQL Servers

2018,2016,2014,

2012, 2008,2005

2000.07.06

SQL Azure

2017

T-SQL/PLSQL

2000 TO 2017

BI Tools

SSIS,SSAS,SSRS

.Net

Fox-Pro

3.0

Lotus

123

VM ware

Replication,SRM

Git

2.16

Jenkins

2.106

Ansible

2.3

Nationality : Indian

Language : Tamil, English

Roles and Responsibilities

Overseeing all activities related to the implementation, operation and maintenance of database systems. The day-to-day activities. Collaborates with application partners that enables operations and drives insights.

We are responsible for resolving incident tickets and handling critical incidents (Sev1, Sev2 high).

Providing SQL Server implementation changes requested from application teams.

Responsible for installing, configuring, and maintaining as per supported LOB applications.

Writing and improving SQL Server T-SQL queries.

Created necessary T-SQL scripts, stored procedures, tables, views, functions, triggers and indexes.

Responsible for providing SQL Server problem resolution and 24x7production

Responsible for disaster recovery and high availability solutions and large scale database migrations from SQL server 2005 to SQL server 2008R2 and 2012.

Created and migrated partially contained databases within Always on Availability Groups.

Created automation of day to day operations, critical SQL server alerts and repetitive tasks.

Monitored the health and performance of SQL, server instances and home grown applications using Extended Events, SQL server Profiler, PerfMon and other third party tools.

Setup and maintained Log Shipping between various environments.

Development/Test/Production QA which included documentation of processes, creation of test scenarios and execution of tests, via T-SQL scripts, to ensure UI standards met the required specifications.

Created necessary T-SQL scripts, stored procedures, tables, views, functions, triggers and indexes.

Optimized the Indexes, adding/deleting them when necessary for better performance.

Responsible for Installing, configuring and maintaining SQL failover clustering for production environments.

Worked with installation, configuration and creation of SSRS.

Deciding whether clustering, log shipping, mirroring, replication, etc. are the right fit to solve a business problem.

On-call troubleshooting for SQL Server service outages.

Sr.SQL Server DBA Solution Architect

SQL Server Installation

SQL Performance tuning

SSRS

SSAS

SSIS

T-SQL

Migration

Upgradation

Mirroring

Logshipping

Replication

AlwaysOn

Azure

WSFC

SQL Server DBA

Upgradation

CIS Security implementation

Software installation

Windows patching

T-SQL

Roles and Responsibilities

Installing all software upgrades for SQL Server.

Implementing Backups and restoring when necessary.

Used BCP utility to publish table output to text files.

Creation and management of database maintenance plan for various database consistency checks.

Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.

Managing of users including creation/alteration, grant of system/DB roles and permission on various database Objects.

Managing of database objects like tables, views, indexes.

Up gradation from SQL Server 2000 to 2005 0n windows 2000/2003 server.

Experience in capacity planning maintaining databases up to a size of 240GB.

Managing user roles, permissions and securing databases.

Created/developed/maintained the stored procedures, triggers to interpret complex business rules, history data and audit analysis.

Assembling, Installing and Servicing of Multimedia PCs and Peripherals.

Roles and Responsibilities

Installed and configured SQLServer2008 R2/ SQLServer2008 with backup jobs, database mail and configuration options.

Upgraded SQL Servers with latest service packs.

Migrated SQL Server databases from SQL Server 2005 to SQL Server 2008 R2.

Created, administered & maintained SQL Server Databases on Production, Test and Staging for various groups and ensured the availability of the database Servers.

Configured and maintained transnational replication for flow of data from QA and Dev. Server to the replica servers.

Monitored data activities like database status, logs, space utilization, locks and long transactions.

Implemented SQL standards in writing stored procedures, Triggers, Views, SQL functions.

Involved in resolving deadlock and blocking issues for concurrent users.

Worked with developers to optimize the code if required to minimize the duration and look if the indexes were used appropriately.

Provided appropriate access to users except system databases owners.

Refreshed databases for pre or post data loads activities.

Supported SQL server developers working on different projects with various requests.

Converted and redesigned existing DTS packages to SSIS packages.

Developed SSIS packages to import and export data from existing systems to upgraded system.

Used database utility programs and 3rd party utilities to monitor database performance, such as Blocking, expensive queries, and Memory utilization.

Contact this candidate