OPIS Senior Database Administrator

Dow Jones & Co.

Since 1882, Dow Jones has been finding new ways to bring information to the world's top business entities. Beginning as a niche news agency in an obscure Wall Street basement, Dow Jones has grown to be a worldwide news and information powerhouse, with prestigious brands including The Wall Street Journal, Dow Jones Newswires, Factiva, Barron's, Market Watch and Financial News.

Location:

NYC – 1211 Ave of the Americas.

Employment type:

Full time. Job Req: 50081.

OPIS, a Dow Jones company, provides price transparency across the global fuel supply chain. The OPIS Cloud Operations team supports the OPIS business by ensuring overall operational performance, security, and reliability of OPIS’ cloud environments. The Senior Database Administrator works closely with OPIS product teams to administer MS SQL and IBM DB2 databases, enforce compliance, and support continuous operation and high availability.

• 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. Develop and implement OPIS database system 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 Dev Ops.

• 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, Power Shell, Python, etc.).

• 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

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, protected veteran status, or disability status (EEO/AA/M/F/Disabled/Vets). Dow Jones is committed to providing reasonable accommodation for qualified individuals with disabilities in our job application and/or interview process. If you need assistance or accommodation in completing your application due to a disability, email us at ta Please put "Reasonable Accommodation" in the subject line.

Business Area:
Dow Jones – Technology. Job Category:
Data Analytics/Warehousing & Business Intelligence. Union Status:
Non-Union role. Pay Range: 120,000 – 150,000.