Simple Logic

4 days ago

Mumbai, India Simple Logic IT Pvt. Ltd Full time

Job Description


Required Skills & Experience: PostgreSQL DBA (Level 3)


- 2+ years of hands-on PostgreSQL DBA experience in production environments.

- Deep knowledge of PostgreSQL internals, architecture, and tuning.

- Proven experience with pgBackRest, Barman, pg_basebackup, pg_dump.

- Strong expertise with HA and replication solutions (Patroni, repmgr).

- Hands-on experience with PITR, disaster recovery, and cluster rebuilds.

- Proficiency in Linux/Unix environments, shell scripting, and automation.

- Solid understanding of database security and compliance best practices.

- Excellent troubleshooting skills and experience handling critical incidents.

- Monitor and optimize performance, tune queries and indexes, manage vacuuming and bloat,

implement pooling (PgBouncer), and maintain robust monitoring and alerts.

- Diagnose and recover from cluster corruption using advanced tools and procedures, leveraging backups and replicas to ensure business continuity.

- Plan and execute major upgrades (pg_upgrade, logical replication), cross-version and cross-platform migrations (on-prem ? cloud), ensuring minimal downtime and data integrity.

- Strong hands-on experience with AWS PostgreSQL services like RDS and Aurora, including parameter groups, snapshot management, performance insights, and multi-AZ failover.

- Experience with monitoring tools (Prometheus, Grafana, or similar) is a plus.

- Good communication skills and ability to work collaboratively in a 24x7 production support environment.

- Experience with logical replication and foreign data wrappers.

- Familiarity with cloud-managed PostgreSQL services.

- Familiarity with connection pooling and proxy tools (PgBouncer, HAProxy).

- Maintain SOPs, runbooks, and knowledge base articles.

- Automate routine tasks and checks using scripts or scheduling tools (cron, pg_cron).

- Mentor junior DBAs and conduct knowledge-sharing sessions.


MySQL DBA Responsibilities (Secondary) :


- Good knowledge of MySQL architecture and installation.

- Perform MySQL backup and restore operations.

- Manage MySQL users, roles, and permissions.

- Setup and troubleshoot MySQL replication.


(ref:hirist.tech)

  • Simple Logic

    2 weeks 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...

  • Simple Logic

    1 week 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

    4 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

    2 weeks 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

    2 weeks 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

    2 weeks 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

    2 weeks 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

    1 week 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

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

    Job Description :We are seeking a skilled DevOps Engineer with 6-10 years of experience to join our technology team working on NBFC domain projects. The ideal candidate will be responsible for building, deploying, and maintaining scalable, high-performance infrastructure and automation solutions to support software development and production environments.Key...

  • Simple Logic

    6 days ago

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

    Accountabilities :- Accountable for MIS reports and data deliveries with required due diligence and process adherence.- Collaborate with business users to prioritize requirements and manage change requests.- Collaborate with the development team for designing solutions with understanding of system data flows.- Mentor development team for optimized and timely...