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
• Provide primary operational support and engineering for multiple large-scale distributed software applications
• Partner with development teams to improve services through rigorous testing and release procedures
• Measure and optimize system performance, with an eye toward pushing our capabilities forward, getting ahead of customer needs, and innovating for continual improvement
• Enhanced reliability, quality, and time-to-market of software solutions through targeted initiatives
• Gathered and analyzed metrics from operating systems and applications to optimize performance tuning and identify faults
• Participate in system design consulting, platform management, and capacity planning
• Developed sustainable systems and services by automating processes and implementing improvements
• Developed custom scripts/tools to automate routine tasks, increasing overall team productivity and efficiency.
• Evaluated new technologies and tools to enhance overall system performance, stability, and security.
• Balance feature development speed and reliability with well-defined service-level objectives

Data Center Exit Project Manager

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

DB2 Database Administrator

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

Restoration of databases from online and offline backups.

Redirected database restores from online and offline backups to fix corruption issues in package descriptors, indexes, and tables.

Performing health checks on databases.

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

Created new tablespaces, buffer pools, and other database objects while monitoring and investigating error logs for proactive issue resolution.

▪ 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.

Implemented user access restrictions, significantly enhancing database security.

▪ 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

DB2 LUW Database Administrator and Team Lead

• Led a team of four database professionals in the administration and optimization of DB2 LUW databases.
• 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, achieving a 20% reduction in recovery time during system failures.

Collaborated with developers to optimize SQL queries and enhance overall application performance.

• Implemented best practices for database design, performance tuning, and security to ensure optimal system functionality.
• Collaborated with cross-functional teams to align database strategies with business requirements and organizational goals.
• Conducted training sessions to enhance team technical skills and maintain up-to-date knowledge of DB2 LUW features.
• Senior DB2 LUW Database Administrator
• Executed data refresh between environments to maintain data consistency. ▪ Restoration of databases from online and offline backups. ▪ Executed redirected database restores from online and offline backups to ensure data availability. ▪ 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 ▪ Granted user authorizations to ensure secure access to database resources. ▪ 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 of TSM client on Database server ▪ Setting up HADR and DB2HAICU ▪ Db2 Upgrade/Patching on Windows and Linux

Database Transition Specialist

• Spearheaded and executed database transition projects, ensuring minimal downtime and data integrity.
• Executed database transitions from on-premises to cloud environments, ensuring seamless integration.
• 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.

Optimized database functionality through robust monitoring and performance tuning measures.

• Senior DB2 Database Administrator
• Managed the end-to-end lifecycle of DB2 databases, including installation, configuration, and optimization.
• 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.
• Supported 33 production servers and 15 test servers to maintain performance.
• Enhanced database efficiency and response times through targeted performance tuning.
• Configured HADR and HACMP setups between primary and standby servers for high availability. 5. Participated in HADR failover drill.
• Restored the Backup images using Redirect Restore method from source to destination and also restored 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, buffer pools, tablespaces as per client requirement.
• Scheduling compressions on big tables and monitoring the reorgs and runstats.
• Maintaining Database Level (DB CFG) and Database Manager Level (Instance) Parameters.
• Involved with the development team and resolving problems related to the database privileges, etc.
• Troubleshot various real-time issues to resolve database performance bottlenecks.
• Monitoring archive mount points and data mount point

• Using RUNSTATS, REORG, to enhance application performance.
• Analyzing and fixing the live database server issues.
• Managed database monitoring and daily activities, coordinating requests to ensure seamless operations.
• Configured and maintained databases to enhance performance and reliability.
• Resolved database-related support tickets, facilitating continuous operational support.
• Monitored system backups to ensure data security.
• Administer the data server on which DB2 resides: monitor disk space and the DB2 log, backups, protect the integrity of the data.
• Creation of database objects: tables, tablespaces, and indexes.
• Import and export to manage data.