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

We are seeking an Entry-Level Building Information Modeling (BIM) Piping Detailer to assist in the day-to-day drawing, layout, and detailing of all PM BIM Projects.
The Auditor will be responsible for conducting audits related to contracted programs and entities
Lead a crew and oversee electrical commercial construction projects ranging in size from $1/2 million to $10 million in size
We are seeking a highly motivated and experienced software developer. In this role you will be responsible for the design, development, implementation, and maintenance of Oracle Integration Cloud integrations and Oracle Fusion Cloud Applications. This role will require a strong understanding of Oracle Cloud architecture, along with experience in middleware tools SOA/OICS, VBCS and APEX.

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.