Job Description:
- Working at Oportun means enjoying a differentiated experience of being part of a team that fosters a diverse, equitable and inclusive culture where we all feel a sense of belonging and are encouraged to share our perspectives.
- This inclusive culture is directly connected to our organizations performance and ability to fulfill our mission of delivering affordable credit to those left out of the financial mainstream.
- We celebrate and nurture our inclusive culture through our employee resource groups.
RESPONSIBILITIES:
Database Design & Architecture
- Design, implement, and maintain optimal database schemas for relational (MariaDB) and NoSQL (MongoDB) databases.
- Participate in data modeling efforts to support analytics in Databricks.
Performance Monitoring & Tuning
- Monitor and tune performance across all platforms to ensure optimal performance.
- Use profiling tools (e.g., query plans, system logs) to identify and resolve bottlenecks.
Security & Compliance
- Implement access controls, encryption, and database hardening techniques.
- Manage user roles and privileges across MariaDB, MongoDB, and Databricks.
- Ensure compliance with data governance policies (e.g., GDPR, HIPAA).
Backup & Recovery
- Implement and maintain backup/recovery solutions for all database platforms.
- Periodically test restore procedures for business continuity.
Data Integration & ETL Support
- Support and optimize ETL pipelines between MongoDB, MariaDB, and Databricks.
- Work with data engineers to integrate data sources for analytics.
Monitoring & Incident Response
- Set up and monitor database alerts.
- Troubleshoot incidents, resolve outages, and perform root cause analysis.
MariaDB-Specific Responsibilities
- Administer MariaDB instances (standalone, replication, Galera Cluster).
- Optimize SQL queries and indexing strategies.
- Maintain stored procedures, functions, and triggers.
- Manage schema migrations and upgrades with minimal downtime.
- Ensure ACID compliance and transaction management.
MongoDB-Specific Responsibilities
- Manage replica sets and sharded clusters.
- Perform capacity planning for large document collections.
- Tune document models and access patterns for performance.
- Set up and monitor MongoDB Ops Manager / Atlas (if used).
- Automate backup and archival strategies for NoSQL data.
Databricks-Specific Responsibilities
- Manage Databricks workspace permissions and clusters.
- Collaborate with data engineers to optimize Spark jobs and Delta Lake usage.
- Ensure proper data ingestion, storage, and transformation in Databricks.
- Support CI/CD deployment of notebooks and jobs.
- Integrate Databricks with external data sources (MariaDB, MongoDB, S3, ADLS)
Collaboration & Documentation
- Collaborate with developers, data scientists, and DevOps engineers.
- Maintain up-to-date documentation on data architecture, procedures, and standards.
- Provide training or onboarding support for other teams on database tools.
REQUIREMENTS:
- MariaDB Tools: MySQL dump, MySQL admin, Percona Toolkit
- MongoDB Tools: mongo dump, mongo top, mongo export, Atlas UI
- Databricks Tools: Jobs UI, Databricks CLI, REST API, SQL Analytics
- Scripting: Bash, Python, PowerShell
- Monitoring: Prometheus, Grafana, CloudWatch, Data Dog
- Version Control & CI/CD: Git, Jenkins, Terraform (for infrastructure-as-code)
- Preferred CLoud provider:AWS
