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
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
SGC is a Certified Small Diverse Business for the Commonwealth of PA serving Harrisburg, Hershey, Mechanicsburg, Carlisle, Lancaster, Allentown, State College, York, Sunbury, Philadelphia & Baltimore.
