Fandango- Sr. Database Architect at Fandango

| Greater LA Area
Sorry, this job was removed at 3:32 p.m. (PST) on Monday, September 9, 2019
Find out who's hiring in Los Angeles.
See all Data + Analytics jobs in Los Angeles

Responsibilities

 

  • Work with engineering and business stakeholders to understand data requirements.
  • Help shape the rapidly growing data needs by evaluating and recommending the best relational and non-relational data stores.
  • Define, design, model, implement, and operate large, evolving, structured and unstructured data sets.
  • Work with the latest cloud database solutions for high performance and availability.

 

Qualifications/Requirements

• Minimum 5-7 years of database administration experience including expert understanding of Microsoft SQL Server. 
• Open Source technology experience is a plus. Currently we are working with MySQL, AWS Redshift, Postgres and others.
• Proven disaster/recovery expertise via backup/restore methodology.
• Excellent troubleshooting skills and ability to understand complex relationships between components of multi-tiered and distributed applications.
• Broad knowledge of common applications and technologies in internet computing (web servers, database servers, load balancers etc.)
• Expertise with at least one highly-available database technology like clustering, replication, mirroring, etc. Preference will be given to candidates with solid transactional replication experience and troubleshooting.
• Flexible, adaptable, and able to manage multiple tasks in a fast-paced environment.
• Proven experience migrating or upgrading database servers to the latest patch and revision levels.
• 24x7 on call rotation with ability to make correct decisions to resolve outages impacting production systems.

Desired Characteristics

• Experience using NoSQL alongside RDBMS 
• Amazon RDS 
• Amazon Aurora 
• Amazon Athena 
• Cloud Solutions and Providers
• Amazon Redshift

 
Read Full Job Description
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

Technology we use

  • Engineering
  • Product
  • Sales & Marketing
    • .NETLanguages
    • C#Languages
    • JavaLanguages
    • JavascriptLanguages
    • PHPLanguages
    • PythonLanguages
    • SqlLanguages
    • NodeLanguages
    • GoLanguages
    • jQueryLibraries
    • ReactLibraries
    • ReduxLibraries
    • AngularLibraries
    • Vue.jsLibraries
    • Polymer Libraries
    • AngularJSFrameworks
    • Node.jsFrameworks
    • MongoDBDatabases
    • AWSDatabases
    • Google AnalyticsAnalytics
    • IllustratorDesign
    • InVisionDesign
    • PhotoshopDesign
    • SketchDesign
    • BasecampManagement
    • ConfluenceManagement
    • JIRAManagement
    • TrelloManagement
    • WordpressCMS
    • SalesforceCRM
    • SendGridEmail
    • Oracle ResponsysEmail
    • AirshipEmail
    • Email on AcidEmail

Location

We welcome you to the posh neighborhood of Beverly Hills 90210 nestled between Silicon Beach and the Entertainment capital of the world.

An Insider's view of Fandango

What’s the vibe like in the office?

There’s a tech start-up feel immersed in a shared passion for movies; our team’s welcoming and collaborative energy truly make the culture special. The innovative office space is an extension of the amazing atmosphere generated by the people. My favorite parts are the massive movie screen and the amazing rooftop patios with beautiful views!

Megan

HR Project Specialist

What makes someone successful on your team?

To be successful at Fandango, you need to be passionate, collaborative, and have a positive attitude. All of these go hand in hand when you enjoy where you work, what you do, and who you work with. We value uniqueness and empower collective ideas to drive innovation. Individual contributions and shared support across teams result in success.

Brian

CRM Operations Manager

What makes someone successful on your team?

What would make someone successful on my team is the ability to multitask; all the while, being able to be flexible and pivot quickly to make smart decisions, business decisions. Customer service supports all of the products under the Fandango umbrella, which are ever-changing. The ability to adapt is key!

Duane

Sr. Customer Service Manager

What are Fandango Perks + Benefits

