Sunitha Roslin P

• Run the production environment by monitoring availability and taking a holistic view of system health
• Build software and systems to manage platform infrastructure and applications
• Improve reliability, quality, and time-to-market of our suite of software solutions
• Measure and optimize system performance, with an eye toward pushing our capabilities forward, getting ahead of customer needs, and innovating for continual improvement
• Provide primary operational support and engineering for multiple large-scale distributed software applications
• Gather and analyze metrics from operating systems as well as applications to assist in performance tuning and fault finding
• Partner with development teams to improve services through rigorous testing and release procedures
• Participate in system design consulting, platform management, and capacity planning
• Developed custom scripts/tools as needed to automate routine tasks, increasing overall team productivity and efficiency.
• Evaluated new technologies and tools to enhance overall system performance, stability, and security.
• Create sustainable systems and services through automation and uplifts
• Balance feature development speed and reliability with well-defined service-level objectives

Data Center Exit Project Manager

• Oversaw the seamless migration of on-premises infrastructure to cloud environments, ensuring minimal disruption and optimal performance.
• Led a team of 5 professionals in executing the migration plan, managing tasks, and resolving issues to meet project timelines.
• Conducted thorough application readiness assessments, identifying dependencies and ensuring compatibility with the target environment.
• Collaborated with stakeholders to define project goals, milestones, and success criteria.
• Provided strategic guidance on cloud adoption, optimizing infrastructure costs, and enhancing overall system efficiency.

DB2 Database Administrator

• Managed and maintained DB2 databases, ensuring optimal performance, security, and availability.
• Implemented database upgrades and patches, keeping systems up-to-date with the latest technologies and security standards.
• Collaborated with development teams to optimize database queries and improve overall application performance.
• Conducted regular backup and recovery drills, ensuring data integrity and disaster recovery readiness.

Data refresh from one environment to another.

Restoration of databases from online and offline backups.

Redirected restore of databases from online and offline backups. Fixing Corruption (Package descriptor / index / table)

Performing health checks on databases.

▪ Creation of new tablespaces, buffer pools, and other database objects. ▪ Monitoring and investigating the error logs.

▪ Experience in Installation and Configuration of database, Catalog Node and Database.

▪ Creating/Dropping/Altering all the DB2 objects

▪ Granting various authorizations to different users in the company. Monitoring the database using event monitors, especially to capture dynamic SQL.

▪ Improving database concurrency using database lock monitoring methods.

Creation of users and granting privileges.

Restricting database access for users.

Having knowledge in implementing Cron jobs in AIX and Linux, and parallel knowledge in scheduling jobs.

▪ Troubleshooting Tools – db2diag, db2dart, db2support, db2pd, db2cat.

DB2 Performance Utilities - REORGCHK, REORG, RUNSTATS.

▪ Backup – Hot/Cold database, table space, full/incremental backups.

▪ Recovery – Full database recovery and roll-forward recovery to the end of logs for no transaction loss, or to a specific point-in-time recovery.

Installation and configuration of the TSM client on the database server.

▪ Setting up HADR and DB2HAICU

Database Transition Specialist

• Spearheaded and executed database transition projects, ensuring minimal downtime and data integrity.
• As the primary DB2 DBA, played a pivotal role in planning and executing the migration strategy.
• Led and mentored cross-functional teams, ensuring a cohesive approach to database transitions.
• Collaborated with stakeholders to understand business requirements and align database strategies accordingly.
• Implemented robust monitoring and performance tuning measures to optimize database functionality.

Senior DB2 Database Administrator

