SQL Server DBA

  • Woodcliff Lake, NJ


: $66,250.00 - $159,250.00 /year *

Employment Type

: Full-Time


: Information Technology

Loading some great jobs for you...

Job Role: SQL Server DBA for Production Support
Location: Woodcliff Lake , NJ
Job Description:
At least 5 years of experience as a SQL Server DBA with experience in configuration and maintenance of database servers and processes, monitoring of system health and performance to ensure high levels of performance, availability, and security
Certification on Microsoft Technology Solutions SQL 2016 or higher
Hands on experience as Production support DBA using ITIL framework - Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end. Ability to manage major incidents and Provide reliable support for business critical production systems
Strong knowledge of indexes, index management, integrity checks, configuration, patching, DMV queries , collation, MaxDOP etc and ability to recommend the ideal configuration for specific application scenarios.
Experience in SQL support on Azure Platform ( PaaS and Iaas)
Hands-on experience with Performance Tuning and Optimization , configuration and maintenance of AlwaysON, and Replication, backups, restores and recovery models
Thorough knowledge and experience in SQL server Troubleshooting and performance investigations for Production Application Issues using Support Troubleshooting Tools (SQL traces), SQL profiler, PSS Diag etc
Experience in configuring High Availability (HA) and Disaster Recovery (DR) options for SQL Server
Knowledge and working experience of SSAS, SSIS and SSRS
Knowledge on DevOps Set Up using CI / CD for Automated Deployment
Experience in configuring and supporting PowerBI Reporting Solutions.Knowledge on modern and open source DB stacks Mongo , PostGreSQL etc.
Ability to draft Technical Architecture / Design Documents pertaining to SQL storage for rollout of new applications to Azure Cloud
Acquaintance with windows server configurations, security delegation, SPNs, storage components.
Familiarity with scripting language like Powershell, VBScript, WSH . Skills to refine and automate regular processes.
Thanks & Regards,
(D) 248-###-####
Associated topics: data administrator, data analyst, data integration, data integrity, data manager, data management, data quality, etl, mongo database, mongo database administrator

* The salary listed in the header is an estimate based on salary data for similar jobs in the same area. Salary or compensation data found in the job description is accurate.

Launch your career - Upload your resume now!

Upload your resume

Loading some great jobs for you...