Database Administrator

Job title: Database Administrator

Job location: Atlantic City, NJ onsite

Job Type: Full time

A leading hospitality and entertaining company is seeking a Database Administrator is responsible for configuring and maintaining servers and databases within the property. The Database Administrator will build and manage SQL clusters, prioritize memory, SQL security, Data Classification, SQL queries, and SQL Backup management.

Responsibilities

Thorough understanding of Microsoft SQL Server 2012 and later.

Can setup, configure, and maintain Microsoft SQL Server in a clustered environment.

Can configure replication of databases and understands impact of replication on systems

Understands best practices for maintaining, backing up and restoring SQL databases in a high-transaction, 24x7x365 environment.

Can author and monitor database maintenance scripts to ensure optimal database operation.

Develops and implements disaster recovery procedures

Ability to conduct analyses and generate reports to reflect findings

Maintain knowledge of basic concepts and techniques

Requirements:

• Bachelor s degree in a related Information Technology field preferred.
• Minimum of 5 years experience with Microsoft SQL Server 2012 and higher
• Demonstrated knowledge with SQL Server Database Engine, buffer cache, transaction log architecture, backups, and execution model.
• Proficiency in SQL and T-SQL is fundamental, encompassing troubleshooting, designing and implementing stored procedures.