Database Administrator- IT- Full Time

Ocean Casino Resort; 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

401k Retirement Plan

Life Insurance

Paid Time Off

Free Parking

Job summary

Ocean Casino Resort in Atlantic City is seeking a Database Administrator to configure and maintain SQL Server databases in a 24x7 environment. The role emphasizes clustering, replication, backups, and DR planning, with a strong focus on performance and reliability.

The ideal candidate has 5+ years of SQL Server experience, proficiency in SQL/T-SQL, and a IT-related degree. On-site role with benefits including health care, retirement plans, and paid time off.

Qualifications

• 5+ years' experience with Microsoft SQL Server 2012+
• Proficiency in SQL and T-SQL
• Experience with backups, replication, and high-availability environments
• Bachelor's degree in IT or related field preferred

Responsibilities

• Configure and maintain Microsoft SQL Server in a clustered environment
• Configure replication and understand its impact on systems
• Maintain backups and disaster recovery procedures for high-transaction workloads
• Develop and monitor database maintenance scripts for optimal operation
• Research new technologies and evaluate applicability to the property

Skills

SQL expertise

T-SQL proficiency

High availability

Analytical thinking

Education

Bachelor's degree in IT

Tools

Microsoft SQL Server

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.