This job is restricted to tax residents of , but we detected your IP as outside of the country. Please only apply if you are a tax resident.
Title: SQL Server DBA Location: Fully Remote (Candidate can be based out of anywhere in US) Duration: 2 month contract + possible extension 40 Hours per week
Ensure all database servers are backed up in a way that meets the business's Recovery Point Objectives (RPO)
Test backups to ensure we can meet the business' Recovery Time Objectives (RTO)
Configure SQL Server monitoring utilities to minimize false alarms
Manage SQL Server security including auditing
Install and configure new SQL Servers
As new systems are brought in-house, choose whether to use clustering, log shipping, mirroring, Windows Azure, or other technologies
Document the company's database environment
Manage HA and DR SQL Server environments
Setup and administer Failover clustering, SAN replication, and other high availability technologies
Setup and administer SQL Server merge, peer to peer, or transactional replication
Configure, manage, Troubleshoot and maintain SQL Server Database Engine, Analysis Services, Integration Services, and Reporting Services
Configure SQL Server agent, create and manage weekly jobs required for optimal database performance Performance
Performance monitoring
When performance issues arise, determine the most effective way to increase performance including hardware purchases, server configuration changes, or index and query changes
Write and tune T-SQL queries to improve performance
Using Profiler traces and other tools to find the most frequently run and expensive queries SQL Server Code and Software Release
Ensure that new database code meets company standards for readability, reliability, and performance
Design indexes for existing applications. Add, modify, monitor and remove indexes and object statistics
Deploy database change scripts and software releases provided by internal teams and third party vendors
Stored procedure development and performance tuning
When users complain about the performance of a particular query, help developers improve the performance of that query by tweaking it or modifying indexes
Advise developers on the most efficient database designs (tables, datatypes, stored procedures, functions, etc)
Design tables and pick datatypes
Share best practice methodologies throughout the residency assignment Resident is expected to be self-directed, able to accomplish tasks with little to no direction