Proof of authorization to work in the United States
Bachelor’s or Master’s degree in Computer Science, Information Systems, or a related field
Must be able to obtain and maintain any certification or license, as required by law or policy
10+ years of relevant experience
5+ years of experience in database engineering, with a focus on PostgreSQL and scalable data architectures
Extensive knowledge of database design principles, normalization, and development methodologies
Proficiency in PostgreSQL, including advanced features such as partitioning, replication, and performance tuning
Demonstrated experience working closely with application developers to ensure collaborative refinement and implementation of data models and queries
Deep understanding of relational and NoSQL databases, including database design and data modeling
Experience with PostgreSQL performance tuning, query optimization, and monitoring tools (e.g., pg_stat_statements, pgBadger)
Demonstrated experience implementing database schema version control tools such as Flyway or Liquibase or AtlasGO
Strong hands-on expertise in PostgreSQL replication including configuration and management of backup tools like pgBackRest or Barman as well as designing and executing failover strategies
Knowledge of containerized deployments (Docker, Kubernetes) and infrastructure-as-code tools (Terraform, Ansible)
Familiarity with CI/CD pipelines and database version control tools (e.g., Flyway, Liquibase)
Exposure to analytics and reporting tools that integrate with PostgreSQL
Responsibilities
Define and drive the architectural vision and design principles for PostgreSQL database systems and Kafka Messaging systems ensuring they are scalable, maintainable, and aligned with business goals
Optimize PostgreSQL performance through query tuning, indexing strategies, and configuration adjustments
Manage database replication, backup, and recovery processes using PostgreSQL-native tools and third-party solutions
Monitor database health and proactively address performance bottlenecks and system anomalies
Collaborate with application developers to design efficient data models and support application performance
Ensure database security, access control, and compliance with data governance policies
Support PostgreSQL upgrades, patching, and migration efforts across environments
Lead the technical direction and innovation of database architecture and management efforts
Drive initiatives for process improvements within the engineering team to enhance productivity, collaboration, and data quality
Implement and operate observability: Prometheus/Grafana dashboards, alerting policies, and centralized logging/tracing
Create runbooks, available for on-call rotations, triage incidents, and drive blameless post-incident reviews
Perform job duties in a safe manner
Attend work as scheduled on a consistent and regular basis