SQL Data Base Administrator (DBA)

Marwood Group; New York (NY); On-site; USD 90,000 - 120,000; Full time

Job summary

Marwood Group is seeking an experienced Data Base Administrator (DBA) to provide technical support for the database environment. The role includes overseeing development, testing backups, and troubleshooting SQL Server outages.

The ideal candidate should have 8+ years of experience with Microsoft SQL Server 2008/2014, strong skills in T-SQL coding, and the ability to work with multiple databases. Knowledge in healthcare-related databases is a plus.

Qualifications

• 8+ years of experience with Microsoft SQL Server.
• Excellent understanding of T-SQL, stored procedures, and views.
• Experience in disaster recovery and backup procedures.

Responsibilities

• Manage and support the database environment and its users.
• Ensure reliability, performance, and recovery objectives are met.
• Troubleshoot SQL Server service outages and performance issues.

Skills

Microsoft SQL Server 2008/2014

T-SQL coding

Database administration

Backup and disaster recovery

Windows Server management

Tools

SSIS

SSRS

MySQL

Crystal Reports

Job description

The Data Base Administrator (DBA) is responsible for providing technical support for the database environment. This includes overseeing the development and organization of the databases and queries, supporting its users and assessing and implementing new technologies. The ideal candidate will also have the ability to handle unique and new challenges on-the-fly in an environment with varietyof stakeholders.

Job Specific Duties:

• Ensure that new database code meets company standards for readability, reliability, and performance
• Identify resource-intensive queries on the server and suggest ways to improve performance on each
• Develop efficient SQL Server T‑SQL queries to meet request needs
• 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)
• Troubleshoot SQL Server service outages as they occur, including after-hours and weekends
• Configure SQL Server monitoring utilities to minimize false alarms
• Install and configure new SQL Servers
• Deploy database change scripts provided by third party vendors
• Document the company’s database environment
• Diagnosing server reliability and performance issues

Required Skills/Experience:

• 8+ years of experience with Microsoft SQL Server 2008/2014
• Knowledge of administration, replication, backup and restore of relational databases, specifically Microsoft SQL Server 2008 & 2014
• Experience working with multiple databases across multiple servers including troubleshooting production SQL Servers and service outages.
• Understands Windows Server (2008 R2/2012 R2) configuration and management, specifically as it relates to MS SQL Server installations and mission critical systems
• Excellent understanding of coding with Microsoft T‑SQL, stored procedures and views
• Understands and is able to properly implement backup and disaster recovery procedures
• Excellent work ethic and willingness to put in extra time as needed

Any experience with any of the following is a plus:

• Healthcare, especially with member eligibility
• FTP, Windows Scripting
• Reporting using SSIS/SSRS
• EDI X12 ANSI format files: 834, 835, 837, 999
• MySQL
• Crystal Reports
• Version Control
• PHP frameworks
• PlexisHealthCare Systems
• Visual Cactus

Additional Information

All your information will be kept confidential according to EEO guidelines.