Postgres DB Developer

Role: My SQL DBA

Work Location: Noida/Hyderabad

Exp : 3+ Yrs

About the Role:

The ideal candidate would be working on the servers which impact various SaaS AI/ML products and

1000+ models in AI/ML. As a DBA administrator the server support would be provided for various

industry verticals like Finance, Telecom, Travel & Transportation, Healthcare, Government etc. This role

would give an opportunity working on multiple and complex databases for fortune 500 customers which

have impact on their data related to AI/ML products/models of the company.

About the Company:

We are America’s oldest machine learning solutions company. With offices across US, China and India,

we hire people with a broad set of technical and domain skills who can contribute to the creation of

machine learning solutions across verticals such as financial services, telecommunications, healthcare,

consumer products etc.

Preferred Qualification:

(Must have)

· Three years or above working experience, more than two years in MySQL, familiar with MySQL

database architecture.

· Have good experience in database troubleshooting and solutions for the whole system chain,

including OS, Database, storage, network, application, cloud and so on.

· Familiar with SQL tuning, know about how to split large tables in MySQL.

· Familiar with the daily backup and restore operations of MySQL, and know about the HA

principles of MySQL replication and MySQL Cluster. Experience in PostgreSQL is preferred.

· Familiar with Linux operating system, be able to write daily scripts with Shell/Python.

· Experience about NoSQL databases is preferred, such as MongoDB, Redis.

· Experience about distribution databases is preferred, such as Greenplum, Clickhouse.

· Oracle DBA or SQL Server DBA working experience is preferred.

· Careful work, strong sense of responsibility, good learning ability and team spirit.

Responsibilities:

· Responsible for the daily maintenance and troubleshooting for all Databases, such as MySQL

and postgreSQL, make sure all database system running safely and stably.

· Establish MySQL daily backup and recovery policies, and data security policies.

· Responsible for the design and implementation of Database tables, and large table split policy.

· Provided daily support to the development team and application team, such as database design

specification and performance tuning suggestions.

About Demandbase company

The world’s largest and fastest-growing companies such as Accenture, Adobe, DocuSign and Salesforce rely on Demandbase to drive their Account-Based Marketing strategy and maximize their B2B marketing performance. We pioneered the ABM category nearly a decade ago, and today we lead the category as an indispensable part of the B2B MarTech stack. Our achievements and innovation would not be possible without the driven and collaborative teams here at Demandbase. As a company, we’re as committed to growing careers as we are to building world-class technology. 

InsideView helps businesses drive rapid revenue growth by empowering business leaders to discover new markets, target and engage the right buyers, and manage customer data quality. Our AI-based B2B data and intelligence platform delivers the industry’s most relevant and reliable buyer signals and, combined with InsideView’s data expertise and best-in-class customer support, is trusted by the world’s best performing companies. 

We believe in the power of technology to deliver business value, and in creating solutions that change the way companies sell and engage with their customers. We take risks in order to develop groundbreaking solutions. We are market savvy and competitive, and ready to transform our industry at this exciting inflection point for the company and the market. We focus on the needs of our customers now, and in the future. We love coming to work every day and are looking for smart, engaged, and fun people to join us. 

Our headquarters is located in San Francisco’s vibrant Potrero Hill neighborhood, with additional locations in downtown Austin, Texas, and Hyderabad, Telangana, India.

Job Description: Database Engineer

We are looking for a Database Engineer with 4+ years of experience. We are looking for the ability to optimize, troubleshoot, and ensure high availability of the databases.

Additional desirable skills:

About You

Mandatory

·  Candidates must have substantial applicable IT experience, extensive development, programming experience in Java/ Dotnet / VB or other Web Application Development

·  Strong experience in DB (PostgreSQL, SQL server) Web Services using Restful, any.

ABOUT US.

