Database AdministratorIn this role, you will have a direct impact on the firm's operational excellence, risk management, and ability to support continued asset growth. You will partner with teams across the organization to solve complex database challenges, optimize performance, and implement innovative solutions in a dynamic, fast-paced environment.
This is a unique opportunity to work at scale, tackling sophisticated database administration initiatives that few organizations can offer. As Geode continues to grow and evolve, you will play a key role in building and enhancing the database infrastructure that supports our long-term success.
This role is based in our office in Boston, Massachusetts. You are required to follow the firm's policy on in-office attendance. Our current policy requires in-office attendance on Tuesday, Wednesday, and Thursday, and then provides an option to work remotely on Monday and Friday. Please note that Geode may modify this policy at any time.
Responsibilities: - Install, configure, patch, upgrade, and maintain database platforms and support components across production and non-production environments.
- Monitor database health, capacity, availability, backup status, replication, and performance; identify trends and address issues before they affect service.
- Administer Microsoft SQL Server and PostgreSQL environments, including security, permissions, configuration, maintenance, and lifecycle management.
- Design, test, document, and support high-availability and disaster-recovery capabilities, including clustering, replication, failover, backup, and recovery procedures.
- Troubleshoot database incidents and performance issues using logs, execution plans, wait statistics, system metrics, and platform-native diagnostic tools.
- Partner with developers and application teams on query tuning, indexing, schema design, deployment readiness, and database-related production support.
- Define and maintain database access controls, privileged-access processes, encryption, auditing, and monitoring in alignment with security and compliance requirements.
- Automate repeatable operational tasks using T-SQL, PowerShell, Python, and approved orchestration or CI/CD tooling.
- Plan and execute database migrations, upgrades, refreshes, data movement, and platform modernization while minimizing operational risk.
- Manage incidents, problems, service requests, and changes through enterprise ticketing and change-management processes; complete root-cause analysis and follow-up actions when needed.
- Create and maintain operational runbooks, recovery procedures, architecture documentation, standards, and knowledge articles; share knowledge across the team.
- Participate in an off-hours on-call rotation, including occasional weekend and holiday support for production services and planned maintenance.
Skills You Bring: - 5+ years of hands-on database administration or database operations experience with Microsoft SQL Server, PostgreSQL, or a comparable enterprise relational database platform.
- Bachelor's degree in Computer Science, Information Systems, or a related field, or equivalent practical experience.
- Experience supporting production database services against defined availability, recovery, security, and service-level requirements.
- Strong SQL skills, including the ability to write, review, troubleshoot, and optimize queries and stored procedures.
- Practical experience with database backup and recovery, performance monitoring and tuning, security administration, patching, upgrades, and migrations.
- Working knowledge of high-availability and disaster-recovery technologies such as clustering, replication, mirroring, availability groups, or managed-cloud equivalents.
- Experience administering database services in Windows and Linux environments.
- Ability to troubleshoot across database, operating system, storage, network, identity, and application layers.
- Clear written and verbal communication skills, with the ability to document technical procedures and explain operational risk to technical and non-technical partners.
- Ability to manage competing priorities, participate in change-controlled production support, and work effectively across infrastructure, development, security, and vendor teams.
Nice to Have:- Experience with cloud and data platforms such as Snowflake, Amazon Aurora or Amazon RDS database services.
- Experience with infrastructure automation, configuration management, source control, and CI/CD practices.
- Hands-on scripting experience with PowerShell or Python.
- Experience with data integration and movement technologies such as SQL Server Integration Services (SSIS), change data capture (CDC), bulk-load utilities, or replication tools.
- Experience with observability and monitoring platforms, centralized logging, alerting, and operational dashboarding.
- Knowledge of identity and access management, secrets management, certificate management, and database security controls.
- Experience in financial services or another regulated industry.
Pay Range: $115,000 - $135,000 per year