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.
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
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
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.
S&P Capital IQ
Getting some business intelligence is a capital idea. Capital IQ provides business research and analysis covering some 60,000 public...