Infopine - Database Administrator - PostgreSQL

1 day ago


Mysuru, India Infopine Consultancy Services Pvt. Ltd Full time

About Us :

Founded in 2017, Infopine is a leading provider of industry-specific ERP solutions, leveraging deep expertise to deliver precision-engineered products that address unique operational challenges. Renowned for advanced functionality, scalability, and proven results, Infopine's ERP systems empower businesses to thrive in complex environments. Driven by innovation and a commitment to customer success, Infopine helps industries streamline operations, enhance decision-making, and achieve sustainable growth. For more details please visit - Skills :

- Strong experience with PostgreSQL architecture and internals.

- Proficiency in SQL, PL/pgSQL, Shell scripting, or Python.

- Experience in configuring high availability and failover mechanisms.

- Knowledge of cloud-based PostgreSQL deployments (AWS RDS, GCP, Azure, etc.).

- Hands-on experience with open-source PostgreSQL tools (pgpool, patroni, repmgr, etc.).

- Solid understanding of database security, compliance, and data protection best practices.

- Experience with performance tuning, monitoring, and optimization.

Preferred Qualifications :


- Bachelor's/Master's degree in Computer Science, Information Technology, or related field.

- Certifications in PostgreSQL or Cloud Platforms (AWS/GCP/Azure) are a plus.

- Experience in a 24x7 production environment.

Key Responsibilities :


- Configure and manage backup, restore, replication, and Point-In-Time Recovery (PITR) using various replication tools.

- Build and maintain large-scale database infrastructure for high-volume, mission-critical environments.

- Install and upgrade PostgreSQL (both minor and major versions).

- Perform switchover/failover tasks based on different scenarios.

- Optimize database performance by scheduling maintenance tasks such as vacuum and analyze.

- Deploy and manage PostgreSQL environments in both on-premises and cloud setups.

- Troubleshoot and resolve issues related to CPU/load, blocking/locking, long-running queries, and disk usage.

- Monitor, tune, and optimize SQL queries and server performance.

- Configure and manage high availability, load balancing, and connection pooling.

- Use and configure open-source tools/utilities like pgpool, pgAdmin, pgbouncer, Patroni, Repmgr, PAF.

- Perform data migrations using relevant tools and methods.

- Create and manage database objects such as triggers, indexes, stored procedures, etc.

- Ensure database security, compliance, and audit readiness.

- Monitor access control and protect against unauthorized database access.

- Identify potential performance or availability issues proactively and address them.

- Automate routine DBA tasks using Shell, Python, or PL/pgSQL scripting.

- Establish and enforce database policies, standards, and best practices.

(ref:hirist.tech)

  • Mysuru, Pune, India Lancesoft Full time ₹ 9,00,000 - ₹ 12,00,000 per year

    Role & responsibilities7+ years of experience in PostgreSQL DBA and good to have knowledge on MS SQL DBADatabase AdministrationInstallation/maintenance of PostgreSQL on Linux 8 or higherExperience in handling database with version 14.X or higherDatabase Maintenance: Backup & (disaster) recovery, Database consistency (DBCC) and table maintenance/...

  • Oracle Database Admin

    2 weeks ago


    Mysuru, Karnataka, India Wipro Limited Full time

    **Role Purpose** The purpose of this role is to provide significant technical expertise in architecture planning and design of the concerned tower (platform, database, middleware, backup etc) as well as managing its day-to-day operations **͏**: **JD for** **Oracle L3: (7+ years of experience)** - Experience in Oracle 10g & 11g & 12c, 19c - Experience in...


  • Mysuru, Karnataka, India INVENSOFT TECHNOLOGIES PVT LTD Full time

    **Designation: System Administrator** **Years of Exp: 2 to 6 Years** **Location: Mysore** **Roles and responsibilities**: - Responsible for the maintenance, configuration, and reliable operation of computer systems, network servers, and virtualization - Install and upgrade computer components and software, manage virtual servers, and integrate automation...

  • Sales Administrator

    4 days ago


    Mysuru, Karnataka, India D'Life Interiors Full time

    **Job Description (JD)**: - Attend the Lead. - Building business relations with current and potential customers. - Initiate outbound callings to connect with potential customers. - Meeting all the targets of cold, active and inactive calls. - Creating and maintaining the database of prospect clients. - Achieving monthly and annual sales targets (Branch...


  • Mysuru, India Aezion.Inc Full time

    Role : Lead SQL DeveloperLocation : timeResponsibilities :- Develop stored procedures, functions, packages, triggers, views, CTEs using T-SQL.- Design logical and physical data models along with collaring, preparing, and presenting statistical information for both internal and external use.- Ensure database optimization, integrity, consistency, security,...


  • Mysuru, India Xpetize Technology Solutions Full time

    Job Title : Java Developer Spring Boot / Microservices / KafkaLocation : Bangalore,MysoreJob Type : FulltimeExperience Level : 4 to 6 yearsJob Summary :We are seeking a skilled and passionate Java Developer with strong expertise in Spring Boot, Microservices Architecture, and Apache Kafka. The ideal candidate will design, develop, and maintain scalable...


  • Mysuru, Karnataka, India Reejays Solutions Full time

    **Position**: Admin Executive **Location**: Mysore, India **Salary**: ₹25,000 - ₹30,000 per month **Joining**: Immediate **About the School**: Our international school in Mysore is dedicated to providing high-quality education and fostering a supportive and inclusive learning environment. We aim to develop well-rounded students who are prepared for...


  • Mysuru, Karnataka, India NECTAR FRESH Full time

    A secretary to a company's managing director (MD) is responsible for a variety of administrative and secretarial tasks, including: - **Scheduling**: Organizing and scheduling meetings, including preparing agendas, booking venues, and setting up resources - **Record keeping**: Maintaining organized filing systems, databases, and records in a confidential and...


  • Mysuru, Karnataka, India EduCADD THINKWorks Mysuru Full time

    **Law Office Receptionist** **Job Summary**: The Law Office Receptionist serves as the first point of contact for clients, visitors, and phone inquiries. This role is essential in providing excellent customer service, maintaining an organized front desk, and supporting the administrative functions of the law office. **Responsibilities**: - **Greet and...

  • Tender Executive

    1 week ago


    Mysuru, Karnataka, India RAMAN IT PVT LTD., Full time

    **Tender Executive - Roles & Responsibilities** - Qualify leads and route them to the appropriate sales executives. - Participate in tender processes, including document preparation and timely submissions. - Make cold calls and follow up on leads generated through marketing or databases. - Coordinate with the sales team by managing schedules, documents, and...