Qualifications:

  • Need to have 8+ years of experience working with Microsoft SQL Server,
  • Hands-on experience on Microsoft SQL Server installation, configuration, debugging, tuning and administration
  • Hands on experience on Always On setup, configuration, and troubleshooting.
  • Strong hands-on experience in implementation of Security and TLS/SSL implementation etc.
  • Understanding of vulnerabilities and remediations
  • Experience with SQL scripting or other automation
  • Experience with Performance monitoring and tuning
  • Working knowledge of Networks, Windows OS.
  • Experience with SQL Server version upgrades and patching
  • Demonstrate ability to find the root cause of a problem in Data Engine, SSRS, SSAS, optimize inefficient execution, and resolve resource contention scenarios

Responsibilities:

  • Manage SQL Server databases
  • Configure and maintain database servers and processes
  • Monitor system's health and performance utilizing ticketing system to ensure issues are addressed in timely manner.
  • Ensure high levels of performance, availability, sustainability, and security
  • Analyze, solve, and correct issues in real time
  • Provide suggestions for solutions
  • Refine and automate regular processes, track issues, and document changes
  • Assist developers with query tuning and schema refinement
  • Provide support for critical production systems
  • Perform scheduled maintenance and support release deployment activities after hours
  • On rotation 24/7 primary dba support every 6-7 week.
  • Administration of Microsoft SQL Server on-prem Always On Clusters
  • Maintain and update the cluster to support day-to-day operations in the enterprise
  • Perform minor and major upgrades, support monthly OS patches
  • Vulnerability management and remediation.
  • Support project teams in troubleshooting job issues and deployment where needed.
  • Activities include DB backups and restores.
  • Research performance issues, configure the cluster with Microsoft best practices, optimizing specifications and parameters to fine-tune and proactively avoid performance issues.