Skip to main content
Kumaran Rajendran

Kumaran Rajendran

Sr Database Administrator

Talent
SecaucusMember since May 3, 2026
IBM DB2 LUWPostgreSQLAWS RDSAWS AuroraAWS RedshiftOracle 19cHADRTSAMPRed Hat HA clustersOracle Data Guarddb2adviseexplain plansdb2pdSYSIBMADM viewsQ ReplicationDB2 SQL ReplicationAWS DataShareShell scriptingRubrikEMC NetWorkerRMANMongoDBNetezzaAWS Schema Conversion Tool (SCT)AWS Database Migration Service (DMS)pgBackrestVACUUM ANALYZEREINDEXINGpg_repackEXPLAIN ANALYZE
·

Hire this person

Send a job offer directly to this candidate

IBM DB2 LUWPostgreSQLAWS RDSAWS AuroraAWS Redshift

About

15+ years of expertise in Database Administration across IBM DB2 LUW, PostgreSQL (AWS RDS/Aurora), AWS Redshift, and Oracle 19c.

Cloud Infrastructure

Lead experienced in provisioning RDS instances, Blue/Green deployments, and optimizing AWS costs.

High Availability

Specialist proficient in implementing HADR, TSAMP, Red Hat HA clusters, and Oracle Data Guard.

Performance Tuning

Expert skilled in query optimization using db2advise, explain plans, db2pd, and SYSIBMADM views.

Complex Migrations

Pro with a track record of upgrading DB2 environments from V9.7 through V11.5 across diverse platforms.

Replication

Authority experienced in configuring bidirectional Q Replication(POC), DB2 SQL Replication, and AWS DataShare.

Automation

Developer proficient in Shell scripting for automated backups, maintenance, and proactive system monitoring.

Enterprise Support

Lead providing 24/7 on-call management for mission-critical SAP BW, ECC, and E-commerce applications. Backup & Recovery Expert with hands-on experience using Rubrik, EMC NetWorker, RMAN Versatile Administrator managing NoSQL (MongoDB) and Appliance (Netezza) environments alongside traditional RDBMS.

Experience

Sr Database Administrator at The Childrens Place (2017-11 – Present)

The Children’s Place is the largest pure-play children’s specialty apparel retailer in North America. The Company designs, contracts to manufacture, sells and licenses to sell fashionable, high-quality merchandise at value prices. The Company operated 1,039 stores in the United States, Canada and Puerto Rico, an online store at, and had 150 international points of distribution open and operated by its 6 franchise partners in 17 countries

  • DB2 LUW V10.1 – V11.5
  • Provide on call support for DB2 LUW databases supporting online applications, Ecom, SAP BW and ECC applications, Style, Store, Cognos, Coupon.
  • DB2 LUW Database Upgrading, Fix Pack, Backup recovery, performance monitoring, Database tuning, maintenance of logs, disaster recovery planning
  • Participating in DR tests HADR, breaking replication and switching roles between primary and standby. Switch Over all Production Database to DR for Data Center Migration.
  • Handling Capacity storage related issues, Analyzing CPU and Memory utilization IBM Data Management Console. alerts and warnings.
  • Involved in query optimization using db2 advise and explain plan. Analyzing resource consuming SQL query using SYSIBMADM views and db2pd.
  • Installation and Migration from DB2 LUW V 9.1 to V11.5 Setting up HADR and migrating DR servers.
  • Using db2 utilities like export, import, load for data migration and refresh, ADMIN MOVE Redirect restore in lower environment and reclaiming space by adjusting used space and free space.
  • Offline Reorg, Online Reorg, Runstats with distribution and Runstats on table.
  • Installation and Configuration of backup recovery tool Rubrik, for DB2 database server for HADR,
  • Planning, Implementation physical layout for DB2 LUW databases file system, creating databases, configuring HADR, deploying shell script to reclaim space from databases, monitoring log space utilization, HADR Peer state, TSAMP domain online state etc.
  • Supporting Non-production environment, QA, DEV, STG. Working with application team to optimization and analyzing queries.
  • Replaced licensed DBI monitoring tool with IBM DB2 Data Management Concole (DMC) for IBM Db2, reducing monitoring costs while maintaining performance visibility and operational efficiency
  • Knowledge configuring Rubrik Polaris backup and recovery solutions for db2 LUW DB.
  • Postgresql 12, 15 AWS RDS and AWS Aurora and AWS Redshift
  • Provisioning and Setup RDS PostgreSQL instance, instance type, storage and networking (VPC, subnets)
  • Creating and managing read replicas, Test Failover Scenarios.
  • Blue/Green Deployment for major upgrade PostgreSQL 15 to 17. Zero to minimal downtime. Aurora PostgreSQL In place upgrade.
  • Conducted audit of AWS RDS infrastructure, identified inactive read replica idle for 2 months, and decommissioned it, resulting in reduced AWS costs and reduce prework time upgrade for blue/green deployment.
  • AWS redshift workload management (WLM), Data share, creating roles and permissions. Implemented Data share, Granting access to tables regularly adding schemas and tables to datashare.
  • Restore AWS Redshift PROD snapshot in lower env different region, table level restore.
  • Implemented pgbackrest and configured backups for incremental from full every day backup reduce backup time.
  • Developed shell script to monitor table and index bloating, performing VACUUM ANALYZE, REINDEXING to reduce size of index improving database performance
  • Monitored AWS CloudWatch metrics for database instances to proactively identify high CPU utilization and elevated I/O throughput, ensuring early detection of performance bottlenecks.
  • Improved database performance by recommending and implementing appropriate indexing strategies, including selective use of partial indexes for high-filter queries.
  • Performed deep query optimization using EXPLAIN ANALYZE, resulting in a 60% reduction in average query latency for the core payments API.
  • Reduced postgresql table bloat by 40% using pg_repack improving query response time and storage efficiency in production environments.
  • Implemented and configured pgBackrest for postgresql15 backup and recovery (POC)
  • Oracle 12c, Netezza Appliance
  • Restore database backup using RMAN, Oracle 12c, 19c database instances, Backup and restore using export and import utilities.
  • Oracle 19c support backup and restore, Oracle Data guard Configuration and administration.
  • Oracle 12c refresh lower env schema for application team using expdb and impdb utility
  • Performed RMAN-based Point-in-Time Recovery (PITR) simulation in a non-production environment, replicating a real-world scenario of rolling back a database to a previous stable state following a bad code deployment application team.
  • Netezza appliance administrator (IBM Netezza 1000-12), failure in disk alerts, coordination with IBM team for disk issues. Creating users and granting object, list privileges on database. Checking for version table and automated to run groom on version tables.

