Database Architect Zilliant
Do you want to work with other talented software professionals and pricing scientists to solve interesting and complex problems with leading edge technology? At Zilliant, we pride ourselves on our technical talents, team camaraderie, and an Agile process that empowers our employees to unlock their best. Zilliant deliveries pricing services to the world's largest companies by providing innovative solutions around high performance, large data sets, scalable computations, and meaningful visualizations. We provide a rich environment for growing your technical proficiency and provide an opportunity to make a difference each day in a fast passed creative atmosphere.
The ideal candidate should possess multi-tenant SaaS database design experience, live to write code, have great organization and communication skills, enjoy a flexible environment, and possess a love of problem solving. If you are a creative problem solver with great initiative and are looking for an opportunity to show off your talents, we are looking for you.
--Bachelor's degree in Computer Science, Engineering or related field.
--10+ years database SQL development skills including stored procedures with relational databases such as SQL Server , Oracle, or MySQL.
--Extensive experience with large scale SaaS database design, hands on implementation, upgrade and support. Deep understanding of big data management through technics such as columnar databases, clustering and sharding desired.
--Promotion and enforcement of software development best practices required including developing unit tests, integration tests and robust API documentation.
--Experience with configuration management systems and continuous build environment.
--Experience with Agile development methodologies like Scrum and XP.
--Excellent written and oral communication skills.
--Own the product database architecture from end to end inclusive of topology, infrastructure, data acquisition, processing and delivery.
--Design multi-tenant database architecture that leverages how our engines solve complex business problems.
--Overall design and architecture of the data warehouse used to analyze our customers data and our engine results.
--Implementation and support of data modeling engine, which provides dynamic schema per tenant.
--Stay abreast of latest database technology and determine how new advances can be leveraged in our product.
--Tunes SQL data structures, queries, and indexes to provide optimal performance to our customers.
--Leads database performance analysis to determine resource utilization for our tenants and provides capacity planning documentation to our operations team. Provide guidance to operations on how to configure database settings.
--Triage performance and functional problems associated with ETL errors, helping developers and operations improve the performance of queries through restructuring or index improvements. Using Profiler traces and other tools to find the most frequently run queries.
--Review product SaaS upgrade processes prior to a release to ensure effectiveness and performance. Provide support during upgrades to diagnose issues and verify correctness.
--Review and ensure that new database code meets company standards for readability, reliability, and performance. Design indexes for existing applications, choosing when to add or remove indexes.
--Advise developers on the most efficient database designs (tables, data types, stored procedures, functions, indexes etc).
--Defining the tasks and work breakdown structure for your development activities with time estimation to support predictable sprint and release planning activities.
--Collaboration with other architects, developers, quality assurance, technical writers, pricing scientists and solution deployment engineers on the in-depth design and implementation of the software.
--Performing required unit and integration testing to deliver quality software to QA and the customer.
--Conduct and participate in design and code reviews, and author technical documentation.
--Mentor other database developers, providing constructive feedback for their continued growth.