Principal Database Architect

Mobile Iron Mountain View, CA
MobileIron is on the cutting edge of the mobile revolution. Think about how important your phone is – mobile devices are becoming increasingly critical for employees to be productive at work. This has left companies struggling to keep those devices secure while enabling access to company information and preserving employee privacy and positive user experience. More and more companies are now turning to Enterprise Mobility Management software to assist them with that priority. Thousands of organizations have selected MobileIron as the platform for their mobile strategies. In fact, MobileIron is the leading standalone EMM vendor in the 2017 Gartner Magic Quadrant and has been recognized as a Leader for 7 consecutive years.

Are you excited by cloud, security, and mobile?

Would you like your expertise to empower millions of employees across thousands of enterprises to be productive while keeping the enterprise data secure? We rock at what we do which is why we have 15,000+ global customers. After our first successful decade, we are looking for people that can help us build the next chapters of our story. Chapter two rapidly expands our "Cloud First" footprint.

Role Description:

Our Server Engineering team is looking for a passionate Principal Database Architect. This role will provide technical oversight for database needs, model data structures, develop implementation packages for these structures and optimize database performance.

The principal database architect is a key role for an individual who is both collaborative and can take ownership of our large PostgreSQL based infrastructure. Managing a mix of both physical and cloud-based PostgreSQL servers, the principal database architect is responsible for the care, feeding, and uptime of mission-critical infrastructure. With a strong understanding of database performance, query optimization, and operational management, the principal database architect works closely with engineers across teams on a variety of projects. With a strong PostgreSQL background, the principal database architect meticulously reviews schema, operational plans, and our database ecosystem to ensure that the right decisions are being made, and that our systems are both performant and error free.

What you'll be doing…

* Responsible for implementing, managing, and tuning high-availability 24x7 PostgreSQL databases.

* Establish policies and procedures pertaining to data management, security, maintenance and utilization.

* Develop, manage, and test database backup & recovery strategies, verifying data integrity.

* Proactively monitor and tune for performance.

* Responsible for capacity planning and recommending paths to account for application growth that are in line with industry best practices.

* Consult with development and architecture teams to help meet continued application growth.

* Define and implement database schema and configurations working with our development teams.

* Create and maintain documentation of procedures, schemas and guides for troubleshooting database systems.

* Research and evaluate new databases, technologies, and trends to provide innovative ideas and solutions to improve the existing infrastructure and support new projects and requirements.

* Perform review of schema, stored procedures, and other changes to the database DDL.

* Audit for data integrity and consistency across systems.

* Work with data-warehousing and Business Intelligence tools.

* Creation and management of ETL applications and pipelines.

Who you are...

* Excellent problem solving, critical thinking, and communication skills

* Self-starter and ability to pick up new technologies rapidly

What you've done…

You have extensive experience in the role of a database architect in a mid-size software engineering organization, with some time in a startup. In that role, you were building a product in Cloud/SaaS or Security solutions ideally for large enterprise customers.

* 14+ years of experience in industry with at least 5 years in a hands-on developer, lead or architect role.

* Must have Expert knowledge of PL/PgSQL, triggers, and stored procedure development and optimization in PostgreSQL.

* Experience with database replication, hot stand-by, clustering, and table partitioning within a cloud (preferably AWS).

* Expert in designing and managing highly available different open source technologies like PostgreSQL, Cassandra, Elastic Search on premises and cloud.

* In-depth understanding of relational and dimensional database theory and concepts.

* Significant practical hands-on experience with database administration, backup and recovery, performance tuning and high-availability solutions.

* Detailed understanding of Postgres database server architecture, concepts, features, and high-availability technologies.

* High-level of proficiency with PostgreSQL in a Linux environment.

* Working knowledge of shell scripting and writing applications in Python.

* Previous experience with Cassandra, Elastic Search, and Redis a strong plus.

* Working knowledge of Docker and previous production experience with PostgreSQL or other databases in a Dockerized environment a plus.

* Solid understanding of PostgreSQL Query Planner, ability to read explain plans and optimize queries against it a plus.

* We are an EEO/AA Employer. Protected veterans and individuals with disability encouraged to apply.

* LI-NV1