AnnArborRecruiter Since 2001
the smart solution for Ann Arbor jobs

Data Platform Engineer

Company: Mojo Trek
Location: Ann Arbor
Posted on: January 26, 2023

Job Description:

COMPANY DESCRIPTION

Mojo Trek, an Inc. 5000 company, delivers an unparalleled recruitment experience, grounded in transparency and integrity. From midsize technology innovators to Fortune 50 powerhouse corporations, we help our clients build technology teams that make a difference, push the change forward, and develop software critical to their success.

Our client, a Fortune 1000 company, creates software that is used in over 17,000 stores that depend on the technology to ensure consumers and businesses alike can order and operate efficiently. The website and mobile apps developed by the teams consistently challenge the status quo of not only the technology in their field, but beyond.

RESPONSIBILITIES



  • 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


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


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


  • Implement new database technologies introduced by SQL SERVER to improve the performance and throughput of the database and increase the availability and reliability on the SQL Server environment.


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


  • Document the company's database environment


  • Install and administer other SQL Server technologies including Analysis Service and Integration Service


  • Engage with app developers to guide them through the design of databases models, tables and database containers etc.



    QUALIFICATIONS



    • 2-3 years of DBA experience with SQL Server platform


    • At least 2-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


    • Nice to have 1-2 years of deployment and production operations experience with NoSQL/NewSQL platforms such as Couchbase, Cassandra, PostgreSQL, MySQL etc.


    • Experience working on SQL Server AlwaysOn Availability Groups (AAG) and Distributed AAG (DAAG) setup and operations


    • Previously or currently managing operations of large databases (5-8TB)


    • Helpful to have worked on both transactional and warehouse database environments


    • Experience with batch and PowerShell scripting


    • Production operations management experience with managing Hadoop environment


    • Nice to have experience with Python scripting

Keywords: Mojo Trek, Ann Arbor , Data Platform Engineer, Engineering , Ann Arbor, Michigan

Click here to apply!

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

I'm looking for
in category
within


Log In or Create An Account

Get the latest Michigan jobs by following @recnetMI on Twitter!

Ann Arbor RSS job feeds