Senior Executive Marketplace

Job Description for PostgreSQL Lead

Job Title: PostgreSQL Lead

Company: Mydbops

About us:

As a seasoned industry leader for 8 years in open-source database management, we specialise in providing unparalleled solutions and services for MySQL, MariaDB, MongoDB, PostgreSQL, TiDB, Cassandra, and more. At Mydbops, we are committed to providing exceptional service and building lasting relationships with our customers. Our Customer Account Management team is vital in ensuring client satisfaction and loyalty.

Role Overview

As the PostgreSQL Lead, you will own the design, implementation, and operational excellence of PostgreSQL environments. You’ll lead technical decision-making, mentor the team, interface with customers, and drive key initiatives covering performance tuning, HA architectures, migrations, and cloud deployments.

Key Responsibilities

• Lead PostgreSQL production environments: architecture, stability, performance, and scalability
• 
  
• Oversee complex troubleshooting, query optimization, and performance analysis
• 
  
• Architect and maintain HA/DR systems (e.g., Streaming Replication, Patroni, repmgr)
• 
  
• Define backup, recovery, replication, and failover protocols
• 
  
• Guide DB migrations, patches, and upgrades across environments
• 
  
• Collaborate with DevOps and cloud teams for infrastructure automation
• 
  
• Use monitoring (pg_stat_statements, PMM, Nagios or any monitoring stack) to proactively resolve issues
• 
  
• Provide technical mentorship—conduct peer reviews, upskill, and onboard junior DBAs
• 
  
• Lead customer interactions: understand requirements, design solutions, and present proposals
• 
  
• Drive process improvements and establish database best practices

Requirements

• Experience: 4-5 years in PostgreSQL administration, with at least 2+ years in a leadership role
• 
  
• Performance Optimization: Expert in query tuning, indexing strategies, partitioning, and execution plan analysis.
• 
  
• Extension Management: Proficient with critical PostgreSQL extensions including:
• 
  
• pg_stat_statements – query performance tracking
• 
  
• pg_partman – partition maintenance
• 
  
• pg_repack – online table reorganization
• 
  
• uuid-ossp – UUID generation
• 
  
• pg_cron – native job scheduling
• 
  
• auto_explain – capturing costly queries
• 
  
• Backup & Recovery: Deep experience with pgBackRest, Barman, and implementing Point-in-Time Recovery (PITR).
• 
  
• High Availability & Clustering: Proven expertise in configuring and managing HA environments using Patroni, repmgr, and streaming replication.
• 
  
• Cloud Platforms: Strong operational knowledge of AWS RDS and Aurora PostgreSQL, including parameter tuning, snapshot management, and performance insights.
• 
  
• Scripting & Automation: Skilled in Linux system administration, with advanced scripting capabilities in Bash and Python.
• 
  
• Monitoring & Observability: Familiar with pg_stat_statements, PMM, Nagios, and building custom dashboards using Grafana and Prometheus.
• 
  
• Leadership & Collaboration: Strong problem-solving skills, effective communication with stakeholders, and experience leading database reliability and automation initiatives.
• 
  
• 
  

Preferred Qualifications

• Bachelor’s/Master’s degree in CS, Engineering, or equivalent
• 
  
• PostgreSQL certifications (e.g., EDB, AWS)
• 
  
• Consulting/service delivery experience in managed services or support roles
• 
  
• Experience in large-scale migrations and modernization projects
• 
  
• Exposure to multi-cloud environments and DBaaS platforms

What We Offer:

• Competitive salary and benefits package.
• Opportunity to work with a dynamic and innovative team.
• Professional growth and development opportunities.
• Collaborative and inclusive work environment.
• 
  

Job Details:

• Work time: General shift
• Working days: 5 Days
• Mode of Employment - Work From Home
• Experience - 4-5 years

Job Summary:

