PostgreSQL Database Administrator
Location: Mumbai
Please send us your resume at careers@ashnik.com
The Position
Ashnik is looking for a talented and passionate person to join our Technical Delivery Team in Mumbai.
Qualification and Experience
- 4 to 5 years of hands on administration experience of working on PostgreSQL Database
- Experience of working in a production support environment
- Engineering or Equivalent degree
Essential Experience and Skills
- Install & Configure PostgreSQL, EDB Postgres
- Technical capabilities – PostgreSQL 9.x, 10.x, 11.x
- Experience in installation, configuration and maintenance of PostgreSQL from 9.5 to 14.x
- Experience of PostgreSQL administration on Linux and Windows
- Experience of backing up and restoring PostgreSQL databases
- Hands-on experience with Database schema creation and performance tuning and ongoing support
- Server tuning
- Troubleshooting of database issues
- Linux Shell Scripting
- Install, configure and maintain Fail Over mechanism
- Backup – restoration, point in time database recovery
- Experience in server-to-server migration
- Experience in migrating oracle databases to Postgres
Responsibilities
- Monitoring database performance to identify slowdowns or potential issues
- Managing users and permissions, including adding new users and removing inactive accounts
- Optimizing queries and handle escalations
- Creating database objects such as tables, views, triggers, and indexes
- Maintaining the database schema, including creating new tables, adding columns to existing tables, and deleting unnecessary tables and data
- Performing regular database backups to ensure data integrity in case of a server crash
- 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
- Performing regular scheduled maintenance on the database server, such as vacuum analysis on large tables to remove obsolete data
What is in it for You?
- Be a part of the thought leadership team in the open-source world
- Provide multi-technology solutions instead of delivering just a product
- Work and learn from the pioneers in the open-source industry
- Be a proud contributor and part of our customers’ fast-growing, digital transformation goals
Benefits
- Comprehensive medical insurance
- WFH option with home office-setup allowance
- In-depth training & development programs
- Professional course and certification support available
- 24×7 employee assistance program
- Generous parental and family leave options
- Paid medical and annual leaves
- Reward and recognition program
- Fast-track career growth
About Us
Since our inception in 2009, Ashnik has consistently led the way in introducing advanced open source technologies to the Southeast Asian and Indian markets. As a premier provider of enterprise open source solutions, we are dedicated to empowering organizations around the globe to harness the power of open source for their digital transformation initiatives. We offer a comprehensive suite of Solutions, Services, Support, and Subscriptions across key technology domains including Unified Observability, Streaming Data Pipelines, Database Platforms, and Application Delivery Platforms.
Utilizing Machine Learning and AI, we develop innovative solutions that significantly impact enterprise growth. To date, over 300 leading global enterprises have benefited from our tailored offerings. We pride ourselves on partnering with foremost open source technology vendors, delivering solutions built on industry-leading technologies such as PostgreSQL, Elastic, Kafka, Nginx, Kubernetes, Apache Spark, MongoDB, Yugabyte, and Ansible. At Ashnik, we are committed to empowering your business with pioneering solutions that drive success and transformation.