SQL Server Database Administrator

ACT Consulting has an immediate need for a SQL DBA- Westchester, NY with our direct client, an alcoholic beverage maker.

Please take a moment to review the job description. If this is something you are interested in, please send a copy of your resume to spaulson@act-info.com or contact us at 203-864-9047 for additional details.

ACT Consulting is a U.S. owned and operated staffing company providing our clients with candidates on a national basis for contract, contract to hire, and direct hire engagements. Our clients are comprised mostly of Fortune 1000 companies, primarily in the areas of Information Technology, Engineering, Professional, Accounting and Finance

Job Title: SQL Server Database Administrator

Job Location: Westchester, NY

Contract Length: 6-12 months

Rate:$ 90/hr on w2

The Role: A SQL Server Database Administrator is responsible for deploying, configuration maintenance, and performance of critical Microsoft SQL Server installations.

Responsibilities include the management of SQL servers to store, organize and access data to ensure maximum availability, reliability, and performance. Additional duties include analyzing the organization's data management, security needs and helping to develop tools, as well as methods to support data access and information security.

Further requirements include coding skills for optimizing TSQL queries to support developers in optimizing queries for applications.

This "hands-on" position requires solid technical skills as well as excellent interpersonal and communications skills. T

his role is an integral part of a global DBA team supporting both MS SQL and Oracle Enterprise Databases.

Essential Duties/Principal Responsibilities:

Install, configure, troubleshoot, monitor and maintain MS SQL platform.

Administer and provide support for MS SQL environment including clustered instances in both virtual and physical environments;

Perform database administration tasks including backups, monitoring, performing database copies, working on database enhancements for existing applications, investigating and responding to incidents and events, performance checks, evaluating/monitoring system logs, disk space, sizing, limits for MS SQL engine, applying security patches

Technically and architecturally support projects and others with SQL Server solutions. Set up databases logically and physically.

Maintain, Monitor and provide best performance to database. Be part of the 24/7/365 On-call Team (at times, as needed).

Minimum Qualifications:

Education, Experience, Skills, Abilities, License/Certification:

Knowledge about cluster and how servers work- need 5 to 6 years for experience Competency in contemporary related IT systems and platforms

Strong communication skills, both written and oral (English) Knowledge of database design and normalization

Understanding of different data storage and backup solutions related to MS SQL Server. Support businesses, projects, and users with SQL Server architecture solutions. Knowledge of TSQL and PowerShell.

Configuration of servers for SQL server installations. Installation SQL Server according to practice and internal policy.

Upgrading SQL Server as well as pathing Setting up database permissions procedures according to policy and practice Setting up and maintaining Disaster/Recovery procedures. Basic knowledge of SQL Server Reporting Services and SQL Server analysis Service.

A bachelor's degree or Associates Degree in MIS or CS preferred, or relevant concentration 5 years minimum of MS SQL server experience