Senior SQL Database Administrator

Company: CYNET SYSTEMS
Location: Princeton
Posted on: March 18, 2023

Job Description:

Pay range: $60 to $63

Job Description:

Responsibilities:

• 
  
• 16+ years of experience in MS SQL Server Database Administration and Implementation(in OLTP, Web Based, Production and Development environments) including Installations and Upgrades.
  
• Always On configuration & management for SQL server databases
  
• Proficiency with performance optimization /tuning.
  
• Good experience using DMV, Query Store.
  
• Experience in installing Service Packs for SQL Server.
  
• Thorough understanding of MS-SQL technology and concepts including Always-On Availability Groups,clustering, replication, and SSRS.
  
• Experience analyzing and optimizing query and database performance, preferably with tools such as SolarWinds Database Performance Analyzer.
  
• Experience running database loads in Microsoft Azure using IaaS and PaaS services.
  
• Upgraded and migrated several servers and databases from lower version of SQL server to higher versions.
  
• Experienced in Configuring, Implementing and Maintaining Database Mirroring in high-performance or high-safety mode.
  
• Good Knowledge in implementing different Replication Models (Snapshot, Merge and Transactional) with different topologies.
  
• Experience with SQL Replication.
  
• Highly experienced in Configuration, Implementation and Maintenance of Log Shipping.
  
• Manage and maintain database changes in Development, QA, Staging and Production.
  
• Expert in Database Design activities including Data Files and File group organization, Capacity Planning.
  
• Expertise in migrating servers using in place and side by side upgrade.
  
• Good knowledge of Windows OS, Virtualization, Storage and Networking.
  
• Experience in Patch and release management.
  
• Develop and maintain system documentation.
  
• Strong communication skills and should have ability to work independently.
  
  

Keywords: CYNET SYSTEMS, Trenton , Senior SQL Database Administrator, IT / Software / Systems , Princeton, New Jersey