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
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
*Participate in 24x7 on call rotations
The salary range for this role is $120,000-$150,000 per year. Compensation is determined during our interview process by assessing a candidate's experience and skills relative to internal peers and market benchmarks evaluated for the scope and responsibilities of the position. Please note that the foregoing compensation information is a good-faith assessment associated with this position only and is provided pursuant to the New York City Salary Transparency Law.
To all Recruitment Agencies: OUTFRONT Media LLC does not accept agency and unsolicited resumes. Please do not forward resumes to our OUTFRONT Media employees or any other company location.OUTFRONT Media is not responsible for any fees related to unsolicited resumes.
OUTFRONT Media Is An Equal Opportunity Employer
All applicants shall receive equal consideration without regard to race, color, religion, gender, marital status, gender identity or expression, sexual orientation, national origin, age, veteran status or disability. Please refer to the