Tech Specialist Database Admin

CME Group-posted 3 months ago
$135,000 - $225,000/Yr
Wacker, IL
1,001-5,000 employees
Resume
Match Score
Upload and Match ResumeTrack Jobs with Teal

We are seeking a hands-on Technology Specialist to lead our database modernization efforts as we migrate from legacy on-premise databases to strategic cloud platforms. This role requires deep expertise in Google Cloud Platform - specifically Cloud SQL, AlloyDB, and Bigtable - alongside advanced proficiency in Python for building scalable data pipelines and automation. You will be responsible for tackling systemic performance challenges, managing our database fleet programmatically, and serving as the go-to expert for our development and reliability teams. Your technical leadership will directly ensure our new cloud infrastructure is performant, stable, and built for scale.

  • Design robust, scalable, and cost-effective data architectures on Google Cloud Platform (GCP), focusing on Cloud SQL, AlloyDB, and Bigtable.
  • Lead performance tuning and optimization efforts for PostgreSQL, diagnosing and resolving complex issues stemming from our legacy Oracle Exadata environment.
  • Build and maintain resilient, cloud-native data pipelines (ETL/ELT) using Python and GCP services such as Dataflow, BigQuery, and Pub/Sub.
  • Develop and implement automation in Python for performance monitoring, remediation, and infrastructure management using IaC tools like Terraform.
  • Guide the technical execution of migrating large, complex databases from Oracle to PostgreSQL on GCP, ensuring data integrity and performance.
  • Serve as a subject matter expert and mentor for development and data reliability teams on PostgreSQL and GCP best practices.
  • 7-10 years of professional experience in a data engineering or database specialist role, with a proven track record of building and maintaining production-grade cloud data systems.
  • Deep, hands-on expertise with GCP, including architecting solutions with BigQuery, Dataflow, Cloud Storage, Pub/Sub, Cloud SQL, and AlloyDB.
  • 6+ years of advanced Python development experience for data processing, automation, and building ETL/ELT pipelines.
  • Expert-level knowledge of PostgreSQL internals (query planner, indexing, vacuuming, locking mechanisms) and performance tuning.
  • Proven experience migrating large, complex databases from Oracle (ideally Exadata) to PostgreSQL.
  • Strong professional experience with other enterprise databases like MS SQL Server.
  • Demonstrable experience building CI/CD pipelines (e.g., GitLab CI, Jenkins) and managing infrastructure as code (IaC) with Terraform.
  • Experience with data orchestration tools such as Apache Airflow or Cloud Composer.
  • Experience with other GCP data services like Bigtable and Memory Store (Redis).
  • Experience with enterprise database monitoring and administration tools (e.g., IDERA, SCOM, Oracle OEM).
  • Understanding of data privacy and compliance standards (e.g., HIPAA, GDPR).
  • Comprehensive health coverage
  • Retirement package that includes both a 401(k) and an active pension plan
  • Highly competitive education reimbursement provisions
  • Paid time off
  • Mental health benefit
  • Annual target bonus opportunity
  • Opportunity to become an owner in the company through a broad-based equity program
Track Jobs with Teal

Job Search Resources

•
Resume Builder
•
Resume Examples
•
Cover Letter Examples

Tools

Career Hubs

Guides

Company

© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service