SQL Server Database Administrator in Ann Arbor, MI at Fast Switch

Date Posted: 12/22/2019

Job Snapshot

Job Description

Job ID: 55344

SQL Server Database Administrator - 55344

  • Our company continues its journey towards the dominant #1 pizza company in the world and sound data is the most fundamental of assets that helps us drive towards that.
  • To help accelerate out drive, we are looking for a driven Data Platform Engineer to join our team at World Resource Center (WRC) in Ann Arbor, MI.

Job Duties:

  • Manage Microsoft SQL Server environment supporting transactional systems, enterprise data warehouse environment and other critical business applications
  • Install, configure, administer and maintain database servers and processes, including monitoring of system health and performance, to ensure highest levels of performance, availability, and security.
  • Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations
  • Help analyze, solve, and correct issues in real time, providing problem resolution end-to-end.
  • Refine and automate regular operational processes, track issues, and document changes.
  • Assist developers with complex query tuning and schema refinement.
  • Perform scheduled maintenance and support release deployment activities.
  • Install/upgrade/configure SQL Server 2012 - 2017.
  • Configure and deploy High-Availability and Disaster Recovery solutions for critical applications to meet SLA’s and limit the outage within the given RPO / RTO.
  • Configuring SQL SERVER Always-On Availability Groups in SQL 2012/2014/2016/2017 for High Availability of database servers as a part of disaster recovery solution.
  • Apply Critical Patch updates and Patch Set Upgrades to the SQL Server environments.
  • Responsible for day-to- day database support and maintenance activities, such as database backups, restores for development env to mission-critical production systems to meet or exceed business and IT needs.
  • Responsible for ongoing database management including but not limited to Query Store monitoring, statistics updates, index management, partition management, data archival etc.
  • Setup and Design of backup and recovery solutions, according to Disaster Recovery scenarios, Plan and Document specifications.
  • Provide support for the client applications and solve client issues.
  • Document the company’s database environment
  • Install and administer other SQL Server technologies including Analysis Service and Integration Service
  • Provide 24/7/365 support of the environment thru on-call rotation
  • Administer and manage Hadoop and Big Data environment – Ambari, Yarn, Spark, Kafka etc.
  • Help operationalize and manage newer NoSQL/NewSQL data platforms for transactional and analytical workloads
  • On-going database support.

Experience Required:

  • Database platform production operations experience with SQL Server 2012 – 2017
  • SQL Server AlwaysOn Availability Groups (AAG)
  • Transactional and warehouse database environments
  • 3-5 years of IT experience (or 2 years of IT experience with Master’s degree in Computer Science)
  • At least 2 to 3 years of DBA experience with SQL Server platform
  • At least 2 to 3 years of hands-on production operations management experience with SQL Server 2016/2017
  • At least 2 years of operations and management experience with data warehouse and/or online transactional environments

Experience Preferred:

  • Knowledge on Distributed AAG (DAAG) setup and operations
  • Knowledge on operations of large (8 TB+) databases
  • Experience with batch and PowerShell scripting
  • Production operations management experience with managing Hadoop
  • Production operations management experience with managing NoSQL / NewSQL data platforms
  • Python scripting

Skills Required:

  • Team player and the ability to work in a collaborative environment
  • Highly resourceful and creative in fulfilling the job requirements
  • Ability work independently with limited management
  • Share knowledge and technical expertise, providing technical mentorship and cross-training to other team members
  • Great communicator

At Fast Switch, Our Purpose is Our People and Our Planet. We come to work each day and are reminded we are helping people find their success stories.  Isn’t that cool? Also, Doing the right thing is our mantra.  We act responsibly, give back to the communities we serve, and have a little fun along the way.

We at Fast Switch have been doing this for 22 years. We’re doing business in almost half the states in the union with offices in Detroit, MI, Columbus, OH, New York, Hartford, CT, Massachusetts, Minneapolis, MN, Los Angeles, CA, San Francisco, CA, and Tucson, AZ.

We're a financially strong, privately-held company that is 100% consultant and client focused.

We've differentiated ourselves by being fast, flexible, creative and honest. Throw out everything you've heard, seen, or felt about every other IT Consulting company. We do unique things, and we do them for Fortune 10 companies, Inc. 500 companies, and technology start-ups. We also have a strong belief in giving back to the communities we serve.

Our benefits are second to none and thanks to our flexible benefits options you can choose just the benefits that you need or want, options include:

• Medical and Dental (Fast Switch pays majority of the medical program)

• Vision

• Personal Time Off (PTO) Program

• Long Term Disability (100% paid)

• Life Insurance (100% paid)

• 401(k) with immediate vesting and 3% (of salary) dollar-for-dollar match

Plus, we have a lucrative employee referral program and an employee recognition culture.

In 2013, 2014, 2015, 2016, 2017 and 2018, Fast Switch was named one of the Top Work Places in Michigan by the Detroit Free Press and one of the Best Staffing Firms in 2016 and 2017. We have won the Columbus Business First “Fast 50” award 9 times in 12 years because of our strong growth which translates into more and better opportunities for our consulting staff members.

Ranked '#1' supplier by over 50% of our customers nationally.

Ranked 'Top 3' supplier by over 75% of our customers nationally.

 To view all of our open positions, please go to: www.fastswitch.com and at the bottom of the page click Job Portal, or get there directly at: https://www.jobs.net/jobs/fastswitch/en-us/all-jobs/

You can also follow us on Twitter at: www.twitter.com/fastswitch

And you can become a fan of Fast Switch on Facebook at: http://tinyurl.com/y9y3gdp