Sr. Database Reliability Engineer

Responsibilities

• Ownership of the health, uptime and performance of all PostgreSQL/Oracle/MySQL & Clickhouse databases
• Partner with internal customers to understand current challenges, plan/communicate improvements and anticipate future needs
• Develop code for automation of routine tasks by leveraging Python, bash, Ansible or a similar scripting language
• Engineer, deploy, maintain, and own all aspects of database monitoring
• Engineer, implement, and routinely test disaster recovery (DR) strategies
• Identify and optimize abusive queries to increase system efficiency
• Design and standardize detailed test conditions and test cases to ensure quality of queries and reports
• Research and troubleshoot data questions and provide support to our software developer teams
• Collaborate on problem resolution, team decisions, and project planning
• Develop strong documentation and support runbooks
• Document actions taken on and all configurations applied to database systems
• Support and foster the professional growth of other database engineering and administration staff via cross-training, coaching, and responsibility sharing
• Participate in an on-call rotation
• Act as a database design, optimization, and maintenance subject matter expert for various teams as they build out and troubleshoot their applications
• Automate database administration and implementation tasks and provide self-service solutions for customers

Requirements

• Bachelor’s degree in computer science, information systems, or engineering discipline and 8+ years of experience in IT; OR 10+ years of professional experience with database reliability or DevOps in lieu of a degree
• 8+ years experience in optimizing SQL queries and data replication
• 8+ years experience in developing monitoring tools and tuning databases

Basic Requirements

• Expertise in at least two database technologies (i.e. MSSQL , MySQL, Postgres, Oracle, Clickhouse, Apache Iceberg etc.)
• Strong attention to detail, high degree of accuracy, excellent oral and written communication skills, strong interpersonal skills, and the ability to meet deadlines
• Experience with highly available solutions and clustered environments
• Experience with Oracle RAC, RMAN, Barman and similar backup/troubleshooting technologies
• Experience working with enterprise resource planning (ERP) systems
• Have a working knowledge and provide basic support for MS SQL and Windows Server
• Experience with GIT and Python
• Machine learning experience
• Big Data experience

Additional Requirements

• Must be able to work extended hours and weekends as needed