Senior Database Administrator

Summary

Join ShiftKey as a Senior Database Administrator and design, implement, and maintain database systems to ensure optimal performance, availability, and security.

Requirements

• 6+ years of experience managing complex production database systems, ideally for a large consumer-facing internet site
• An associate or bachelor’s degree in a technical field such as Information/Data Systems is preferred
• Understanding of database patching and upgrade strategies, and the ability to enforce standards using tools and automation
• Expertise in database server tuning, query optimization, replication strategies, storage engines, monitoring, capacity planning, backup, and high availability (HA) solutions
• Ability to develop procedures, processes, and conventions to standardize database operations
• Solid understanding of security administration and policies
• Experience with scripting languages like PowerShell and Python for monitoring and custom automation
• Experience working with source code management tools like Git
• Familiarity with automated configuration management tools like Ansible and Terraform
• Experience with cloud-based systems or virtual environments, including AWS, Azure, and Google Cloud
• Familiarity with maintaining confidentiality and a willingness to operate in a HIPAA-compliant environment. Must be willing to learn how to design and follow procedures and write documentation to maintain compliance

Responsibilities

• Design, implement, and maintain database systems to ensure optimal performance, availability, and security
• Collaborate with cross-functional teams to develop and implement database solutions that meet business requirements and ensure data integrity
• Provide technical expertise, mentor junior administrators, and drive continuous improvement in database management practices
• Manage databases (PostgreSQL) in Production/QA/Dev environments, including handling installations, configurations, upgrades, and schema changes
• Provide best practices on database design, availability, replication, security, auditing, and backup/recovery methodologies
• Troubleshoot database issues to maintain system availability and scalability within production environments
• Perform capacity-planning exercises to identify the necessary hardware, software, and database configurations/architectures required to support application needs
• Support multiple Scrum teams to produce quality deliverables, meet deadlines, manage priorities effectively, and communicate progress
• Participate in an on-call rotation to respond to and resolve application issues, ensuring that production applications remain online

Benefits

• Comprehensive health, vision, and dental coverage
• Progressive PTO & Company-paid holidays with a broad selection of floating holidays to honor employees’ diverse needs
• 100% 401(k) employer match up to 6%
• Paid parental leave
• Investment in your wellness: access to mental health support