Description
. PostgreSQL DBA experience in a 24x7 production environment . 7+ years of database management and engineering experience . Exceptional SQL development and performance tuning skills . Experience architecting a large-scale production database platforms . Expertise with Postgres system metrics and optimization strategies . Familiarity with system level metrics and practical use of common Linux utilities . Mastery of one of the following scripting languages: Python, Perl, Bash . Understanding of virtualization and clustered environments . Proactively monitoring database performance and troubleshooting issues . Working cross-functionally with our engineers and analytics professionals to optimize queries, fix performance bottlenecks, improve existing schemas and design new ones . Creating and maintaining change control and testing processes, reviewing and approving database modifications . Conducting research and making recommendations on data-related products, services, protocols, and standards planning for future growth of our data asset . Reviewing development and deployment processes related to databases and identifying areas of improvement (such as online schema changes) . Creating and maintaining documentation, troubleshooting playbooks, testing failover and recovery plans . Great communication skills and a passion for both troubleshooting and learning
Skills
- Linux