What are the responsibilities and job description for the SQL Database Administrator - Only Locals to Mahwah, NJ position at NLB Services?
SQL Server Database Administrator (DBA) to support mission critical applications by managing, optimizing, and maintaining our enterprise SQL Server environments. This role focuses heavily on database performance, query tuning, proactive monitoring, and ensuring reliable data services for application teams. The ideal candidate has strong experience supporting large, complex SQL Server environments and enjoys partnering closely with developers to resolve performance bottlenecks and improve overall system stability.
POSITION GENERAL DUTIES AND TASKS –
Key Responsibilities
• Administer, maintain, and support enterprise Microsoft SQL Server databases.
• Monitor database performance, analyze slow queries, and implement tuning strategies (indexes, plans, statistics, etc.).
• Work closely with application teams to review and optimize SQL queries, stored procedures, and data access patterns.
• Perform regular database maintenance including backups, restores, integrity checks, and patching.
• Support high availability and disaster recovery configurations (AlwaysOn Availability Groups, clustering, replication).
• Implement and maintain automation for SQL Server maintenance tasks where appropriate.
• Assist in diagnosing application performance issues that originate within the database layer.
• Participate in a rotational weekend/on-call schedule to support production releases and critical issues.
Required Qualifications -
• 8 years’ experience in professional services or related field
• 5 years’ experience working with databases such as Oracle, SQL Server, PostgreSQL.
• 5 years of experience working with SQL and data modeling tools.
• 5 years of experience working with stored proc, query optimization, index analysis, continued tuning, performance tuning
Preferred Skills -
• Experience with SQL Server AlwaysOn, clustering, or other HA/DR technologies.
• Knowledge of cloud or containerized database environments (Azure SQL, SQL Server on containers).
• Familiarity with CI/CD processes for database changes.
• Understanding of ETL processes and integration tools (SSIS, Azure Data Factory).
• Certifications such as MCSA: SQL Server, MCSE: Data Management & Analytics, or Azure SQL certifications.