Database Administrator- IT- Full Time

Theoceanac; Atlantic City (NJ); On-site; USD 87,000 - 122,000; Full time

Benefits offered by this job

Free meal on shift

Training & Development

Health Care Plan (Medical, Dental &amp

401k

Life Insurance (Basic, Voluntary &

Paid Time Off

Free Parking

Job summary

Theoceanac in Atlantic City, NJ seeks a Database Administrator to configure and maintain SQL Server databases within a casino property. The role emphasizes clustering, replication, backups, and high-availability in a 24/7 environment.

Required are a related IT degree and at least 5 years of SQL Server experience, strong SQL/T‑SQL skills, and excellent communication. Casino registrations compliance is also part of the job. This full-time role offers competitive benefits and growth opportunities.

Qualifications

• Bachelor's degree in a related Information Technology field preferred.
• Minimum 5 years’ experience with SQL Server 2012+ and SQL Server Engine, backups, and transaction logs.
• Proficiency in SQL and T-SQL, including troubleshooting and designing stored procedures.
• Excellent phone and written communication skills; ability to communicate in English.
• Must complete casino employee registration with NJ CCG or DGE as applicable.

Responsibilities

• Configure and maintain SQL Server in a clustered environment.
• Configure replication and understand its impact on systems.
• Maintain backups, restore procedures, and high-availability operations.
• Author and monitor database maintenance scripts.
• Develop disaster recovery procedures.
• Analyze data and generate reports; communicate findings.
• Plan, organize, and complete work; present findings.

Skills

MS SQL Server

SQL Server clustering

Replication

Backups & recovery

T-SQL

Troubleshooting

Stored procedures

Education

Bachelor's degree in Information Technology or related field

Job description

About the Role

The Database Administrator is responsible for configuring and maintaining servers and databases within the property.

Position 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.
• Researches and evaluates new technologies
• Develops and implements disaster recovery procedures
• Ability to conduct analyses and generate reports to reflect findings
• Ability to express ideas or make recommendations concerning job related issues
• Maintain knowledge of basic concepts and techniques
• Ability to prepare and deliver formal presentations before public and private concerns
• Ability to perceive quality of work, read materials and review documents
• Ability to communicate clearly and effectively both orally and in writing
• Ability to logically and independently plan, organize, and complete work

Essential Functions

• Exposure to stressful situations related to servicing clients in a high pressure and fast paced environment

• Must be able to work holidays and weekends, as well as flexible shifts and/or unusual hours
• Must be able to lift/push/pull up to 25 pounds

What's Required

• Bachelor's degree in a related Information Technology field preferred.
• Minimum of 5 years' experience with Microsoft SQL Server 2012 and higher with 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.
• Excellent phone and written communication skills
• Ability to effectively communicate in English
• Strong problem-solving and analytical skills and can 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 the requirements imposed by New Jersey Casino Control Act and regulations.

• Free meal on shift
• Training & Development
• Health Care Plan (Medical, Dental & Vision)
• Retirement Plan (401k,)
• Life Insurance (Basic, Voluntary & AD&D)
• Paid Time Off
• Free Parking
• Our cash compensation amount for this role is $86,900- $121,700 annually. Final offer amounts are determined by multiple factors including experience and expertise and may vary from the amount listed above.