Skip to Main Content

Senior SQL Server Database Administrator

Main Street DBAS Boise, ID

  • Posted: over a month ago
  • $93,000 to $125,000 Yearly
  • Full-Time
  • Benefits: life insurance, medical, vision, 401k, dental,
Job Description

This job is for a senior-level SQL Server DBA providing operational database management tasks for select customers. The DBA will be self-sufficient in terms of their abilities to exceed customer expectations while being part of a team to lend support and assistance when needed.

Database support will include day-to-day duties for proper database maintenance along with proactive measures to maximize the database availability and performance.

This job will provide the flexibility to work from a home office a majority of the time with occasional visits to customer locations.

Job includes aspects of 24x7 support in conjunction with other team members.

Requirements:

-Minimum of 5 years of experience as a SQL Server DBA in SQL server 2005 or above.

-Excellent understanding of SQL with experience with performance monitoring, analysis, and tuning of relational databases. This includes the use of T-SQL, profiler, tuning advisor, indexes, statistics, query plan analysis.

Experience with:
-Creating triggers, stored procedures, and complex join statements

-Migrating data to/from other data sources using DTS/SSIS/SSRS and deploying/maintaining packages/jobs.

-Engineering DR/BC and backup solutions including full, differential, transactional backup, backup mirroring, and automated maintenance jobs with alerting.

-Experience with Azure

-DP300, specifically in the areas listed below

  • Plan and implement data platform resources
  • Implement a secure environment
  • Monitor and optimize operational resources
  • Optimize query performance
  • Perform automation of tasks
  • Plan and implement a High Availability and Disaster Recovery (HADR) environment
  • Perform administration by using T-SQL
  •  

- AZ104 or az-104


-Database Administration for SQL Server installations including capacity planning, installing, upgrading, configuration and patching, and all functions to provide high availability, high performance, and high security.

-Implement and support housekeeping procedures such as backups, integrity checking
Production and maintenance of high-quality documentation.

-Providing overnight and off-hours support as part of a support team.

-Experience with setup and support database clustering, mirroring, replication, and log shipping in Windows 2003/2008 enterprise environment.

-Knowledge of table partitioning and archiving mechanisms.

-Ability to function well in a virtual team working independently while managing time and priorities in a 24 X 7 DBA remote support environment.

-Must possess strong interpersonal skills. Previous consulting experience is a plus.

-Must be eligible to work in the United States

Physical Demands:

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

While performing the duties of this job, the employee is frequently required to use hands to finger, handle, or feel and talk or hear. The employee is required to stand; walk; sit; reach with hands and arms; climb or balance and stoop, kneel, crouch, or crawl. Additionally, the employee must occasionally lift and/or move up to 50 pounds.

Specific vision abilities required by this job include color vision, depth perception, and ability to adjust focus.

Company Description
We get it.

When you need a DBA service you want to know that the provider has the requisite processes, monitoring systems, call center support and other elements to offer a true managed service.

But once the service is chosen the most important determinant for success is the skill, work ethic and personality of the DBA doing the work.

That is why we assign named personnel to you - so you can work with the same DBAs day in and day out - so that when there is a problem the confidence and trust you need to have in the DBA working the issue is already there.
We like to think we have simplified the approach to DBA service.

Main Street DBAS

We get it. When you need a DBA service you want to know that the provider has the requisite processes, monitoring systems, call center support and other elements to offer a true managed service. But once the service is chosen the most important determinant for success is the skill, work ethic and personality of the DBA doing the work. That is why we assign named personnel to you - so you can work with the same DBAs day in and day out - so that when there is a problem the confidence and trust you need to have in the DBA working the issue is already there. We like to think we have simplified the approach to DBA service.

Main Street DBAS's Logo

Address

Boise, ID
USA

Industry

Technology

Website

View all jobs at Main Street DBAS

What email should the hiring manager reach you at?

By clicking the button above, I agree to the ZipRecruiter Terms of Use and acknowledge I have read the Privacy Policy, and agree to receive email job alerts.