Mssql Dba

HMG America LLC is the best Business Solutions focused Information Technology Company with IT consulting and services, software and web development, staff augmentation and other professional services. One of our direct clients is looking for MSSQL DBA in Princeton NJ or Boston MA . Below is the detailed job description. Role: MSSQL DBA Location: Princeton NJ or Boston MA (Onsite) 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.