Job Id : 1138
Jobtitle : SQL Database Administrator
Location : Ann Arbor, MI
Company Name : Dominoâs
Industry : Information Technology
Salary : $50,000 - $80,000 YEAR
Job type : Fulltime
Posted on: 2019-07-01
Required Skills : Engineering, Information Technology, Design
Benefits : No benefits are available
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.
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.
DISH Englewood, CO
Job Description: Seeking a Junior Software Developer who will develop automated test scripts to ...
Simplion Technologies Inc Pleasanton, CA
Job Description: Core expertise lies in managing and leading high-performing global software ...
Simplion Technologies Inc Santa Clara, CA
Job Description: Required Expertise: Strong understanding of computer science ...
Iconvergence Solutions Kirkland, WA
Responsibilities: Define and develop the technical specifications, functional requirements, ...
Iconvergence Solutions Bellevue, WA
Job Description : Required Skills: SDETs (Java/Selenium) CI/CD Financial domain ...
We’re an equal opportunity provider.
All applicants will be considered for employment without attention to race, color, religion, sex, sexual orientation, gender identity, national origin, veteran or disability status.
OPTnation.com is not a Consulting Company/Training Company/H1B Sponsor.