MS SQL Server DBA

Job description: MS SQL Server DBA 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

• 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
• Travel to/from work and on-site attendance to perform the position responsibilities and the essential functions of the job

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
• 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.