New Job Sql Server Dba In Tamil Nadu

SQL Server DBA
SQL Server DBA

SQL Server DBA

Company : 2COMS Consulting Private Limited
Salary : Details not provided
Location : Tamil Nadu

Full Description

  • Handled large database estates and managed TB of databases
  • Install, configure and administer the SQL Server 2019, 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
  • Technical and Process guidance to L2 and L1 DBA
  • Provide 24x7 and on call support for critical application databases

6.00-11.00 Years