Job

SQL Database Administrator

Main Street DBAs

http://www.mainstreetdbas.com

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 24×7 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 use of tSQL, 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 and deploying/maintaining packages/jobs.

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

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 of 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 in table partitioning and archiving mechanisms

Ability to function well in a virtual team working independent 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.

Details

Type:
Full-Time
State(s):
Ohio
Location(s):
Cincinnati - Remote Position
Function:
Information Technology
Industry:
For-Profit Vendor
Compensation:
$100,000.00 - $125,000.00
Posted on:
February 13, 2017

How to Apply

Please forward your resume to:

Ashlie Stapleton – Human Resource Manager

astapleton@mainstreetdbas.com