K-861 - Database Administrator

K-861 - Database Administrator

26 May
|
Numerator
|
Pune Division

26 May

Numerator

Pune Division

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.



Job Description



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.



Our Team



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.



Responsibilities Include:

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.

The original job offer can be found in Kit Job:
https://www.kitjob.in/job/22738292/k-861-database-administrator-pune-division/?utm_source=html

Reply to this offer

Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.

Subscribe to this job alert:
Enter Your E-mail address to receive the latest job offers for: k-861 - database administrator
Publish a new Free Offer
Need to publish an offer? With more than 1 million unique users per month, you will find the ideal candidate for your company instantly, what are you waiting for!
Publish Now

Subscribe to this job alert