Balachander Vijayarangan

• Achieved efficient database management by creating and maintaining DB2 objects, including tables, tablespaces, indexes, triggers, functions, packages, and plan binds, resulting in improved data accessibility and performance.
• Manage Re-orgs, deadlocks, long running Db2 threads, maintain RI and replication standards.
• Managed scheduling and execution of utility batch jobs to enhance efficiency in image copy unload/load re-organization.
• Provided application testing support and managed database operations to enhance software development processes.
• Executed mainframe to AWS migration of DB2 databases, ensuring seamless transition and data integrity.
• Executed data integration initiatives across systems to meet defined project release standards.

• Manage Re-orgs, deadlocks, long running Db2 threads, maintain RI and replication standards.
• Schedule batch process for backups and statistics.
• Create and schedule utility batch jobs for image copy, unload/load, re-org.
• Created and monitored performance metrics to keep databases functioning at optimal capacity.
• Generated health check reports to share with Level-3 DBA's.
• 24/7 production support for handling DB2 issues.

As a Technical Lead of ECS Infrastructure team, following are the job responsibilities:

• Designed and implemented multiple test environments to ensure optimal performance and adherence to project timelines.
• Configured and launched application code in designated test environments for quality assurance.
• Engaged with internal and external stakeholders after task completion to drive tickets forward for effective resolution.
• Developed and updated problem records and knowledge articles, ensuring comprehensive application documentation during the software development lifecycle.
• Engaged with cross-functional technical teams to drive alignment of solutions with established strategies and standards.

As a Technical Analyst in P&C mainframe support team, following are the job responsibilities:

• Executed technical shakedowns to assess performance and implementation environments.
• Triage testing defects on the mainframe applications.
• Provided comprehensive mainframe application support to enhance service delivery within auto and fire departments.
• Compiled detailed knowledge items on testing defects to facilitate effective communication and knowledge sharing among team members.

As a Technical Analyst in P&C mainframe support team, following are the job responsibilities:

• Build and deploy application test codes across various environments like development, system , performance and implementation.
• Triage build/deployment issues in test systems.
• Product model deployments in test systems.
• Create and update knowledge items on deployment process and procedures.