What are the responsibilities and job description for the Database Developer position at CEMCO1?
SUMMARY
The Database Developer is part of the CEMCO development team whose responsibilities include managing and maintaining the enterprise data warehouse. Strong development skills in C# and .Net, including Excel VSTO. The ideal candidate should have a deep understanding of database management systems, as well as the ability to write complex code in C# and .Net to build, maintain and optimize databases. Effective at communicating with users to define requirements and design, solutions based on those requirements.
This position is also responsible for creating tools that provide insight to various departments, including Finance, Accounting, and Customer Service to build data visualizations and dashboards.
ESSENTIAL DUTIES AND RESPONSIBILITIES
- Design, install, configure, and maintain database management systems.
- Monitor database performance and provide optimization.
- Develop, implement, and maintain backup and recovery procedures.
- Perform database security administration.
- Ensure data integrity, reliability, and availability.
- Write efficient and reliable C# and .Net code to access and manipulate data.
- Develop and maintain custom applications using Excel VSTO
- Collaborate with development and infrastructure teams to optimize performance.
- Effectively communicate technical requirements to user.
- Design and develop SSIS packages to automate ETL processes.
- Create, design, and maintain SSRS reports for various business requirements.
EDUCATION AND / OR EXPERIENCE, CERTIFICATIONS, REGISTRATIONS
SKILLS
PHYSICAL DEMANDS :
While performing the duties of this job, the employee is regularly required to talk, hear, sit, stand, type, and walk. The employee frequently is required to use hands or fingers, handle or feel objects, stand, walk, sit and reach with hands and arms. The employee must routinely lift and / or move 30 pounds and occasionally lift and / or move up to 50 pounds. Specific vision abilities required by this position include close vision, distance vision, and the ability to adjust focus and spend long periods of time looking at a monitor. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
WORK ENVIRONMENT :
This job operates in a professional office environment. This role routinely uses standard office equipment such as computers, phones, photocopiers, filing cabinets and fax machines. The noise level in the work environment is usually low to moderate.