Senior SQL Database Developer
Job Description
SofterWare is on the “Philly.com Top Workplaces” list for the seventh time! We have enjoyed over 35 years of continuous growth because our employees and customers are happy. Our employees are offered a challenging and rewarding career along with a generous benefits program. SofterWare is a fun place to work and we support a work-life balance.
We offer benefits such as time off to volunteer, meditation classes, and a casual dress environment. In addition, we enjoy company events like a family Halloween open house and an annual holiday party. Our open office is state of the art and provides you with access to a gym, cafeteria, and walking trails, which will keep you energized.
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 practicesParticipate 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
Reasonable accommodations may be made to enable individuals with disabilities to perform these essential functions.
Requirements
- 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
Education and 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
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
"Life at SofterWare is rewarding in many ways. The flexible work schedules allow for a great balance outside of the office. In daily activity, I love working with knowledgeable members from all departments when troubleshooting issues as well as gaining insights for improvements to the current products and future enhancements. I have found that my coworkers have great knowledge of the fundraising industry and they enjoy sharing that experience to make our products the best they can be. "
Matt Krout
Product Developer