Get a free C.V. review by sending your C.V. to submitcv@careerassociated.com or click the following link. Submit C.V.! use the subject heading REVIEW.
IMPORTANT: Read the application instructions keenly, Never pay for a job interview or application.
Click the Links Below to Get Job Updates.
https://www.facebook.com/groups/1126060830815705
https://t.me/joinchat/EBWPu0Cfzh880lRySce_AQ.
Job Purpose
To manage the performance, security and integrity of Metropol’s database infrastructure. You will be instrumental in the planning and enhancement of the database environment for the future.
Duties & Responsibilities
Database Performance:
Main Activities
- Monitor performance and manage parameters in order to provide fast response to queries.
- Use automated tools effectively to interpret the state of databases and extract areas of improvement.
- Take charge of writing and optimizing in-application database statements.
- Write and optimize queries to retrieve data from MongoDB.
- Implement a strategy for speedy data retrieval that combines relational and NoSQL datastores.
Planning:
Main Activities
- Map out the conceptual design for a planned database, considering both backend organization of data and front-end accessibility for clients.
- Refine the physical design to meet storage system requirements.
- Carry out capacity planning for the database.
Reporting:
Main Activities
- Implement a data warehousing strategy
- Write database documentation, including data standards, procedures and definitions for the data dictionary (metadata)
- Generate daily, weekly and monthly reports as discussed with your supervisor.
- Communicate regularly with technical and operational staff to ensure database integrity and security.
Data Security:
Main Activities
- Control access permissions and privileges on production databases.
- Maintain the data recovery aspects of a database.
- Refine the logical design of the databases so that it can be translated into a specific data model.
- Maintain data standards, including adherence to any data protection legislation.
JOB SPECIFICATIONS
Competencies:
· Capable of configuring popular relational database systems and orchestrating clusters as necessary.
· Ability to plan resource requirements from high level specifications
· Familiar with tools that aid with profiling server resource usage and optimizing it.
· Proficient in using Git.
· Provable two years of experience working with NoSQL datastores (MongoDB preferred)
· Provable four years of experience working with PostgreSQL.
· Skilled at optimizing large complicated SQL statements.
· Knowledge of best practices when dealing with relational and NoSQL databases.
Skills:
- Proven ability to work under pressure and meeting tight deadlines
- Flexible and mature approach with ability to work unsupervised
Education, Qualifications & Experience:
· Bachelor’s degree in Computer Science or equivalent.
· Certification in any relational database system.
· Training in Mongo DB is an added advantage.
- · Ability to write code in any contemporary language is an added advantage.
.
.
.
