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
· Bachelor’s degree (B.A. or B.S.) from a four-year college or university
· 3-5 years’ experience with T-SQL, SQL, SSIS, SSMS, SSRS, ETL, HTML/CSS.
· 3-5 years’ experience in Database Administration in SQL Server
· 3-5 years’ experience in Microsoft Visual Studio
· 3-5 years’ experience with Microsoft VSTO Add-ins
· 3-5 years’ experience with Data Analytics (i.e., Qlik, Tableau, Power BI)
SKILLS
· Technical expertise: In-depth understanding of database technologies, and cloud-based databases, as well as proficiency in database design, normalization, and data modeling.
· Data Visualization & Reporting: Skilled in creating dynamic, interactive dashboards, reports, and visualizations that provide actionable insights and support data-driven decision-making.
· Problem-solving skills: Ability to diagnose and resolve complex database issues, including performance bottlenecks and security vulnerabilities.
· Communication skills: Clear and effective communication skills, both oral and written, to explain technical concepts to non-technical stakeholders.
· Attention to detail: Careful and thorough approach to work, with the ability to identify and correct errors before they become major problems.
· Project management skills: Ability to prioritize and manage multiple projects, meet deadlines, and work under pressure.
· Collaboration and teamwork: Strong interpersonal skills, ability to work well in a team environment, and willingness to share knowledge and collaborate with others.
· Adaptability: Ability to learn and adapt to new technologies and processes quickly and effectively.
· Initiative: Self-starter mentality, with a drive to continually improve processes and technologies.
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.