PRIMARY RESPONSIBILITIES: Works collaboratively with Java development teams throughout the product design and development processes, to ensure optimal usage of SQL Server for storage and transaction processing Writes, refines, and optimizes T-SQL code for maximum performance, reliability, and maintainability Analyzes and interprets complex requirements, translating these into efficient backend processes Ability to reverse-engineer legacy code at times, improving and refining older T-SQL using newer and more efficient techniques and approaches Designs and implements relational databases and structures as needed Participates in developing cutting-edge storage design structures and data processing flows Creates documentation for both new and existing code POSITION REQUIREMENTS: SKILLS AND QUALIFICATIONS: 2-4+ years working as a database engineer or related role Intermediate to Advanced level T-SQL experience, including query tuning and optimization Experience with reporting platforms, and the ability to translate business needs into functional and efficient T-SQL driven reports SQL Server Administration experience is a plus ETL experience is also a plus Intimate knowledge of SSMS, and working knowledge of the other MS SQL Server Tools Ability to work with differing workflows, including agile, to quickly respond to a variety of business needs Has sound and demonstrable knowledge of best practices with regard to database development and coding standards Experience with Source Control and workflow ticketing systems IDERA for SQL Server tools, including Diagostic Manager and Admin Toolset Experience with SQL monitoring tools (Idera, Solarwinds, etc) a plus Knowledge of, or experience using, advanced SQL Server functionality (Examples include: service broker, resource governor, temporal tables, query store, Always-On, stretch database, etc) JOB COMPLEXITY: Position can involve complex logic and algorithms, and may require creative solutions at times.
Leverages experience to promote best practices and help define procedures. Works with a team to promote innovation and knowledge transfer across the organization. SUPERVISION: Works under general supervision, primarily independent. EXPERIENCE: 2-4+ years of experience of database administration or development. EDUCATION: Bachelor’s degree or higher in Computer Science or a related field, or equivalent functional experience in the area.
WORK ENVIRONMENT: Occasional off-hour/evening/weekend and/or overtime hours will be required.
Job description provided by mPulse.
View the original posting
