Geode Capital Management, LLC is seeking a highly motivated
Associate Database Administrator to join our System Operations (SysOps) team! On the SysOps Team, our mission is to support the whole firm’s database administrative needs. In this role, you will see a direct correlation between your work efforts, asset growth, risk mitigation, and internal user satisfaction. You will have a unique opportunity to solve interesting database administrative challenges, at a scale few companies can match. As we continue to expand and create, we have a lot of exciting work ahead of us!
This is a hybrid work environment opportunity located in Boston, Massachusetts with a weekly in office schedule of Tuesdays, Wednesdays and Thursdays and remote work availability on Mondays and Fridays.
Responsibilities:
- Install, configure, and maintain database servers and processes, including monitoring system health and performance, to ensure high levels of 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 and identify areas of improvement
- At times, provide off-hours support, including weekends and holidays, on a rotation
Skills You Bring:
- Minimum three years of experience in MS SQL or Postgres
- Bachelor’s degree in Computer Science or Information Systems
- Proficient in supporting production database services per defined service level requirements
- Knowledgeable in Database Administration with a focus on data cleanup, transformation, architecture, and automation
- Proficient in writing and optimizing T-SQL queries
- Proficiency in SQL with experience in major database systems (e.g., SQL Server and PostgreSQL)
- Knowledge of industry standard database solutions, including high availability, database clusters, mirroring, and replication
- Experience in database migration, troubleshooting and resolving issues
- Good understanding of database performance monitoring and tuning
- Experience working in Linux and Windows environments
Nice to Have:
- Experience with cloud database solutions (e.g., Snowflake, Aurora)
- Experience with CI/CD tools
- Hands-on scripting experience with PowerShell or Python
- Experience with advanced data movement techniques, including CDC
- Financial industry experience preferred
Company Overview:
Founded in 2001, Geode is headquartered in Boston’s financial district, the center of one of the world’s most vibrant finance and technology hubs and employs approximately 180 employees.
Geode is a systematic asset manager providing core beta exposures across a range of equity and niche asset classes, with over $1 trillion in AUM. With a robust infrastructure and experienced investment professionals, Geode offers the scale of a large asset management firm with the benefits of a smaller organization.
Geode is proud to be an equal opportunity employer and support a diversified work environment. Learn more about Geode at www.geodecapital.com.
