Cutshort logo
For Employers
Ashnik logo
PostgreSQL-Database Administrator
Ashnik
PostgreSQL-Database Administrator

PostgreSQL-Database Administrator at Ashnik · Pune · 2 - 8 years · ₹4L - ₹12L / yr · Posted 26 Nov 2021

InvokHR's logo

PostgreSQL-Database Administrator

at Ashnik

Agency job
2 - 8 yrs
₹4L - ₹12L / yr
Pune
Skills
skill iconPostgreSQL
Linux administration
Linux/Unix
production support

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

Read more
Users love Cutshort
Read about what our users have to say about finding their next opportunity on Cutshort.
Shubham Vishwakarma's profile image

Shubham Vishwakarma

Full Stack Developer - Averlon
I had an amazing experience. It was a delight getting interviewed via Cutshort. The entire end to end process was amazing. I would like to mention Reshika, she was just amazing wrt guiding me through the process. Thank you team.
Companies hiring on Cutshort
companies logos

Similar jobs (5)

Talentoj
Actively reviewing applications
Talentoj
Agency job
via Talentojcom by Nikita Chilwal
Bengaluru (Bangalore)
5 - 10 yrs
₹6L - ₹20L / yr
skill iconPostgreSQL
DBA
skill iconAmazon Web Services (AWS)
Linux administration
Database Design
+1 more

Job Summary

Responsible for administration of Postgres databases with secondary skills in administration of

DB2, Oracle, MS-SQL, Clickhouse, Neo4J.

Skill Requirements:

 5+ years of experience in Postgres database administration

 DB design (Architecture design principles, modelling, partitioning, setting standards and

normalisation), installation, managing schemas, performance tuning, parameter tuning,

storage management, DB maintenance, patching, upgrade, back-up & recovery, High

availability ,replication and capacity planning.

 Coding Stored procedures

 Working with Linux OS including shell scripting.

 Strong experience in AWS and Azure environment.

 Experience with an organisation with reliance on 24x7 database services.

 Must be an initiative-taker & analytical person with good communication and

interpersonal skills.


Key competencies

 Postgres database administration

 Skills on other database technologies like DB2, Oracle, MS-SQL, Clickhouse

 Cloud services - AWS and Azure.

Read more
Cloud Sara Technologies
Actively reviewing applications
Pradeepa R
Posted by Pradeepa R
Chennai
2 - 5 yrs
₹3L - ₹4L / yr
skill iconPostgreSQL
SQL
Stored Procedures
Views & Triggers
Deadlock & Lock Management

PostgreSQL Developer – Chennai

Experience: 2–5 Years

Location: Chennai

Employment Type: Contract

Contract Duration: 6+ Months

Immediate Joiners Only

Payroll: Candidate's existing payroll will continue (Payroll stays with you).

Job Description

We are looking for an experienced PostgreSQL Developer with strong hands-on experience in SQL development, database optimization, and troubleshooting.

Roles & Responsibilities

  • Write and optimize efficient SQL queries, views, stored procedures, and custom functions.
  • Develop and implement indexing strategies for better database performance.
  • Analyze SQL execution plans and optimize query performance.
  • Work with database triggers and troubleshoot database-related issues.
  • Identify and resolve blocking sessions, deadlocks, slow queries, and database locking issues.
  • Handle high-concurrency database environments and ensure optimal performance.

Required Skills

  • PostgreSQL
  • Advanced SQL
  • Stored Procedures & Functions
  • Views & Triggers
  • Indexing & Query Optimization
  • Execution Plan Analysis
  • Deadlock & Lock Management
  • Performance Tuning

Interested candidates can share their updated resumes.

Read more
MNC
Bengaluru (Bangalore)
7 - 10 yrs
₹12L - ₹16L / yr
Linux administration
Oracle
Splunk

Job Summary:

We are looking for an experienced Production Support Engineer with strong Linux Administration skills to manage production environments, troubleshoot application and infrastructure issues, and ensure system availability and stability. The role involves Linux administration, production support, database support, monitoring, observability, cloud exposure, and automation.

Primary Skills:

  • Linux Administration
  • Production Support

Secondary Skills:

  • Oracle SQL / Database Support
  • Splunk
  • Grafana
  • AppDynamics
  • Cloud – OCP / OpenShift
  • Monitoring & Observability
  • Shell Scripting / Automation

Key Responsibilities:

  • Provide L2/L3 production support for critical applications and infrastructure.
  • Perform Linux server administration, troubleshooting, and issue resolution.
  • Monitor production systems and proactively identify performance and availability issues.
  • Analyze application, system, and infrastructure logs to troubleshoot incidents.
  • Work with Oracle databases and perform basic SQL queries and database-related troubleshooting.
  • Use monitoring and observability tools such as Splunk, Grafana, and AppDynamics.
  • Troubleshoot system performance, connectivity, process, disk, memory, and CPU-related issues.
  • Participate in incident, problem, and change management activities.
  • Support cloud/container platforms such as OpenShift/OCP.
  • Create and maintain Shell scripts for operational tasks and automation.
  • Coordinate with application, database, cloud, and infrastructure teams for issue resolution.
  • Participate in production deployments, maintenance activities, and release support.
  • Follow ITIL processes and maintain proper incident and operational documentation.
  • Participate in on-call and production support activities as required.

