SQL Server DBA/Architect in Hamilton, NJ

Hybrid in Hamilton, NY, US • Posted 2 days ago • Updated 2 days ago
Contract Independent
Contract W2
No Travel Required
Hybrid
Depends on Experience
Fitment

Dice Job Match Score™

🎯 Assessing qualifications...

Job Details

Skills

  • SQL Server
  • ETL
  • AWS
  • Cloud
  • Disaster recovery

Summary

SQL Server Expertise

- 8+ years of SQL Server administration experience

- Expert knowledge of SQL Server 2019/2022

- Advanced T-SQL programming (stored procedures, functions, triggers, views)

- Query optimization and execution plan analysis

- Index design and optimization

- Database design and normalization (1NF through 5NF)

- SQL Server security and compliance

- Backup and recovery strategies

- SQL Server Agent and job scheduling

- Database maintenance plans

 High Availability & Disaster Recovery

- SQL Server Always On Availability Groups

- Database mirroring and replication

- Log shipping

- Failover clustering

- Multi-region deployment strategies

- Backup and restore strategies

- Point-in-time recovery

- Disaster recovery planning and testing

 

Performance Tuning

- Query performance tuning and optimization

- Index tuning and maintenance

- Execution plan analysis

- Wait statistics analysis

- Blocking and deadlock resolution

- Resource Governor configuration

- Memory and CPU optimization

- I/O optimization

- Performance monitoring tools (SQL Profiler, Extended Events, DMVs)

 

Cloud Database Services

- AWS RDS for SQL Server (3+ years)

- Cloud database security and compliance

- Cloud backup and recovery

- Cloud monitoring and alerting

- Cost optimization strategies

 

Data Migration

- Large-scale data migration experience (500GB+)

- Conversion scripts experience

- ETL tools and processes (SSIS, Azure Data Factory, AWS DMS)

- Data validation and quality assurance

- Legacy database migration experience

- Network database to relational conversion

- Data mapping and transformation

- Migration automation and scripting

 

Scripting & Automation

- PowerShell scripting for automation

- T-SQL scripting

- Source code management, GIHUB

- CI/CD for database deployments

- Automated testing frameworks

 

Professional Experience (Must Have)

- 10+ years of database administration experience

- 8+ years of SQL Server administration

- 3+ years of cloud database experience (Azure SQL or AWS RDS)

- Experience with large-scale data migrations (500GB+ databases)

- Experience with mission-critical systems (99.9%+ uptime)

- Led or participated in database modernization projects

- Experience with high-transaction environments (50K+ transactions/day)

- Experience with Agile/Scrum methodologies

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: 10317361
  • Position Id: BR9009
  • Posted 2 days ago
Create job alert
Set job alertNever miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Hybrid in Hamilton, New York

2d ago

Easy Apply

Full-time

Depends on Experience

Hybrid in Hamilton, New York

Today

Easy Apply

Contract

Depends on Experience

No location provided

Today

Easy Apply

Full-time, Part-time, Contract, Third Party

New Jersey

Today

Easy Apply

Full-time, Part-time, Contract, Third Party

Search all similar jobs