SQL Server Database Administration

  • San Jose, CA
  • Posted 3 days ago | Updated 1 day ago

Overview

Hybrid
$75 - $80
Contract - Independent
Contract - W2
Contract - 12 Month(s)
Able to Provide Sponsorship

Skills

SQL Server
Azure
Asset Management
High Availability
Availability Groups
Disaster Recovery

Job Details

Position: SQL Server Database Administration

Location: San Jose/San Francisco

Roles and Responsibilities

  • Expert in SQL Server Database Administration, including SQL Server on VMWare (on premise), Azure SQL Database and Azure SQL Managed Instance, SQL Server Reporting Server (SSRS).
  • Install, configure, and maintain MSSQL databases on production, development, and UAT environments.
  • Monitor database performance to ensure high levels of performance, availability, and security.
  • Optimize and fine-tune databases for better query performance and scalability.
  • Implement and manage backup and recovery procedures, ensuring that databases are protected against data loss and can be quickly restored.
  • Responsible for evaluating patch releases and patching requests from development, and communicating constraints, issues, and timelines for deployment.
  • Database and T-SQL optimization including performance tuning, query optimization, and supportability.
  • DevOps - be able to set up and integrate related DevOps process, managing CI/CD pipelines for Azure devops or Flyway tools.
  • Change management including maintenance of multiple development, UAT, and production environments. Responsible for deploying approved changes to production.
  • Create and maintain appropriate documentation about the database.
  • Regular proactive capacity planning and tending reviews of all SQL Server databases. Producing weekly, and monthly management reports.
  • Manage SQL server and Windows security audits and take corrective action to stay compliant.
  • Provide support after hours through the on-call rotation and weekend support coverage.
  • Perform scheduled maintenance and support release deployment activities after hours.

Experience and Qualifications

  • 10+ years of strong SQL Server Database administration experience preferably in the asset management Industry.
  • Knowledge of Azure cloud and 3+ years of experience in Azure SQL Server Managed Instances or Azure SQL Server.
  • 5+ years of experience with backups, restores and recovery models.
  • 5+ years of experience of High Availability (HA), Availability Groups (AG) and Disaster Recovery (DR) options for SQL Server.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.