Database Engineer
Malibu, CA

Job Description

Why We Work at Dun & Bradstreet

We are at a transformational moment in our company journey - and we're so excited about it. Each day, we are finding new ways to strengthen our award-winning culture, and to accelerate creativity, innovation and growth. Our purpose is to help customers improve business performance with Dun & Bradstreet's Data Cloud and Live Business Identity, and we're wildly passionate and committed to this purpose. So, if you're looking to make an immediate impact at a company that welcomes bold and diverse thinking, come join us!

Brief Description:

The Database Engineer engages directly with all groups within Technology.  This individual must perform in a fast-paced environment and will be responsible for working directly with the development team to support and deploy changes to the various test environments. The Database Engineer will be responsible for designing, modifying, developing, and implementing data driven solutions for our applications. This position will focus on the development and design of a robust, scalable database structures and queries. Responsible for designing databases and ensuring their stability, reliability, and performance and work with other developers optimizing SQL statements as necessary for applications.

Responsibilities:

Develops, designs and implements advanced SQL queries to improve operating efficiencies, reduce costs and meet the business needs.

Advanced knowledge and hands on experience of key technical concepts, such as: logical and physical data modeling, performance tuning, code reviews process, data normalization processes, data integration methods, production support, etc.

Provides guidance to the intra departmental team in the interpretation and application of the departments' and translate business needs to technical specifications.

Be part of cross-functional projects to address data requirements

Create, maintain, and modify SSIS Packages.

Analyze existing SQL / ETL Scripts and improving them to achieve better performance and reliability

Ability to manipulate data using SSIS and TSQL.

Ability to write complex stored procedures and TSQL code.

Experience in performance tuning SQL Server and SSIS Packages.

Ability to write efficient TSQL and ETL Code.

Experience/Education Requirements:

Bachelor's Degree in Technology or a related field of study

Must have at least 5 years of experience in as a Database Engineer for SQL Server (2012/2014/2016) in a multi-site enterprise environment supporting an ecommerce application.

Must have 5 years of experience with SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).

Must have thorough knowledge of indexes, index management, and statistics on SQL Server. Must have experience in troubleshooting and resolving SQL Server database problems related to code performance.

Must have experience with Team Foundation Server and GIT.

Must have experience supporting development through multiple environments.

Must have 2 years of Python, C# and PowerShell development experience

Must have 2 years of experience working in an AWS cloud environment.

Strong knowledge with big-data data lake design, including data validation, data ingestion, data consuming.

Fluent in Enterprise Data Modeling (Dimensional & Relational) with a solid understanding of the Data modeling concepts like Star-Schema Modeling, Snowflakes Modeling, Fact and Dimension Tables modeling of data at all the three levels: conceptual, logical & physical design.

Proficient in writing Transact SQL queries involving creation of Tables, Views, Stored Procedures, File groups, Partitions, performing inserts, updates, deletes using Joins, Sub queries, Cursors and adding constraints on the tables.

Dun & Bradstreet is an Equal Opportunity Employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, creed, sex, age, national origin, citizenship status, disability status, sexual orientation, gender identity or expression, pregnancy, genetic information, protected military and veteran status, ancestry, marital status, medical condition (cancer and genetic characteristics) or any other characteristic protected by law.

We are committed to Equal Employment Opportunity and providing reasonable accommodations to applicants with physical and/or mental disabilities. If you are interested in applying for employment with Dun & Bradstreet and need special assistance or an accommodation to use our website or to apply for a position, please send an e-mail with your request to TalentAcquisitionTeam@dnb.com. Determination on requests for reasonable accommodation are made on a case-by-case basis.

Please note that all Dun & Bradstreet job postings can be found at https://dnb.wd1.myworkdayjobs.com/Careers and all communication from Dun & Bradstreet will come from an email address ending in @dnb.com.