Our current enterprise environment consists of multiple stand-alone Postgres 14 databases. PostgreSQL is deployed using docker in some cases and Kubernetes with Crunchy PGO in other cases.
Only Linux operating systems are used.
As the Data Engineer you will be required to work in a dynamic environment with software developers, the DB team, System admin and the Network Team. The ability to work with minimal supervision and the ability to work in a team in an agile environment is a must!.
Are you passionate about open source technologies? This role requires someone who has fully embraced open source technologies.
Prior exposure to alternative DB technologies such as Time Series optimized databases like TimescaleDB would be beneficial.
Do you have experience and innovative ideas in database administration, data replication, DevOps and middle-tier administration? These attributes would be highly advantageous.
As the Database Engineer you will provide database administration/application support to the entire system development life cycle. In conjunction with relevant team members you will be responsible for daily operations, monitoring, backup and recovery, performance tuning, installation, configuration and patching of databases.
In addition this role plays an important part to assist the data analysis team with optimization of queries and data structures.
As the Data Engineer you will be required to work with System Analysts and the Data Manager to review and optimize logical data models/database scripts and implement them into the physical database.
Our global teams are all fully remote, if you enjoy not having to deal with traffic and have the infrastructure to work from home please keep reading!!
JOB REQUIREMENTS
- Analytical thinking
- Excellent communication
- Ability to learn, absorb and apply new knowledge
- Strong attention for detail
- Working in a team
- Proactive approach
- Remain calm under pressure
TECHNICAL REQUIREMENTS
Hands-on experience in database administration and performance tuning. 4+ years’ technical knowledge and experience with Postgres in a production setting and JSON/JSONB features.
- NoSQL database experience, such as MongoDB is a plus.
- PostgreSQL Development experience is required
- Experience with Shell Scripting
- Experience with SQL development, data modeling and database security.
- Experience with Database backup, disaster recovery processes and procedures.
- Experience with SQL tools as required for the database solution such as pgAdmin or DataGrip.
- Experience with git or other source control software.
- An understanding of the Agile framework and the DevOps approach.
- Experience researching software & technology and making recommendations on their use.
- Strong problem solving and analytical skills. Very good communication skills and interpersonal skills.
- Experience responding to and resolving database access and performance issues.
- Experience interpreting database error messages and the ability to execute recovery of the database instance, data or other pertinent database components
- Experience with PostgreSQL streaming Replication and Patroni
- Good Experience with PostgreSQL Logical Replication..
- Experience with native PostgreSQL Table Partitioning,
- Experience with High Availability and Hot-standby servers
- Experience with PGBouncer
- Experience with PGBackrest
- Experience with Docker Containers, docker-compose and Kubernetes when used with PostgreSQL
- Experience with Time Series database such as TimescaleDB
- Experience with Triggers
- B.SC. in Computer Science or Computer Engineering, or related technical discipline is desirable.
At Mi-C3 you are guaranteed to never stop learning, you will be encouraged to be innovative and creative,
your only limit will be yourself. We are global teams made up of individuals who value and celebrate each team member’s individual strengths that they bring to the table. We encourage and value different perspectives to drive innovation and creativity. Our culture fosters strong bonds and trust amongst our global teams built over years of support and growth. We work hard, but we also know how to have fun and laugh! If this sounds like a place you could call home and you have the relevant skills and experience please share your CV with us.
