Senior SQL Server DBA
Capital IQ - New York, NY

This job posting is no longer available on Capital IQ. Find similar jobs: Capital IQ jobs

-

27668

Description

S&P Capital IQ

delivers in-depth intelligence across asset classes and capital structures to more than 4,200 institutions, wealth managers and investment advisors around the world. Built on the 150-year heritage of Standard & Poor’s, S&P Capital IQ brings together key capabilities in research, strategy, evaluation, analysis, data solutions and risk mitigation under one roof. A client-centric firm, S&P Capital IQ has the institutional fortitude of over $1 billion in annual revenue, yet is nimble enough to respond to any client request with a customized, real-world solution.

S&P Capital IQ is currently seeking a Senior SQL Server DBA. As a Senior SQL Server DBA, you will be part of Global Database Team within the Operations and Reliability Organization. The successful candidate will be responsible for administration and maintenance of production database servers, participate in the design of complex database systems, performance tuning and on-call support during off hours and weekends.

Responsibilities:
Experience in MS SQL Server 2008 installation and configuration with Clustered Environments of VLDB level databases in excessive of 1TB

Participates in the creation and enforcement of architectural standards: security, availability, replication, storage, archive/purge, configuration management, metadata and data dictionary

Participates in the creation and enforcement of database development standards and processes, including: naming, coding, database security, data access, documentation

Initiates proactive solutions and enforces best practice approaches to problem solving and maintenance of database systems

Monitors and optimizes system performance using index tuning, disk optimization, partitioning and other methods

Responsible for backups, recovery, and disaster recovery processes

Responsible for providing and reviewing trend analysis and make informed decisions regarding resource management

Performs logical and physical data modeling

Develops reliable and efficient database code to support enterprise reporting

Implements complex database solutions to support business needs

Qualifications

5+ years of experience with database maintenance and management, data/process analysis and modeling, logical and physical database design and development.

Strong troubleshooting skills for resolving various performance issues and tuning.

Expert-level knowledge of database design, implementation, transaction processing, referential integrity, performance tuning and monitoring with an emphasis in MS SQL

Exceptional data modeling, relational database design, and ability to create and implement physical databases from logical data models

Experience with developing and managing high availability solutions: replication, clustering, mirroring, log shipping

Demonstrated exceptional data-access coding skills: T-SQL, stored procedures, triggers, functions, and views.

Hands-on knowledge of database backup and recovery methods and tools (SQL native, Oracle RMAN, Idera, etc)

Self-starter who thrives in a fast-paced environment

Excellent analytical skills, with the ability to translate information and develop insights

Exceptional interpersonal skills, ability to lead working groups, negotiate and create consensus

Excellent oral and written communication skills, with the ability to engage with senior management

Oracle and Vertica experience is a plus

Hands-on experience with at least one of the following development environments/languages: C#, Java, .NET, JavaScript

Experience working with large scale enterprise environment

Bachelor's degree in Computer Science, Information Systems or Engineering is required

About the Company

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.

Schedule

Full-time

Primary Location

US-NY-New York

Job Type

Systems/Technology

Organization

Capital IQ

Corporate Brand

S&P Capital IQ

Capital IQ - 15 months ago - save job - block
Recommended Jobs
SQL server developer
AKT corp - Jersey City, NJ
AKT corp - 12 days ago

MySQL DBA
Tremor Video - New York, NY
Tremor Video - 20 days ago

SQL Server BA/Developer
Tier1 IT - New York, NY
Tier1 IT - 22 days ago
About this company
9 reviews
Getting some business intelligence is a capital idea. Capital IQ provides business research and analysis covering some 60,000 public...