Database Administrator- IT- Full Time

Ocean Casino Resort•Atlantic City, NJ

About The Position

The Database Administrator configures and maintains servers and databases within the property. The role requires maintaining Microsoft SQL Server systems, including clustered environments and database replication, and supporting reliable operation in a high-transaction, 24x7x365 environment. The administrator also develops and monitors maintenance scripts, evaluates new technologies, and implements disaster recovery procedures. The position involves analyzing information and preparing reports, communicating recommendations and findings, delivering presentations, and independently planning and completing work. It is performed in a high-pressure, fast-paced client-service environment and requires flexibility to work weekends, holidays, shifts, or unusual hours. The role requires lifting, pushing, or pulling up to 25 pounds.

Requirements

Minimum of 5 years’ experience with Microsoft SQL Server 2012 and higher.
Demonstrated knowledge of 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 complete casino employee registration with the New Jersey Casino Control Commission or New Jersey Division of Gaming Enforcement, as applicable, and abide by requirements imposed by the New Jersey Casino Control Act and regulations.
Ability to lift, push, or pull up to 25 pounds.

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.
Communicate ideas and 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 weekends, holidays, flexible shifts, and/or unusual hours as required.