• Managed the end-to-end lifecycle of DB2 databases, including installation, configuration, and optimization.
• Orchestrated successful database transitions from on-premises to cloud environments, ensuring seamless integration.
• Implemented disaster recovery plans and conducted regular audits to maintain data security and compliance.
• Collaborated with development teams to troubleshoot database-related issues and optimize query performance.
• Production support experience with DB2 UDB V9.1, 9.5 and 9.7, 10.5 Installations, Configurations and Administration.
• To Support 33 Production Servers and 15 Test Servers.
• Performance tuning of databases.
• HADR & HACMP setup lying between primary and standby servers. 5. Participated in HADR failover drill.
• Restoring the Backup images using Redirect Restore method from source to destination and also restore from tsm
• Applying PATCHES (Fix Packs) on db2 servers. 8. Automating mundane tasks through scripting. 9. Installation and configuration of TSM client and setting up archival to TSM
• DB2 UDB Command Line Utilities like db2icrt, db2ckbk, etc.
• Creating Instances, DB2 databases, bufferpools, tablespaces as per client requirement.
• Running REORG and RUNSTATS for better performance of the database.
• Scheduling compressions on big tables and monitoring the reorgs and runstats.
• Maintaining Database Level (DB CFG) and Database Manager Level (Instance) Parameters.
• Increasing and decreasing tablespace sizes using alter tablespace command. And also added new containers to existing tablespace.
• Involved with the development team, and resolving problems related to the database privileges, etc.
• Troubleshooting for various real time issues.
• Monitoring archive mount points and data mount point

DB2 LUW Database Administrator and Team Lead

• Led a team of four database professionals in the administration and optimization of DB2 LUW databases.
• Implemented best practices for database design, performance tuning, and security to ensure optimal system functionality.
• Collaborated with cross-functional teams to understand business requirements and align database strategies with organizational goals.
• Conducted regular training sessions for team members to enhance technical skills and ensure up-to-date knowledge of DB2 LUW features.

Senior DB2 LUW Database Administrator

• Managed the installation, configuration, and maintenance of DB2 LUW databases, ensuring high availability and reliability.
• Led the implementation of database upgrades, patches, and performance tuning measures to optimize system performance.
• Implemented disaster recovery plans, reducing recovery time by 20% in case of system failures.
• Collaborated with developers to optimize SQL queries and enhance overall application performance.
• Data refresh from one environment to another. ▪ Restoration of databases from online and offline backups. ▪ Redirected Restore of databases from online and offline backups. ▪ Fixing Corruption (Package descriptor / Index /table ) ▪ Performing health checks on databases. ▪ Creation of new Table spaces/ Buffer pools and other database objects ▪ Monitoring and Investigating the error logs ▪ Experience in Installation and Configuration of database, Catalog Node and Database. ▪ Creating/Dropping/Altering all the DB2 objects ▪ Granting various authorizations to different users in the company. ▪ Monitoring database using Event monitors especially to capture dynamic SQL. ▪ Improving database concurrency using database lock monitoring methods. ▪ Creation of users and granting privileges ▪ Restricting the database access for users. ▪ Having knowledge in implementing Cron jobs in AIX and Linux and parallel knowledge in scheduling jobs ▪ Troubleshooting Tools – db2diag, db2dart, db2support, db2pd, db2cat ▪ DB2 Performance Utilities - REORGCHK, REORG, RUNSTATS. ▪ Backup – Hot/Cold database, table space, full/incremental backups ▪ Recovery – Full database recovery and roll forward recovery to end of logs for no transaction loss or to specific point in time recovery. ▪ Installation and configuration TSM client on Database server ▪ Setting up HADR and DB2HAICU ▪ Db2 Upgrade/Patching on Windows and Linux

• Providing 24/7 support.
• Creation of database objects: tables, tablespace, and indexes.
• Import and export to manage data.
• Managing database monitoring, day-to-day activities, and coordinating activities or requests.
• Monitoring Backups.
• Using RUNSTATS, REORG, to enhance application performance.
• Analyzing and fixing the live database server issues.
• To do space calculations and to monitor the file systems' space usage.
• DB Configuration, Database Maintenance.
• Solving Tickets Related to Any DB issue.
• Administer the data server on which DB2 resides: monitor disk space and the DB2 log, backups, protect the integrity of the data.
• Publishing database Growth of the databases every Month.