SQL DB Admin Onsite 9467

29 Jul 2024

Vacancy expired!

Onsite Day 1 - Jersey City, NJ (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 theRequired Skills Technical Skills-

SQL Server DB Administration Technology

MultiCloud PGRoles & 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

  • ID: #44454798
  • State: New Jersey Jerseycity 07097 Jerseycity USA
  • City: Jerseycity
  • Salary: Depends on Experience
  • Job type: Contract
  • Showed: 2022-07-29
  • Deadline: 2022-09-26
  • Category: Et cetera