Database Administrator- IT- Full Time

Ocean Casino Resort•Atlantic City, NJ

1d•$86,900 - $121,700

About The Position

The Database Administrator configures and maintains servers and databases within the property. The role supports Microsoft SQL Server in a clustered, high-transaction, 24x7x365 environment, including database replication, maintenance, backup and recovery, and disaster recovery. The administrator also researches and evaluates technologies, conducts analyses, generates reports, and communicates findings and recommendations.

Requirements

Minimum of 5 years’ experience with Microsoft SQL Server 2012 and higher.
Demonstrated knowledge of the SQL Server Database Engine, buffer cache, transaction log architecture, backups, and execution model.
Proficiency in SQL and T-SQL, including troubleshooting and designing and implementing stored procedures.
Excellent phone and written communication skills.
Ability to communicate effectively in English.
Strong problem-solving and analytical skills, with the ability to think strategically.
Ability to perceive quality of work, read materials, and review documents.
Ability to communicate clearly and effectively both orally and in writing.
Ability to lift, push, or pull up to 25 pounds.
Ability to complete required New Jersey casino employee registration and comply with applicable requirements.

Nice To Haves

Bachelor’s degree in a related Information Technology field is preferred.

Responsibilities

Configure and maintain servers and databases within the property.
Set up, configure, and maintain Microsoft SQL Server in a clustered environment.
Configure database replication and understand its impact on systems.
Maintain, back up, and restore SQL databases in a high-transaction, 24x7x365 environment.
Author and monitor database maintenance scripts to support optimal database operation.
Research and evaluate new technologies.
Develop and implement disaster recovery procedures.
Conduct analyses and generate reports reflecting findings.
Express ideas and make recommendations concerning job-related issues.
Maintain knowledge of basic concepts and techniques.
Prepare and deliver formal presentations before public and private concerns.
Plan, organize, and complete work logically and independently.
Work holidays and weekends, as well as flexible shifts and/or unusual hours.
Complete casino employee registration with the New Jersey Casino Control Commission or New Jersey Division of Gaming Enforcement, as applicable, and abide by applicable requirements.