Lead Senior Database Administrator / DBA

PCS Revenue Control Systems, Inc.; New Jersey; On-site; USD 110,000 - 150,000; Full time

Job summary

PCS Revenue Control Systems, Inc. is seeking an experienced Senior Database Administrator to manage and optimize Microsoft SQL Server environments in production systems.

You will focus on performance, reliability, maintenance, and operational excellence to keep critical systems stable and fast. The ideal candidate will work closely with development, infrastructure, and support teams to implement changes, tune queries, manage backups, and ensure scalability as data grows.

Qualifications

• 5+ years of hands-on SQL Server DBA experience.
• Strong knowledge of performance tuning, indexing, and execution plans.
• Experience with Availability Groups, backups, and restores.
• Familiarity with large historical data sets and temporal tables.
• Excellent communication with cross-functional teams.

Responsibilities

• Manage production and non-production SQL Server environments.
• Monitor health, performance, backups, and maintenance jobs.
• Support Availability Groups, listeners, and recovery processes.
• Troubleshoot incidents and drive root-cause analysis.
• Collaborate with development and infrastructure teams to implement changes.
• Tune queries, indexes, and heavy transactional workflows.
• Document procedures and improve repeatable operations.

Skills

SQL Server

Performance tuning

Availability Groups

Backup & Restore

SQL scripting

Automation

Job description

We are seeking an experienced Senior Database Administrator to manage, optimize, and help scale our Microsoft SQL Server environments. This role is focused on database performance, reliability, maintenance, and operational excellence for large production systems.

The ideal candidate is proactive, detail-oriented, and comfortable working closely with development, infrastructure, and support teams to keep mission-critical systems stable, secure, and performing well.

Key Responsibilities

• Manage and maintain production and non-production Microsoft SQL Server environments.
• Monitor database health, performance, storage, jobs, alerts, backups, restores, and maintenance processes.
• Support SQL Server Availability Groups, listeners, backup and restore processes, and database cloning.
• Troubleshoot production database issues, identify root causes, and drive incidents through resolution.
• Support performance testing, capacity planning, and database scalability as data volume and usage grow.
• Work closely with development and infrastructure teams to review and implement database changes, tune SQL performance—including queries, stored procedures, indexes, and transaction-heavy workflows—and improve overall database reliability.
• Improve database operations through monitoring, automation, documentation, and repeatable procedures.

Required Experience

• Strong hands-on experience as a DBA supporting large Microsoft SQL Server production databases.
• Strong experience with SQL Server performance tuning, including query optimization, indexing, execution plans, stored procedures, and complex SQL scripts.
• Experience managing SQL Server jobs, alerts, backups, restores, maintenance plans, Availability Groups, and listeners.
• Experience with system-versioned temporal tables, history tables, archiving, and large historical data sets.
• Ability to troubleshoot database performance issues across applications, reporting, imports, exports, and high-volume transaction systems.
• Experience with database monitoring, health checks, performance analysis, and proactive alerting.
• Strong communication skills and the ability to work effectively with development, infrastructure, support, and other technical and nontechnical teams.

Preferred Experience

• Experience supporting SaaS platforms or customer-facing business applications.
• Experience with multi-customer or multi-tenant database environments.
• Familiarity with monitoring, logging, and observability tools such as New Relic, ELK, or similar platforms.
• Experience improving database operations through automation, documentation, and process improvement.