SQL Server Developer I

SQL Server Developer

Setting new standards for industrial process automation solutions in the metropolitan New York City tristate area, Control Associates, Inc. is a premier provider of process automation systems, valves, measurement, pressure management, asset reliability and data management solutions. We are looking to hire a SQL Server Development Engineer to work out of our headquarters in Allendale, NJ.

Established in 1933, Control Associates along with its global process automation business partner, Emerson, specializes in supporting the process control equipment and service needs of the following industries: Biotech, Chemical, Food & Beverage, HVAC, Hydrocarbon Processing, Natural Gas Distribution & Transmission, Oil Refining, Pharmaceuticals, Power Generation, Pulp & Paper, and Water & Wastewater Treatment.

Responsibilities

• Develop many complex SQL statements that maintain stability, reliability, and performance of databases
• Create Stored Procedures and complex functions.
• Rewrite and optimize existing SQL statements to establish best practices
• Write complex queries for applications
• Manage database standard procedures including, upgrade, backup, recovery, migration, etc.
• Work directly with SQL Server DBAs to perform certain DBA tasks
• Ensure performance, security, and availability of SQL Server databases
• Manage SQL Server Database integration with specific tools and software, including Business intelligent software and Workflow Management tools.
• Responsible for troubleshooting ordinary database issues
• Become a SQL Server expert, who continuously thinks about performance improvement and optimal usage
• Other responsibilities as assigned by the Engineering Manager.

Required

• Bachelor’s degree required, concentration in Comp Sci, Biology or Chemistry preferred.
• 2 years’ professional experience with SQL Server development required any applicable academic experience may also be considered.
• Experience writing stored triggers and procedures is required.
• Experience with SQL Server SSIS packages is highly preferred.
• Must have excellent written, verbal and electronic communications skills.
• Must have experience working within a development team
• Please note that work visa sponsorship is not available for this role.
• This is a direct placement position; third party contracts are not available.
• This is not a remote opportunity, if not local to Allendale, NJ, relocation to NYC tristate area will be required

Control Associates, Inc., offers competitive salaries that include a bonus potential.

Excellent benefits, including multiple medical plan choices, vision, and dental insurance with coverage for both employees and dependent family members. Medical and dependent care flexible spending benefits, health savings accounts, company paid for long-term disability and life/ADD insurance plans with a buy up option.

Paid time off including vacation days, holidays, and sick days

Our retirement plans include a 401(k) plan (with company match) and an Employee Stock Ownership Plan (ESOP), is a company-funded benefit that provides additional retirement compensation to qualifying employees.

Certification/Training, we provide both in-house and Client/System specific technical training

Control Associates Inc. is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to age, creed, race religion, color, national origin, citizenship, disability, sex, marital status, sexual orientation, familial status, gender, ancestry, or liability for services in the U.S. Armed Forces, or any other characteristic protected by federal, state, or local laws. This policy applies to all terms and conditions of employment.

Control Associates participates in E-Verify. Click here to view E-Verify Participation Poster