Senior Sql Database Administrator

DASH2
MI, United States
Full-time

Job Summary

As a Sr. Database Administrator, you will ensure the databases that support our technology systems perform efficiently and are designed to be highly available.

Responsibilities

  • Work with our developers and business analysts to create and modify our database structure
  • Monitor the performance of the database servers
  • On-call support on a rotation basis
  • Strong understanding and ability to configure and troubleshoot physical and logical replication in MySQL and / or PostgreSQL
  • Strong understanding and ability to configure and troubleshoot log shipping and Always-on HA solutions in SQL Server
  • Identify and resolve performance bottlenecks both in on-premises and cloud
  • Familiarity with deploying and managing MySQL and / or PostgreSQL, SQL Server in cloud environments (e.g., AWS, Azure, GCP), preferably AWS
  • Perform database maintenance tasks, including backups / restores, updating statistics, rebuilding indexes, etc.
  • Work with our data engineers to help map data in our production databases to our data warehouse
  • Maintain system security and data integrity
  • Work with our systems engineers to ensure optimal hardware and storage subsystems
  • Develop, manage, and maintain a strong disaster recovery and high availability plan
  • Install, upgrade, and patch the database servers
  • Participate in code and design reviews
  • Participate in production code pushes

Minimum Qualifications

  • Bachelor’s degree in computer science or business information systems, a related degree or equivalent experience
  • 5 years of relevant work experience
  • 2 years of experience with prod workload in AWS ecosystem
  • Experience with PostgreSQL 13 and / or MySQL 5.7 and above.
  • Experience with SQL Server 2016 and above
  • Experience with maintaining AWS RDS and Aurora instances
  • In-depth understanding of the database engine and strong performance tuning skills
  • Troubleshooting experience with MySQL and / or PostgreSQL, SQL Server high availability solutions
  • Strong experience working with Unix / Linux and Shell Scripting
  • Strong communication skills
  • Ability to work independently and with others in a team environment
  • Ability to prioritize tasks
  • Strong analytical and problem-solving skills
  • Troubleshoot service outages as they occur, including after hours and weekends.
  • Strong sense of personal accountability for results
  • Experience with Infrastructure as a code (IAC) such as terraform, or Cloud-formation is an added advantage
  • Familiarity with database CICD process, concept, and tools
  • Understanding of NoSQL databases is an added advantage

Preferred Qualifications

  • 1 year of experience with SQL Server T-SQL coding
  • 1 year of experience with SQL Server database administration
  • 1 year of experience with SQL Server Integration Services
  • 1 year of programming experience
  • Proficiency in the Microsoft Office suite
  • Proficiency in the Azure management platform
  • Proficiency in Microsoft SQL Server
  • 6 days ago
Related jobs
Promoted
DASH2
MI, United States

Database Administrator, you will ensure the databases that support our technology systems perform efficiently and are designed to be highly available. Familiarity with deploying and managing MySQL and/or PostgreSQL, SQL Server in cloud environments (e. Troubleshooting experience with MySQL and/or Po...

Promoted
Optomi
MI, United States

The Senior DBA will be responsible for supporting day-to-day operations and management of enterprise-level production database systems, both on-premise and in the cloud. Setup and optimize SQL Server standard and SQL AG. Candidates must be able to lead and mentor a team of engineers focused on deplo...

Promoted
Pan Asia Resources
Lansing, Michigan

The Database Administrator Specialist takes on the role of assisting with database structure and design, implementing, and maintaining the database environment, participating in enterprise efforts as needed, and ensuring compliance with security and integrity needs across the database environment. J...

Promoted
Rockwell Automation
Troy, Michigan

To support our ongoing growth, we are looking for a Senior Database Administrator with experience in SQL Server Administration and other data platform technologies (Preferred). Additional experience with any of the following: PowerShell, PostgreSQL, MongoDB, MySQL, Kafka, Druid, Terraform, Ansible, ...

Promoted
RKT Holdings
Detroit, Michigan

Troubleshooting experience with MySQL and/or PostgreSQL, SQL Server high availability solutions. Database Administrator, you will ensure the databases that support our technology systems perform efficiently and are designed to be highly available. Familiarity with deploying and managing MySQL and/or...

Promoted
SpartanNash
Byron Center, Michigan

Byron Center, Michigan 49315 Job Description: Responsible for performing database administration and overseeing the planning, design, administration, operation, and maintenance of all database systems. Provides technical guidance to the application development and production support teams on trouble...

Rockwell Automation
Troy, Michigan

To support our ongoing growth, we are looking for a Senior Database Administrator with experience in SQL Server Administration and other data platform technologies (Preferred). Additional experience with any of the following: PowerShell, PostgreSQL, MongoDB, MySQL, Kafka, Druid, Terraform, Ansible, ...

Masco Cabinetry
Livonia, Michigan

The Senior Database Administrator is responsible for managing smooth operations related to multiple Oracle Applications Database environments running on Real Application Cluster. Analyze and implement the physical database design and structure, ensure enterprise database environments are in optimal ...

Haavia, Inc.
Lansing, Michigan

As a senior Database & Services Administrator, the employee performs a complete range of information system database analyst assignments including, but not limited to, designing, developing, testing, and implementing database and related systems services for production, test, and development env...

Tyler Technologies
Troy, Michigan

The Senior DBA will be responsible for supporting day-to-day operations and management of enterprise-level production database systems, both on-premise and in the cloud. Setup and optimize SQL Server standard and SQL AG . Candidates must be able to lead and mentor a team of engineers focused on depl...