Job Description
_ Please note; this position is based in the City of Industry, CA._
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.
Company Description
CEMCO, LLC, is the premier manufacturer of steel framing and metal lath products and accessories in the United States. CEMCO's manufacturing facilities are located in the Los Angeles, California; Pittsburg, California; Denver, Colorado, and Fort Worth, Texas.
Since 1974, CEMCO has taken a leadership role in the steel framing and metal lath industries by pursuing innovation at break-neck speed allowing for efficient, economical, and effective solutions for tomorrow's challenges. The latest is RC1-XDTM, a new solution for high-end sound abatement resilient channels. Also available to all CEMCO customers is Safety Edge technology providing safer framing products for end users. CEMCO also manufactures market leading firestopping solutions and slotted track for head-of-wall applications, Sure-Board for shear-walls, Sure-Span steel floor joists for commercial and mid-rise projects, the ProX Header and ProX R.O. Rough-Opening framing systems.
CEMCO is a proud member of the Steel Framing Industry Association (SFIA) and ASTM. All of CEMCO's products are manufactured from mill-certified hot-dipped galvanized PRIME steel, giving the industry confidence CEMCO's products will perform as intended long after the project completion. CEMCO's Design and Structural Engineering and Technical Services Groups provide support to engineers and contractors before, during and even after a project is complete.
CEMCO, LLC, is the premier manufacturer of steel framing and metal lath products and accessories in the United States. CEMCO's manufacturing facilities are located in the Los Angeles, California; Pittsburg, California; Denver, Colorado, and Fort Worth, Texas.\r\n\r\nSince 1974, CEMCO has taken a leadership role in the steel framing and metal lath industries by pursuing innovation at break-neck speed allowing for efficient, economical, and effective solutions for tomorrow's challenges. The latest is RC1-XDTM, a new solution for high-end sound abatement resilient channels. Also available to all CEMCO customers is Safety Edge technology providing safer framing products for end users. CEMCO also manufactures market leading firestopping solutions and slotted track for head-of-wall applications, Sure-Board for shear-walls, Sure-Span steel floor joists for commercial and mid-rise projects, the ProX Header and ProX R.O. Rough-Opening framing systems.\r\n\r\nCEMCO is a proud member of the Steel Framing Industry Association (SFIA) and ASTM. All of CEMCO's products are manufactured from mill-certified hot-dipped galvanized PRIME steel, giving the industry confidence CEMCO's products will perform as intended long after the project completion. CEMCO's Design and Structural Engineering and Technical Services Groups provide support to engineers and contractors before, during and even after a project is complete.