SQL Data Engineer

Skills

• Must have the ability to communicate highly technical information to both technical and non-technical personnel • SQL Server 2000 2005 2008 2008 R2 2012 2014+ • Windows Server 2003 2008 2008 R2 2012+ • SSIS SSAS SSRS as well as the SQL Server Database Engine and SQL Server Agent • Microsoft Office (Word Excel Visio)

Description

• Ensure SQL Server services and databases are operational and available to end users and processes

• Perform backup and restore operations, including cloning production databases to development, quality control, and customer test environments

• Review, install, test, schedule, and move to production all security patches for all environments, including database engine, SSIS, SSAS, SSRS

• Add, delete, and modify logins and permissions in all environments as needed

• Monitor SQL Server and Windows Server performance, making adjustments when necessary following approved technical and Change Control procedures

• Create, manage, and troubleshoot SQL Server Agent jobs and SSIS packages

• Design, document, and implement database schema and ETLs

• Write, document, implement, review, and tune stored procedures, functions, and ad hoc T-SQL queries

• Analyze and optimize database table indexes and statistics

• Manage database space usage and participate in storage capacity planning

• Work all SQL Server incidents and requests to completion, including: running scripts, reviewing logs and/or trace files, troubleshooting performance issues, and assisting developers as necessary

• Assumes other duties as assigned.

Responsibilities

• • Work within a collaborative Agile environment
• • Analyze requirements and create performant, scalable database structures, objects and stored procedures
• • Analyze, create and tune complex T-SQL code to ensure optimal performance and data integrity across very large data sets
• • Create, modify and deploy SQL Server Integration Services packages to extract, transform and load large sets of data
• • Troubleshoot database performance issues in an MSSQL environment
• • Review and tune code to ensure best practices, quality standards and data integrity
• • Configure database parameters and define data repository requirements, data dictionaries, and warehousing
• • Design and implement approaches to improve database performance, capacity, and scalability
• • Confer with appropriate managers and peer team members regarding problems with and capabilities of databases
• • Experience with Oracle database, Elasticsearch, GitLab, MySQL, PostgreSQL, Kafka a plus