Database Administrator Senior

About the role

Administer, test, and implement computer databases, applying knowledge of database management systems. Provide advanced database administration for Platform-as-a-Service (PAAS) platform data stores and shape the database administration function.

Enhance, monitor, and support all layers of data storage for the Xponent product. Provide advanced database administration for PAAS data stores using MySQL, Redshift, and MongoDB (NoSQL Database).

• Provide access to MySQL database for customers to use for multiple purposes in their own orchestration in a shared host, private schema Amazon AWS RDS Aurora cluster.
• Use data mechanism for storing specific types of data into a semi-defined NoSQL schema in MongoDB.
• Implement Redshift for clients to connect to BI Tools and receive aggregate views of the data exported from Mongo regularly.

Oversee all layers of the database to empower clients while aligning with corporate directives for data security, privacy, management, and retention. Maintain, monitor, and grow the database being used by clients and the internal services team on behalf of clients. Develop telemetry and database observation practices to better address potential issues.

Telecommuting is permitted 100%. Position reports to company HQ in Englewood, CO.

Responsibilities

• Administer, test, and implement computer databases using database management systems.
• Provide advanced database administration for PAAS data stores (MySQL, Redshift, MongoDB).
• Manage customer access to MySQL databases in a shared host, private schema Amazon AWS RDS Aurora cluster.
• Store and manage data in semi-defined NoSQL schemas using MongoDB.
• Implement Redshift for BI tool connectivity and aggregated data views.
• Maintain, monitor, and scale databases for client and internal use.
• Develop telemetry and observation practices for proactive issue resolution.
• Ensure alignment with corporate data security, privacy, management, and retention policies.

Requirements

Bachelor's degree or U.S. equivalent in Computer Science, Electrical Engineering, or a related field, plus 5 years of professional experience in a related occupation.

• Managing cloud-native RDBMS, including replication and failover, using Aurora MySQL/PostgreSQL Management.
• Amazon Redshift-specific operations including distribution and sort keys, COPY command, and WLM tuning.
• Using MongoDB Query Language (MQL) and aggregation framework for document-based data retrieval.
• Snowflake SQL and architecture including time travel, virtual warehouses, and semi-structured data (VARIANT) features.
• Using Python scripting to migrate databases from on-premises to cloud-based platforms, and vice versa.
• Automating infrastructure deployment using Terraform and Terragrunt, integrated with Jenkins pipelines.
• ETL Development for NoSQL to MySQL/Redshift migration, including building ETL pipelines to extract data from NoSQL databases (e.g., MongoDB), transform it, and load it into MySQL or Amazon Redshift for relational querying and analytical reporting.

Pay

$140,358 - $166,799.46 per year.