[The logo is protected from the company]

McGraw-Hill Companies, Inc. (The)

The McGraw-Hill Companies, Inc. provides information services for the financial, education, commercial, and commodities markets worldwide. The company operates in four segments: Standard & Poor's (S&P) Ratings, S&P Capital IQ/S&P Indices, Commodities & Commercial (C&C), and McGraw-Hill Education (MHE). The S&P Ratings segment offers credit rating services; and information and independent benchmarks to investors for their investment and financial decisions, and acce... Read More

Address      1221 Avenue Of The Americas New York, NY 10020 United States
Website      www.mcgraw-hill.com/
Holding      No Holding Details

View Company Page
Apply to job

Database Architect

Bentek is currently seeking a Senior Database Architect to join their team.  The Senior Database Architect is responsible for analyzing the use of data and interpreting data directly to the goals of Bentek Energy in a way that provides unambiguous results. The incumbent must guarantee the accuracy and accessibility of all valuable data, and be tasked for knowing what data is important and why.

 

Responsibilities:  

    * Responsible for identifying and interpreting the data needs of specific business groups.
    * Responsible for overseeing the design, assessment, development, implementation and maintenance of the major databases and metadata structures.
    * Responsible for observing and keeping up with industry trends and new technologies in order to provide sound technical recommendations to senior management.
    * Responsible for formulating data and metadata policies and procedures for functional design and development to build, maintain and upgrade the data model, also while ensuring compliance with corporate data standards.

 
Qualifications
 

 

Required:

    * Strong experience in interpreting business requirements into a plan to design, develop, implement and maintain database systems to meet company goals, as well as completing from start to end database solutions for the company.
    * Strong experience with master data concepts.
    * Experience in Database Administration knowledge in SQL Server ( 2005, 2008 R2,  and 2012 )
    * Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, database mirroring issues, security issues, etc.
    * Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.
    * Ability to detect and troubleshoot SQL Server related CPU problems, memory problems, I/O problems, and disk space and other resource contention.
    * Knowledge of backups, restores, recovery models, database shrink operations, DBCC commands, Clustering, Database mirroring, Replication.
    * Knowledge of how indexes work, index management, integrity checks, server configuration, patching. How statistics work, how indexes are stored, how they can be created and managed effectively.
    * Knowledge of SQL Server tools ( Profiler, SSMS, PerfMon, DMVs, system sprocs)
    * SQL Development – ability to write and troubleshoot SQL Code and design using T-SQL ( stored procedures, functions, tables, views, triggers, indexes, constraints )
    * Acquaintance with windows server 2008 R2, security delegation, SPNs, storage components.

Preferred:

    * Experience with Powershell and or SSIS desired.
    * Any experience with the BI stack – SSIS, SSRS, SSAS desired.

Benefits

Regular full-time employees of The McGraw-Hill Companies routinely receive the following benefits:

    * Medical, Dental, Vision insurance, Flexible spending accounts with company contribution
    * 401K with company matching, long-term and annual incentives, stock purchase program
    * Many work/life benefits such as low-cost emergency child- and elder-care, parental leave for birth or adoption, flexible work arrangements, volunteer opportunities, employee assistance programs, tuition reimbursement, employee discounts, and much more

About the Company
BENTEK is an energy market information, analysis and decision tools company based in the heart of the Rocky Mountain Front Range, just 25 miles west of Denver Colorado.  The firm provides data, analytical tools, research, market advice and strategy recommendations focused on the energy market with a special emphasis on buyers, sellers and transporters of natural gas.  Our flagship products are Energy Market Fundamental reports and the Benport Data Warehouse™ an information service and set of associated technologies used by participants in the North American natural gas market for the examination, analysis and visualization of pipeline flows and capacity utilization at specific receipt and delivery points.
 
The future of energy is in your hands.  At Platts, the world's leading energy information provider, traders, risk managers, analysts, and industry leaders will depend on you to help them make better trading and investment decisions in the all-important energy markets. Our real-time news, pricing, analytical services and conferences help markets operate with transparency and efficiency.  With more than 600 employees in 17 offices spanning five continents, you get the best of a small company and a Fortune 500 corporation at Platts.  We have a highly diverse workforce, a global perspective, and a "business casual" culture. Platts is a division of The McGraw-Hill Companies.
 

The McGraw-Hill Companies (NYSE: MHP) is a Fortune500 corporation with over 20,000 global employees and over 10,000 U.S. employees. Around the world, McGraw-Hill provides people with the information and insights they need to adapt and grow in changing times. Our business spans the fields of financial services, education, and business information with leading brand names such as Standard & Poor's, McGraw-Hill Education, Platts, and J.D. Power & Associates. By working together with our customers and partners, these brands are laying the foundation for a smarter, better world.

 

The McGraw-Hill Companies is an equal opportunity employer. Only electronic job submissions will be considered for employment. For special accommodation due to disability, please email webmaster -at- mcgraw-hill.com and your request will be forwarded to the appropriate individual.
 

Other Job Information

Vacancy type:

Full Time

Contact Mode:

not provided

Fax:

+1-212-5123840

Contact Name:

not provided

Job Duration:

not provided

Phone:

+1-212-5122000

Email:

not provided

News - McGraw-Hill Companies, Inc. (The)

Related Jobs

BFSI Solution Architect

    *  Execute ”Seeing is Believing” events for prospect ...   [more]

Application Architect

 This individual contributor provides expertise and guid ...   [more]

IT Enterprise Architecture

Celgene Corporation is committed to delivering innovativ ...   [more]

Principal Architect Security & Infrastructure

Responsible for the articulation of the infrastructure e ...   [more]

Architecture Group Manager

Identify the current state of how IT is currently being ...   [more]

Architect Specialist

Description -Serve as solution architecture in the integ ...   [more]

Domain Architect

Works with various stakeholders to understand the busine ...   [more]

Architect

Description • Develop a thorough understanding of Global ...   [more]

Expand

Collapse