OPIS Senior Database Administrator

Opis•New York, NY

43d

About The Position

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 team's software engineers and database developers.

Requirements

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 netwo rking protocols
Programming and Automation Experience (SQL Scripting, PowerShell, Python, etc.)

Nice To Haves

Database Certifications (SQL Server, DB2) preferred

Responsibilities

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.