Experience

• 

  Stlsd

  Aug 2001 - Nov 2003

  Senior programmer
• 

  Ibfi

  Nov 2003 - Jul 2004

  Team lead
• 

  Deutsche bank

  Jul 2004 - Aug 2007

  Technical lead/senior database developer

  • Lead 3rd Line Support team which was responsible to look after production issues deliver proper solution in time.• Re-designed existing application for better performance and closely worked with development and DBA team to tune SQL queries, stored procedures, DTS packages and Adjustment process.• Created missing indexes and removed unused and redundant indexes• Written complex stored procedures, views, DTS packages and SSRS reports• Implemented SQL Server features like table partition, index views, filtered indexes, covering indexes for better performance• Migrated Data load process from MS Access to SQL Server 2000 using DTS(ETL) Packages and Job• Developed front end application using VB which allows business users to do day to day activities and Web Reporting using Active Server Pages.• Developed various RAD tools for trading desk by gathering Business Requirement from various regions (Singapore, Hong Kong, Tokyo, Sydney) using MS Access, Visual Basic 6.0, Excel-VBA and SQL Server 2000/2005. Show less

• 

  Barclays investment bank

  Sept 2007 - Apr 2019

  Database specialist/performance tuning expert/application dba

  Roles and Responsibilities:• As an application DBA Responsible for providing SQL server problem resolution and 24X7 production support and server outages.• Built in house SQL server database statistics collection and reporting tool in order to proactively analyze and fix the blocking/locking issues, long running queries, performance issues, Db size growth, etc.• Responsible for evaluating new features and successfully implemented SQL Server features like data compression (page and row), table partition, filtered and covering indexes, MAXDOP at server and query level, etc.• Responsible for database physical and logical design, Disaster recovery process, capacity planning, CAPEX, Infrastructure management.• Responsible for regular monitor of servers, which includes backup job monitoring, Disk space monitoring, Services monitoring, CPU activity, Index fragmentation, Microsoft Windows Clustering and SQL Server Clustering balance, Disk I/O performance, Tempdb, log Usage, memory usage and blocking/locking monitoring and troubleshoot using native available tools. Show less

• 

  Zenoti

  May 2020 - Dec 2023

  Senior manager db team, engineering |scrum master

  Roles and Responsibilities:• Manage and oversee day-to-day activities of Core database team.• Protect development team from outside distractions, impediments, or team conflicts, and maintain focus on product backlog project timeline.• Coordinate all scrum ceremonies including sprint planning, daily stand-ups, sprint retrospectives, sprint demos, story grooming, and release planning.• Identify and resolve database issues related to performance and capacity.• Provide 24X7 production support with respect to DB performance• Troubleshoot complex database issues in accurate and timely manner.• Ensure database management and maintenance tasks are performed effectively.• Provide regular updates to management on database project status.• Develop best practices for performance and operational efficiency.• Responsible for providing technical expertise to development team (150+ members), technical trainings, coding standards, code reviews for complex objects, High Level design approval (Technical) for new projects.• Use inbuild and third party tools(New Relic) to proactively analyse and fix the database performance and capacity issues. Show less

• 

  Softture

  Jan 2024 - now

  Senior manager / database architect

  Roles and Responsibilities:• Developing and implementing an overall organizational data strategy that is in line with business processes. The strategy includes data model designs, database development standards, implementation and management of data warehouses and data analytics systems.• Identifying data sources, both internal and external, and working out a plan for data management that is aligned with organizational data strategy.• Coordinating and collaborating with cross-functional teams, stakeholders, and vendors for the smooth functioning of the enterprise data system. • Managing end-to-end data architecture, from selecting the platform, designing the technical architecture, and developing the application to finally testing and implementing the proposed solution.• Responsible for providing technical expertise to development team (150+ members), technical trainings, coding standards, code reviews for complex objects, High Level design approval (Technical) for new projects.• Use inbuild and third party tools(New Relic) to proactively analyse and fix the database performance and capacity issues. Show less