Established in 2009, Ashnik is a leading open-source solutions and consulting company in South East Asia and India, headquartered in Singapore. We enable digital transformation for large enterprises through our design, architecting, and solution skills. Over 100 large enterprises in the region have acknowledged our expertise in delivering solutions using key open-source technologies. Our offerings form critical part of Digital transformation, Big Data platform, Cloud and Web acceleration and IT modernization. We represent EDB, Pentaho, Docker, Couchbase, MongoDB, Elastic, NGINX, Sysdig, Redis Labs, Confluent, and HashiCorp as their key partners in the region. Our team members bring decades of experience in delivering confidence to enterprises in adopting open source software and are known for their thought leadership.

THE POSITION

Ashnik is looking for talented and passionate people to be part of the team for an upcoming project at client location.

QUALIFICATION AND EXPERIENCE

• Preferably have a working experience of 4 Years and more , on production PostgreSQL DBs.
• Experience of working in a production support environment
• Engineering or Equivalent degree
• Passion for open-source technologies is desired

ADDITIONAL SKILLS

• Install & Configure PostgreSQL, Enterprise DB
• Technical capabilities PostgreSQL 9.x, 10.x, 11.x
• Server tuning
• Troubleshooting of Database issues
• Linux Shell Scripting
• Install, Configure and maintain Fail Over mechanism
• Backup - Restoration, Point in time database recovery
• A demonstrable ability to articulate and sell the benefits of modern platforms, software and technologies.
• A real passion for being curious and a continuous learner. You are someone that invests in yourself as much as you invest in your professional relationships.

RESPONSIBILITIES

• Monitoring database performance
• Optimizing Queries and handle escalations
• Analyse and assess the impact and risk of low to medium risk changes on high profile production databases
• Implement security features
• DR implementation and switch over

LOCATION: Bangalore and Mumbai

