Database Engineer - Digital Infrastructure

Job Description

Job Description

Title: Platform Database Engineer, Digital Infrastructure

Location: New York City

Position: Full Time Employment

Job Description:

The Platform Database Engineer is responsible for administration, development and scaling Outfront Media Digital Operations database systems. The engineer will support technical initiatives to implement data systems for digital content delivery and digital boards’ uptime analyses. The engineer will work on ensuring timely data collection and the collected data is within required quality standards The engineer will also support all database related operations like backup, upgrade, performance tuning, recovery and failover. The engineer will be on call for 24x7 production issues..

Core Responsibilities:

• Design, administer, tune, and monitor production databases ensuring 24x7 operations and good performance;
• Collect, analyze and share data to help operations and business teams drive improvement in key business metrics;
• Utilize database and web application technologies to evaluate and develop innovative business intelligence tools and automated reports;
• Design, develop and test BI solutions such as databases, data warehouse, queries, views, reports, and dashboards;
• Assist in data conversions, imports and exports of data within and between internal and external systems;
• Manage and support development and staging database environments;
• Implement and improve backup/recovery processes, disaster recovery and failover processes;
• Troubleshoot BI tools, database systems, and overall performance;
• Interact with Business, Program Management, and Engineering on meeting ongoing reporting requirements;
• Document new and existing models, solutions and implementations;
• Strictly adhere to process, instructions, policies, and standards

Requirements:

• BS in Computer Science or information systems related field or equivalent experience
• 5+ years of operational PostgreSQL and MySQL database skills in a Linux production environment
• 3+ years of experience supporting fast growing mission critical production systems
• Knowledge of business intelligence tools and systems
• Data analysis and data mining skills
• Good Linux and shell scripting skills (PHP, Python, LAMP)
• Self-starter and independent worker
• Good verbal and written communications skills
• Good documentation skills
• Experience with enterprise data warehouses a plus
• MySQL/PostgreSQL Management Certifications highly desired
• Ability to create clear step by step knowledge base documents for NOC and field personnel to follow and resolve known issues
• Participate in 24x7 on call rotations