Associate Database Administrator

Geode Capital Management
Boston, MA, United States
4 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Experienced
Experience required
3 years minimum
Working hours
Regular working hours

Tech stack

Microsoft Windows Cluster Analysis Information Systems Databases Data Cleansing Data Infrastructure Database Servers Linux PostgreSQL Microsoft SQL Server Operational Databases Windows PowerShell
+8 more
Query Optimization Runbook SQL Databases SQL Server Integration Services Transact-SQL Database Performance Database Migration Information Technology

Job description

Experteer Overview As an Associate Database Administrator on the SysOps team, you will support the firm’s database services, impacting asset growth and risk management. You will install, configure, monitor, and optimize database environments, collaborating with developers and operations to ensure security, availability, and performance. You will design automated processes with T-SQL, PowerShell, and SSIS, and contribute to runbooks and knowledge sharing. The role offers exposure to enterprise-scale data infrastructure and a culture of continuous learning. Compensation / Benefits * Install, configure, and maintain database servers and processes with a focus on security, performance, availability, and resilience * Design, develop, implement, and maintain processes using T-SQL, PowerShell, and SSIS * Define and implement data access controls and monitoring * Assist developers with complex query tuning and schema refinement * Be proactive in identifying areas for improvement * Handle incident, problem, and change requests through enterprise ticketing systems per established processes * Document procedures, runbooks, and technical knowledge; share best practices and support continuous learning * Provide off-hours support, including weekends/holidays, on a rotation Tasks * Minimum 3 years of experience in MS SQL or Postgres * Bachelor’s degree in Computer Science or Information System * Proficient in supporting production database services per defined service levels * Knowledgeable in Database Administration with focus on data cleanup, transformation, architecture, and automation * Proficient in writing and optimizing T-SQL queries * Proficiency in SQL with experience in SQL Server and PostgreSQL * Knowledge of HA, clustering, mirroring, and replication * Experience in database migration, troubleshooting and issue resolution * Good understanding of database performance monitoring and tuning * Experience working in Linux and Windows environments Key requirements * health coverage * 401(k) matching * annual profit sharing * paid parental leave * generous time off * tuition and certification reimbursement

Requirements

Windows problem, and change requests through enterprise ticketing systems per established processes * Document procedures, runbooks, and technical knowledge; share best practices and support continuous learning * Provide off-hours support, including weekends/holidays, on a rotation Tasks * Minimum 3 years of experience in MS SQL or Postgres * Bachelor’s degree in Computer Science or Information System * Proficient in supporting production database services per defined service levels * Knowledgeable in Database Administration with focus on data cleanup, transformation, architecture, and automation * Proficient in writing and optimizing T-SQL queries * Proficiency in SQL with experience in SQL Server and PostgreSQL * Knowledge of HA, clustering, mirroring, and replication * Experience in database migration, troubleshooting and issue resolution * Good understanding of database performance monitoring and tuning * Experience working in Linux and Windows environments Key requirements * aaaa

Benefits & conditions

on coverage * 401(k) matching * annual profit sharing * paid parental leave * generous time off * tuition and certification reimbursement

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on us.experteer.com

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

7:49 min

Demonstrating cluster configuration and live database operational monitoring

Sani Yusuf · LIVE

3:04 min

Database evolution and the funding behind vector databases

Erik Bamberg · LIVE

2:50 min

Introduction and the value of runbooks

Hila Fish · WWC 2023

52 sec

Running persistent Linux environments directly on Windows

Ben Breard Ben Breard · WWC 2025

1:52 min

Evolution of distributed SQL database management systems

Akmal Chaudhri Akmal Chaudhri · LIVE

4:01 min

Managing application isolation via pluggable database models

Wei Hu Wei Hu · WWC 2022

Videos

See all

Related articles

See all