Skip to Main Content

Senior Database Architect - MySQL PostgreSQL Vertica

New York, New York

Apply

Description

The Senior Database Administrator is responsible for developing and recommending solutions for heterogeneous data store environment in the Technical Operations group. The data environment consists primarily of MySQL, PostgreSQL, Vertica, and Aerospike.

Team Description:

The Data Ops team in Technical Operations organization handles a wide variety of production operations responsibilities, from providing tech support to architecting long-range build-out and day-to-day operations at our five global data centers. We have well over 7,000 servers, which process over a million of ad serving requests per second (billions per day). We are an all Linux shop (all production operations run on Linux), with mostly Mac laptops. We’re in search of troubleshooters and those who love to tinker and innovate with technology.

Responsibilities:

• Own high availability production database systems
• Work with infrastructure engineers, developers, and architects to troubleshoot issues, optimize performance, define and implement database best practices
• 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
• Write well-designed, testable, efficient SQL queries, code, and scripts
• Execute full lifecycle software development practices and standard operating procedure
• Interaction with software engineering and DBA teams in order to understand their database requirements for new products or features
• Perform database administration tasks, including automation, performance monitoring, system tuning, and SQL query optimization
• Work with security and operations to manage access control to databases
• Monitor databases for problems and diagnose their origin
• Identify and resolve production application issues
• Plan and provide operational oversight in database maintenance with minimal impact to customers
• Plan detailed deployments with database and software engineers that use advanced techniques to minimize or eliminate downtime when making schema changes
• Participates in prototyping and proof of concept system development and benchmarking
• Evaluates the merits and benefits of potential systems enhancements to improve overall performance and address/meet evolving business requirements
• Evaluate new database technologies and tools to meet growing challenges
• Plans and implements backup and recovery strategies
• Diagnoses and develops/recommends solutions to address system, software, security and other complex database issues
• Acts as lead on technical projects
• Participates in code reviews, ensuring best practices are followed


Qualifications

• Must have a Bachelor’s degree or higher, or foreign equivalent, in Computer Science or a related technical field, or equivalent work experience
• 7+ years of working with multiple RDBMS platforms such as MySQL, PostgreSQL, Oracle, etc.
• 7+ years of experience on Linux/Unix. Ubuntu/Debian experience a plus
• 5+ years of experience SQL, Python, shell scripting, Perl and source code control
• 5+ years monitoring and data collection tools such as Nagios, Grafana, Percona Tools, VividCortex
• 4+ years with column-oriented databases such as Vertica
• 4+ years with key-value stores such as Aerospike and Redis
• 4+ years of experience with System administration software such as Puppet, Chef, or Cfengine
• 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 produce clean, well-documented, efficient, and standards-compliant code - with an eye towards performance optimization
• Excellent written and oral communication skills
• Experience with Cloud computing platforms, such as Azure, Amazon AWS
• Expertise on how operating systems work
• Experience and knowledgeable in clustering database systems
• Experience and knowledgeable in maintaining and setting up high availability systems
• Demonstrated ability to lead cross functional projects


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

Job ID 1959456 Date posted 11/08/2019
Career Areas

#XandrLife

#XandrLife means we’re creating an incredible experience for our people, too. Let our employees show you what it’s really like to work here.

See what it's like here
Back to top