Senior Database Administrator – MS SQL | MySQL | AWS
Talented database administrator with 8+ years of diverse experience in database design and administration. Extensive technical skills and advanced understanding of SQL server, MySQL and Windows server administration. Strong collaborator and team player with excellent communication skills and expertise in analytical problems

TECHNICAL SKILLS
DATABASE    MS SQL Server 2005, 2008/R2, 2012,
2014, 2016, MySQL
OPERATING SYSTEM
Windows Server 2003,2008, 2012, RHEL7

TOOLS    Veritas NetBackup, Arcserve, HP Data Protector, Nagios Monitoring, BMC Remedy, SSIS, SSRS
ANCILLARY TOOLS
AWS Solution Architect associate, Ansible, Mongo DB, PostgreSQL & Elasticsearch

WORK EXPERIENCE
Senior Database Administrator
NCS PTE LTD, Singapore
02/2018 – Present Achievements/Tasks
Manage MS SQL server (Cluster, Always On, Replication, log shipping) My SQL (Multi Master Replication) and PostgreSQL database administration.
Enhance database performance, perform restores, implement recovery procedures, handle performance tuning and conduct regular system backups.
Design and plan zero downtime upgrade of databases.
Monitor data growth, row migration and correct the problem. Implement Capacity Planning and size the space accordingly.
Develop and test storage strategies and disaster-recovery plan for company's operational databases & applications, deliver solution that guarantee recovery performance and high availability.
System administrator in Windows servers (2008 R2, 2012 and 2016) & beginner level administration in RHEL and Operational support for DC (Domain controller) and AD (Active Directory). Participate in Disaster recovery.
Involve in IT auditing & handle incident management. Coordinate with vendors to implement the new projects, prepare invoices for new projects.
Scheduling, Monitoring SSIS jobs and find the error for the failed jobs and send to ETL team. Help ETL team to create SSIS packages & Deploy them using SSMS.
Help development team to Publish SSRS reports to SharePoint.

DATABASE ADMINISTRATOR
HCL Insys Pte Ltd, Singapore
07/2014 – 02/2018
Achievements/Tasks
Provide 24/7 On-Call support for critical production databases. Install and configure MS SQL Server 2005 to 2016 versions.
Expert in Database Backup, Recovery and Disaster Recovery procedures.
Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC Utilities.
Hands on experience in the Migration of SQL Server 2005 databases to SQL Server 2008 and Migration of SQL Server 2008 databases to SQL Server 2012.
Experience in Log shipping, Mirroring, Replication & Always On. Use Performance Monitor/Profiler and other Monitoring tools.
Administer, maintain and implement Standard Operating Procedures & build documents to ensure the security and integrity of the company database SQL server authentication, server roles, database roles and permissions.

SQL DATABASE ADMINISTRATOR
WIPRO Technologies, Bengaluru, India
02/2011 – 01/2014
Achievements/Tasks
Installation of SQL Server 2000,2005, 2008 & 2012. Troubleshoot issues as and when occurs, monitor Error Logs. Monitor overall health checks of SQL Server.
Backup and Restoration.
Housekeeping activities to maintain the space in the drives. Apply latest service packs and security patches.
Capacity planning based on monthly growth of databases. Manage fail over Clustering, Log shipping and mirroring. Maintain all the SQL documents like build docs, CMDB & SOP.
Experience in Database backup and disaster recovery procedures.

AWARDS & TRAINING
Best Employee (01/2017 – 12/2017)
HCL Insys Pvt Ltd

Attended MySQL & MongoDB basic training (01/2019 – 07/2019)
NCS pte ltd

Regular Singapore SQL Pass session attendee.
HCL Insys Pvt Ltd & NCS pte ltd
Attended Microsoft training
Wipro Technologies

CERTIFICATIONS
Microsoft certified in Administering Microsoft SQL Server 2012/2014 databases EXAM 70-462

Microsoft Certified in MCTS SQL Server 2008, Implementation and Maintenance EXAM 70-432