Coordinate and work with other technical staff to develop relational databases and secondary databases.
Develop automated database applications, where necessary, using the applicable database packages.
Identify inefficiencies in current databases and leverage solutions.
Install and configure relevant components to ensure database access and overall database security.
Diagnose and resolve database access and performance issues.
Analyze user requirements and, based on findings, design functional specifications for client/server databases and database applications.
Evaluate and select database components, including hardware, relational database management systems, ETL software, metadata management tools, and database design solutions.
PERCENTAGES OF JOB RESPONSIBILTIES
% OF JOB
DESCRIPTION
75%
Integrations between various data sources, mainly MS SQL 2008/2012. This includes writing queries, triggers, stored procedures, data quality, data validity, and ensuring database integrity. Highly technical. Highly logical.
20%
Working with the Development team (Cold Fusion) in order to ensure that the coding is in line with the database structure and database attributes.
5%
Determining data quality issues, troubleshooting data issues
Knowledge, Skills & Experience
Years of direct experience in enterprise-level data integrations
Proven experience in overseeing the linking of cross-functional databases between disparate business units and systems.
Strong experience writing SQL queries, stored procedures and triggers
Strong experience with database platforms, including Microsoft SQL 2008/2012
Experience with database design applications, including Microsoft SQL 2008/2012.
Maintain high standards of data quality through the introduction and enforcement of information handling processes and organization of the data integration processes.
Hands on experience with business and technical requirements analysis, business process modeling/mapping and methodology development, and data mapping.
Working technical knowledge of current database software, protocols, and standards.
Strong understanding of database structures, theories, principles, and practices.
Working technical experience with designing, building, installing, configuring and supporting database servers, including Microsoft SQL 2008/2012.
Strong knowledge of system and software quality assurance best practices methodology.
Hands-on database tuning and troubleshooting experience.
Experience with data processing flowcharting techniques.
Technical Project management experience.
Working technical experience with developing, installing, configuring and supporting database environments.
Knowledge of applicable data privacy practices and laws.
Personal Attributes
Highly self-motivated and directed.
Highly Logical.
Keen attention to detail.
Proven analytical and problem-solving abilities.
Ability to effectively prioritize and execute tasks in a high-pressure environment.
Good written and oral communication skills.
Strong technical documentation skills.
Good interpersonal skills.
Ability to conduct research into database issues, standards, and products as required.
Ability to present ideas in user-friendly language.
Strong customer service orientation.
Experience working in a team-oriented, collaborative environment.
Formal Education & Certification
College diploma or university degree in the field of computer science and 5+ years equivalent work experience.
