Associate Database Administrator

• 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
• Handle incident, problem, and change requests across all severity levels through enterprise ticketing systems, following established incident and change management processes
• Document procedures, operational runbooks, and technical knowledge; share best practices with the team, and contribute to continuous learning and operational improvement
• At times, provide off-hours support, including weekends and holidays, on a rotation

Do you have experience in Windows?, Do you have a Bachelor’s degree?, * 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 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 Pythion
• Experience with advanced data movement techniques, including CDC
• Financial industry experience preferred

Pulled from the full job description

• Paid parental leave
• Parental leave
• Health insurance
• 401(k) matching
• Gym membership
• Adoption assistance
• Profit sharing

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 200 employees. Geode is an institutional asset manager providing core beta exposures across a range of equity and niche asset classes, with over $1.5 trillion. 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., Our benefits program is designed to support employees both professionally and personally, offering comprehensive health coverage, 401(k) matching, annual profit sharing, paid parental leave, and generous time off. We also provide tuition and certification reimbursement, student loan support, fitness reimbursement, commuter subsidy, charitable donation matching, family care assistance including a backup care benefit, adoption and surrogacy support. Hybrid work arrangements and a culture that encourages community engagement through volunteer opportunities and employee events further enhance the employee experience at Geode. Geode is proud to be an equal opportunity employer and support a diversified work environment. Learn more about Geode at www.geodecapital.com/careers.