BALAMANIKANDAN K

Technologies and Products:

Database (MySQL, MariaDB, Cassandra & Postgres)

Responsibility:

Work as part of a team and provide 24*7 support whenever required.

Writing various shell scripts for automation on Installation, Upgrade, Replication rebuild, DB audit etc. Performing regular audit on server threshold and taking necessary action.

Database tuning and performance monitoring as per the load.

Working on troubleshooting for L3 issues.

Working on configuration and performance tuning of pgpool (Connection Pooling), Repmgr (HA), VCS Cluster for PostgreSQL.

Monitoring, Vaccum DB, Postgis, DB Replication,Performance Tuning, Index Mgmt, Data Migration on postgres DB.

Working experience on Cluster Environment (Galera Cluster, Innodb Cluster, NDB Cluster) Managing MySQL replication servers on a large scale.

Huge backup restoration using binary logs.

Backup configuration using Percona Xtrabackup utility. Expertise in Percona Toolkit for online changes and No downtime activity.

Ensure to provide required training for team on performing assigned tasks.

Setup and maintain documentation and standards. Working on POC for new technology and preparing SOP.

Handling various technologies like Cassandra, PostgreSQL.

Project:

Reliance Jio Infocomm

Technologies and Products:

Database (MySQL, MariaDB, Cassandra & Postgres)

Responsibility:

Work as part of a team and provide 24*7 support whenever required.

Writing various shell scripts for automation on Installation, Upgrade, Replication rebuild, DB audit etc. Performing regular audit on server threshold and taking necessary action.

Database tuning and performance monitoring as per the load.

Working on troubleshooting for L3 issues.

Working experience on Cluster Environment (Galera Cluster, Innodb Cluster, NDB Cluster) Managing MySQL replication servers on a large scale.

Huge backup restoration using binary logs.

Backup configuration using Percona Xtrabackup utility. Expertise in Percona Toolkit for online changes and No downtime activity.

Ensure to provide required training for team on performing assigned tasks.

Setup and maintain documentation and standards. Working on POC for new technology and preparing SOP.

Handling various technologies like Cassandra, PostgreSQL.

Technologies and Products:

• Database (MySQL, Mariadb & Postgres)

Projects: Payroll, HR

Responsibility:

• Work as part of a team and provide 24*7 support whenever required.
• Database tuning and performance monitoring.
• Supporting the team for troubleshooting on L3 tasks.
• Working experience on GR setup and troubleshooting.
• Managing MySQL replication servers on a large scale.
• Restoring the databases using binary logs if backup not available.
• Backup configuration using Percona Xtrabackup utility.
• Working with Percona Toolkit for online changes.
• Troubleshooting, Installation and Configuration of Postgres server.
• Setup replication for Postgres server using BDR replication.
• Ensure to provide required training for team on performing assigned tasks.

Technologies and Products:

• Database (MySQL & Postgres)

Projects: Media

Responsibility:

• Handling the team for the productivity.
• Installation, configuration and upgrading of MySQL server software.
• Implement and maintain database security (create and maintain users and roles, assign privileges).
• Database tuning and performance monitoring.
• Setup and maintain documentation and standards.
• Plan growth and changes (Capacity planning).
• Work as part of a team and provide 24*7 support whenever required.
• Do general technical troubleshooting and give consultation to application teams.
• Interface with MySQL for technical support.
• ITIL skill set requirement (Problem Management/Incident Management/Chain Management etc.)
• Managing MySQL Cluster Servers Database and OS level.
• Installation, Configuration of Percona MySQL and Percona XtraDB Cluster.
• Configuring Galera Cluster on unix servers.
• Basic troubleshooting, installation and configuration of Postgres server.

Technologies and Products:

Database: MySQL & MSSQL

Projects: Automobile & Australia Court

Responsibility:

• Involved extensively in Installation, Upgrading, Configuration, Maintenance and setting up replication for MySQL and MSSQL databases.
• Creation of users, roles and granting/ revoking necessary permissions to users and roles.
• Experience with Installing and configuring database monitoring utility for MySQL and MSSQL.
• Database conversion from MS-SQL to My-SQL and vice versa.
• Database Engine conversion from MyISAM to INNODB and vice versa.
• Writing scripts, procedures and views for data retrieval and maintenance.
• Database upgrades (My-SQL).
• Highly involved in Performance tuning of Databases, Disk I/O, Memory and testing SQL Queries to enhance performance.
• Wrote Shell, SQL scripts and setup CRON jobs to backup databases and crucial system tables.

• Web servers (Apache Tomcat)
• FTP Servers (Serv-U, FileZilla, MS-FTP and Titan Ftp server)
• Database (MySQL, SQL Server 2005 and SQL Server 2008)

• In-house Product Implementation (EMR), Testing, Quality Assurance & Trouble Shooting.
• Installation, Configuration and Upgrades of EMR software on (Cloud based and Web Based) SAAS datacenter’s and Client hosted servers.
• Installing and configuring FTP.
• FTP users’ creation and access mechanism.
• Database maintenance (Both MS-SQL and My-SQL).
• Installation, configuration, setting up replication.
• Database conversion from MS-SQL to My-SQL and vice versa.
• Database Engine conversion from MyISAM to INNODB and vice versa.
• Writing scripts, procedures and views for data retrieval and maintenance.
• Database upgrades (Both MS-SQL and My-SQL).
• Replication fix in MySQL.
• Recovering database in MySQL
• Installation of RPM packages on Linux.
• Managing larger MySQL databases on Linux.
• Installation of MySQL and tomcat in Linux.
• Handling DML, DCL, TCL and DDL queries in MySQL as well as MSSQL.
• MySQL tuning for INNODB as well as MYISAM database.
• Replication setup on MySQL as well MSSQL.

. Coordinated with customers to gather source server details, including
database size, versions, storage, IOPS, HA setup, replication, and
performance metrics.
•Executed metadata collection scripts on source environments to assess schema size, table distribution, engine types, configurations, and user privileges.
•Prepared detailed assessment reports with recommendations for Azure target architecture, including SKU sizing, compute tier, and storage configuration.
•Assisted in provisioning Azure database servers and configuring
networking, firewall rules, private endpoints and backup policies.
•Performed prerequisite validation and parameter tuning on target servers prior to migration.
•Supported end-to-end database migrations (logical and physical),
ensuring minimal downtime and zero data loss.
•Conducted post-migration validation, including data integrity checks, and performance benchmarking.
•Automated health checks, reporting, and metadata collection using Shell scripting and PowerShell.
•Identified areas in need of critical improvement and implemented
strategies to achieve targets.
•Delivered performance improvement presentations and optimization recommendations to customers.

Technologies and Products:

Dialers, IVR, VAS services, PABX Configuration, PRI Configuration, MySQL 4, Web Servers (Apache Tomcat and IIS), CRM and Database (SQL Server 2000, SQL Server 2005, SQL Server 2008).

Projects: Just Dial, Reliance, Edelweiss

Responsibility:

Avhan Dialers Configuration.

CRM Configuration.

Database Maintenance.

Zephyr Configuration (VAS Services for Reliance).

Avhan IVR.

Avhan Call Flow Designer.

Avhan Campaign Manager (applications) Implementation, Testing & Trouble Shooting.

PABX Integration.

• Coordinated with other engineers to evaluate and improve software and hardware interfaces.
• Analyzed data to coordinate installation of new systems or modification of existing systems.
• Integrated third-party tools and components into applications.
• Worked with customers for needs analysis and to determine vendor costs.