Job Details

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

Sql Dba Onsite Nj

New Jersey, Jerseycity, 07097 Jerseycity USA
Apply Now

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

Apply Now Subscribe Report job