Tech Specialist Database Admin

6 days ago

Chicago, IL, United States CME Group Full time
Technology Specialist

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.

Core Responsibilities
  • Cloud Architecture: Design robust, scalable, and cost-effective data architectures on Google Cloud Platform (GCP), focusing on Cloud SQL, AlloyDB, and Bigtable.
  • Database Performance & Optimization: Lead performance tuning and optimization efforts for PostgreSQL, diagnosing and resolving complex issues stemming from our legacy Oracle Exadata environment.
  • Data Pipeline Development: Build and maintain resilient, cloud-native data pipelines (ETL/ELT) using Python and GCP services such as Dataflow, BigQuery, and Pub/Sub.
  • Automation & Infrastructure as Code (IaC): Develop and implement automation in Python for performance monitoring, remediation, and infrastructure management using IaC tools like Terraform.
  • Migration & Modernization: Guide the technical execution of migrating large, complex databases from Oracle to PostgreSQL on GCP, ensuring data integrity and performance.
  • Mentorship & Guidance: Serve as a subject matter expert and mentor for development and data reliability teams on PostgreSQL and GCP best practices, helping to elevate the team's technical capabilities.
Required Qualifications & Experience
  • Experience: 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.
  • Google Cloud Platform (GCP) Expertise: Deep, hands-on expertise with GCP, including architecting solutions with BigQuery, Dataflow, Cloud Storage, Pub/Sub, Cloud SQL, and AlloyDB.
  • Python Proficiency: 6+ years of advanced Python development experience for data processing, automation, and building ETL/ELT pipelines.
  • Database Expertise:
    • 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.
  • DevOps & IaC: 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).

  • SQL Database Admin

    2 days ago

    Chicago, IL, United States Jconnect Inc Full time

    Hello Greetings!!! This is Sakshi from Jconnect INC. Below is the requirement with my client. Please let me know if you are available for this role. Title: SQL Database Admin Location : Chicago, IL Duration: Fulltime JOB DESCRIPTION: 7+ years Job Description SQL Database Admin • SQL Server 2022 Administrative expertise • SSIS,SSRS,SSAS installation and...

  • SQL Database Admin

    4 days ago

    Chicago, IL, United States Diverse Lynx Full time

    Title: SQL Database Admin Location: Chicago, IL Type: Fulltime/Permanent Role Must Have Technical/Functional Skills • SQL Server 2022 Administrative expertise • SSIS,SSRS,SSAS installation and configuration expertise • Experience in Handling Large databases • Expertise in Azure migration. • Powershell scripting experience. • Expertise in...

  • Oracle ORMB Admin

    4 days ago

    Chicago, IL, United States SysMind Tech Full time

    Hi, My name is Sia and I work as a Hiring manager with SYSMIND. We have been serving fortune 500 clients in the Industry to bridge their staffing gap since the past 25 years. I have aa urgent position. I currently have an urgent opening that aligns well with your background, and I'd love to connect with you to discuss the opportunity in detail. Job Title:...

  • UniVerse DB Admin

    1 week ago

    Chicago, IL, United States ACE Tech Resources Full time

    Job Description UniVerse DB Admin Location: Chicago-Area - Hybrid Position Description: Hands-on administration and tuning of UniVerse and other in-production databases. Develop, implement, and support applications that interface with core systems. Part of a team that is responsible for the transfer of all system files within the Client's database, to/from...

  • Oracle DB admin

    2 weeks ago

    Chicago, IL, United States CData Software Full time

    Role name: Database Administrator Role Description: Oracle DBA activitiesDevOps SupportTroubleshooting, ScriptingCloud ExposureAnalytical AbilitiesITSM ProcessCommunication Skills Competencies: Windows Powershell, Oracle DBA, Exadata Administration Experience (Years): 8-10 Essential Skills: Oracle DBA admin Support (Oracle Enterprise Manager (OEM), Oracle...

  • Oracle DB admin

    2 weeks ago

    Chicago, IL, United States CData Software Full time

    Role name: Database Administrator Role Description: Oracle DBA activitiesDevOps SupportTroubleshooting, ScriptingCloud ExposureAnalytical AbilitiesITSM ProcessCommunication Skills Competencies: Windows Powershell, Oracle DBA, Exadata Administration Experience (Years): 8-10 Essential Skills: Oracle DBA admin Support (Oracle Enterprise Manager (OEM), Oracle...

  • Oracle DB admin

    5 days ago

    Chicago, IL, United States CData Software Full time

    Role name: Database Administrator Role Description: Oracle DBA activitiesDevOps SupportTroubleshooting, ScriptingCloud ExposureAnalytical AbilitiesITSM ProcessCommunication Skills Competencies: Windows Powershell, Oracle DBA, Exadata Administration Experience (Years): 8-10 Essential Skills: Oracle DBA admin Support (Oracle Enterprise Manager (OEM), Oracle...

  • Database Administration Specialist

    2 weeks ago

    Chicago, IL, United States Sepal Full time

    About the Project: Sepal is conducting an exciting research study aimed at understanding work excellence among database administrators to establish professional benchmarks. We are looking for enthusiastic participants who can share their professional background, design field-specific screening questions, and document substantial work projects as case...

  • Database Administration Specialist

    2 weeks ago

    Chicago, IL, United States Sepal Full time

    About the Project: Sepal is conducting an exciting research study aimed at understanding work excellence among database administrators to establish professional benchmarks. We are looking for enthusiastic participants who can share their professional background, design field-specific screening questions, and document substantial work projects as case...

  • DataStage Developer/ Admin

    7 days ago

    Chicago, IL, United States Syntricate Technologies Full time

    Required Skills: 10 years of experience in DataStage administration and Development Ability to manage new project/assignment and should manage effectively. Lead the design and implementation of data warehousing solutions to support business intelligence and analytics needs. Oversee the development and maintenance of ETL processes to ensure efficient...