Bachelor's degree in Information Technology preferred.
5+ years of experience with Microsoft SQL Server 2012 and higher.
Proficient in SQL and T-SQL, including troubleshooting and stored procedures.
Strong problem-solving and analytical skills.
Excellent communication skills in English.
Responsibilities
Configure and maintain Microsoft SQL Server in a clustered environment.
Set up and manage database replication, understanding its system impact.
Implement best practices for database maintenance, backup, and restoration.
Author and monitor database maintenance scripts for optimal performance.
Research and evaluate new technologies for database management.
Develop and implement disaster recovery procedures.
Conduct analyses and generate reports based on findings.
Benefits
Free meal on shift.
Training & Development opportunities.
Comprehensive Health Care Plan (Medical, Dental & Vision).
Retirement Plan (401k).
Life Insurance options (Basic, Voluntary & AD&D).
Paid Time Off.
Free Parking.
Full 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
Requirements
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.
Benefits
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.
