Senior Database Engineer & Architect (SQL) (PX)

<p><span>As a Senior Database Engineer &amp; Architect (SQL), you will play a key role in </span><strong><span>designing, optimizing, and scaling</span></strong><span> our database infrastructure. You will collaborate closely with engineers, data analysts, and product teams to improve the current database architecture and build new high-performance, scalable, and secure databases tailored to our business needs.</span></p><p></p><ul><li><p><span>Design, develop, and optimize highly scalable database architectures with a focus on </span><strong><span>PostgreSQL</span></strong><span>.</span></p></li><li><p><span>Lead the </span><strong><span>migration, optimization, and restructuring</span></strong><span> of existing databases to ensure efficiency and scalability.</span></p></li><li><p><span>Implement and enforce database best practices, including indexing, partitioning, query optimization, and normalization.</span></p></li><li><p><span>Define and execute </span><strong><span>high-availability and disaster recovery</span></strong><span> strategies.</span></p></li><li><p><span>Develop and maintain </span><strong><span>ETL pipelines</span></strong><span> and data processing workflows.</span></p></li><li><p><span>Work closely with engineering teams to ensure efficient database schema design and support the development of new features.</span></p></li><li><p><span>Monitor and troubleshoot database performance, identifying and resolving bottlenecks.</span></p></li><li><p><span>Ensure data security and compliance with industry standards, implementing encryption, access control, and auditing policies.</span></p></li><li><p><span>Optimize stored procedures, triggers, and functions for maximum efficiency.</span></p></li></ul><p></p><h4><strong><span>Technology Stack:</span></strong></h4><ul><li><p><strong><span>Database:</span></strong><span> PostgreSQL (Primary), AWS RDS, SQL.</span></p></li><li><p><strong><span>Big Data &amp; ETL:</span></strong><span> Apache Kafka, Airflow, dbt, Snowflake (nice to have).</span></p></li><li><p><strong><span>Performance Optimization:</span></strong><span> Indexing, Partitioning, Query Optimization, Caching.</span></p></li><li><p><strong><span>Security:</span></strong><span> Data Encryption, Role-Based Access Control (RBAC), Auditing.</span></p></li><li><p><strong><span>Tools &amp; DevOps:</span></strong><span> Liquibase, Flyway, Terraform, Kubernetes (for DB management).</span></p></li><li><p><strong><span>Scripting &amp; Programming:</span></strong><span> SQL, PL/pgSQL, Python, Bash.</span></p></li></ul><ul><li><p><strong><span>Methodologies:</span></strong><span> Agile, Scrum.</span></p></li></ul><p></p><h4><strong><span>What Twisto can offer:</span></strong></h4><ul><li><p><strong><span>Meaningful work &amp; impact - </span></strong><span>Your solutions will shape Param Group’s AI strategy and directly influence our products and internal processes.</span></p></li><li><p><strong><span>Flexibility -</span></strong><span> Fully remote; an office is available if you’re near one of our locations.</span></p></li><li><p><strong><span>Learning culture -</span></strong><span> Work alongside fintech experts, experiment with new tech, and keep growing</span><strong><span>.</span></strong></p></li><li><p><strong><span>Modern tech stack - </span></strong><span>AWS, PostgreSQL, Kafka, Airflow, dbt, Snowflake, and more.</span></p></li></ul> <h3>Requirements</h3> <ul><li><p><strong><span>5+ years of experience</span></strong><span> as a </span><strong><span>Database Developer or Database Architect</span></strong><span>, focusing on PostgreSQL.</span></p></li><li><p><span>Proven expertise in designing, optimizing, and managing </span><strong><span>large-scale, high-performance databases</span></strong><span>.</span></p></li><li><p><span>Strong knowledge of </span><strong><span>AWS database services </span></strong><span>(RDS, Aurora, EC2-based PostgreSQL instances) and </span><strong><span>on-premise PostgreSQL</span></strong><span> deployments.</span></p></li><li><p><span>Experience implementing HA (High Availability) &amp; replication strategies (e.g., Patroni, PgBouncer, Streaming Replication).</span></p></li><li><p><span>Deep understanding of query optimization, partitioning, indexing, caching, and concurrency control.</span></p></li><li><p><span>Proficiency in backup/recovery strategies and disaster recovery planning.</span></p></li><li><p><span>Hands-on experience with </span><strong><span>CI/CD pipelines</span></strong><span> and </span><strong><span>Infrastructure as Code</span></strong><span> tools like Terraform, Ansible, or AWS CloudFormation.</span></p></li><li><p><span>Experience in </span><strong><span>database security</span></strong><span>, </span><strong><span>ETL pipelines and data warehousing</span></strong><span>.</span></p></li><li><p><span>Proficiency in </span><strong><span>SQL, PL/pgSQL</span></strong><span>, and scripting languages like </span><strong><span>Python</span></st