Development and maintenance of database procedures, reports, and automated jobs. Enhancement of existing database functions based on new/changing business requirements.
Report, research, correct, and test defects in reports, stored procedures, and other database related functions. Accurately translate business requirements into functional implementations.
Evaluate data quality in databases and across the data warehouse as well as against the extract, transfer, and load (ETL) workflow. Identify, analyze, and interpret trends or patterns in complex data sets. Design, document, maintain, execute system tests and requirements around data and data quality.
Identify and leverage opportunities to improve data management processes, systems, and standards.
Other duties as assigned.
Report progress weekly to management and project manager.
Qualifications
Required skills (rank in order of importance):
SQL server experience
Backup / recovery operation
Database planning and design
Database monitoring / performance tuning
Load balancing
Database upgrading
Red gate toolsets
Additional Information
Additional Skills: 1 year experience with Database monitoring also required.