If you’re incredibly organised and what to put your IT skills to good use, we’ve got the perfect job for you.
As a database architect you’ll be in charge of computerised information systems, which in simple terms means keeping an eye on databases and ensuring they’re performing well.
Key Skills:
MySQL, Database Management, Scripting language (Python, Ruby, R, ...)
The project will require set-up of a MySQL database, stream twitter, Facebook and other offline source data into the database via an API.
Database requirements:
· Designing and setting up database on an AWS instance.
· Advising on database hardware and software requirements.
· Preparing for database expansion by studying plans and requirements
· Setting up and testing new database and data handling systems
· Monitoring database efficiency
· Developing protocols for data processing
· Creating complex query definitions that allow data to be extracted as outlined
· Maintaining database results by setting and enforcing standards and controls.
· Keeping senior technical management informed by preparing reports on system performance and problems.
Coding requirements:
· Write effective, scalable code to access APIs or make use of existing libraries
· Develop code that allow for streaming of social media content and store output in database.
· Develop code that extracts historic social media content and store output in database.
· Test and debug the code base.
· Document code to ensure future proofing.
· Coordinate with data scientists and implement feature requests for the API.
Experience
· Work experience as a Python Developer
· Proven expertise in creating python code base with good error handling
· Knowledge of object-relational mapping (ORM)
· Strong analytical and organizational skills
· Eye for detail and accuracy
· Ability to understand business needs
· Understanding of structured query language (SQL)
· Knowledge of ‘relational database management systems’ (RDBMS), ‘object-oriented database management systems’ (OODBMS) and XML database management systems
· Experience with their database software/web applications
· Up-to-date knowledge of technology