Culture
Volunteer in local community
Fandango participates in an American Red Cross blood drive, beach clean up, etc.
Partners with Nonprofits
Fandango supports a variety of charities and organizations such as the LA Food Bank, Downtown Women's Center, etc.
Friends outside of work
Eat lunch together
Intracompany committees
We have a TECHWomen chapter with different committees & a shared mission to empower & connect the next generation of women leaders in STEM. We also partner with Employee Resource Groups with NBCU.
Daily stand up
Open door policy
Team owned deliverables
Team based strategic planning
Group brainstorming sessions
Pair programming
Open office floor plan
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Fandango employees can contribute up to $2,700 annually to their FSA.
Disability Insurance
Varies based on elected coverage.
Dental Benefits
Varies based on elected coverage.
Vision Benefits
Varies based on elected coverage.
Health Insurance Benefits
Varies based on elected coverage. NBCU & Fandango offers a fertility benefit program, employee assistance program through ComPsych, Doctor on Demand, and more!
Life Insurance
Life insurance is equal to 1.5 times an employee's annual salary. Employees can elect additional coverage.
Pet Insurance
We offer My Pet Protection by Nationwide. Varies based on state.
Wellness Programs
Onsite Gym
Team workouts
Fandango offers In-office yoga, meditation, nutritionist sessions.
Retirement & Stock Options Benefits
401(K)
401(K) Matching
Fandango provides employees with a 401(k) matching plan managed by Fidelity. We match 6% of contributions and up to 1.5% of an employee's annual gross pay of your eligible earnings.
Employee Stock Purchase Plan
Purchase NBCU company stock at a discounted price.
Performance Bonus
Child Care & Parental Leave Benefits
Child Care Benefits
Fandango provides backup child care assistance.
Generous Parental Leave
We provide up to 16 weeks of parental leave for the primary caretaker. Fandango also provides 2 weeks of leave for the secondary caretaker.
Flexible Work Schedule
Fandango provides employees with a flexible work schedule that includes summer hours, core hours, flexible start and end times.
Remote Work Program
Our remote work program includes work from home full-time remote for specific positions, work remotely on occasion as needed.
Family Medical Leave
Employees are eligible for 12 weeks of family medical leave.
Adoption Assistance
We reimburse up to $10,000 (minus applicable taxes).
Vacation & Time Off Benefits
Generous PTO
Fandango offers company holidays, vacation, floating holidays, personal days, sick days, etc.
Paid Holidays
Paid Sick Days
Hours of paid sick leave varies by employee type (full time, part time, etc.).
Perks & Discounts
Casual Dress
Commuter Benefits
Company Outings
Fandango hosts company outings semi-annually (summer party & holiday party, among other events).
Free Daily Meals
Breakfast items available daily in the kitchen. Employees get free lunch on Tuesday, Thursday.
Game Room
Our game room includes video games.
Stocked Kitchen
Some Meals Provided
Employees get free lunch on Tuesdays & Thursdays.
Happy Hours
Happy hours are hosted on occasion.
Parking
We offer employees free on-site garage parking.
Pet Friendly
Fandango's pet policy is occasional bring your pet to work days.
Relocation Assistance
Varies on a case by case basis.
Fitness Subsidies
Professional Development Benefits
Job Training & Conferences
Fandango offers employees professional development opportunities like onsite training courses, The ability to attend job related conferences and seminars.
Tuition Reimbursement
Varies by degree type.
Diversity Program
Lunch and learns
Fandango hosts Hot Topic lunch and learn meetings once per month.
Cross functional training encouraged
Promote from within
Mentorship program
Our mentorship program includes 1-to-1 program, cross-department program, leadership mentoring.
Continuing Education stipend
Varies by program/degree type.
Online course subscriptions available
Customized development tracks
Paid industry certifications
Varies by program/degree type.

Additional Perks + Benefits

Fandango also offers generous discounts including 4 free Universal Parks tickets, movie tickets for Fandango & movie rentals for FandangoNOW, our streaming service.