Pine Labs - MS SQL/DBA Expert - PostgreSQL (5-12 yrs)

Job Description - Senior Engineer DBA (IC)

We at Pine Labs are looking for those who share our core belief - Every Day is Game day. We bring our best selves to work each day to realize our mission of enriching the world through the power of digital commerce and financial services.

Role Purpose :

We are seeking for an expert DBA with Hands On experience on SQL Server and PostgreSQL having a minimum of 3 years of experience.

Candidate should have a good understanding of SQL Scripting and experience in writing automation scripts for DBA tasks.

Responsibilities we entrust you with :

- Core DBA skills expert

- Database Migration, Automation using Scripts.

- Auto failover strategy or proactive fixes for handling outage scenarios.

- Perform code review for DDL and DML scripts for SQL Server and PostgreSQL.

- Monitoring and Troubleshooting

- Patroni HA/DR and Passive Replication configuration in PostgreSQL.

- Strong knowledge in Linux and Windows OS.

Relevant work experience :

- Strong working experience of providing Production Support for various Database Technologies including MS SQL Server and PostgreSQL expertise.

- Strong working experience in supporting High Availability (HA) and Disaster Recovery (DR) options for MSSQL Server (SQL Always On) and PostgreSQL Passive Replication and Patroni HA.

- Experience in working with multiple OS platforms like Windows/ Linux etc.

- Experience in working with PostgreSQL tools, Passive Replication, partitioning etc.

- Good understanding of one or more cloud computing environments like AWS and Azure, AWS preferred.

- Knowledge of backup/recovery mechanisms, Index management, and statistics.

- Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQLProfiler and other technologies related monitoring and troubleshooting tools.

- Ability to detect and troubleshoot SQL related CPU, memory, I/O, disk space and other resource contention.

- Experience in troubleshooting and resolving database integrity issues, performance issues, blocking & deadlocking

- Capacity Planning (Backup Share, Disk, CPU, Memory etc)

- Good communication and documentation skills

Years of experience : Minimum 3 years of experience and maximum 5 years experience with Primary Skillset needed is SQL Server while Secondary in PostgreSQL.

- You take the shot : You Decide Fast and You Deliver Right

- You are the CEO of what you do : you show ownership and make things happen

- You own tomorrow : by building solutions for the merchants and doing the right thing

- You sign your work like an artist : You seek to learn and take pride in the work you do