2coms consulting

SQL Server DBA

  • Job Type: Full Time
  • Industry Type: IT Sector
  • Industry Location: Chennai, Bangalore North
  • Experience: 6-11yrs
  • No. of Positions: 10
  • Salary Range: 7-13.2 lac
  • Primary Skills: SQL DB Admin SQL Server Database Admin SQL DBA SQL Server DBA
  • Secondary Skills: SQL Server DB Admin
  • Job Location: Chennai, Bangalore North
  • Posted Date: 385 days ago
Job Description
  • Handled large database estates and managed TB size 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
 

 

Relevant Job Openings
Front End Developer
Python Developer
Python Developer
Network Administrator or System Administrator
Exclusive Hiring For MS Dynamics Sr CRM Developer
Immediate Hiring For PHP Developer Ahmedabad .