SQL Developer

The Senior Database Developer is an expert in SQL Server database systems, configuration best practices, normalization strategies and coding standards. They are responsible for collaborating with the development team on future enhancements and improving existing systems through normalization and SQL optimizations. They coordinate database development tasks with project managers and work closely with the development team to translate business requirements to database design and implementation. They serve as an authority on database best practices and inform proper database design and performant SQL implementations

Responsibilities

Serve as a database authority and mentor team members on database best practices to inform proper database design and performant SQL implementations
Collaborate with the application development teams on database design and query optimization
Review and optimize SQL queries and stored procedures, verify they adhere to coding standards, performance recommendations and security best practices
Participate in regular sprint planning, retrospectives, daily scrum and other group functions as part of agile development teams
Support the operations teams on production issues, deployments, server maintenance, Disaster Recovery (DR) strategies, backups and other production service requests
Collaborate with the analytics team to define and implement data warehousing, ETL, Data Analysis and Reporting
Position requires occasional after-hours work during releases or other critical initiatives

Required Experience

Expert developing Microsoft SQL Server databases in a large scale multi-tenant enterprise environment
Expert in writing and reviewing performance optimized T-SQL including stored procedures and functions in a multi-tenant high-volume enterprise database environment
Expert in translating business requirements into normalized, performant database schema
Expert in database normalization and denormalization
Expert in analyzing and optimizing query performance through schema changes, SQL enhancements and indexing strategies
The ideal candidate:
Will be able to work independently as well as in a group
Will suggest improvements to both the technology and business functionality of the product
Will estimate work activity, will deliver high-quality, low-defect engineering work product within established timelines and will ensure effective information flow throughout
Will have excellent communication skills, a strong work ethic, good time management and decision making capabilities

Preferred Experience

10+ years of experience developing SQL in an enterprise environment 10+ years of experience designing and implementing databases in an enterprise environment Bachelor’s degree in Computer Science or equivalent in a related field

Post Date

Job Type

Full Time

Location Type

Remote

Location

Harrisburg

Salary Range

$110,000-$130,000

Latest Jobs Listings

Open Jobs & Careers in Pennsylvania & Maryland

The DevOps Engineering Manager is responsible for overseeing the implementation and optimization of DevOps practices, leading the development and maintenance of automated deployment pipelines, ensuring smooth software delivery by fostering collaboration between development and operations teams, and managing the technical infrastructure necessary for continuous integration and deployment (CI/CD) while prioritizing team efficiency and performance. They will manage and optimize infrastructure cost, ensure adherence to security best practices, guarantee system uptime and reliability and lead incident response teams to quickly identify and resolve production issues.
The Project Manager will layout the jobs he/she is assigned. He/she will send the material lists out for quotes, purchase the material, track submittals, order special material, return any material that needs replaced or is defective. He/she will communicate on a daily basis with CFO with regards to any change orders or issues/concerns with invoicing the job. He/she will take job meetings and provide minutes from those meetings to share with the office. He/she will pull permits and call for inspections. He/she will work with other subcontractors and organize fire alarm, security, etc. He/she will coordinate with the job foreman and make sure all close out documents, time sheets and paperwork are sent back to the office. Oversees the safety of the job site and makes sure all toolbox talks are completed weekly. If there are any special safety concerns, makes owners and office aware of them.
The Design & Fabrication manager is responsible for the design and fabrication part of “do work” function. Design includes preparing shop drawings, line work from scan data, production drawings, installation drawings, as-built drawings and more. Fabrication encompasses the fabrication shop where materials are cut, and panels are fabricated and crated for shipment to a project. The role sits on the company’s leadership team.
The Process Manufacturing Engineer is responsible for complex problem-solving activities in the areas of manufacturing and new product implementation. These specific problem-solving activities can include safety improvements and initiative support, manufacturing cost reduction, manufacturing efficiency increases, operational excellence and continuous improvement, increase equipment reliability, preventative and predictive maintenance, development of critical spare parts lists, and support of new product introduction initiatives at the site manufacturing level.

Latest Career & Hiring Insights

If you have an interview scheduled, there’s a lot to consider and prepare for. We’re here to help with that, and sell yourself the most effectively to get your dream job.