Prajakta Nar

• Delivered comprehensive support for Sybase and MSSQL database servers, ensuring optimal performance for HSBC's tier-1 application.
• Collaborated with application teams to provide specialized support in database engineering, ensuring efficient project delivery and system reliability.
• Achieved timely resolution of production incidents affecting performance, connectivity, security, and database integrity through effective diagnosis. Conducted thorough root cause analysis of critical incidents and implemented proactive solutions to enhance system reliability.
• Oversaw implementation of version control systems, such as Git and SVN, ensuring efficient collaboration and workflow among developers and engineers during project phases.
• Enhanced deployment workflows by streamlining CI/CD pipelines for multiple operational environments.
• Automated monitoring and alerting systems, reducing incident response times significantly.
• Led cross-functional teams in adopting DevOps best practices, fostering a culture of collaboration and continuous improvement.
• Mentored junior engineers on automation tools and cloud technologies, enhancing team skill sets and productivity.
• Provided 24/7 on-call support for critical systems, ensuring high availability and rapid issue resolution.
• Facilitated team training sessions on latest DevOps practices, elevating team skill levels and productivity.
• Engineered and executed containerization strategies utilizing Docker to enhance resource utilization and management.
• Developed innovative internal tools to streamline database processes, focusing on patching, builds, releases, and role-swaps.
• Achieved streamlined database operational activities through effective automation of infrastructure using infrastructure as code (IaC) and implementation of continuous integration (CI) and continuous delivery processes. Enhanced overall efficiency across the environment by building robust automation capabilities.

• Oversaw the management, upkeep, and enhancement of high-volume Tier 1 database servers, focusing on Sybase and MSSQL platforms.
• Managed comprehensive automation of database activities, ensuring effective backup and recovery processes while monitoring system performance.
• Analyzed and rectified performance, connectivity, security, and database corruption problems to maintain stability in critical production environments.
• Analyzed operational workflows to pinpoint performance bottlenecks and scaling obstacles for enhanced efficiency.
• Evaluated and integrated new monitoring tools to optimize development operations and automate routine tasks.

Delivered L2/L3 database support for Sybase and SQL production servers.

• Oversaw database maintenance activities, including setups, upgrades, patching, and recovery management.
• Achieved robust high availability and disaster recovery solutions on Sybase and SQL servers through effective management of Sybase replication, Always-On mirroring, and log shipping strategies.
• Monitored database events and alerts to support system performance. Assisted in managing space allocation for optimal resource utilization. Aided in user management to enhance access control and security.
• Analyzed production challenges to determine root causes, ensuring efficient problem resolution and operational continuity.
• Coordinated case escalations with vendor to enhance service delivery and support operations.
• Architected and implemented scalable database solutions to support high-availability requirements for critical systems.
• Executed proactive performance tuning and monitoring of databases to ensure optimal operational efficiency.
• Developed and executed efficient patching strategies, significantly decreasing downtime during scheduled maintenance.
• Coordinated efforts with cross-functional teams to establish comprehensive database requirements and implement effective solutions.

• Facilitated round-the-clock operational assistance to ensure seamless functionality in SCB production, disaster recovery development, and UAT infrastructure.
• Achieved improved system performance through diligent monitoring of long-running transactions. Enhanced resource utilization by managing CPU and memory effectively. Streamlined database and tempdb space management for increased operational efficiency.
• Achieved improved database performance through diligent maintenance activities, including updating statistics and executing DBCC checks. Enhanced data organization by managing catalog index recreation and reorganization processes.
• Managed systematic database compaction to ensure operational efficiency during scheduled maintenance windows.
• Monitored and optimized production systems to prevent downtime and enhance productivity.