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

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

Similar jobs (5)
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.
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.
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
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.

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.








