Job Summary
The Database Administrator is responsible for the performance, integrity and security of database(s). They will also be involved in the planning, design, and development of the database(s); as well as troubleshooting any issues on behalf of the users.
Minimum Qualification:Bachelor
Experience Level:Mid level
Experience Length:5 years
Job Description/Requirements
FEED THE CHILDREN
JOB ADVERT POSITION:DATA BASE DEVELOPER
REPORTS TO:
VP OF IT SOLUTIONS
WORKS WITH:
DATA HANDLING TEAMS IN THE ORGANIZATION
MISSION:
Providing hope and resources for those without life’s essentials
VISION:
Create a world where no child goes to bed hungry
SUMMARY:
Database Developer are generally responsible for the performance,
integrity and security of databases. They are often also involved in
planning, developing and troubleshooting of databases.
The Database Administrator is responsible for the performance,
integrity and security of database(s). They will also be involved in the
planning, design, and development of the database(s); as well as
troubleshooting any issues on behalf of the users. The goal is to
provide a seamless flow of information throughout the organization,
considering both backend data structures and frontend accessibility for
end users. These responsibilities will include owning, tracking and
resolving database related incidents and requests, fulfilling requests
and resolving incidents within SLAs, reviewing service related reports
(e.g.: database backups, maintenance, monitoring) on a daily basis to
ensure service related issues are identified and resolved, responding to
database related alerts and escalations and working with others in the
Information Technology department to come up with strategic solutions to
recurring problems.
ESSENTIAL JOB FUNCTIONS:
Designing database tables and structures.
Creating views, functions and stored procedures.
Writing optimized SQL queries for integration with other applications.
Creating database triggers for use in automation.
Maintaining data quality and overseeing database security.
Provide guidance and support to Application Developers
Assist with schema design, code review, SQL query tuning
Install, tune, implement and upgrade DBMS installations
Write and deploy SQL patches
Upgrade and improve application schema and data upgrades
Process work accurately and in a timely manner
Pay attention to detail at all times
Proactively and regularly make recommendations for system improvements
Collate, prepare and present statistical information for internal and external use
Responsible for troubleshooting and resolving database related performance problems and ensuring data integrity.
Implement operational automation using scripts.
Setup of archive and ETL jobs related to ongoing maintenance and optimization of all installed database systems.
Responsible for database architecture and documentation of Data Dictionaries and Relational Models.
Create database schemas, tables, fields, permissions, stored procedures and other elements in database systems.
Create and maintain database security, role-based group permissions, and data access.
Monitor systems and platforms for availability, proactively correcting related problems.
Work with project management and support teams on ensuring maximum performance and uptime of systems.
WORKING CONDITIONS:
While performing the duties of this job, the employee is regularly
required to sit and talk or hear. The employee is frequently required to
walk and use hands and fingers. The employee is occasionally required
to stand and reach with hands and arms. The employee must occasionally
lift and/or move up to 25 pounds.
Works in a normal office environment where there are few physical
discomforts associated with changes in the weather or noise, dust, dirt
and the like.
The incumbent’s working conditions are typically moderately quiet.
Create server and database sizing documentation needed for new projects or upgrades to existing systems.
Maintain professional and technical knowledge by attending educational workshops or training.
Contributes to team effort by accomplishing project or development related results as needed.
Establish an environment of high performance and continuous
improvement that values learning, a commitment to quality, welcomes and
encourages collaboration, and fosters both intra and inter-departmental
dialogue and respect.
Model the type and level of behavior, professionalism and personal
leadership that is in accordance with the values. of the organization.
Perform other related duties as required.
QUALIFICATIONS:
Education:
Bachelor’s degree in computer science or a related information
technology field, or equivalent training and experience related to
Microsoft SQL database development.
Experience:
The following need to be very specific to MS SQL and the .Net framework.
8+ years of proven Database Administration experience required
Experience with Microsoft SQL Server and Business Intelligence platform tools required
Experience with T-SQL coding, writing stored procedures, and maintaining database security required
Excellent knowledge of data backup, recovery, roles, replication, and clustering techniques required
Excellent technical problem-solving capability (primarily with
software applications, network environments, servers, and operating
systems) required
Knowledge of third-party DBA tools and applications (e.g. TOAD, Erwin, ER Studio) required
Experience with Database Administration for MSSQL Server required
Experience in Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools required
Experience with backups, restores, replications, and other recovery models required
Knowledge of High Availability (HA) and Disaster Recovery (DR) options for MSSQL Server required
Experience working with Microsoft Business Intelligence platform tools; namely SSAS, SSIS, and SSRS required
Experience working with Windows Azure or other cloud-based server platform technologies required
Knowledge of indexes, index management, and solving production issues based on statistics required.
4 years of experience with programming languages such PL/SQL coding
Easily design and implement a business process into functional and efficient code
Implement and manage Organization data management practices and policies
4 years of experience in administering, managing and tuning databases
4 years of experience with Oracle RAC, SQL Server or MySQL
Good understanding of data and scheme standards and concepts
Good understanding of database design, implementation, troubleshooting and maintenance
expertise in SQL
Sense of ownership and pride in your performance and its impact on organization success
Critical thinker and problem-solving skills
Good time-management skills
Licenses and Certifications:
MCTS, MCITP, MCSE, or MCDBA certifications preferred
KNOWLEDGE, SKILLS AND ABILITIES:
Computer Skills – Advanced skills using Microsoft Office products Word, Excel, PowerPoint and Outlook.
Customer Service - Manages difficult or emotional customer
situations; Responds promptly to customer needs; Solicits customer
feedback to improve service; Responds to requests for service and
assistance; Meets commitments.
English Language — Knowledge of the structure and content of the
English language including the meaning and spelling of words, rules of
composition, and grammar.
Oral Communication - Speaks clearly, persuasively and professionally
in positive or negative situations; Listens and gets clarification;
Responds well to questions; Demonstrates group presentation skills;
Participates in meetings.
Written Communication - Writes clearly and informatively; Edits work
for spelling and grammar; Varies writing style to meet needs; Presents
numerical data effectively; Able to read and interpret written
information.
Teamwork - Balances team and individual responsibilities; Exhibits
objectivity and openness to others' views; Gives and welcomes feedback;
Contributes to building a positive team spirit; Puts success of team
above own interests; Able to build morale and group commitments to goals
and objectives; Supports everyone's efforts to succeed.
Ethics - Treats people with respect; Keeps commitments; Inspires the
trust of others; Works with integrity and ethically; Upholds
organizational values.
Reasoning - Ability to apply common sense understanding to carry out
instructions furnished in written, oral, or diagram form. Ability to
deal with problems involving several concrete variables in standardized
situations.
Physical Demands: The physical demands described here are
representative of those that must be met by an employee to successfully
perform the essential functions of this job.
HOW TO APPLY:
If you meet the qualifications and requirements stated above send
your application and detailed CV with relevant documentation to the
********************y
18th May 2021.
We regret that only short-listed candidates will be contacted.
Feed the Children is an Equal Opportunity Employer
Important Safety Tips
1. Do not make any payment without confirming with the BrighterMonday Customer Support Team.
2. If you think this advert is not genuine, please report it via the Report Job link below.
