DBA- SQL Server and PostgreSQL

Profile Summary: -

• Managed and administered 3500+ database in 300+ instances.
• Excellent team managing skills.  Provided periodic updates to higher management on on-going and upcoming projects, presents weekly/monthly reports. Involved in team meetings with Business stake holders.
• Lead DBA team which supports operations 18*7 in APAC, Australia, and New Zealand regions.
• Installed and configured Microsoft Windows Clustering and SQL Server Clustering on Windows 2008/R2/2012/2014/2016/2017/2019 Servers.
• Migrate SQL databases from On-Prem to Azure, configure Geo-Replication for High Availability, Manage database on Elastic pools and managed instance.
• Automate common management tasks using PowerShell. Backup and restore Azure SQL databases.
• Ensure data and applications are highly available and have disaster recovery
• Experience in migrating SQL Server from lower version to higher versions using Side-by-Side and In-Place methods with minimum downtime.
• Performed database logical and physical design, maintenance, tuning, archiving, backups, replication, recovery, software upgrades, capacity planning and optimization for SQL Server database.
• Extensive knowledge of configure and troubleshoot windows and SQL clustering, Log shipping, Replication, Always On and mirroring concepts.
• Experience in creating and deploying SSIS packages and SSAS cubes. Able to create SSRS reports and troubleshoot issues as well.
• Monitor and optimize system performance using SQL Profiler, Database Engine Tuning Advisor, Extended events and TPT-solar wind DPA
• Diagnosed job errors and implemented solutions or worked with developers and/or Server Administration as necessary to solve break/fix and other issues.
• Regular monitor of servers, which includes backup job monitoring, Disk space monitoring, Services monitoring, and block monitoring and troubleshoot using SQL Server Native tools and IBM Tivoli.
• Proactively monitored the database health through automated scripts for checking the database and extents growth, probing the alert log files, monitoring the rollback segments and temporary space usage.
• Improved performance, reliability, security, and scalability by improving internal processes and make recommendations on new storage hardware.
• Intermediate knowledge on Postgres DBA core activities
• Installation and troubleshoot issues with PostgreSQL-11,12,13 versions on Windows and Linux.
• Configured HA for PostgreSQL using third party tools such BFM.
• Well versed with Backup and Restore activities using Pg_dump, pg_dumpall, pg_basebackup and pg_restore utilities.
• Troubleshoot performance related issues in PostgreSQL databases.