Database Platform Engineer
The candidate must have worked as a database engineer with hands-on experience deploying, managing and supporting Microsoft SQL Server, PostgreSQL and Snowflake. In addition, the candidate should have general infrastructure experience covering Linux, Windows Server, networking and working with hardware. This role will be focused on database support primarily for Microsoft SQL Server and a vendor platform based on PostgreSQL.
The role will reside within the firm's Systematic Data team, which ingests, transforms, curates and provides large scale historical datasets and platforms to the rest of the firm. The role is expected to work closely with other database engineers, infrastructure engineers, and data scientists/engineers to build, scale, optimize, make resilient and operate these platforms.
Principal Responsibilities: - Microsoft SQL Server Administration
- Install, monitor, and maintain Microsoft SQL Server software/databases
- Implement, maintain and test backup and recovery processes
- Provides system and database troubleshooting and optimization
- Demonstrates an in-depth knowledge of database internals and data structures
- Account and access control management
- Management of replication/scale out technologies, such as Always On availability groups, and load balancing/workload management
- Automation of administrative tasks (Python, PowerShell, Bash)
- PostgreSQL Administration
- Help manage and maintain a MPP (Massively Parallel Processing) PostgreSQL based appliance
- Implement, maintain and test backup and recovery processes
- Manage and automate replication, failover/failback processes
- Manage and test upgrades
- Work with vendor, and infrastructure teams, to address break/fix (hardware failures), migrations and changes
- Snowflake Administration
- Manage setup and maintenance of accounts in conjunction with the infrastructure team
- Manage account, access control and shares
- Troubleshoot authentication and connectivity issues
- Work with Snowflake on outages/issues
- Server & Storage Administration
- Experience and understanding of working with physical infrastructure (servers, storage, networking, etc.)
- Coverage and escalation for systems, storage and data center changes and incidents
Qualifications/Skills Required: - Bachelor degree in computer science, or information technology, or other related field of study
- At least 5 years of experience in Microsoft SQL Server and PostgreSQL Database Administration/Engineering
- Experience with Snowflake
- Experience with Windows Server and Linux operating systems
- Understanding of networking and load balancing
- Scripting/programming (Python/Bash, Powershell)
Desired Skills: - IaC automation (Ansible, Terraform, etc.)
- Job schedulers/orchestrators (Airflow, Nomad, etc.)
- Storage
- Local storage (NVMe, RAID)
- NAS (NFS/SMB)
- Physical infrastructure
- Servers, optics, cabling, rackspace, power, etc.