Database Engineer II

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.