Sql Dba Onsite Nj job vacancy in Jerseycity, New Jersey ReqRoute, Inc

Vacancy expired!

SQL DBA

Duration: 1 year contract

Location:

Jersey City – NJ ONSITE

8yrsJob Description:(Maintenance, Security, Upgrades, Performance Tuning, etc.) • Installing, Configuring and Upgrading SQL Server/Applying Service Packs • Hands on experience on Log shipping, SQL Server Replication troubleshooting replication issues with in SLA, experience in configuring Database mirroring and trouble shooting the issues and hands on experience in Always On high availability and troubleshooting the 4.Required Skills Technical Skills- ,SQL Server DB Administration Domain Skills- 6.Technology MultiCloud PG8.Roles & Responsibilities • Database Administration for the SQL Server 2008R2 to SQL Server 2019 (Maintenance, Security, Upgrades, Performance Tuning, etc.) • Installing, Configuring and Upgrading SQL Server/Applying Service Packs • Hands on experience on Log shipping, SQL Server Replication troubleshooting replication issues with in SLA, experience in configuring Database mirroring and trouble shooting the issues and hands on experience in Always On high availability and troubleshooting the issues. • Hands on experience in installing SQL server standalone and Failover Clustering and troubleshooting. • Extensive experience in designing and handling Disaster recovery/high availability. • Good Knowledge and work experience in TDE and Column level encryption • Should have experience with using Trace flags / Profiler to solve Dead Locks/Long running queries. • Data Transformation and Loading, Experience with SSIS and SSRS troubleshooting • Experience in Plan growth and changes (capacity planning) • Experience in ITIL process in handling CR’s, incidents and service requests. • Work experience/ Knowledge on Power shell command utilities. • Creating Users and assign permissions based on the level of database access the user would need • Creating Linked Servers to SQL Servers and other databases such as, Access, Informix etc. • Database restores from PROD to non-PROD • Contribution in Optimizing SQL server databases and environment as per the need and environment • Troubleshooting various issues & problems that arise in a day-to-day work • Monitoring and Performance tuning Physical Server Level, Database level (Database settings and options) and query tuning. • Documenting major changes to the SQL Servers. • Performing Health Check • Applying Service Packs Should have good understanding of the MS SQL, related utilities and tools • Identification- Use native tools like Profiler, Perfmon, system stored procedures, dynamic management views, custom stored proce

Vacancy expired!

ID	#44693448
State	New Jersey
City	Jerseycity
Job type	Contract
Salary	USD $60 - $65 60 - 65
Source	ReqRoute, Inc
Showed	2022-08-08
Date	2022-08-05
Deadline	2022-10-04
Category	Et cetera
Create resume

Job Details

Sql Dba Onsite Nj