Senior Database Engineer

Our client is looking to hire an experienced database professional to join their growing team. The right candidate will have extensive experience with PostgreSQL databases, both on-premise and in the cloud.

They will be comfortable working in a highly collaborative, DevOps culture working across the technology organization.

Responsibilities

Responsible for designing, implementing, and maintaining critical database systems (PostgreSQL) which support a growing 24x7 SAAS platform

Ensures the database design and operations support the availability, scalability, and recoverability needs of the business

Performs tuning and capacity management to ensure the database meets the performance needs of the business

Guides and provides direction to developers and engineers on database development, design principles, query optimization, and index management in a fully automated deployment pipeline

Provide support for development and testing including test data setup, automated testing scenarios, and dev / test environment data refreshes

Research and evaluate emerging database technologies and trends to enhance the use of data and databases within the organization

Provides leadership for all policies and procedures that govern data operations, security, management and usage

Accountable for complying with HIPAA security policies within the database platform

Provides on-call coverage for production support and manage

Requirements

BS degree in Information Systems, Engineering, or equivalent

7+ years experience with relational database administration

3+ years experience administering highly-available PostgreSQL databases

Expert in RDBMS principles, database design and normalization

Expert in PostgreSQL database architecture, concepts, features, and high-availability technologies

Expert in query optimization, indexing knowledge, modeling basics, materialized views and partitioning

Expert with PL / PgSQL, triggers, and stored procedure development and optimization in PostgreSQL

Proficiency with operating PostgreSQL in a Linux environment

Experience with .NET clients using npSQL a plus

Experience with RDBMS in the cloud a plus

Experience with Oracle and MS SQL Server a plus

Experience with agile software development and DevOps principles a plus

Displays an entrepreneurial instinct for identifying value and pragmatic solutions

Ability to manage diverse activities simultaneously, delivering on commitments and operating with speed, accuracy and strong judgment

Ability to operate independently as well as influence across the technology organization

Strong project management skills and detail oriented