Unclassified - Boston, MA
posted 3 months ago
As a senior member of a skilled database administrator team, you will play a crucial role in the migration, maintenance, update, and support of various database platforms including Snowflake, Fivetran HVR Replication Tool, DB2, Oracle, SQL Server, AWS RDS, Redis, DocumentDB, DynamoDB, and Data Migration Service (DMS). This position requires a strong focus on production on-call support, maintenance, and off-hour deployments, ensuring the health and well-being of the database environments. You will be responsible for maintaining a Snowflake data warehouse and managing data replication from various sources, which includes production deployments via a dev/ops procedure. Your responsibilities will also encompass setting up and maintaining security and access for production environments, as well as development tasks such as data modeling, schema design, and the creation of database objects like tables, stored procedures, triggers, functions, and jobs. You will be expected to identify, assess, and evaluate technologies, products, and tools for building enterprise architecture services, and analyze archiving approaches to propose and implement solutions. In addition, you will review and revise existing tables and indexing strategies to enhance storage efficiency and access, provide performance tuning assistance on all data pulls and queries, and work closely with end-users to resolve issues. Your role will involve assisting programmers during development by answering questions and providing guidance, as well as analyzing problems and proposing solutions to meet architectural challenges. Participation in unit, system, user, and performance testing will also be part of your responsibilities, along with user-level familiarity with version control tools and the installation and maintenance of database systems.