Experience

• 

  Fujitsu americas

  Apr 2013 - Apr 2018

  Sql server database administrator

  • Handled over 600 servers and 5000+ databases for Honeywell with a team of 11 DBAs.• Installed, Configured and maintained SQL Server 2005, 2008/R2, 2012, 2014, 2016 in standalone and clustered environment.• Created database backup and Restore strategy for production, development and test environments.• Ensured all databases are backed up in a way that meets the business’s Recovery Point Objectives (RPO)• Verified backups to ensure business’ Recovery Time Objectives (RTO) can be met.• Involved in day to day monitoring of SQL Server jobs failures, error logs, space usage, and security.• Coordinated and schedule DB downtime to perform DB maintenance procedures. I.e. DB patching, upgrades, etc.• Handled and resolve SQL Server Performance related issues including High CPU, Memory, and low disk space.• Conducted database Refresh from Prod to UAT, QA and Test environments for testing of new builds and deployments.• Participated in On-Call, Overnight off-hour, and weekend patching activities.• Coordinated and/or participated in database stress tests, analyzing results, and working with different teams (SA, Wintel, Storage, Network, Dev, and AD) to resolve issues.• Setup and configured Database Mirroring in High-Performance, High-Safety mode as DR strategy.• Installed, configured and maintained Log Shipping to create Standby Server.• Created Maintenance plan for database consistency and optimization which included Database Integrity Check, Reorganize Indexes & History cleanup.• Owned, tracked and resolved database related Incidents and requests, fulfilling and resolving incidents within SLAs.• Service pack & hot fix installation, configuration, tuning & make the systems available ASAP and provide 24 X 7 dedicated support to all Production servers• Installed and configured, SSAS, SSIS, SSRS services, Database Mail, & Operators.• Scheduled Jobs and Alerts using SQL Server Agen Show less

• 

  Wipro limited

  Apr 2018 - Apr 2019

  Senior sql server database administrator

  • Provide Database Administration Support for Citigroup with over 6500+ servers for multiple applications and businesses, including ICG, GCG and CTO. • Implementation, configuration, maintenance, and performance of critical SQL Server RDBMS systems, to ensure the availability and consistent performance of corporate applications.• Support for SQL Server 2008R2/2012/2014/2016 databases on Cloud, Standalone and Clustered environments with database sizes ranging from 10 MB to over 7 TB.• Capacity planning and monitoring database growth. Providing trend analysis to management team to enable them to make informed decisions regarding resource management.• Troubleshoot and resolve database integrity issues, Performance issues, Blocking, Deadlocks, and Long Running Queries.• Configure, manage and perform backups, restores, DB recovery, database shrink operations, and DBCC commands.• Ensure all database servers are backed up in a way that meets the business’s Recovery Point Objectives (RPO).• Maintain and resolve issues related to High Availability solutions like Database Mirroring, Log Shipping, & Clustering.• Proactively work on alerts generated via BMC Patrol and System Center Operations Manager (SCOM).• Troubleshoot various problems that arise in day-to-day work. Independently analyze, solve and correct issues in real time and providing problem resolution end-to-end.• Monitor Disk space usage, Memory utilization, High CPU usage, resource utilization by session, buffer pool hit-ratios.• Resolve Maintenance Plan related issues like Rebuilding Indexes, Update Stats to improve performance.• Fine tuning of jobs, performance management, overnight support, weekend deployments, patching, software upgrades, builds, designs and configurations.• Provide systems metrics, root cause analysis and proactive monitoring and communicate any performance degradation to management.• Effectively communicate current status of all projects, problems, and issues to service manager. Show less

• 

  Federation of state medical boards

  Apr 2019 - now

  Database administrator