HarperCollins Publishers

SQL Server Programmer

US-PA-Moosic
Category
Information Technology

Overview

Harper Collins is seeking an experienced SQL Server professional to join their centralized Data Management team, which encompasses an enterprise-wide scope in terms of managing, surfacing and controlling corporate data assets and providing technical support for data access, data definition and data management. This person will code and analyze SQL Servers programs that support both software applications as well as those used in data warehousing/analysis. This will involve working with business analysts and other PMO partners to develop and execute data migration plans, administer data management procedures and support and rectify daily operational production issues. It will also involve working closely with software developers to optimize database and query performances. This position reports to the Manager, SQL Systems, working closely with the PMO and business teams.

 

Responsibilities

 
The essential responsibility of this developer is to analyze/create/debug views, functions, triggers and stored procedures using SQL, while coordinating with other Software development teams. This requires strong knowledge and experience with modern SQL Server technology (later editions such as 2008/2012 preferred), as well as strong knowledge of SQL Server internals with an emphasis on how to optimize query performance. Additionally, strong knowledge of database,scripting in C#, with or without the use of SSIS (which is a plus), will be required for the purposes of data extraction, manipulation and transformation. Knowledge of Mulesoft Dataweave is a plus as well.

 

The selected candidate should be willing to work on production issues which may require availability after business hours (either remotely or in person).

Qualifications

  • Experience with MS SQL Server 2000/2005/2008 – 2008/2012/2014 preferred
  • Technical fluency in all phases of the data management lifecycle
  • Demonstrated proficiency with database programming using T-SQL, as well as scripting using C# focused on data manipulation and transformation
  • Experience in designing and creating complex SSIS based programs is a plus.
  • Mulesoft Dataweave experience is a plus

 

About the Company:

 

HarperCollins Publishers is the second largest consumer book publisher in the world, with operations in 18 countries. With nearly two hundred years of history and more than 120 branded imprints around the world, HarperCollins publishes approximately 10,000 new books every year in 17 languages, and has a print and digital catalogue of more than 200,000 titles. Writing across dozens of genres, HarperCollins authors include winners of the Nobel Prize, the Pulitzer Prize, the National Book Award, the Newbery and Caldecott Medals and the Man Booker Prize. HarperCollins, headquartered in New York, is a subsidiary of News Corp (NASDAQ: NWS, NWSA; ASX: NWS, NWSLV) and can be visited online at corporate.HC.com.

HarperCollins Publishers is an Equal Opportunity Employer.

 

Please note that HarperCollins Publishers does not accept resumes from agencies unless our Human Resources department has authorized in writing a specific agency to submit resumes for a specific position.  Therefore, if an agency submits a resume without Human Resources’ prior written approval to do so, the individual identified on that resume will not be considered a candidate presented by your company. 

 

 

Options

Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed