the smart solution for Buffalo jobs

Database Administrator - SQL Server

Company: Delaware North
Location: Buffalo
Posted on: November 9, 2018

Job Description:

Our Exciting Work EnvironmentThis position will be based out of Delaware North s new global headquarters, a state-of-the-art, 12-story, mixed-use building in downtown Buffalo, N.Y. The headquarters facility, reflective of our values, integrates the latest advances in environmental, energy conservation and office design. The OpportunityPerform normal database administration tasks to monitor performance, maintain databases and implement upgrades as needed, keeping current of changes for vendor, security and platform releases. Administer a collection of -250 servers & -600 point-of-sale workstations running Microsoft SQL Server housed on physical servers, on premise virtual appliances and in the Amazon AWS cloud. Install and configure new database Servers including MSSQL, AWS RDS, etc. Manage production environment to ensure high availability, good performance and sufficient capacity. Perform system support and maintenance functions. Develop and maintain standard documentation for system configuration and support. Maintain database schemas, query logic and report definitions for various in-house-developed/focused applications. Manage vendor relationship(s). Work closely with vendor(s) to complete project and for resolution of problems. Ensure all database servers are backed up in a way that meets the business s Recovery Point Objectives (RPO). Test backups to ensure we can meet the business Recovery Time Objectives (RTO). Provide direction and guidance to design, integrate and implement systems supporting company and systems initiatives. Ability to participate in business meetings. Collate asset and budget raw data for annual IT budget recommendations to present to business leadership. Participate in preparation efforts and implementation of annual PCI audit. Investigate and remediate reports of sensitive data stored unencrypted in databases or throughout computer file systems. Document, maintain and provide strategic changes to the company s database standards/best practices. Document the company s database environment. Identify and design new database architectures as new systems are brought in-house. Installing and hardening database environments to meet project, application and industry standards/specifications. Provide on-call 24/7 support for database including after-hours and weekends. Cursory troubleshooting and resolving of database performance issues ranging from indexing issues, system misconfiguration or application coding issues working with application vendors. Configure SQL Server monitoring utilities to minimize false alarms. Oversee junior resources as needed.Requires 3 - 5 years with the following:

  • Microsoft SQL Server, SSIS, SSRS
  • MySQL
  • PostGreSQL
  • Amazon AWS RDS, RedShift, EC2 and S3
  • MongoDB
  • VMware
  • PowerShell, Python and/or other scripting languages
  • Automation, development or DevOps experience Who We AreTake your career beyond the ordinary to the extraordinary.At Delaware North, you ll love where you work, who you work with, and how your day unfolds. Whether it s in sporting venues, casinos, airports, national parks, iconic hotels, or premier restaurants, there s no telling where your career can ultimately take you. We empower you to do great work in a company with 100 years of success, stability and growth. If you have drive and enjoy the thrill of making things happen - share our vision, grow with us.Delaware North is one of the largest and most admired, privately-held hospitality companies in the world. Founded and owned by the Jacobs family for nearly 100 years, it is a global leader in hospitality and food service with operations in the sports, travel hospitality, restaurants and catering, parks, resorts, gaming and specialty retail industries. Delaware North has annual revenue exceeding $3 billion with 60,000 employee associates. To learn more, visit .All applicants will be subject to a pre-employment background check and may be subject to a pre-employment drug test depending upon the position and/or client requirements.Delaware North Companies, Incorporated and its subsidiaries consider applicants for all positions without regard to race, color, religion, creed, gender, national origin, age, disability, marital or veteran status, sexual orientation, or any other legally protected status. Delaware North is an equal opportunity employer. #LI-PE1 Associated topics: data analyst, data center, data integration, data integrity, data scientist, database administrator, etl, erp, hbase, teradata

    Keywords: Delaware North, Buffalo , Database Administrator - SQL Server, IT / Software / Systems , Buffalo, New York

    Click here to apply!

    Didn't find what you're looking for? Search again!

    I'm looking for
    in category

Other IT / Software / Systems Jobs

25B Information Technology Specialist
Description: 25B Information Technology Specialist Job ID: Job Views: 43 Location: NIAGARA FALLS, New York, United States ZIP Code: 14304 Job Category: Signal and Military Intelligence Posted: 11.12.2018 Age Requirements: (more...)
Company: Army National Guard
Location: Niagara Falls
Posted on: 11/18/2018

Software Developers, Analysts
Description: Indotronix International Corporation seeks Software Developers
Company: Indotronix
Location: Rochester
Posted on: 11/17/2018

Description: Revature is the fastest growing employer of emerging technology talent in the US and we are currently looking to hire over 100 new Software Engineers. Our Software Engineers design, analyze and build (more...)
Company: Revature
Location: Rochester
Posted on: 11/18/2018

Earn 800-1200 Weekly as a Health Rep working from Home. Computer and Phone are a must
Description: Comprehensive full training is provided and an excellent
Company: Jumpstart consult
Location: Erie
Posted on: 11/17/2018

Software Test Engineer
Description: Description of Job Duties: br The Colleague Ethos API team is looking for a Software Test Engineer. Successful canidates will lead the team's end-point test automation efforts. Exciting opportunity (more...)
Company: Ellucian Inc
Location: Rochester
Posted on: 11/17/2018

Field Service Engineer - New York
Description: Field Service Engineer - New York Job DescriptionWhen you re part of the team at Thermo Fisher Scientific, you ll do important work, like helping customers in finding cures for cancer, protecting the (more...)
Location: Rochester
Posted on: 11/17/2018

Current College Students - Tech & Computer Science Tutor (more than $1k+/mo)
Description: Varsity Tutors is looking to contract with tutors to connect with clients across a variety of academic subjects
Company: Varsity Tutors
Location: Buffalo
Posted on: 11/17/2018

C# Tester
Description: Job Title C TesterWork Location Erie, PA
Company: HUMAC INC.
Location: Erie
Posted on: 11/18/2018

Teamcenter Lead Developer
Description: Teamcenter Lead DeveloperLocation: Erie, PA12 Months 7-8 Years of Exp.Expertise in design, development
Company: Systel,Inc.
Location: Erie
Posted on: 11/17/2018

Product Tester at Home. $25hr-$45hr. No Experience Required. Part-time
Description: In-Home Usage Tester Product Tester--from--home Part-timePresently we're recruiting Product Testers from home in several US cities--to expand our private network of In-Home Usage Testers IHUT to (more...)
Company: American Consumer Panels
Location: Buffalo
Posted on: 11/18/2018

Log In or Create An Account

Get the latest New York jobs by following @recnetNY on Twitter!

Buffalo RSS job feeds