Senior MySQL Application Database Architect

New York City, NY, United States Full Time Senior
Senior MySQL Application Database Architect

AppNexus is hiring a Senior Application Database Architect to work closely with application teams to optimize database performance, automate operations and define database best practices. In this role, you will be responsible for the performance, tuning, scripting and scalability for all the production databases supporting our APIs and production applications.

About the job:
  • Work closely with our application teams to troubleshoot issues, optimize performance, define and implement database best practices
  • Write well designed, testable, efficient database queries, code, and scripts
  • Understand the full system architecture, review application data models and make recommendations for improving overall data architecture
  • Provide data modeling solutions by designing and maintaining new logical and physical data models.
  • Implement schema changes, thoroughly testing DDL scripts, including scripts to rollback changes, and apply schema changes to production
  • Plan detailed deployments with database and software engineers that use advanced techniques to minimize or eliminate downtime when making schema changes
  • Responsible for 24x7 uptime of our application databases including planning zero downtime database upgrades and maintaining database SLAs
  • Timely interaction with software engineering and DBA teams in order to understand their database requirements for new products or features
  • Execute full lifecycle software development practices and standard operating procedure
  • Use (primarily) MySQL and Postgres technology to power our high-volume, business-critical websites and systems
  • Evaluate new database technologies and tools to meet growing challenges
About your skills and experience:
  • Hands-on experience with:
    • Database monitoring tools and best practices
    • Large production database clusters
    • Designing relational schemas and indexing.
  • Strong knowledge of commonly-used concepts, practices, and procedures within the software development field
  • Ability to work effectively in a coordinating role across multiple disciplines with a collaborative work style and customer-service orientation and an ability to translate business goals into information management requirements
  • Ability to own and make key technical and organizational decisions
  • Demonstrated creative problem-solving abilities with an ability to generate ideas for improving systems and processes
  • Effective with time management and an ability to manage competing priorities and requests
  • Supports and maintains positive attitude and vision with peers, associates, and management
  • Strong attention to detail with an ability to follow-up and follow-through on project actions and tasks
  • Ability to produce clean, well-documented, efficient, and standards-compliant code - with an eye towards performance optimization
  • Excellent written and oral communication skills
More about you:
  • You are passionate about a culture of learning and teaching. You love challenging yourself to constantly improve, and sharing your knowledge to empower others
  • You like to take risks when looking for novel solutions to complex problems. If faced with roadblocks, you continue to reach higher to make greatness happen
  • You care about solving big, systemic problems. You look beyond the surface to understand root causes so that you can build long-term solutions for the whole ecosystem
  • You believe in not only serving customers, but also empowering them by providing knowledge and tools

We’re passionate about connecting highly skilled women with leading companies commited to diversity and inclusion

Are you looking for your dream job? In Office. Flexible. Remote.

Join our Movement

Are you hiring? Join our platform for diversifying your team

Post a job