We are seeking a highly motivated and creative Social Media Manager & Video Content Creator to lead our online presence. This role is perfect for a multi-talented individual who can not only manage and grow our social media channels but also create compelling video content that drives engagement and brand loyalty. The ideal candidate will be a strategic thinker, a skilled content producer, and a proactive community manager who is comfortable taking full ownership of our social media and video initiatives.

Key Responsibilities:

Social Media Management & Strategy:

• Ownership of Social Media Accounts: Manage and take full ownership of all company social media accounts, including Facebook, Instagram, YouTube, LinkedIn, and Twitter.
• Content Planning & Development: Develop and implement a comprehensive social media content calendar. Coordinate with the design team to produce engaging image and video content that aligns with our brand strategy.
• Community Engagement: Timely responses to all online inquiries and direct messages from customers on social media platforms. Monitor conversations, address customer questions, and coordinate with internal teams for sales inquiries and support issues.
• Brand Growth: Develop and execute strategies to grow our social media followers, increase engagement rates, and expand our brand's reach.
• Performance Analysis: Track, analyze, and report on social media performance metrics to optimize content strategy and improve results.

Video Content Production & Editing:

• Content Creation: Conceptualize, shoot, and edit a wide range of video content specifically for social media. This includes short-form videos (Reels, Shorts, TikToks) and long-form content for platforms like YouTube and webinars.
• Full Production Cycle: Manage the entire video production process from idea generation and storyboarding to shooting, editing, and final delivery.
• Video Editing: Utilize professional video editing software (e.g., Adobe Premiere Pro, DaVinci Resolve) to assemble raw footage, add motion graphics, special effects, music, and sound design to create high-quality, polished videos.
• Asset Management: Maintain a well-organized library of video assets, including raw footage, final edits, and project files.

Big Picture (The Opportunity)

We are looking to hire an experienced SDE ll (JAVA) to help us keep growing. If you're hard-working and dedicated, Agami Tech Pvt Ltd is an ideal place to get ahead.

Responsibilities :

• Writing back-end code & front –end code and building efficient Java modules
• Contribute in all phases of the development lifecycle, Write well designed, testable,
• Design, build, and maintain efficient, reusable, and reliable Java code code
• Help maintain code quality, organization, and automatization
• Ensure designs are in compliance with specifications
• Prepare and produce releases of software components
• Support continuous improvement by investigating alternatives and technologies and
• presenting these for architectural review
• Translate application storyboards and use cases into functional applications
• Ensure the best possible performance, quality, and responsiveness of the applications
• Identify bottlenecks and bugs, and devise solutions to these problems
• Align with organizational security protocols and data protection requirements and
• Implement the required feature
• Participate in all phases of the SDLC

Skills and Experience :

• BS/MS Degree in Computer Science, Engineering or a related subject
• Hands-on experience in designing and developing applications using Java EE platforms
• Object-oriented analysis and design using common design patterns.
• Profound insight of Java and JEE internals (Class loading, Memory Management,
• Transaction management, etc.)
• excellent knowledge of Relational Databases, SQL, and ORM technologies (JPA2,
• Hibernate)
• Experience in the Spring Framework
• Hands-on experience in designing and developing applications using JavaScript, j Query,
• and AJAX.
• Ensure that the APIs and services are adequate to support the application
• Profound insight of Java and JEE internals (Class loading, Memory Management,
• Transaction management etc.)
• Excellent knowledge of Relational Databases, SQL, and ORM technologies (JPA2,
• Hibernate)
• Experience with test-driven development
• excellent written and verbal communication skills Ability to quickly adapt and learn new
•  
• Collaborate with other parts of the technology team, including product, QA, etc. to
• deliver a solid product.

Qualifications:

A Bachelor’s degree in Computer Science (or equivalent experience)

Job Role:

Experience building and maintaining code for:

Android platform (Android Studio, Kotlin, Java, Android SDK) OR

Any other platform, with proven track record of picking up new skills

