SQL DBA Developer

Valiant Technologies LLC; Jersey City (NJ); On-site; USD 120,000 - 170,000; Full time

Job summary

Valiant Technologies LLC in Jersey City is seeking an experienced Senior SQL Server DBA to manage, secure, and optimize enterprise databases. You will oversee performance tuning, high availability, disaster recovery, backups, and cloud database management, including Azure SQL migrations and automation.

The role requires hands-on experience with Always On, clustering, indexing strategies, and SQL Agent automation. Collaboration with development teams to optimize procedures is essential.

Qualifications

• Senior SQL Server DBA with enterprise experience sought for data environments.
• Strong expertise in performance tuning, HA/DR, backups, and cloud DB management.
• Experience with migrations to Azure SQL and managed instances is a plus.

Responsibilities

• Design, install, configure, and maintain SQL Server environments.
• Upgrade, patch, and migrate SQL Server instances.
• Monitor performance and troubleshoot complex issues.
• Optimize queries, indexes, and execution plans.
• Manage Always On AGs, Failover Clustering, and mirroring.
• Implement backup/DR strategies and conduct capacity planning.
• Secure databases, manage permissions, auditing, and roles.
• Automate DBA tasks with PowerShell, T-SQL, and SQL Agent jobs.
• Collaborate with developers to optimize procedures and objects.
• Support on-prem to Azure SQL migrations and cloud management.

Skills

SQL Server admin

Performance tuning

High availability

Disaster recovery

Backup strategies

Cloud databases

PowerShell

T-SQL

SQL Agent

Azure SQL

Indexing strategies

Always On

Tools

Azure SQL

Always On

Failover Clustering

SQL Server Agent

Job description

We are looking for an experienced Senior SQL Server DBA responsible for managing, maintaining, securing, and optimizing enterprise database environments. The ideal candidate will have strong experience in SQL Server administration, database performance tuning, high availability, disaster recovery, backup and recovery, and cloud database management.

Design, install, configure, and maintain Microsoft SQL Server database environments.

Perform SQL Server upgrades, migrations, patching, and version upgrades.

Monitor database performance and troubleshoot complex database issues.

Perform SQL query optimization, execution plan analysis, and indexing strategies.

Manage SQL Server Always On Availability Groups, Failover Clustering, and database mirroring.

Implement and maintain backup and recovery strategies, including full, differential, and transaction log backups.

Develop and maintain disaster recovery (DR) and business continuity plans.

Manage database security, user permissions, roles, authentication, and auditing.

Perform database capacity planning, storage management, and performance monitoring.

Troubleshoot blocking, deadlocks, locking, and concurrency issues.

Automate DBA activities using PowerShell, T-SQL, and SQL Agent jobs.

Manage SQL Server Agent jobs, alerts, operators, and maintenance plans.

Support database migrations from on-premises environments to Azure SQL and Azure SQL Managed Instance.

Work with development teams to optimize stored procedures, views, functions, and triggers.

Implement database monitoring and proactive performance management.

Maintain database documentation, standards, and operational procedures.

Participate in production support, incident management, and root cause analysis.

We are an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, national origin, citizenship/ immigration status, veteran status, or any other status protected under federal, state, or local law.