Lead Database Administrator (MySQL/ PostgreSQL/ Aurora)

Company Description

Who we are?

Become a Zider Tech member and join this amazing company that is on top of the
e-commerce game! Join a company that is not only growing but having fun while
doing it. We are a human centric organization with huge growth plans and with
a purpose to help more and more people with little or no digital experience to
start their online business (e-commerce), move their offline to online or grow
their offline businesses even more by having an online presence.
Where are we coming from and where are we going?
Zid has had a tremendous grow over the last ‎5 years. From ‎5 people to ‎300+
people at present and counting. Our revenues have been increasing more than ‎3
times year on year and we have had a great success. We know that huge growth
brings a few complications and challenges to our technology and we, in
engineering, are aware of them and we are looking to solve those. We are an
e-commerce SaSS platform, a fintech startup, a logistics and shipping
consolidator and we understand and believe that technology and business go
hand-in-hand.

Job Description

What do we expect from you?
In this role, you will play a key role in helping us to analyze the existing
database architecture, data models, understand the complete business processes
and optimize the running queries smartly to boost the applications performance
and reduce any duplicated/unwanted scanning or storage I/O hits. You should be
responsible for database monitoring, troubleshooting and performance tuning.
The expected Key responsibilities & duties:
* You will act as Lead Database Administrator and have experience in Aurora/ PostgreSQL/ MySQL RDS DB Administration.
* Supports application development projects by leading in the creation of standards and procedures related to database management systems
* Troubleshoot database problems and implement corrective measures as required.
* You will play a lead role in helping us develop highly scalable and performant database systems.
* You must have a strong AWS working knowledge with Aurora MySQL/PostgreSQL, Clusters/Global Databases - backups/snapshots, cloning and DMS.
* We will expect you to use your expert knowledge in Aurora/ PostgreSQL/ MySQL RDS internals including storage engines, specially InnoDB to optimize our database performance.
* Your expertise should include database upgrades, replication using DMS, recovery, DB migration, etc.
* You will need to have expertise in in MySQL/ PostgreSQL performance tuning and real-time troubleshooting.
* Experience managing high traffic, multi-tier products at scale specifically in ecommerce domains.
* Experience managing multi-tenant Aurora MySQL database and experience with scaling and optimizing databases.
* Strong knowledge of AWS managed services including RDS, KMS, DMS, Lambda functional and EKS
How does your first month look like?
Your first day will be kicking off with some analysis of the current
situation. We expect this to take approximately a week of walkthrough and
meetings while you also get to know more about the company and the products
and meet people.
In the second week till the end of your month, you would be expected to have
clarity on the current DB and DWH setup. You will review the DB component and
review the running queries on the whole platform including the DB and DWH.
In your first month, you are expected to understand the DB setup components
and how to manage and optimize the running queries besides that, you will be
responsible for reviewing any coming database queries by the developers or DWH
team to approve and confirm their quality in the context of the performance
and the cost perspectives.
How will you do it?
You will be working side by side with the DevOps Team and Data Warehouse Team
to ensure that you have the right guidance to your day-to-day tasks. This is
critical to ensure your success! And don 't forget your success is our
success!
When will you work?
We are a full flexible and full remote. It means that you decide when,
however, it is important that you have your calendar updated. You will be
working fully remote or if you are in Riyadh from our office here.
Ohh and yes, you will have ‎21 days of Holidays to enjoy and other benefits
too!

Qualifications

Hard skills
* Over ‎9+ years of experience in Database Administration.
* ‎5+ years of experience in leading and organizational skills.
* Plan and manage capacity of database management systems.
* Experience of data warehouse system design, development, and testing.
* Strong analytical and problem-solving skills.
* Strong knowledge of data warehouse and ETL.
* Strong knowledge of AWS managed services especially (RDS and DMS).
* Extensive Knowledge of MySQL/ PostgreSQL/ Aurora.
* Excellent communication and customer interfacing skills.
* Experience in successful delivery of multiple products on time and with Quality.
Soft Skills
* Great communication skills
* Team player
* Attention to detail
* Excellent debugging and problem-solving skills
* Excellent communication skills, both written and verbal.
* Smart working habits!
* Ability to at point work under pressure (doesn 't happen often but sometimes we have deadlines!)

Additional Information

What are we offering?
* Competitive Salary
* Holidays of ‎21 days + additional days given regularly
* Trainings (we kicked the learning internally and recently completed an AWS Architecting course)
* Career path clearly defined!
* ZEA - Zid Entertainment - Fun Thursdays!