Hands-on experience with modern technologies.

Excellent Kotlin/Java programming skills

Excellent analytical, debugging and troubleshooting skills (battery usage, network usage optimization, etc)

Passion for usability, simplicity and consistency in software development.

Excellent communication and collaborative skills.

Exposure to Agile methodologies

Bonus points for knowledge of iOS platforms, hybrid platforms(React native, Flutter).

• Looking for an experienced Integration specialist with a good expertise in ETL Informatica and a strong Application integration background
• Minimum of 3+ years relevant experience in Informatica MDM required. Powercenter is a core skill set.
• Having experience in a broader Informatica toolset is strongly preferred
• Should prove a very strong implementation experience in Application integration, should demonstrate expertise/presentation with multiple use cases
• Passionate coders with a strong Application development background
• Should have application development experience outside of ETL, (just learning ETL as a tool is not enough), experience in writing application outside of ETL will bring in more value
• Strong database skills with a strong understanding of data, data quality, data governance, understanding and developing standalone and integrated database layers (sql, packages, functions, performance tuning ), i.e. Expert with a strong integration background who has more application integration background than just an ETL Informatica tool
• Experience in integration with XML/JSON based and heavily involve JMS MQ (read/write)
• Experience in SOAP and REST based API's exchanging both XML and JSON files used for request and response
• Experience with Salesforce.com Integration using Informatica power exchange module is a plus but not needed
• Experience with Informatica MDM as a technology stack that is used for integration of senior market members with Salesforce.com is a plus but not needed,
• Very strong scripting background (C/bourne shell/Perl/Java)
• Should be able to understand JAVA, we do have development around JAVA, i.e ability to work around a solution in programming language like Java when implementation is not possible through ETL
• Ability to communicate effectively via multiple channels (verbal, written, etc.) with technical and non-technical staff.

As a DB2 Administrator, candidate would involve in L2 activities, troubleshooting database & key responsible for Migration, Upgrading activities including DB2 replication suite and services.

Responsibilities -

·         Product lifecycle Management of DB2 LUW Product including replication suite

·         Perform Health check activities, monitoring, backup, space management, Maintenance i.e. Reorg / Run stat utilities

·         Follow-up CIRATS i.e. Compliance, Issue, Risk and APAR (Authorized Program Analysis Report) Tracking System

·         User management and BAU activities

·         Setup and maintenance of Data replication services

·         Disaster recovery and business continuity planning

·         Backup and recovery methods including point in time recovery

·         DB2 node directory / catalog configuration

·         Database performance tuning and troubleshooting

·         24*7 on call support for DB2 portfolio and applications

·         Provide best in class solutions for all business needs

·         Explore and help organization to implement best technical practises / recommendations to reduce technical debt and cost

·         Managing and maintaining physical databases including database storage management, procedures and tools for access, database security, monitoring and tuning the database

·         Analysing system storage capacity and recommending improvements to ensure efficiency

·         Assisting in the design and implementation of the physical framework of the database

Required Skillset -

• 6+ years of relevant experience in DB2 LUW Administration
• Good experience with
  • Performance tuning and troubleshooting
  • High availability solutions HACMP, TSA, MSCS Cluster
  • Monitoring, backup, recovery, IBM Data Server Manager, TSM , Commvault
  • Data replication, Q-replication & CDC
  • Implementing DB2 key features
  • Desirable experience with Db2 Pure scale
• Experience with tools i.e. ITM, Nagios, Service Now
• Experience with automation and scripting such as CRON, PowerShell, Shell Scripting
• Experience with configuring and usage of Clustering, db2diag and notification logs, snapshot and event monitor
• Experience with use of problem and change management tools

Other desired traits -

• Technical agility
• Good Team player, Self-starter
• Willing to take accountability and drive projects/tasks to completion
• Good written, verbal communication and interpersonal skills
• Ability to relate technical issues to non-technical personnel