Raja Loganathan

Same duties and responsibilities as Trade Socio India Pvt Ltd

MongoDB:

• Installed and configured multi-node cluster.
• Performed mongo server installation, maintenance, and upgrades for QA, Test, and Production on Linux Handled security, buffer tuning, and data integrity.
• Implemented replicas and performed addition/removal of nodes.
  Executed MongoDB query language to create database, collection, indexes, collations, read/write a document with read/write concern, CRUD operations.
• Executed mongostat, mono top, mongoreplay, mongo, profiler, compass, and tools to monitor the performance of the cluster, schema, and query, and to resolve them.
  

MySQL:

• Performed MySQL server installation, maintenance, and upgrades for QA, Stage, and Production on Linux Handled security, schema changes, buffer tuning, and data integrity.
• Established High availability replication environment, master-master, and master- slave environment.
• Define and document database best practices.
• Ability to carry out security tasks at the network level such as blocking/unblocking TCP/IP ports through the firewall on both Linux and windows and blocking/unblocking remote access to MySQL server.
• Performed CPU/IO and Memory test using Sysbench and utilized the Mysqlslap benchmark tool to capture Mycelia performance.
• Migration MySQL to AWS.
• Installed and configured multi-node cluster.
• Performed mongo server installation, maintenance, and upgrades for QA, Test, and Production on Linux Handled security, buffer tuning, and data integrity.
• Implemented replicas and performed addition/removal of nodes.

· Executed MongoDB query language to create database, collection, indexes, collations, read/write a document with read/write concern, CRUD operations.

• Executed mongostat, mono top, mongoreplay, mongo, profiler, compass, and tools to monitor the performance of the cluster, schema, and query, and to resolve them.

PostgreSQL:

• Plans and coordinates the administration of PostgreSQL databases to ensure accurate, appropriate, and effective use of data, including database definition, structure, documentation, long – range requirements, and operational guidelines
• Performs quality control audits to ensure accuracy, completeness, such as database dictionaries
• Establish and maintain security and integrity controls
• Prepares and/or reviews activity, progress, and performance reports
• Install, configure, test, monitor, upgrade, and tune new and existing PostgreSQL databases
• Managed schema, indexing, objects, and partitioning the tables Created automated scripts to backup the database nightly and restore it in case of failure or migration to new hardware
• Identified bottlenecks, issues, and areas of improvement for current databases Worked with teams and architects to design applications and systems around storage solutions that fit the problem space Tuning autovacuum parameters to ensure up to date table stats and reclaim space consumed by dead tuples
• Contributed to decreasing need for downtime by developing and improving procedures for automated monitoring and proactive intervention
• Migration PostgreSQL to AWS
• On call 24/7, support for MySQL, MS SQL Server

Cassandra DBA

• Installed, configured, and Tested Data stax Apache Cassandra multi-node cluster.
• Estimated cluster sizing and configured Cassandra YAML file to modify, and update configuration to improve performance.
• Configured CQL to perform CRUD operations with Read and write consistency level, Quorum Model)
• Created Cassandra keyspaces with replication and compaction strategy and node sync, created column families and implemented partitioning and clustering using a primary key.
• Implemented node configuration and performed Cassandra stress test.
• Monitored and performed database operations, Cassandra, using top, nodetool commands, system and output log, JVM garbage collection log, Ops Center, and life cycle manager GUI tool.
• Performed Node addition/removal/replace, Node bootstrapping, Node repair, sstablesplit, and CQL copy. Sstabledump, sstableloader, Dsbulk, Backup Monitored and performed database operations, Cassandra, using top, dstat, nodetool commands, system and output log, JVM garbage collection log, OpsCenter, and life cycle manager GUI tool.
• MS SQL Server
• Installed and configured the SQL Server 2000, 2005, and 2008 and 2008R2 and 2012, 2014.
• Applying SQL Server patches and hot fixes to stand-alone and cluster servers.
• Resolving the SQL Server blocking and Disk space issue. Finding and fixing the root cause
• Expertise in Database backup, Recovery, Restoration, and Disaster Recovery Plans.
• Experience in User Management activities like adding the user and managing the permissions.
• Experience in Creating and scheduling jobs and troubleshooting failed jobs.
• Configured and troubleshot the TRANSACTION REPLICATION and DR activities.
• Performed the Cluster installation and added the nodes in the respective servers.
• Performed the Failover and Failback operations in the cluster environment and added the new Disks and troubleshooting activities.
• Configured and maintained and troubleshooting the Database mirroring and experienced in Mirroring DR activities.
• Experience with upgrade and migration activities from SQL 2005 to 2008 and from 2008 to 2012.

• Working with a developer in the development of the database schema design using the Entity-relationship model as per user requirement
• Worked on planning and implementing MS SQL server security and database permissions.
• Wrote and reviewed T-SQL Script for creating the table, constraints, triggers, stored procedures, views, and functions for critical business applications.
• Established backup of SQL Server 2012 by using SQL Server Agents jobs for periodic backups.
• Updated statistics with full scan every week to make that the query optimizer uses the most recent statistics.
• Used SQL Profiler, Execution Plans, Performance Monitor, and DBCC Commands to find the slow-running queries to get the performance metrics
• Implemented database Mirroring to ensure the high availability of critical databases.

Project Name: Planet soft ERP
Roles: Senior Application Engineer (Jan 2004 to Feb 2006)
Software: C#, VB.NET, Web Services, SQL Server 2005, and Crystal Report XI.
Project Description
Planet soft ERP, the company's highly innovative product has been developed with the technological foresight to provide high-quality business solutions, which enhance the financial operations and management capabilities of many small & medium-sized corporations. It is the strength of the Planet soft ERP product that has enabled Planet soft to form an organization that offers a total business solution for its users Planet soft ERP business suite of software solutions encompasses over 20 modules covering:

• Accounting Subsystem
• Distribution Subsystem
• Manufacturing Subsystem
• System Administration Subsystem
• Crystal Report Family of Technologies

Project Description:
This system will be used to conduct distance learning courses for an educational institution and the features are:

• Conduct teaching sessions in different study periods based on availability
• Teaches courses/programs that are made of many units. Each unit is composed of e-Content, Assessment, Resources, and its collaboration facility like a forum chat session with trainers, etc.
• Student–Course–Trainer Enrollment process Course Evaluation Process.
  Software: C#, VB.NET, Web Services, SQL Server 2005, and Crystal Report XI.

IT Tutor Experience in BASIC, COBOL, FoxPro, Visual Basic, ASP, PHP, and .NET