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!
|