Develop, maintain, and optimize databases supporting enterprise analytics workloads across cloud and on-premise environments
Implement data storage solutions that align with data modeling and AI integration needs, including relational and non-relational structures
Monitor database performance, execute tuning procedures, and resolve bottlenecks or failures proactively
Design and maintain database schemas, indexes, and partitioning strategies to support query efficiency and AI-driven analytics
Support data access, backup, and recovery strategies in accordance with organizational standards and compliance requirements
Ensure data integrity and security by applying role-based access controls, encryption standards, and audit logging
Collaborate with analytics engineers and platform teams to streamline data ingestion and integration into analytics environments
Participate in capacity planning and forecast database infrastructure needs based on product roadmaps
Document database configurations, operational procedures, and change management logs
Conduct root cause analysis and propose structural changes to improve system reliability
Support release management for changes impacting database environments across staging and production

Requirements

Proficiency in SQL and one database platform (e.g., BigQuery, PostgreSQL, MySQL, SQL Server, or Oracle)
Experience implementing and managing relational database structures
Experience building out ETL or ELT systems
Familiarity with scripting for automation (e.g., Bash, Python) and database monitoring tools
Understanding of backup, restore, and high-availability practices
Ability to troubleshoot complex issues and implement corrective actions
Strong documentation and configuration management habits
1–3 years of experience managing databases in analytics or software engineering environments
Previous experience supporting union or public sector data systems
Bachelor’s degree in a technical field or equivalent work experience.

Benefits

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

SQLBigQueryPostgreSQLMySQLSQL ServerOracleETLELTBashPython

troubleshootingdocumentationconfiguration managementcollaborationcapacity planning