PostgreSQL Database Administrator

**Open Positions: 1**:** Location**: Mumbai**

**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**:
**Who we are?**:
We are a pure-play enterprise open-source consulting and services firm, with offices in Singapore,
Indonesia, and India. Having started operations in 2009, we have helped companies accelerate their
digital transformation initiatives and given them sustainable advantage over their competition. We
work with some of Asia’s leading brands, yet we’re detail oriented enough to make the success of
every customer project personal.

**What are we passionate about?**:
To give confidence to enterprise customers to adopt open-source technologies for business-critical

**Innovate at Ashnik**:
Come join us at the cutting edge of open-source digital evolution. From expertise in consultation of services to digital transformation across databases, high speed data pipeline and cloud to finally
having skilled manpower on a plethora of latest opensource technologies, we’re already there.

We’re taking it apart, re-imagining it and pushing the boundaries of what is possible. If you’re driven
to innovate, to do things that haven’t been done before, then you’ll find a home at Ashnik.