The Wall Street Journal · 2 months ago
OPIS Senior Database Administrator
NYC - 1211 Ave of the Americas
Full-time
Onsite
Mid, Senior Level
$120K/yr - $150K/yr
4+ years expOPIS LLC, a Dow Jones company, provides price transparency across the global fuel supply chain. The Senior Database Administrator will oversee and manage OPIS database systems and their infrastructure, ensuring optimal performance, availability, and security while collaborating with product teams to support the development and deployment of new systems and products.
FinanceFinancial ServicesInternet
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
Qualification
Required
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
Preferred
BS in Computer Science, Information Technology, Information Systems, or related field preferred with 4 years of relevant experience, or 7 years of relevant experience
Database Certifications (SQL Server, DB2) preferred
Programming and Automation Experience (SQL Scripting, PowerShell, Python, etc.)
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
Company
The Wall Street Journal
Winner of 40 Pulitzer Prizes for outstanding journalism, The Wall Street Journal includes coverage of U.S.
1001-5000 employees
Funding
Current Stage
Late StageTotal Funding
$0.49M2015-03-31Angel· $0.49M
Leadership Team
Nitin Rakesh
Member, CEO Council
Oren Zaslansky
Member, CEO Council
Company data provided by crunchbase