Excellent opportunity with one of my best clients in the e-commerce space. You will work as part of the data engineering and data science team. You will work on a large cloud migration and be an integral part of decision making on the company's data roadmap over the next year.
The Role
- Responsible for database administration
- Automate tasks
- Ensure database backup processes are automated
- Create and maintain automated maintenance plans
- Responsible for maintaining the integrity and performance of company databases
- Optimise database security
- Review modifications to the existing data warehouse software
- Manage access to databases
- Diagnose and troubleshoot database errors
- Recommend and implement emerging database technologies
- Create and manage database reports, visualisations and dashboards
- Be available for on-call support as needed
- Strong command of SQL and SQL server tools, other databases such as MariaDB and MySQL also great to have
- Familiar with data warehouse builds
- Advance knowledge of database security
- Strong relational and dimensional data modelling
- Experience in database administration, information technology, database architecture or a related field
- Experience with Linux and Windows Server environments
- Extensive experience with database technologies (MS SQL, PostgreSQL)
- Experience with cloud services (Google cloud preferred but AWS or Azure also fine)
- Familiarity with agile and software development lifecycle including design, build, code review, testing, release and bug fixing