OPIS Senior Database Administrator
Share
Job Location:
New York City, NY - USA
Monthly Salary:
Not Disclosed
Posted on:
30+ days ago
Vacancies:
1 Vacancy
Job Summary
Job Description:
About Our Organization:
Dow Jones is a global provider of news and business information delivering content to consumers and organizations around the world across multiple formats including print digital mobile and live events. Dow Jones has produced unrivaled quality content for more than 130 years and today has one of the worlds largest news-gathering operations globally. It is home to leading publications and products including the flagship Wall Street Journal Americas largest newspaper by paid circulation; Barrons MarketWatch Mansion Global Financial News Investors Business Daily Factiva Dow Jones Risk & Compliance Dow Jones Newswires OPIS and Chemical Market Analytics. Dow Jones is a division of News Corp (Nasdaq: NWS NWSA; ASX: NWS NWSLV).
About the Team:
Our Technology team drives the evolution of our Technology Engineering Data Product and User Experience functions. With a keen focus on delivering cutting-edge solutions we shape the digital landscape for our customers readers and users. From revolutionizing visuals to optimizing tools and harnessing the power of data mobile video and social platforms our team is committed to providing a seamless and immersive experience across all touchpoints. Collaborating closely with our newsrooms and strategic partners we spearhead the development of groundbreaking products and technologies.
About the Role:
OPIS a Dow Jones company provides price transparency across the global fuel supply chain including the Spot Wholesale Rack and Retail markets. The OPIS Cloud Operations team supports the OPIS business by ensuring the overall operational performance security and reliability of OPIS cloud environments. The team works closely with the OPIS Product development teams with a focus on high availability and continuous operation resource allocation and monitoring compliance and financial management. It provides guidance defines guardrails and ensures compliance with corporate and business unit as well as industry best practices and standards. The team is responsible for the configuration and management of the operational infrastructure of the OPIS cloud environments including the OPIS database systems for OPIS applications. This role is a part of the OPIS Cloud Operations team working with OPIS Product teams software engineers and database developers. As a Senior Database Administrator
You Will:
Oversee and manage OPIS database systems (MS SQL and IBM DB2) and their infrastructure to ensure optimal performance availability and security.
Manage database and database objects design configuration and testing activities to ensure the performance of the databases in support of OPIS applications from development to production.
Monitor system health database availability and performance diagnose and resolve technical issues resolve database performance and capacity issues replication and other distributed data issues and implement proactive measures to prevent disruptions.
Plan and execute database system housekeeping such as tuning indexing etc. and upgrades data migration and security patches.
Design database backup archiving and storage strategy. As well as develop and implement OPIS database systems disaster recovery plans and procedures.
Collaborate with OPIS product teams to leverage our database systems in order to design optimal solutions and support the development and deployment of new systems and products.
Provide advanced database technical support and offer timely and effective solutions to complex challenges.
Create and maintain database standards and policies and comprehensive documentation for database system configurations processes and procedures using Atlassian Confluence and Azure DevOps.
You Have:
BS in Computer Science Information Technology Information Systems or related field preferred with 4 years of relevant experience or 7 years of relevant experience
Proven expertise in administering Microsoft SQL Server and IBM DB2 databases as well as highly available database technologies (Microsoft Replication Log Shipping Mirroring Failover Clustering IBM DB2 HADR)
Proven experience administering Linux and Windows Server operating systems and AWS cloud services
Strong understanding of cloud database technologies cloud computing concepts and networking protocols
Database Certifications (SQL Server DB2) preferred
Programming and Automation Experience (SQL Scripting PowerShell Python etc.)
Our Benefits
Comprehensive Healthcare Plans
Paid Time Off
Retirement Plans
Comprehensive Insurance Plans
Lifestyle programs & Wellness Resources
Education Benefits
Family Care Benefits & Caregiving Support
Commuter Transit Program
Subscription Discounts
Employee Referral Program
Learn more about all our US benefits
Business Area:
Dow Jones - TechnologyJob Category:
Data Analytics/Warehousing & Business IntelligenceUnion Status:
Non-Union rolePay Range: 120000 - 150000We recognize that attracting the best talent is key to our strategy and success as a company. As a result we aim for flexibility in structuring competitive compensation offers to ensure we are able to attract the best candidates. The quoted salary range represents our good faith estimate as to what our ideal candidates are likely to expect and we tailor our offers within the range based on the selected candidates experience industry knowledge location technical and communication skills and other factors that may prove relevant during the interview process.Pay-for-performance is a key element in our strategy to attract engage and motivate talented people to do their best work. Similarly to salary for bonus eligible roles targets are set based on a variety of factors including competitive market practice.For benefits eligible roles in addition to cash compensation the company provides a comprehensive and highly competitive benefits package with a variety of physical health retirement and savings caregiving emotional wellbeing transportation and other benefits including elective benefits employees may select to best fit the needs and personal situations of our diverse workforce..Required Experience:
Senior IC
Key Skills
- Databases
- SQL
- High Availability
- PL/SQL
- Solaris
- Microsoft SQL Server
- Database Design
- Performance Tuning
- MySQL
- Shell Scripting
- Database Administration
- Oracle
About Company
Dow Jones is the definitive source of premium business news, data and intelligence that moves markets and minds. Dow Jones helps you cut through the noise and act with clarity. Whether you're navigating risk, seizing market opportunity, or staying ahead of global events, Dow Jones giv ... View more
