GANESAN BALAKRISHNAN *

GANESAN BALAKRISHNAN :adbtt1@r.postjobfree.com

: +1-925-***-****

PROFILE

** ***** ** ********** ** the IT industry with exposure to SQL SERVER Development and administration. Have knowledge in .net Framework, Sybase T-SQL development. Highly inspire individual with strong team orientation, good communication skill and the ability to learn. Work towards strong team building with self-motivation and looking forward the challenging task that provides opportunities to continuous learning and growth. PROFESSIONAL SUMMARY

10+ years of experience in Database Administration and Developer for very large and complex databases in SQL Server 2016, 2014, 2012, 2008 R2, 2008, 2005 and 2000.

Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.

Strong technical background along with the ability to perform business analysis and write effective documentation and specifications.

Experience in AWS and Azure Cloud

Expertise in T-SQL writing stored procedures, triggers and functions.

Administering SQL Server High Availability and Disaster Recovery strategies.

Implemented the new SQL Server 2012 mechanisms like data compression, online indexing, Contained Databases, security principals and AAG.

Experience in using DMV and dynamic management functions for finding out long running queries.

Experience in Disaster Recovery Planning and Security Management operations.

Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.

Having hands on experience in DR processes including Log shipping and Database Mirroring.

Worked on SQL Server 2012 migration from SQL Server 2008 / 2005.

Implemented Always-ON (AAG) on SQL Server 2012 SP2 CU5

Handling Memory configurations for SQL Server 2014 and SQL Server 2012 on Windows 2012.

Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support.

Created Linked Servers between SQL Server 2008 R2 & Oracle 9i and 10g. Also created DTS package for data transfer between the two environments.

Working knowledge in Analysis Services (SSAS), Reporting Services (SSRS) and Clustering.

Experience in supporting Very Large databases (VLDB) and troubleshooting the problems.

Strong experience in mentoring team members and writing documentation.

24 X 7 Production Database on Call Support

Experience in Health care, Content Management System (CMS), Banking, Automobile, Oil/Gas and Gaming Domain.

GANESAN BALAKRISHNAN 2

EMPLOYMENT

Feb 2016 – Till Date : Database Administrator @ Nexon America Jan 2015 – Feb 2016 : Solution Architect @ Mahindra Satyam/Tech Mahindra Jun 2010 – Jan 2015 : System Analyst @Mahindra Satyam/Tech Mahindra Jun 2007 – Jun 2010 : Senior Software Engineer@ Satyam Computer Services Jul 2005 – Jun 2007 : Software Engineer@ Satyam Computer Services Nov 2003 – Jun 2005 : Junior Programmer@ Laserwords Private Ltd TECHNICAL SKILLS

Databases: MS SQL Server 2016/2014/2012/2008/2005/2000 Programming: Visual Basic .net/6.0/5.0, C, C++ & SQL DBA: Database administration of MS SQL Server 2016, 2014, 2012, 2008, 2005 Operating System: Windows 2012/2008 R2/2008/2003 Advanced Server, NT & Windows 9x Other Software: Windows 2008/2003 Advanced Server, NT & Windows 9x Tools: SQL LiteSpeed, Visio., Remedy, JIRA, Splunk, Zabbix, Foglight Network Topologies: TCP/IP, DNS, WINS, DHCP, FTP, SNMP, SMTP Cloud AWS, Azure

EDUCATION

PROJECTS

Employer: Nexon America Feb 2016 – Till Date

Title: Database Administrator – SQL Server

Responsibilities:

Database Development and Administrator

Install, upgrade and apply fixes to SQL Server on DC, AWS and Azure Cloud.

Setup and Manage Logshipping, Mirroring and Replication configuration

Automate Database monitoring tasks

Work with Game developers for performance tuning and apply game patches

Develop SSIS packages to load the application logs to splunk

Handing security groups, firewall for VMWare, Azure and AWS.

Backup configuration, Capacity planning and DR setup Environment: SQL Server 2005/2008/2008R2/2012/2014 Enterprise, Windows Enterprise Server 2012, AWS, Microsoft Azure, Foglight, Zabbix, Splunk, Puppet, Litespeed 4.x/5.x/6.x/7.x 2000-2003 : Master of Computer Applications @ Bharathidasan University, India 1997-2000 : Bachelor of Science (Computer Science) @ Bharathidasan University, India GANESAN BALAKRISHNAN 3

Employer: Satyam Computers/Tech Mahindra Inc Jun 2005 – Feb 2016 Title: SQL Server Development/DBA

Responsibilities:

Production Support DBA

Works with BP to fix server/database level performance issues.

Query Optimization and performance tuning troubleshooting.

Commissioning and decommissioning new servers/databases for new applications.

Managing server inventory and Audit level health check of servers

Indexing,Rebuilding for optimal performance

Working with operational support team to schedule the new changes as per the ITIL process.

Automating Administrative Tasks like space analyze, data file growth, login failures, account lock-out by creating alerts, jobs, scheduling jobs, and SSIS Packages Maintenance

Monitoring user access to the databases regularly by configuring audit jobs for capturing activities based on events.

Executing DBCC commands periodically to check database consistency, and rectifying the errors reported.

Based on transaction volumes and Database size growth, analyze and advise on capacity planning.

Interacting with the support teams so that the database environment is always available without any downtime

Disaster Recovery planning and Drill

Always-on configuration.

Environment: SQL Server 2005/2008/2008R2/2012/2014 Enterprise, Windows Enterprise Server 2012, Microsoft Visio, Microsoft Reporting Services, Litespeed 4.x/5.x/6.x/7.x Clients: American Express, Ford Motors, Fujitsu Services, Microsoft and Chevron. Content Management System (CMS) Nov 2004 - Jun 2005 Title: SQL Server Development/DBA

Responsibilities

Worked in database migration from PostgreSQL to SQL Server.

Involved in Database Design and Performance tuning.

Creation of user databases and database objects.

Backup & Recovery

Keeping track of all available free space at SQL Server level

Data server error log monitoring - to trace and identify issues reported by the SQL Server within production environments and offer potential solutions

Involved in refreshing the test/dev databases

Job scheduling in SQL Server

Environment: SQL Server 2005, SQL Server 2000, Windows 2003/2000 Server, Enterprise Manager, SQL Query Analyzer, SQL Profiler.

GANESAN BALAKRISHNAN 4

Client: Access Dental (Carmichael) Nov 2003 - Oct 2004 Title: SQL Server Developer/DBA

Responsibilities

Involved in database design.

Stored Procedures, Views and Triggers development.

Transaction and Merge Replication setup and troubleshooting the replication issues.

Involved in Database Design and Performance tuning.

Scheduling automated jobs for the database transaction

Creation of user databases and database objects.

Backup & Recovery

Environment: SQL Server 2000, Windows 2003/2000 Server, Enterprise Manager, SQL Query Analyzer, SQL Profiler, VB.net

Contact this candidate