AnnArborRecruiter Since 2001
the smart solution for Ann Arbor jobs

SQL Database Administrator/ SQL Server DBA

Company: IT Associates, Inc.
Location: Ann Arbor
Posted on: February 16, 2020

Job Description:

Please call for more details- 630.948.3231 SQL Database Administrator6+ months Contract or contract to hire Ann Arbor,MI Rate : w2 or c2c Phone + On-site interview or SkypeNo Visa restriction!Resposnsibilities-Manage Microsoft SQL Server environment supporting transactional systems, enterprise data warehouse environment and other critical business applicationsInstall, 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 expectationsHelp 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 environmentInstall and administer other SQL Server technologies including Analysis Service and Integration ServiceProvide 24/7/365 support of the environment thru on-call rotationAdminister 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 workloadsSkills Required-Database platform production operations experience with SQL Server 2012 2017MUST have worked on SQL Server AlwaysOn Availability Groups (AAG)MUST have worked on both transactional and warehouse database environmentsNice to have knowledge on Distributed AAG (DAAG) setup and operationsNice to have knowledge on operations of large (8 TB+) databasesNice to have experience with batch and PowerShell scriptingNice to have some production operations management experience with managing HadoopNice to have some production operations management experience with managing NoSQL / NewSQL data platformsNice to have experience with Python scriptingQualifications3-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 platformAt least 2 to 3 years of hands-on production operations management experience with SQL Server 2016/2017At least 2 years of operations and management experience with data warehouse and/or online transactional environmentsTeam player and the ability to work in a collaborative environmentMust be highly resourceful and creative in fulfilling the job requirementsMust be able to work independently with limited managementShare knowledge and technical expertise, providing technical mentorship and cross-training to other team membersMust be a great communicator - provided by Dice

Keywords: IT Associates, Inc., Ann Arbor , SQL Database Administrator/ SQL Server DBA, IT / Software / Systems , Ann Arbor, Michigan

Click here to apply!

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

I'm looking for
in category
within


Other IT / Software / Systems Jobs


System Administrator
Description: IT Systems Administrator By joining JAC Products as our IT Systems Administrator, you can experience our unique culture first hand. In this position, you will have the opportunity to oversee server and (more...)
Company: JAC Products
Location: Britton
Posted on: 02/26/2020

Software Quality Assurance Engineer
Description: Quality Engineer Entrega is a leading provider of Application Design, Development and Delivery services to global clients. Our team of professionals use their expertise and experience to deliver results (more...)
Company: Entrega
Location: Troy
Posted on: 02/26/2020

Android Application Software Developer
Description: About GM br There's never been a more exciting time to work for General Motors. To achieve our vision of a world with Zero Crashes, Zero Emissions and Zero Congestion, we need people to join us who (more...)
Company: General Motors
Location: Detroit
Posted on: 02/26/2020


System Administrator
Description: IT Systems Administrator By joining JAC Products as our IT Systems Administrator, you can experience our unique culture first hand. In this position, you will have the opportunity to oversee server and (more...)
Company: JAC Products
Location: Saline
Posted on: 02/26/2020

Senior iOS Developer
Description: As a Software Developer at United Shore you will work in a fast paced, results driven environment and be responsible for building a highly scalable enterprise application. ul li Develop mobile applications (more...)
Company: United Shore
Location: Pontiac
Posted on: 02/26/2020

Junior Software Developer
Description: Revature is the fastest growing employer of emerging technology talent in the US and we are currently looking to hire over 100 new Software Engineers.Our Software Engineers design, analyze
Company: Revature
Location: Troy
Posted on: 02/26/2020

Agile technical Coach
Description: Bachelors Degree in Computer Science, Information Technology, or related area required. - Requires 6-8 years of experience in a related area. Experience with simple design practices and story decomposition (more...)
Company: KYYBA Inc
Location: Auburn Hills
Posted on: 02/26/2020

Entry Level Software Engineer
Description: Revature is the fastest growing employer of emerging technology talent in the US and we are currently looking to hire over 100 new Software Engineers.Our Software Engineers design, analyze
Company: Revature
Location: Dearborn
Posted on: 02/26/2020

Front End Developer (Entry Level)
Description: In the next 4 weeks, Revature is looking to hire over 300 Front End Developers-- across the country. We are the largest employer of emerging tech talent.One day someone is going
Company: Revature
Location: Troy
Posted on: 02/26/2020

Automotive Technical Author
Description: The Technical Service Author is responsible for the prioritization, authoring and delivery of technical repair procedures via service actions to Service Technicians that support the organization. - Responsibilities (more...)
Company: Brightwing
Location: Auburn Hills
Posted on: 02/26/2020

Log In or Create An Account

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

Ann Arbor RSS job feeds