PostgreSQL Dba

2 months ago


Gandhinagar, India Aforeserve Com Ltd Full time

We are a leading IT Infrastructure Services and Industry 4.0 Solutions provider in India, offering comprehensive and standardized life cycle services for the full spectrum of Information, Communication, and Technology (ICT) products including notebooks, desktops, network and servers, computer peripherals, surge protection, and power conditioning units and mobility devices - Tablets and Phones, as well as for a range of non IT automated systems such as digital cinema projectors, self-services kiosks, Point Of Sale terminals, ATMs and satellite communication systems. Today, we support over half a million devices and addresses 87,000+ on-site service requests every month with a team of 4,000+ engineers, executives and support personnel.

**Roles and Responsibility**
- Managing PostgreSQL database
- Created tables, schemas, androles, and accessed POSTGRSQL.CONF files
- Creating and dropping users in PostgreSQL
- PostgreSQL index management, Table Partition
- Monitoring the production PostgreSQL alert logs for database errors.
- Involved in PostgreSQL Up-gradation ( Major & Minor).
- Doing Patching on OS level
- PostgreSQL Streaming Replication and Logical Replication
- Analyzing active connections and provide suggestions for improvement.
- Creating and maintaining database standards and policies
- Supporting various database activities
- Maintain database security (Create and maintain users, assign privileges)
- Managing database availability and performance.
- Advance file permissions.
- Basic knowledge on Linux File Hierarchy Structure and Partitioning.
- Manage users and groups including add, remove, modify.
- Monitoring Disk space, CPU, Memory Utilization, etc.

**Qualifications: -**
- Notice period: Immediate joiner / 15 days

Location: Gandhinagar
No of Openings: 1
- Shift Timings : 9 AM - 6 PM
- Working Days - Mon - Sat

**Job Types**: Full-time, Regular / Permanent

**Salary**: ₹321,975.35 - ₹602,160.99 per year

Schedule:

- Day shift

Ability to commute/relocate:

- Gandhinagar, Gujarat, Gandhinagar - 382010, Gujarat: Reliably commute or planning to relocate before starting work (required)

**Experience**:

- total 5work: 1 year (preferred)

**Speak with the employer**
+91 9833916236



  • Gandhinagar, India Dev Information Technology Ltd. Full time

    Strong experience as a Database Administrator / DBA including performance tuning and optimisation - Experience of building and deploying MS SQL clusters into production - Experience of working with high availability, scalable environments - Strong analysis and problem-solving skills - Collaborative with strong communications skills, comfortable liaising with...