What are the responsibilities and job description for the Database Administrator- IT- Full Time position at Ocean Casino Resort?
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.
Salary : $87 - $122