Banner Image

Skills

  • Data Management
  • Data Security
  • Design
  • Microsoft
  • PostgreSQL
  • SQL

Services

  • DBA- SQL Server and PostgreSQL

    $20/hr Starting at $2K Ongoing

    Dedicated Resource

    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...

    Data ManagementData SecurityDesignMicrosoftPostgreSQL

About

MS SQL Server and PostgreSQL DBA with more than 10 years of experience.

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 checki

Work Terms

3-4 hours per day excluding weekends