Senior Cloud Data Base Administrator

US-MI-Ann Arbor
# Positions
1
Category
Current Opening

Overview

The Senior Cloud Data Base Administrator (DBA) is responsible for providing oversight and technical support for the database environment including overseeing the administration, development and organization of the databases, and the assessment and implementation of new technologies.

The Senior DBA works with our Center for Connected Health team to develop technical solutions to address complex problems that require the regular use of ingenuity and creativity. This role requires interaction with core software development team members to deliver robust and scalable database platform infrastructure.

Responsibilities

  • Support the database system in an AWS environment
  • Implement auto scaling, data distribution, cluster and query performance tuning methods, near real time data sync capabilities.
  • Serves as lead point of contact for cloud database issues
  • Evaluate and address database performance and data audit requirements for application development projects
  • Standardize and manage Database Administrator procedures for monitoring database performance, testing, archiving, and optimizing
  • Design and implement processes and standards for database systems recovery and back-up checks, as well as user performance and data security
  • Work as part of the production team and with the project managers to coordinate data development and determine project scope to optimize the efficiency of the organization’s business processes and manage projects to successful completion

Qualifications

  • Must have extensive database management experience
  • Must have experience in supporting Linux and Unix database environments
  • Extensive experience of designing schemas for OLTP & OLAP databases using PostgreSQL database solutions.
  • Experience porting from an Oracle environment to PostgreSQL
  • Strong work experience with cloud based database environments preferably AWS cloud
  • Good working experience of PL/SQL
  • Hands-on experience in using cloud watch and other management/monitoring tools, utilizing dashboards to address and manage system health, improve end user performance
  • Strong problem solving and multi-tasking skills (technical and non-technical)
  • Working experience on PostgreSQL database
  • Good knowledge of PostgreSQL backup and recovery scenarios
  • Ability to write Python, PowerShell and Unix Shell (Bash, K, C) scripts for build and deployment automation
  • Good knowledge of data analysis tools, ETL process in AWS (Athena, Data Pipeline, Lambda)
  • Ability to commit and deliver measure result with tight projects and task timeline
  • Bachelor's Degree from an accredited institution

Options

Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed

Connect With Us!

Not ready to apply? Connect with us for general consideration.