Mandatory Skills:

  • 7+ years of relevant IT experience
  • Strong Linux Administration
  • Strong Production Support experience
  • Good troubleshooting and incident management skills
  • Experience working in a 24x7 production environment
  • Hands-on experience with monitoring/logging tools

Good to Have:

  • Oracle SQL
  • Splunk / Grafana / AppDynamics
  • OpenShift / OCP
  • Shell scripting
  • Cloud exposure
  • Monitoring & Observability


Read more
Risosu Consulting LLP
at Risosu Consulting LLP
1 candid answer
Vandana Saxena
Posted by Vandana Saxena
Mumbai, Navi Mumbai
4 - 8 yrs
₹6L - ₹8L / yr
MySQL DBA
NOSQL Databases
skill iconPostgreSQL
skill iconMongoDB


Job Description (JD) for the MySQL Database Administrator role

Experience: 4-8 Years 

Location : Mumbai 

Job Title: MySQL Database Administrator 

Responsibilities 

  • Provision and configure MySQL database instances in clustered and non-clustered environments. 
  • Ensure database performance, security, availability, and reliability. 
  • Prepare and maintain database documentation, technical specifications, and operational procedures. 
  • Perform database upgrades, backups, restoration, recovery, and migrations. 
  • Monitor database and server resource utilization and perform performance tuning and optimization. 
  • Manage database users, access privileges, periodic access reviews, audits, and documentation. 
  • Configure, monitor, and troubleshoot MySQL replication. 
  • Collaborate with application, infrastructure, development, and other stakeholder teams to resolve database-related issues. 
  • Provide database and application deployment support, as required. 
  • Perform database backup and restoration validation, data integrity checks, and post-migration validations. 
  • Follow database change management, security, and operational best practices. 


Skills and Qualifications 

  • Strong hands-on experience in MySQL database administration. 
  • Good working knowledge of recent MySQL versions, preferably MySQL 8.x. 
  • Understanding of MySQL storage engines, including InnoDB and MyISAM. 
  • Practical experience in configuring, monitoring, and troubleshooting MySQL replication. 
  • Knowledge of MySQL administration best practices, security, and high availability. 
  • Proficiency in writing, analyzing, and optimising SQL queries. 
  • Experience with MySQL features such as the Event Scheduler, audit logging, and performance monitoring. 
  • Ability to assess database resource requirements based on application workloads and technical specifications. 
  • Familiarity with other SQL and NoSQL databases, such as PostgreSQL and MongoDB. 
  • Understanding of MySQL limitations compared with other relational database platforms and the ability to identify suitable workarounds. 
  • Working knowledge of version control tools such as Git, SVN, or CVS. 
  • Graduate degree in a relevant discipline and good verbal and written communication skills. 


Good to Have 

  • Basic Linux administration, command-line troubleshooting, and Bash scripting skills. 
  • Familiarity with application server frameworks such as JBoss, GlassFish, and WildFly. 


Read more
Cloud Sara Technologies
Actively reviewing applications
Jayasri Kolla
Posted by Jayasri Kolla
Chennai
2 - 5 yrs
₹3L - ₹4L / yr
SQL
views
Stored Procedures
custom functions

Postgress Developer

Experience: 2 to 5 Years

Location: Chennai

Type: Contract

Duration : 6+ Months


Immediate joiners only



Roles & Responsibilities:

Hands-on experience writing efficient SQL queries, views, stored procedures, custom functions, indexing strategies.

Analyse execution plans, and triggers.

Ability to Identify and resolve blocking sessions, deadlock issues, slow queries, and database locks in high-concurrency environments.

Read more
Why apply to jobs via Cutshort
people_solving_puzzle
Personalized job matches
Stop wasting time. Get matched with jobs that meet your skills, aspirations and preferences.
people_verifying_people
Verified hiring teams
See actual hiring teams, find common social connections or connect with them directly.
ai_chip
Move faster with AI
We use AI to get you faster responses, recommendations and unmatched user experience.
Did not find a job you were looking for?
icon
Search for relevant jobs from 10000+ companies such as Google, Amazon & Uber actively hiring on Cutshort.
companies logo
companies logo
companies logo
companies logo
companies logo
Get to hear about interesting companies hiring right now
Company logo
Company logo
Company logo
Company logo
Company logo
Linkedin iconFollow Cutshort
Users love Cutshort
Read about what our users have to say about finding their next opportunity on Cutshort.
Shubham Vishwakarma's profile image

Shubham Vishwakarma

Full Stack Developer - Averlon
I had an amazing experience. It was a delight getting interviewed via Cutshort. The entire end to end process was amazing. I would like to mention Reshika, she was just amazing wrt guiding me through the process. Thank you team.
Companies hiring on Cutshort
companies logos