Numerator is a data and tech company bringing speed and scale to market research. Headquartered in Chicago, IL, Numerator has more than 2,000 employees worldwide. The company blends proprietary data with advanced technology to create unique insights for the market research industry that has been slow to change. The majority of Fortune 100 companies are Numerator clients.
What We Do and How?
We are a market research company, revolutionizing how it's done! We mix fast paced development and unique approaches to bring best practices and strategy to our technology. Our tech stack is deep, leveraging several languages and frameworks including Python, C#, Java, Kotlin, React, Angular, and Django among others.
Our engineering hurdles sit at the intersection of technologies ranging from mobile, computer vision and crowdsourcing, to machine learning and big data analytics.
From San Francisco to Chicago to Ottawa, our R&D; team is comprised of talented individuals spanning across a robust tech stack. The R&D; team is comprised of product, data analytics, engineers across Front End, Back End, DevOps, Business Intelligence, ETL, Data Science, Mobile Apps, and much more. Across these different groups we work towards one common goal: To build products into efficient and seamless user experiences that help our clients succeed.
About the Role
We’re hiring a talented Database Administrator enthusiast to work in our platform to help ensure that our data quality is flawless. As a company, we have millions of new data points every day that come into our system. You will be working with a passionate team of engineers to solve challenging problems and ensure that we can deliver the best data to our customers, on-time. You will be using the latest cloud data warehouse technology to build robust and reliable data pipelines.
Responsible for implementing, managing, and tuning high-availability 24x7 PostgreSQL and Snowflake databases.
Establish policies and procedures pertaining to data management, security, access control policies, maintenance and utilization.
Develop, manage, and test database backup & recovery strategies, verifying data integrity.
Perform database installations, configurations, upgrades, and migrations.
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.
Skills & Requirements
3+ years of experience as a DBA on designing, building, configuring and maintaining PostgreSQL databases.
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.
Expert knowledge of PL/PgSQL, triggers, Materialized views and stored procedure development and optimization in PostgreSQL.
Experience with database replication, hot stand-by, clustering, and table partitioning.
Experience with patroni & HA proxy, streaming replication is must.
Linux platform familiarity, system resource monitoring and tuning.
Working knowledge of shell scripting and writing applications in Python.
Ability to communicate effectively with others, both in oral and written communication.
Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.
Job Description Summary of This Role Plans computerized databases, including base definition, structure, documentation, long-range requirements, operational guidelines and protection. Ensures accura [...]
Job Description Job Description: The IT Data Architect /DBA will work with project teams and stakeholders to design, optimize, and maintain data infrastructure to extract and organize data for use [...]
Job Description Position Type : Full time Type Of Hire : Experienced (relevant combo of work and education) Education Desired : Bachelor's Degree Travel Percentage : 0 PERCENT Mongo DBA : [...]
Introduction At IBM, work is more than a job - it's a calling: To build. To design. To code. To consult. To think along with clients and sell. To make markets. To invent. To collaborate. Not just t [...]