Database Developer at Feed the Children

REPORTS TO: VP OF IT SOLUTIONS

WORKS WITH: DATA HANDLING TEAMS IN THE ORGANIZATION

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.