Description

Job Overview: Installs, monitors, and maintains production database while ensuring high levels of data availability. Ensures the integrity and availability of databases and their accompanying software by developing, implementing, and overseeing database policies and procedures. Coordinate and assist other IT teams in the design, development, and enforcement of security standards that align to MICS with respective areas of responsibility. Provide guidance and direction for the protection of information systems assets to the IT management team.

Job Duties:

• Designs and implements redundant systems, policies, and procedures for disaster recovery

  and data archiving to ensure effective protection and integrity of data assets.

• Assesses and develops long-term strategic goals for production databases in conjunction with data owners and department managers.
• Assists with the implementation of new databases ensuring that standards, policies, and procedures are met or exceeded.
• Patches, upgrades, proactive/reactive maintenance, supporting the app dev team (performance tuning, SQL dev), war rooms, and incident restoration.
• Provide Level 3 support for 24x7 business operations including on-call.
• Tune performance and resolve availability issues of product or service and its dependencies.
• Develops, documents, and performs tasks needed to integrate new technologies into existing database environments in coordination with senior Team members.
• Manage all database instances across development, staging, and production environments, handling installation, configuration, and maintenance.
• Skilled in establishing a mechanism to harden the database environment conforming to Center for Internet Security standards.
• Plans and coordinates data migrations between systems.
• Researches and makes recommendations on database products, services, protocols, and standards.
• Refine and automate regular processes, track issues, and document changes.
• Perform technical tasks using both standard and non-standard analysis, design, programming methods, and relational database management techniques.
• Perform Database backup/recovery - Optimizing stored procedures, and indexing.
• Optimize database performance using advanced techniques.
• Familiar with SQL reporting services including creating, modifying, and managing custom reports.

Outstanding Benefits & Awesome Perks: Enjoy competitive weekly pay, outstanding benefits, and advancement opportunities. Generous benefits include medical, dental, life and disability insurance, onsite medical clinics and pharmacy, 401(k) retirement plan, paid time off, wellness programs, and more. Plus, take advantage of perks like discounts on childcare, fuel, bus passes and fitness membership, free uniforms, free uniform cleaning, and tuition reimbursement.

Who We Are: Mystic Lake Casino Hotel® and Little Six Casino® are owned and operated by the Shakopee Mdewakanton Sioux Community (SMSC). SMSC has a diverse collection of enterprises on its lands in Prior Lake and Shakopee, Minnesota. From Mystic Lake Casino Hotel, Little Six Casino, and Mystic Lake Center® to natural grocery stores and fitness centers, our enterprises help drive the local economy.

SMSC has donated more than $350 million to organizations and causes and has contributed millions more to regional governments and infrastructure such as roads, water and sewer systems, and emergency services. The SMSC is the largest philanthropic benefactor for Indian Country nationally and one of the largest charitable givers in Minnesota.

We are committed to inspiring possibilities, fostering meaningful connections and creating memorable experiences for our guests. We welcome all voices and encourage innovation. We’re always looking for talented people to join our community. You’ll be part of a fun, connected team that values your skills and supports you as you grow. Stay connected with us at mysticlake.com/careers

Qualifications

Knowledge of SQL reporting services including creating, modifying, and managing custom reports.