Senior Consultant (Database Administrator) at Cap Gemini America Inc. (MetLife) (2013-03 – 2017-11)

A global leader in consulting, technology services and digital transformation.

  • Provide 24*7 on call support for DB2 LUW databases supporting online applications
  • DB2 LUW Database Migration, Backup recovery, performance monitoring, Database tuning, maintenance of logs, disaster recovery planning.
  • Upgrading and down grading instance at fix pack levels. Rollbacked fixpack changes etc.
  • Participating in DR tests both HADR and SAN level replication DR sites.
  • Handling Capacity storage related issues, Analyzing CPU and Memory utilization using perceiver tool and IBM Data Server Manager
  • Involved in query optimization using db2 advise and explain plan. Analyzing resource consuming SQL query using SYSIBMADM views and db2pd, db2top. Tuning SQL code by changing the predicate conditions, Analyzing the execution plan cost and updating application to change the SQL query.
  • Installation and Migration from V 9.1 to V10.5 fp 8, Setting up HADR and migrating DR servers.
  • Using db2 utilities like export, import, load, db2move for data migration and refresh, Redirect restore in lower environment and reclaiming space.
  • Offline Reorg, Online Reorg, Runstats with disDBtribution and Runstats on table.
  • Shell scripting to automate day to day work w.r.t example. Reduction of DMS tablespace files system utilization. Script checks for tablespaces which free space and release back to OS if it reaches limit. Find the unused indexes using db2pd select query. Script to run online reorg using REORG_TB_STATS and SESSION.TB_STATS
  • Performing rolling upgrades in Db2 HADR environment (Fix Pack level upgrade).
  • Installed, Configured and Implemented Q Replication V 9.7 (unidirectional and bidirectional) using replication center between Aix and Linux POC.
  • Installation and Configuration of backup recovery tool EMC Networker 9.6.10, for UDB database server for HADR, Cross node etc., load copy yes, HACMP Strategy.
  • SQL replication, Performance Monitoring and fine Tuning OLTP Applications and problem determinate and troubleshooting, Tivoli System Automation for Multiplatform (TSAMP) using DB2 High Availability Disaster Recovery (HADR) with Auxiliary Standby.
  • Red hat HA cluster. Implementation and Configuration of Red hat HA cluster. Db2 stop and start scripts, with other tools like BMC patrol, guardium, EMC networker etc.
  • HACMP strategy, DB2 SQL replication, Performance monitoring and fine tuning OLTP Appl.

Education

M C A (Master of Computer Applications) – Madras University, INDIA

Skills

Sr Database Administrator

Reviews

Related