Get your dream job within 2 days (HURRY UP)ENROLL NOW
+

SQL Database Administrator

Domino’s – Ann Arbor, MI



Engineering, Information Technology, Design



Salary : $50000 - $80000  / YEAR

Manage Microsoft SQL Server environment supporting transactional systems, enterprise data warehouse environment and other critical business applications

Review and analyze business requirements and define system specifications.

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.

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.

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

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

Administer and manage Hadoop and Big Data environment – Ambari, Yarn, Spark, Kafka etc.

Design, install, configure, and maintain NoSQL/NewSQL database clusters (Cassandra, PostgreSQL, MySQL, etc.) for transactional and analytical workloads

Establish standards and best practices for operating a high-performance and highly available NoSQL/NewSQL database such as Cassandra, PostgreSQL, MySQL etc.

Qualifications

8-10 years of IT experience (or 6 years of IT experience with Master’s degree)

At least 4 to 6 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

1-2 years of deployment and operations experience with Hadoop technologies

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

Database platform production operations experience with SQL Server 2012 – 2017

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

Production operations management experience managing NoSQL / NewSQL data platforms such as Cassandra, PostgreSQL, MySQL etc.

Recommended jobs for you

  • Research Assistant

    University of Michigan Ann Arbor, MI

    View Job
  • Research Analyst

    University of Michigan Ann Arbor, MI

    View Job
  • Statistician Senior

    University of Michigan Ann Arbor, MI

    View Job
  • Research Support Programmer Intermediate / Associate

    University of Michigan Ann Arbor, MI

    View Job
  • Database Analyst / Prgm Inter

    University of Michigan Ann Arbor, MI

    View Job

Thanks For Your Feedback

Attach A Resume First