Simple Logic

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

    1 day ago

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

    Description : Team Leadership & Project Management : - Lead, mentor, and manage a team of 10 database professionals to deliver high-quality, timely, and efficient database solutions. - Oversee end-to-end database development, maintenance, and performance improvement projects. - Allocate resources, define project timelines, and ensure...

  • Simple Logic

    2 days ago

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

    Description : We are looking for a detail-oriented and technically inclined Business Analyst to support the development and enhancement of internal enterprise platforms. This role requires strong skills in requirement gathering, workflow design, stakeholder management, and an understanding of IT operations and performance metrics. The ideal...

  • Simple Logic

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

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

  • Simple Logic

    2 weeks ago

    Mumbai, Maharashtra, India Simple Logic IT Pvt. Ltd Full time ₹ 15,00,000 - ₹ 25,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 day ago

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

    Description : Job summary : Join our growing team as an AI/ML Engineer and work on Large Language Models (LLMs), RAG architectures, and cutting-edge AI frameworks.Qualifications : years of AI/ML engineering experience with production-level deployments - Strong expertise in Python, APIs, and microservices - Experience with Azure AI Foundry, AWS...

  • Simple Logic

    4 weeks ago

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

    Roles and Responsibilities :- Installation, configuration and administration of WebLogic infrastructure.- Patching and Upgrade of WebLogic infrastructure.- Deployment and Un-deployment of applications.- Expertise in performance tuning Heap size configuration, thread dump analysis, heap dump analysis.- Administration and configuration of Web Server like...

  • Simple Logic

    4 weeks ago

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

    Role and Responsibilities :- Installation, configuration and administration of WebLogic infrastructure.- Patching and Upgrade of WebLogic infrastructure.- Excellent experience in troubleshooting.- Knowledge on WLST scripting.- Deployment and Un-deployment of applications.- Expertise in performance tuning - Heap size configuration, thread dump analysis, heap...

  • Simple Logic

    20 hours ago

    Mumbai, India Simple Logic IT Pvt. Ltd Full time

    Description :We are looking for a detail-oriented and technically inclined Business Analyst to support the development and enhancement of internal enterprise platforms.This role requires strong skills in requirement gathering, workflow design, stakeholder management, and an understanding of IT operations and performance metrics.The ideal candidate will work...

  • Simple Logic

    21 hours ago

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

    Description :Team Leadership & Project Management : - Lead, mentor, and manage a team of 10+ database professionals to deliver high-quality, timely, and efficient database solutions.- Oversee end-to-end database development, maintenance, and performance improvement projects.- Allocate resources, define project timelines, and ensure adherence to SLAs and...