The Sr. Database Engineer is responsible for the integration of client data elements into the defined architectural standard for use by various departments throughout the organization. This individual will assist project teams with tasks associated with the Initiation, Planning, Development, Deployment, and Ongoing Support Maintenance phases of our Agile Methodology in accordance with the documentation that is provided defining project scope and deliverables. These activities may include the development of data structures, ETL development, BI report development, and campaign execution.
Essential Duties and Responsibilities
Develop Logic and Physical models based on the definedarchitecture
Data Integration into approved architectures
Extract Transform Load (ETL) development andtesting
Submission of ETL solutions for final approval to the Systems Administrator
Development of appropriate notification / alert strategies within all ETLs
Serve as Subject Matter Expert (SME) within the Data Services Department for multiple clients / projects
Develop BI solutions using various toolsi.e.Azure Data Factory, SSIS, to meet organizational needs
Develop, implement and support customer user-defined stored procedures, functions, andviews
Maintain dataintegrity
Suggest software, hardware, and process-level improvements to uppermanagement
Suggest overall process improvements for existing solutions to uppermanagement
Supply proper data documentation for various project phases (as necessary),i.e.Entity-Relationship Diagrams, Data Dictionaries, ETL definitions
Advise Systems Administrator on effective backup / replication scheduling.
Capacity / scalability planning for expanding dataneeds
Provide 24 / 7 support for clients / projects serving as the SME (as necessary)
Integration of various 3rd data objects,i.e.Acxiom,DataFlux
Development and implementation of various Householding strategies as defined by PM on a per-clientbasis
Participate in peer codereview
Other duties and responsibilities asassigned
Sense of ownership and pride in your performance and its impact on the company's success
Critical thinker and problem-solving skills
Background / Experience
Excellent understanding of T-SQL
7+ years Microsoft SQL Server 2016 and above
7+ years IT industry experience; Marketing or Advertising experience a plus
Excellent skills with ETL tools like Azure Data Factory and SSIS
VB Script, C#, .NET, and Azure Cloud experience a plus
MCSA, MSCE, MCDBA Certifications a plus
Advancedproblem-solvingskills and excellent communication skills
Team player
Good time-management skills
Great interpersonal and communication skills
Database Engineer • Houston, TX, United States