Rajesh Balan

Rajesh Balan Email and Phone Number

Data & BI Industrialization, Cloud Administration @ Cognizant
teaneck, new jersey, united states
Rajesh Balan's Location
Bengaluru, Karnataka, India, India
Rajesh Balan's Contact Details

Rajesh Balan personal email

About Rajesh Balan

Having hands-on & experience on Database Administration, Data Architecture, Data Modelling, Netezza ,Snowflake, DB2 & Informatica, Shell scripting for 10 + years.Understanding of Big Data tools, R Analytics, Hadoop, IBM Big InsightsWorking with Cognizant from June 2016 as EIM lead and database administrator for Data-warehouse TechnologiesWorkied with IntraMart India Bangalore for 2 years as a Netezza DBA for Warehouses with Informatica & MicroStrategy which involves data modelling, architecture as well.Worked with Hitachi Consulting Bangalore for 5 months as Netezza Architect.Worked with Accenture for 2 years and 2 month where I was responsible for the successful execution & completion of Warehouse activities which includes data migration, data staging, loading, masking, tuning & Security.Worked with IBM India for 3 months as DB2 DBA, due to location constraints had to resign.Started career with Tata Consultancy Services Ltd. & worked for 3 years and 3 months. Extensive use of performance tuning using Distribution key, Organizing key, Reading Plan Files ,GRA, Netezza Analytics functions, UDXHave been a problem solver on Linux based requirements, scripting logics, monitoring tools & space allocation.Well versed with ITIL processes & procedures, Team leading skills & Deliver methodologies.Knowledge of Database Administration and Application in DB2 UDB with experience ranging from database creation, monitoring, performance tuning to database Migration (both on OS level and database level).Well versed with Shell Scripting and automation of manual run batch processes.Very high analytical approach, managing & leadership qualities to lead a team.A good team member having skills to understand the requirements from client & act smartly upon them. Achieved client appreciation from time to time.My technological forte is IBM Netezza Pure Data systems, IBM DB2 UDB Database, MSSQL, Informatica and Unix-based Shell scripting, Job Automation. Well versed with Project Management

Rajesh Balan's Current Company Details
Cognizant

Cognizant

View
Data & BI Industrialization, Cloud Administration
teaneck, new jersey, united states
Website:
cognizant.com
Employees:
278214
Rajesh Balan Work Experience Details
  • Cognizant
    Senior Manager
    Cognizant Mar 2022 - Present
    View
  • Cognizant
    Project Manager
    Cognizant Jun 2016 - Present
    Bengaluru, Karnataka, India
    View
  • Petsmart
    Netezza Dba
    Petsmart May 2014 - May 2016
    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
    View
  • Intramart
    Dba Lead & Data Analyst
    Intramart May 2014 - May 2016
    Bengaluru Area, India
    View
  • Hitachi Consulting
    Senior Consultant
    Hitachi Consulting Jan 2014 - Apr 2014
    Bengaluru Area, India
    View
  • Accenture
    Ibm Db2 Dba
    Accenture Nov 2011 - Dec 2013
    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
    View
  • Ibm
    Db2 Dba
    Ibm Aug 2011 - Oct 2011
    Noida Area, India
    Was hired for L2 production support.
    View
  • Tata Consultancy Services
    Team Lead
    Tata Consultancy Services Apr 2008 - Jul 2011
    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.
    View

Rajesh Balan Skills

Db2 Unix Linux Windows Unix Shell Scripting Sql Tuning Aix Pl/sql Oracle Data Warehousing Netezza Autosys Informatica Cloud Computing Performance Tuning Data Recovery Hadr Hacmp Backup And Restore Load Balancing Data Loading Data Masking Data Migration Database Administration Database Design Database Security Microsoft Sql Server Ssis High Availability Sql Business Intelligence Solaris Shell Scripting Ibm Aix Itil Sdlc Data Modeling Etl Requirements Analysis Microstrategy Tidal Enterprise Scheduler Disaster Recovery Vendor Management Devops

Rajesh Balan Education Details

Frequently Asked Questions about Rajesh Balan

What company does Rajesh Balan work for?

Rajesh Balan works for Cognizant

What is Rajesh Balan's role at the current company?

Rajesh Balan's current role is Data & BI Industrialization, Cloud Administration.

What is Rajesh Balan's email address?

Rajesh Balan's email address is ra****@****ail.com

What schools did Rajesh Balan attend?

Rajesh Balan attended Galgotia S College Of Engineering And Technology, Greater Noida, Dr. B. R. Ambedkar University, Agra, Kendriya Vidyalaya.

What skills is Rajesh Balan known for?

Rajesh Balan has skills like Db2, Unix, Linux, Windows, Unix Shell Scripting, Sql Tuning, Aix, Pl/sql, Oracle, Data Warehousing, Netezza, Autosys.

Who are Rajesh Balan's colleagues?

Rajesh Balan's colleagues are Shashank Pandya, Mohit Kwatra, Stefano Palazzini, Aishwarya Sampath, Ashima Taneja, Subramanyam Battala, Rohith Gunda.

Not the Rajesh Balan you were looking for?

View similar profiles

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.