Skip to main content
Johnson Jobs

Senior SQL Server DBA

object dataJersey City, NJ

today

Occupations

Database AdministratorsDatabase ArchitectsNetwork and Computer Systems Administrators

Industries

Computer Systems Design ServicesCustom Computer Programming ServicesOther Computer Related Services
APPLY NOW (opens in a new tab)

About the role

Senior SQL Server DBAOnsite, NYC | Contract | In-person interview | 8+ years
About the Role: Our client in New York City is looking for a senior SQL Server DBA with strong hands-on administration and production support experience. In this role you will set up new SQL Server environments, maintain and support existing business-critical databases, and look after the Windows servers they run on. You will work closely with application, network and infrastructure teams and use scripting to keep databases and servers running well. The client is also moving a legacy Ingres platform to SQL Server, so Ingres migration experience will make you stand out. This is a contract role, fully onsite, with in-person interviews.
Required Skills:
  • Strong SQL Server administration, including installs, configuration, patching and upgrades across production and non-production, and building new environments
  • Stored procedures, views, triggers and query troubleshooting, along with performance tuning, indexing and execution plan analysis
  • Routine database maintenance such as monitoring, health checks, index and statistics upkeep, integrity checks, SQL Agent jobs and capacity planning
  • Resolving incidents, outages, blocking, deadlocks and failed jobs, with root cause analysis
  • Developing, supporting and troubleshooting SSIS and ETL processes
  • Managing logins, roles, permissions and database access
  • Supporting SQL Server on Windows Server, including service accounts, Active Directory authentication, ports and firewall rules, and working with network teams on connectivity issues
  • Backup and recovery using full, differential and transaction log backups, aligned to RPO and RTO requirements
  • Always On Availability Groups across multiple nodes and data centers, synchronous and asynchronous commit, WSFC and quorum configuration with File Share and Cloud Witness, and log shipping
  • Running DR exercises and failover and failback tests, and maintaining HA/DR runbooks
  • PowerShell, T-SQL and batch scripting for maintenance, deployments, monitoring and alerts
  • Supporting application releases, documenting procedures, and working with development and QA teams on defect fixes Highly Preferred
  • Hands-on Ingres to SQL Server migration, including Ingres SQL, database objects, data types and schema differences
  • Schema and data migration, dependency analysis, reconciliation and post-migration validation
  • Migration testing, cutover and post-production stabilization
  • Modernizing large or business-critical legacy databases
  • Utilities or T&D domain experience
  • Data modeling and database design, including logical and physical models, keys, constraints and normalization
  • Database source control

Matching similar jobs

JOB OVERVIEW

Experience level

Senior

Location

Jersey City, NJ

Occupation

Database Administrators

Industry

Computer Systems Design Services

Posted

today

Tired of running searches?

Rank the roles you'd take once, and matches like these arrive on their own.

CREATE PROFILE (opens in a new tab)