Simple Logic

6 days ago

Mumbai, Maharashtra, India Simple Logic IT Pvt. Ltd Full time

The ideal candidate will be responsible for ensuring database availability, security, performance, and scalability.

You will work closely with application developers, system engineers, and DevOps teams to provide high-quality data solutions and troubleshoot complex issues in a mission-critical environment.

Responsibilities :

- Install, configure, and upgrade PostgreSQL databases in high-availability environments

- Design and implement database architecture, including replication, partitioning, and sharding

- Perform daily database administration tasks including backups, restores, monitoring, and tuning

- Optimize queries, indexes, and overall performance of PostgreSQL systems

- Ensure high availability and disaster recovery by configuring replication (Streaming, Logical) and backup solutions (pgBackRest, Barman, WAL archiving)

- Implement and maintain security policies, user access control, and encryption

- Monitor database health using tools such as pgAdmin, Nagios, Zabbix, or other monitoring tools

- Troubleshoot database-related issues in development, test, and production environments

- Automate routine tasks using shell scripting, Python, or Ansible

- Work with DevOps/SRE teams to integrate PostgreSQL into CI/CD pipelines and cloud platforms

Technical Skills

PostgreSQL Expertise :

- Proven experience with PostgreSQL 11+ (latest version experience preferred)

- Strong knowledge of SQL, PL/pgSQL, database objects, and data types

- Experience with PostgreSQL replication: streaming, logical, and hot standby

- Deep understanding of VACUUM, ANALYZE, autovacuum configuration and tuning

Tuning & Monitoring :

- Query optimization and slow query analysis using EXPLAIN and ANALYZE

- Experience with database performance monitoring tools (e.g., pg_stat_activity, pgBadger)

- Strong debugging and troubleshooting of locking, deadlocks, and resource contention issues

DevOps Integration :

- PostgreSQL experience on AWS RDS, Azure Database for PostgreSQL, or GCP Cloud SQL

- Familiarity with IaC tools like Terraform or CloudFormation is a plus

- Experience with CI/CD integration and containerization tools (Docker, Kubernetes) for DB deployment

Compliance :

- Implement role-based access control, data masking, and audit logging

- Ensure compliance with standards like GDPR, ISO 27001, or SOC 2 where applicable

Education :

- Bachelors or Masters degree in Computer Science, Information Technology, or a related field

Experience :

- Minimum 4+ years of experience in PostgreSQL database administration

- PostgreSQL certification (e.g., EDB Certified Associate/Professional) is a plus

- Experience in 24x7 production environments supporting high-volume transactions

Desirable Skills :

- Exposure to multi-tenant architectures

- Experience migrating from Oracle/MySQL to PostgreSQL

- Knowledge of NoSQL systems (MongoDB, Redis) is a plus

- Understanding of data warehousing and ETL processes

(ref:hirist.tech)

  • Simple Logic

    3 days ago

    Mumbai, Maharashtra, India Simple Logic IT Pvt. Ltd Full time

    About the RoleWe are looking for a detail-oriented and technically inclined Business Analyst (BA) to support the development and enhancement of internal enterprise platforms focused on service delivery, vendor lifecycle management, and infrastructure monitoring.This role requires strong skills in requirement gathering, workflow design, stakeholder...

  • Simple Logic

    3 weeks ago

    Mumbai, Maharashtra, India Simple Logic IT Pvt. Ltd Full time

    Key Responsibilities :- Lead a team of Oracle DBAs supporting multiple BFSI clients in 24x7 support and project-based engagements- Own and govern database delivery across L1L3 operations (incidents, performance tuning, patching, upgrades, security hardening)- Ensure compliance with SLAs, ITIL processes, and RBI/SEBI regulatory norms for database management-...

  • Simple Logic

    6 days ago

    Mumbai, Maharashtra, India Simple Logic IT Pvt. Ltd Full time ₹ 15,00,000 - ₹ 20,00,000 per year

    Job Summary : We are seeking an experienced and highly skilled Lead . NET Core Developer to join our dynamic team in Navi Mumbai. The ideal candidate will possess a strong background in . NET Core development, excellent leadership abilities, and a proven track record of delivering high-quality software solutions. This role requires a hands-on leader who can...

  • Simple Logic

    5 days ago

    Mumbai, Maharashtra, India Simple Logic IT Pvt. Ltd Full time

    Key Responsibilities :- Proficient in SQL script writing.- Strong understanding of query optimization and performance tuning.- Hands-on experience with complex queries, stored procedures, and indexing strategies.- Knowledge of database design and normalization.- Familiarity with MSSQL, MySQL, or PostgreSQL is preferred.- Experience in debugging and resolving...

  • Simple Logic

    5 days ago

    Mumbai, Maharashtra, India Simple Logic IT Pvt. Ltd Full time

    We are seeking a highly skilled and experienced Lead Database Administrator (DBA) to oversee the design, implementation, maintenance, and optimization of our organizations database systems. The Lead DBA will be responsible for ensuring database performance, security, and availability, while guiding a team of database administrators and engineers. This role...

  • Simple Logic

    7 days ago

    Mumbai, Maharashtra, India Simple Logic IT Pvt. Ltd Full time ₹ 9,00,000 - ₹ 12,00,000 per year

    Job Summary :We are seeking experienced Oracle DB Performance Tuning and PLSQL Optimization to join our team. The successful candidates will be responsible for optimizing and rewriting PLSQL code to enhance database performance and efficiency. This role requires deep expertise in Oracle database performance tuning, PLSQL optimization, Partitioning, and a...

  • Simple Logic

    2 days ago

    Mumbai, Maharashtra, India Simple Logic IT Pvt. Ltd Full time

    Manager - Key Account Description:What we're looking for: We are seeking a result-driven Key Account Manager who is passionate about driving aggressive revenue growth from a portfolio of customers spread across different Good understanding for Hunting new logos and farming opportunities in major BFSI players & other industry verticals.- Engage regularly...

  • Simple Logic

    6 days ago

    Navi Mumbai, Maharashtra, India Simple Logic IT Pvt. Ltd Full time

    Job Description :Key Responsibilities :System Administration & Configuration :- Install, configure, and maintain Linux operating systems (RHEL, CentOS, Ubuntu, SUSE).- Manage user accounts, groups, permissions, and security policies.- Handle system upgrades, patches, and kernel tuning to ensure stability and performance.- Manage storage systems, file systems...

  • Database Consultant

    2 weeks ago

    Navi Mumbai, Maharashtra, India Simple Logic IT Private Limited Full time

    Hiring for Database Developer Lead With Simple Logic IT Pvt Ltd at Seawood-Navi Mumbai-WFOExperience : 10 YrsWork Location : Seawood-Navi MumbaiWork Mode : Work From OfficeNote : Should hav Team Handling and Insurance Domain Experience (Mandatory)Primary Skills :1. Team handling (more than 10 resources).2. Work with large datasets and write efficient SQL...

  • Database Consultant

    3 weeks ago

    Navi Mumbai, Maharashtra, India Simple Logic IT Private Limited Full time

    Hiring for Database Developer Lead With Simple Logic IT Pvt Ltd at Seawood-Navi Mumbai-WFO Experience : 10 Yrs Work Location : Seawood-Navi Mumbai Work Mode : Work From Office Note : Should hav Team Handling and Insurance Domain Experience (Mandatory) Primary Skills : 1. Team handling (more than 10 resources). 2. Work with large datasets and write...