Senior Application Database Architect (MySQL)

Smith Arnold Partners - Manhattan, NY (30+ days ago)5.0


Global Internet Technology Company focused on Global Digital Advertising Technology. Award Winning Company, experiencing rapid Growth!

Responsibilities:
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
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
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
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
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
Evaluate new database technologies and tools to meet growing challenges

Requirements:
5+ years on hands on Architecture and Development experience with large production database clusters
5+ years on hands on experience with designing relational schemas and indexing
5+ years on hands on experience with Database monitoring tools and best practices
Strong Database Architecture experience with MySQL including Logical and Physical Data Modeling
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
Demonstrated creative problem-solving abilities with an ability to generate ideas for improving systems and processes
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

Click here to view our new interview training videos.

Smith Arnold Partners is a Stamford, Connecticut based highly specialized technical professional and executive search firm that has helped thousands of companies and people make a professional connection. Smith Arnold Partners has successfully completed searches on behalf of the most recognizable firms in the United States.