ABOUT US. (https://www.ashnik.com/" target="_blank">https://www.ashnik.com/)

Established in 2009, Ashnik is a leading open-source solutions and consulting company in South East Asia and India, headquartered in Singapore. We enable digital transformation for large enterprises through our design, architecting, and solution skills. Over 100 large enterprises in the region have acknowledged our expertise in delivering solutions using key open-source technologies. Our offerings form critical part of Digital transformation, Big Data platform, Cloud and Web acceleration and IT modernization. We represent EDB, Pentaho, Docker, Couchbase, MongoDB, Elastic, NGINX, Sysdig, Redis Labs, Confluent, and HashiCorp as their key partners in the region. Our team members bring decades of experience in delivering confidence to enterprises in adopting open source software and are known for their thought leadership.

As a team culture, Ashnik is a family for its team members. Each member brings in different perspective, new ideas and diverse background. Yet we all together strive for one goal – to deliver best solutions to our customers using open source software. We passionately believe in the power of collaboration. Through an open platform of idea exchange, we create vibrant environment for growth and excellence.

THE POSITION

Ashnik is looking for talented and passionate people to be part of the team for an upcoming project at client location.

QUALIFICATION AND EXPERIENCE

• Preferably have a working experience of 4 Years and more , on production PostgreSQL DBs.
• Experience of working in a production support environment
• Engineering or Equivalent degree
• Passion for open-source technologies is desired

ADDITIONAL SKILLS

• Install & Configure PostgreSQL, Enterprise DB
• Technical capabilities PostgreSQL 9.x, 10.x, 11.x
• Server tuning
• Troubleshooting of Database issues
• Linux Shell Scripting
• Install, Configure and maintain Fail Over mechanism
• Backup - Restoration, Point in time database recovery
• A demonstrable ability to articulate and sell the benefits of modern platforms, software and technologies.
• A real passion for being curious and a continuous learner. You are someone that invests in yourself as much as you invest in your professional relationships.

RESPONSIBILITIES

• Monitoring database performance
• Optimizing Queries and handle escalations
• Analyse and assess the impact and risk of low to medium risk changes on high profile production databases
• Implement security features
• DR implementation and switch over

LOCATION: Pune 
Experience: 2 yrs plus

ABOUT US.

Established in 2009, Ashnik is a leading open-source solutions and consulting company in South East Asia and India, headquartered in Singapore. We enable digital transformation for large enterprises through our design, architecting, and solution skills. Over 100 large enterprises in the region have acknowledged our expertise in delivering solutions using key open-source technologies. Our offerings form critical part of Digital transformation, Big Data platform, Cloud and Web acceleration and IT modernization. We represent EDB, Pentaho, Docker, Couchbase, MongoDB, Elastic, NGINX, Sysdig, Redis Labs, Confluent, and HashiCorp as their key partners in the region. Our team members bring decades of experience in delivering confidence to enterprises in adopting open source software and are known for their thought leadership.

As a team culture, Ashnik is a family for its team members. Each member brings in different perspective, new ideas and diverse background. Yet we all together strive for one goal – to deliver best solutions to our customers using open source software. We passionately believe in the power of collaboration. Through an open platform of idea exchange, we create vibrant environment for growth and excellence.

THE POSITION

Ashnik is looking for talented and passionate people to be part of the team for an upcoming project at client location.

QUALIFICATION AND EXPERIENCE

• Preferably have a working experience of 4 Years and more , on production PostgreSQL DBs.
• Experience of working in a production support environment
• Engineering or Equivalent degree
• Passion for open-source technologies is desired

ADDITIONAL SKILLS

• Install & Configure PostgreSQL, Enterprise DB
• Technical capabilities PostgreSQL 9.x, 10.x, 11.x
• Server tuning
• Troubleshooting of Database issues
• Linux Shell Scripting
• Install, Configure and maintain Fail Over mechanism
• Backup - Restoration, Point in time database recovery
• A demonstrable ability to articulate and sell the benefits of modern platforms, software and technologies.
• A real passion for being curious and a continuous learner. You are someone that invests in yourself as much as you invest in your professional relationships.

RESPONSIBILITIES

• Monitoring database performance
• Optimizing Queries and handle escalations
• Analyse and assess the impact and risk of low to medium risk changes on high profile production databases
• Implement security features
• DR implementation and switch over

LOCATION: Pune

Experience: 8 yrs plus

Package: upto 17 LPA

Who We Are

Getir is a technology company, a pioneer of the online ultra-fast grocery delivery service business, that has transformed the way in which millions of people across the world consume groceries. We believe in a world where getting everything you need, when you need it, sustainably, is the new normal. 

Getir is growing incredibly fast in Europe, but we want to grow globally. From London to Tokyo, Sao Paulo to New York, our global ambitions can only be accomplished with exceptional technology.

If you've got the experience and the ambition to be a Database Administrator (Postgres) at Getir and  a founding part of our technology hub in Bangalore, please apply.

What you’ll be doing:

• Work with engineering and other teams to build & maintain our database requirements and answer big data questions
• Use your past DBA experience and industry wide best practices to scale and optimize the database services.
• Regularly conduct database health monitoring and diagnostics
• Create processes to ensure data integrity and identify potential data errors.
• Document and update procedures and processes.
• Troubleshoot and resolve problems as they arise

What we look for in you:

• You have A Bachelor’s degree in Computer Science, Computer Engineering, Data Science, or another related field.
• 3+ years of experience as a Database Administrator
• Proficiency administering PostgreSQL
• Extensive experience performing general troubleshooting database maintenance activities including backup and recovery, capacity planning, and managing user accounts.
• Experience in identifying and documenting risk areas and mitigation strategies for process and procedure activities.
• Experience in managing schemas, indexing, objects, and partitioning the tables.
• Experience in managing system configurations.
• Experience creating data design models, database architecture, and data repository design.
• Strong understanding of SQL tuning and optimization of query plans.
• Linux shell scripting skills and experience with production Linux environments
• Experience working with software engineers in a highly technical environment.
• Knowledge of 1+ programming language (e.g. C++, Scala, Java, JavaScript etc.)
• Excellent verbal and written communication skills.
• Knowledge administering MongoDB (Good to have)
• Knowledge administering Amazon RDS for PostgreSQL & Redshift. (Good to have)