Data Base Administrator (DBA)

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

Job summary

The Marwood Group is seeking a Data Base Administrator to provide technical support for our database environment. This role includes overseeing database development, optimizing queries, and supporting end-users in a dynamic setting. Ideal candidates will possess over 8 years of experience with Microsoft SQL Server 2008/2014 and demonstrate strong troubleshooting skills.

The position requires a deep understanding of T-SQL and disaster recovery procedures, as well as knowledge of Windows Server configurations. Those with additional experience in healthcare data or SQL reporting will stand out.

Qualifications

• 8+ years of experience with Microsoft SQL Server 2008/2014.
• Knowledge of administration, replication, backup, and restore of databases.
• Experience troubleshooting production SQL Servers and service outages.

Responsibilities

• Ensure new database code meets company standards.
• Identify and improve resource-intensive queries.
• Develop efficient SQL Server T-SQL queries.

Skills

Microsoft SQL Server 2008/2014

T-SQL

Windows Server Configuration

Disaster Recovery Procedures

Troubleshooting SQL Servers

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.