MS SQL Database Admin

SQL
• Handled large database estates and managed TB of databases
• Install, configure and administer the SQL Server 2026, 2017, 2016, 2014, 2012, 2008 R2, 2008 and 2005 on Windows and Linux Servers
• Install and configure database monitoring tools
• Database refresh (Prod to Dev, QA)
• Database auditing and compliance
• Plan the instance upgrade, migration and patching
• Define backup and restore strategy
• Proactively analysis the performance and tuning recommendation
• Implement and troubleshoot DTS packages
• Experience in application DBA support and deployment activities
• Design, setup and configure load balancing on clusters
• SQL EM Metric design and configuration
• Develop database re-usable components
• Database disaster recovery (DR) strategy like mirroring / log shipping / replication configuration
• Develop data purging, archival management methods and best practices
• OS level activities related to database tasks and windows administration
• Coordinate and work with vendors for bug fixes and major incident resolution
• Primarily role is supporting the production and non-prod database environments
• Ensure the reduction of repeated errors through implementation of necessary checkpoints
• Contribute towards evaluation of tools, products and software selection
• SLA tracking and reporting to Higher management
• Prepare and Maintain Standard Operating Procedure for all activities
• Proactive identification of risks and mitigation of the same
• Technical presentation on emerging technologies.
• Foresee the need for newer technology based trainings on customer needs and provide suggestions for such trainings to Project Manager.
• Implement and Periodical check on Automation
• Implement and Periodical check on DB Security
• Identify, document and track Technology related risks and mitigation plan in the project