Address
Form of workJob Description
Job Description:
PostgreSQL database administration (DBA) experience o Database recovery and tuning o Maintain backups and disaster recovery o Monitor and optimize database performance o Manage security and authentication o Data extraction and transformation o Data modelling and schema design o Manage users - roles - and tablespaces o Resolve production data issues and preserve data integrity • Data engineering and data pipeline implementation experience • Microsoft Transact-SQL and Python development experience • Data Lake environment experience • Database design - security - and architecture experience • Docker experience • Git and GitHub experience • Apache Airflow configuration and management experience • Apache Spark experience • Microsoft SQL Server administration experience • Strong understanding of APIs • Grafana experience • Machine Learning pipeline experience • Experience with Cloud-based database platforms (Azure - AWS - GCP - etc.) • Linux Server or Linux subsystem experience such as YUM and DNF packages - implementing PostgreSQL - Centrify • Collaboration with data scientist teams - application teams - and project management teams
Experience Preferred:
PostgreSQL database administration (DBA) experience o Database recovery and tuning o Maintain backups and disaster recovery o Monitor and optimize database performance o Manage security and authentication o Data extraction and transformation o Data modelling and schema design o Manage users - roles - and tablespaces o Resolve production data issues and preserve data integrity • Data engineering and data pipeline implementation experience • Microsoft Transact-SQL and Python development experience • Data Lake environment experience • Database design - security - and architecture experience • Docker experience • Git and GitHub experience • Apache Airflow configuration and management experience • Apache Spark experience • Microsoft SQL Server administration experience • Strong understanding of APIs • Grafana experience • Machine Learning pipeline experience • Experience with Cloud-based database platforms (Azure - AWS - GCP - etc.) • Linux Server or Linux subsystem experience such as YUM and DNF packages - implementing PostgreSQL - Centrify • Collaboration with data scientist teams - application teams - and project management teams
Experience Preferred:
- Minimum of three (4) years of experience as a Database Administrator (DBA).
- Minimum of two (2) years of experience as a Data Engineer.
Experience in managing and maintaining Data Lakes Data Warehouses and public cloud or on-prem data environments.
Education Preferred:
Education Preferred:
- Bachelor's degree in an IT-related or engineering field - or relevant certifications (e.g. Microsoft SQL Server - PostgreSQL DBA - AWS - Azure)
Additional Information:
- Selected candidate will have to pass DPHs Live Scan check prior to engagement in addition to any requirements from the vendor.
- Work location is Commerce CA. with a hybrid of two days on-prem and three days work from home Address is 5555 Ferguson Drive Commerce CA 90022.
