Database Engineer

5 - 7 years experience  •  Business Services

Salary depends on experience
Posted on 02/22/18
Concord, MA
5 - 7 years experience
Business Services
Salary depends on experience
Posted on 02/22/18

Why We Work at Dun & Bradstreet

Life here at Dun & Bradstreet is changing – for the better. With almost two centuries of experience and a new modern vibe, work at D&B has never been more exhilarating. Our purpose is to grow the most valuable relationships in business by uncovering truth and meaning in data. We’re wildly passionate about our purpose, and it has us evolving everything we do – from how we engage with our customers to how we energize one another. So if you thrive in a fluid, agile culture but want the solidity of a storied and commanding brand, come join us!

Job Title: Database Engineer

Why We Work at Dun & Bradstreet

Life here at Dun & Bradstreet is changing – for the better. With almost two centuries of experience and a new modern vibe, work at D&B has never been more exhilarating.

Our purpose is to grow the most valuable relationships in business by uncovering truth and meaning in data. We’re wildly passionate about our purpose, and it has us evolving everything we do – from how we engage with our customers to how we energize one another.

So if you thrive in a fluid, agile culture but want the solidity of a storied and commanding brand, come join us!

Our Technology Team:

Technology is a global team that creates and operates the systems that deliver D&B data into our customer’s ecosystems. We eat, breathe, and dream of technologies that run our business today - and those that will transform the way we deliver value in the future.

Job Description:

• Helps develop and innovate strategies for OLAP/OLTP infrastructure database management, archive recovery, and migration

• Evaluates and analyzes existing data using Transact SQL and other data profiling tools

• Evaluates and improves database efficiency, table design, and maintenance strategies

• Resolves performance and capacity issues specific to working in a global, distributed environment with emphasis on maximizing replication efficiency

• Manages alerts, reports, and automated processes for failed jobs as appropriate

• Conducts QA audits and analyzes trends for changes in key metrics

• Stores, trends, and analyzes database and system performance measurements

• Evaluates and enforces security measures according to policies using best practices, such as:

Minimizing the scope of exposure to logins Updating security patches Isolating service accounts for administrative jobs Performing necessary security audits

Required Skills/Job Specifications

  • Working understanding of DMV’s, DTA and SQL Profiler with the ability to troubleshoot queries and analyze execution plans
  • Very strong T-SQL development skills and knowledge of SQL internals
  • Solid understanding of multi-tier architecture environment or Service Oriented Architecture
  • Working knowledge of SSIS packages and best other practices

Required Experience/Qualifications:

• 5-7 years of any combination of OLTP, OLAP, data warehousing, or business intelligence experience

• Development experience in SQL Service 2012 or higher

• SQL Server Integration Services (SSIS)

• ETL processes and practices in a VLDB data warehousing and data mart environments

• Ability to write queries, stored procedures, triggers and follow execution paths

• Ability to optimize poorly performing queries using T-SQL best practices

Bonus skills:

  • Extending SQL server with C# CLR
  • Experience with SQL server 2016 features. (real time analytics)
  • Experience with SSAS
  • Experience with NoSQL technologies.

R-02578

Not the right job?
Join Ladders to find it.
With a free Ladders account, you can find the best jobs for you and be found by over 20,0000 recruiters.