Rajesh Balan Email & Phone Number

Bengaluru, Karnataka, India

Bengaluru Area, India

Ensure all daily ETL jobs run without any fail.Ensure Data Quality and Integrity of DWH.Trouble shoot the jobs where there are running slow and optimize them.Creating/designing new reports as per requirement.Create database and establish users with appropriate permissions Data replication to DR server via nzbackup-nzrestore implemented TwinfinWork with Data Modellers to understand how the objects will be created within the databaseInvolved in D/W Database Designing and subsequent creation of Integration Layer, Service Layer and data marts.Create database tables objects within the database based on capacity considerations put forth by the business analystsReview table design and ensure that appropriate distributions are set.Setup and schedule Backup routines, Crontab jobsCreate Netezza best practices and educate developers on NetezzaPerformance monitoring and optimization solutionWorked with Netezza TAM on overall health of system and performance improvementSetup GRA groups, Row security & Work load Management.Server Migration from Twinfin12 to Twinfin48 to MAKO applianceCo-ordination with system owners/ custodians/users of multiple upstream / downstream applications spread across multiple affiliate countries and their support groups to ensure smooth integration and minimum business impact from changes to existing systemCo-ordination with Onshore team and assigned work to them to leverage onsite – offshore modelHelp in designing and mapping new oracle tables with retiring DB2 tablesDeveloped common queries used in different programsInvolved in Database Designing activities for different interfacesWriting PL/SQL code for procedure, functions, triggers, Packages etc for database level. Query Optimization using Netezza Performance Portal, nzadmin tool, nzsqa, nz_responderExtensive usage of nzload, nz_migrate, nzsql, nzsession, nzbackup, nzrestoreSolving trouble tickets & Execution of change Requests

Bengaluru Area, India

Bengaluru Area, India

Bengaluru Area, India

ErWin Modeler, Data Modeler.DB2 Warehouse Tech, Shell Scripting,Informatica, Netezza Appliance, Autosys Job Scheduler.Ensuring successfull movement of various releases from Devlopment to Production.Ensure Data Quality and Integrity of DWH.Trouble shoot the jobs where there are running slow and optimize them.Creating/designing new reports as per requirement.Create database and establish users with appropriate permissions Data replication to DR server via PTS & CDC implemented TwinfinWork with Data Modellers to understand how the objects will be created within the databaseInvolved in D/W Database Designing and subsequent creation of Integration Layer, Service Layer and data marts.Create database tables objects within the database based on capacity considerations put forth by the business analystsReview table design and ensure that appropriate distributions are set.Setup and schedule Backup routines, Crontab jobsCreate Netezza best practices and educate developers on NetezzaPerformance monitoring and optimization solutionWorked with Netezza TAM on overall health of system and performance improvementSetup GRA groups, Row security & Work load Management.Server Migration from DB2 to Netezza & Twinfin12 to Twinfin48Co-ordination with system owners/ custodians/users of multiple upstream / downstream applications spread across multiple affiliate countries and their support groups to ensure smooth integration and minimum business impact from changes to existing systemCo-ordination with Onshore team and assigned work to them to leverage onsite – offshore modelHelp in designing and mapping new oracle tables with retiring DB2 tablesInvolved in Database Designing activities for different interfacesWriting PL/SQL code for procedure, functions, triggers, Packages etc for database level. Query Optimization using Netezza Performance Portal, nzadmin tool, nzsqa, nz_responderExtensive usage of nzload, nz_migrate, nzsql, nzsession, nzbackup, nzrestore

Noida Area, India

Was hired for L2 production support.

Mumbai Area, India

IBM Certified L2 Database Administrator for IBM DB2. Having thorough knowledge of configurations, installing, maintaining various flavours of DB2 on Linux,Unix & Windows. Have a full hands on experience with IBM AIX+DB2. AIX level 1 administration, Shell Scripting, Ticketing system. Onboarding client for remote support.Production support for more than 20 clients & hadling over 100 production instances & over 200 devleopment/integration/test instances. Ensuring audit complaince, implimenting database security & performance tuning.Implemented Data compression, Backup compression.Migration of databases, underwriting backup-restore policies.DR drills, maintenace of DR.I have worked with NSDL for TCS for 2 yrs.User Management Database hardening and SecurityBackup/Restore managementPerforming redirect restores.Installation / Upgrade/Migration to higher patches of Databases. Recovery System CrashesHADR setup & maintenance.HPU for recovering data.Data loads in bulk using cursors.Range partitioning of tables.Attaching / detaching the partitions online.Row level compression for space reclaims & better performance.Database performance and trouble shooting Preparing RCA & devising preventive measures.Causal Analysis of performance issuesClient Software installation and up gradation. BCP and DR strategiesUnix shell scriptingTable, index & SP management.Providing the L2 support for Database Tower.Import/Export tables/databases.Data guard Configuration.Problem solving in coordination with application team.Performing load testing and DR testing on a scheduled basis.Administrative Support for Oracle/MySQL also.

Mca, Computers

Bachelor Of Science (Bsc), Computers And Instrumentation

Schooling, Basic