Position: Postgres DBA
Company: Zazmic Inc.
Category: SQL
Experience required: 5y
English level: intermediate

Required skills
At least 5 years of experience as a database developer, database engineer, database administrator or related role BS in Engineering, Computer Science or Information Technology
Experience in creating logical and physical relational databases
5+ years of SQL expertise - can write a query to do almost anything
Experience designing, implementing, testing, and deploying Postgres
Database tuning experience, database integration design and implementation, and management of database projects
Ability to work with a team in an Agile environment - can address bugs with QA, plan schemas with engineering, and respond quickly to other business needs
Knowledge and know-how to troubleshoot potential issues, and experience with best practices around database operations
Highly organized and self-motivated with the ability to prioritize projects, meet deadlines, and make room for emergencies, as needed

Duties and Responsibilities:
Design and develop logical and physical data models along with preparing and presenting statistical information for both internal and external use
Ensure database optimization, integrity, consistency, security and privacy
Providing support, guidance and collaboration with application developers to implement database architectures in support of enhancements to existing systems
Create scripts to build new database objects
Develop stored procedures, functions, packages, triggers and views
Develop, modify or configure moderately complex SQL applications based on requirements provided by the business analysis and architecture teams
Work in a collaborative environment to review current systems and present ideas for system improvements
Assist with schema design, code review and SQL query tuning
Review and approve database design by the technical team
Providing assistance to others in topics related to data management
Creating reports on databases
Develop policy and procedure related to database design
Upgrade and improve data and application schema, preparing design documents and functional specifications
Troubleshoot performance issues, fine-tune databases and index analysis
Coordinate with team members to ensure releases are deployed correctly and that all application processes are followed as per the defined standard operating procedures

Propose

• Flexible working hours, remote work opportunity;
• Professional growth;
• Close cooperation with the development team;
• Dynamic and challenging tasks;

Project description
Boostr is a venture backed enterprise software company building solutions for the media & advertising industry. Frustrated by generic, horizontal CRM products, the founders decided to build the platform they wish they had as operators at Yahoo. We started with a CRM platform that’s disrupting how media sales teams are managed resulting in time savings, increased forecast accuracy and revenue growth. Then we introduced an Order Management (OMS) product disrupting the market with the first omni-channel solution. Now we’re the only platform with a single CRM+OMS to manage the entire workflow. The best part, we’re just getting started and have an exciting roadmap of new products and features that will change the advertising world.
https://boostr.com/
https://www.youtube.com/watch?time_continue=1&v=enBJk8Ufz4I

Key Stats:
We’re inventing what the future looks like enabling our customers to realize their GTM strategies
5 years young
60+ employees - 30 on the technical team
$13m + in funding, inclusive of a $7M Series A in July 2020, from Vocap Investment Partners, Bertelsmann Digital Media, Lightspeed, WGI, C2Ventures, Math Capital and the “who’s who” of media insiders
We work with industry leaders - Buzzfeed, Outfront, Electronic Arts, Vevo, Complex, Match Media, Axios
Growing over 100% YoY

For the technical:
This is not your ordinary application. You will be working with Silicon Valley insiders that have built database internals (Postgres), and enterprise scale systems such as Salesforce and Siebel systems. You will be building the next generation of enterprise level infrastructure. You will be implementing and testing more than just another website. You will be learning techniques that allow infrastructure to scale to 1000's B2B customers and 100,000s users. The infrastructure will allow those customers to define their own custom fields, define their own algorithms, organize their UI's, etc.. Much like most other SaaS solutions, Boostr will scale to a level that is not typically seen in a web app.

You will be working on:
Optimizing Postgres performance
Implementing complex BI / reporting queries
Assisting with ERD design
Mongo DB optimization / design
Federated / multi-tenant design
Definition of views / materialized views


Team:
30 Software Engineers
18 - Ruby on Rails
8 - Angular
5 - Quality Assurance
3 - Automated QA
1 - DevOps
2 - Project Managers

Technology stack:
Ruby on Rails 4/5, PostgreSQL, Angular.Js, Angular 8