
Database Administrator Lead - PostgreSQL
ABOUT Ashnik
Established in 2009, Ashnik is a leading open-source solutions and consulting company in South East Asia and India, headquartered in Singapore. We enable digital transformation for large enterprises through our design, architecting, and solution skills. Over 100 large enterprises in the region have acknowledged our expertise in delivering solutions using key open-source technologies. Our offerings form critical part of Digital transformation, Big Data platform, Cloud and Web acceleration and IT modernization. We represent EDB, Pentaho, Docker, Couchbase, MongoDB, Elastic, NGINX, Sysdig, Redis Labs, Confluent, and HashiCorp as their key partners in the region. Our team members bring decades of experience in delivering confidence to enterprises in adopting open source software and are known for their thought leadership.
THE POSITION
Ashnik is looking for talented and passionate people to be part of the team for an upcoming project at client location.
RESPONSIBILITIES
· Monitoring database performance
· Optimizing Queries and handle escalations
· Analyse and assess the impact and risk of low to medium risk changes on high profile production databases
· Implement security features
· DR implementation and switch over
QUALIFICATION AND EXPERIENCE
· Preferably have a working experience of 4 Years and more , on production PostgreSQL DBs.
· Experience of working in a production support environment
· Engineering or Equivalent degree
· Passion for open-source technologies is desired
ADDITIONAL SKILLS
· Install & Configure PostgreSQL, Enterprise DB
· Technical capabilities PostgreSQL 9.x, 10.x, 11.x
· Server tuning
· Troubleshooting of Database issues
· Linux Shell Scripting
· Install, Configure and maintain Fail Over mechanism
· Backup - Restoration, Point in time database recovery
· A demonstrable ability to articulate and sell the benefits of modern platforms, software and technologies.
· A real passion for being curious and a continuous learner. You are someone that invests in yourself as much as you invest in your professional relationships.
LOCATION: Bangalore & Mumbai
Experience: 7 yrs plus
Package: upto 20 LPA

Similar jobs
🚀 Hiring: Python Developer
⭐ Experience: 2+ Years
📍 Location: Mumbai (Andheri East )
⭐ Work Mode:- 5 Days Work From Office
⏱️ Notice Period: Immediate Joiners
(Only immediate joiners & candidates serving notice period)
Looking for a skilled Python Developer with experience in Django / FastAPI and MongoDB / PostgreSQL.
⭐ Must-Have Skills:-
✅ 2+ years of professional experience as a Python Developer
✅Proficient in Django or FastAPI
✅Hands-on with MongoDB or PostgreSQL
✅Strong understanding of REST APIs & Git
Job description
- Database Design & Development:
- Design, implement, and maintain PostgreSQL databases.
- Develop efficient schemas, indexes, and stored procedures to optimize data performance.
- Backend Development:
- Develop RESTful APIs and backend services using Node.js.
- Integrate databases with backend applications for seamless data flow.
- Query Optimization & Performance Tuning:
- Optimize SQL queries for performance and scalability.
- Monitor database health and troubleshoot slow queries or deadlocks.
- Security & Compliance:
- Implement database security best practices, including role-based access control (RBAC) and encryption.
- Ensure compliance with industry standards like GDPR, HIPAA, etc.
- Data Migration & Backup:
- Develop and maintain data migration scripts between different PostgreSQL versions or other databases like mongodb.
- Set up and manage database backup and recovery strategies.
- Write efficient SQL queries and manage database schemas using PostgreSQL.
- Build RESTful APIs and integrate third-party APIs/services.
- Optimize application performance and troubleshoot production issues.
- Ensure data security and protection practices are followed.
- Write clean, maintainable code and participate in code reviews.
Job Summary:
We are seeking an experienced and highly motivated Senior Python Developer to join our dynamic and growing engineering team. This role is ideal for a seasoned Python expert who thrives in a fast-paced, collaborative environment and has deep experience building scalable applications, working with cloud platforms, and automating infrastructure.
Key Responsibilities:
Develop and maintain scalable backend services and APIs using Python, with a strong emphasis on clean architecture and maintainable code.
Design and implement RESTful APIs using frameworks such as Flask or FastAPI, and integrate with relational databases using ORM tools like SQLAlchemy.
Work with major cloud platforms (AWS, GCP, or Oracle Cloud Infrastructure) using Python SDKs to build and deploy cloud-native applications.
Automate system and infrastructure tasks using tools like Ansible, Chef, or other configuration management solutions.
Implement and support Infrastructure as Code (IaC) using Terraform or cloud-native templating tools to manage resources effectively.
Work across both Linux and Windows environments, ensuring compatibility and stability across platforms.
Required Qualifications:
5+ years of professional experience in Python development, with a strong portfolio of backend/API projects.
Strong expertise in Flask, SQLAlchemy, and other Python-based frameworks and libraries.
Proficient in asynchronous programming and event-driven architecture using tools such as asyncio, Celery, or similar.
Solid understanding and hands-on experience with cloud platforms – AWS, Google Cloud Platform, or Oracle Cloud Infrastructure.
Experience using Python SDKs for cloud services to automate provisioning, deployment, or data workflows.
Practical knowledge of Linux and Windows environments, including system-level scripting and debugging.
Automation experience using tools such as Ansible, Chef, or equivalent configuration management systems.
Experience implementing and maintaining CI/CD pipelines with industry-standard tools.
Familiarity with Docker and container orchestration concepts (e.g., Kubernetes is a plus).
Hands-on experience with Terraform or equivalent infrastructure-as-code tools for managing cloud environments.
Excellent problem-solving skills, attention to detail, and a proactive mindset.
Strong communication skills and the ability to collaborate with diverse technical teams.
Preferred Qualifications (Nice to Have):
Experience with other Python frameworks (FastAPI, Django)
Knowledge of container orchestration tools like Kubernetes
Familiarity with monitoring tools like Prometheus, Grafana, or Datadog
Prior experience working in an Agile/Scrum environment
Contributions to open-source projects or technical blogs
Sizzle is an exciting new startup that’s changing the world of gaming. At Sizzle, we’re building AI to automate gaming highlights, directly from Twitch and YouTube streams. We’re looking for a superstar Python expert to help develop and deploy our AI pipeline. The main task will be deploying models and algorithms developed by our AI team, and keeping the daily production pipeline running. Our pipeline is centered around several microservices, all written in Python, that coordinate their actions through a database. We’re looking for developers with deep experience in Python including profiling and improving the performance of production code, multiprocessing / multithreading, and managing a pipeline that is constantly running. AI/ML experience is a plus, but not necessary. AWS / docker / CI/CD practices are also a plus. If you are a gamer or streamer, or enjoy watching video games and streams, that is also definitely a plus :-)
You will be responsible for:
- Building Python scripts to deploy our AI components into pipeline and production
- Developing logic to ensure multiple different AI components work together seamlessly through a microservices architecture
- Managing our daily pipeline on both on-premise servers and AWS
- Working closely with the AI engineering, backend and frontend teams
You should have the following qualities:
- Deep expertise in Python including:
- Multiprocessing / multithreaded applications
- Class-based inheritance and modules
- DB integration including pymongo and sqlalchemy (we have MongoDB and PostgreSQL databases on our backend)
- Understanding Python performance bottlenecks, and how to profile and improve the performance of production code including:
- Optimal multithreading / multiprocessing strategies
- Memory bottlenecks and other bottlenecks encountered with large datasets and use of numpy / opencv / image processing
- Experience in creating soft real-time processing tasks is a plus
- Expertise in Docker-based virtualization including:
- Creating & maintaining custom Docker images
- Deployment of Docker images on cloud and on-premise services
- Experience with maintaining cloud applications in AWS environments
- Experience in deploying machine learning algorithms into production (e.g. PyTorch, tensorflow, opencv, etc) is a plus
- Experience with image processing in python is a plus (e.g. openCV, Pillow, etc)
- Experience with running Nvidia GPU / CUDA-based tasks is a plus (Nvidia Triton, MLFlow)
- Knowledge of video file formats (mp4, mov, avi, etc.), encoding, compression, and using ffmpeg to perform common video processing tasks is a plus.
- Excited about working in a fast-changing startup environment
- Willingness to learn rapidly on the job, try different things, and deliver results
- Ideally a gamer or someone interested in watching gaming content online
Seniority: We are looking for a mid to senior level engineer
Salary: Will be commensurate with experience.
Who Should Apply:
If you have the right experience, regardless of your seniority, please apply.
Work Experience: 4 years to 8 years
About Sizzle
Sizzle is building AI to automate gaming highlights, directly from Twitch and YouTube videos. Sizzle works with thousands of gaming streamers to automatically create highlights and social content for them. Sizzle is available at www.sizzle.gg.
We are seeking a skilled NestJS/PostgreSQL Developer to join our development team. As a NestJS/PostgreSQL Developer, you will be responsible for designing and implementing server-side applications, APIs, and databases using NestJS framework and PostgreSQL. You will work closely with other developers, stakeholders, and project managers to deliver high-quality software solutions.
Responsibilities:
- Develop server-side applications and APIs using the NestJS framework.
- Design and implement efficient and scalable database schemas using PostgreSQL.
- Collaborate with front-end developers to integrate server-side logic with the user interface.
- Write clean and maintainable code following best practices and coding standards.
- Conduct code reviews and provide constructive feedback to improve code quality.
- Optimize application performance and troubleshoot any issues or bugs.
- Work closely with stakeholders to understand requirements and translate them into technical solutions.
- Participate in the entire software development lifecycle, including planning, designing, coding, testing, and deployment.
- Stay up-to-date with the latest trends and technologies in web development, NestJS, and PostgreSQL.
Requirements:
- Bachelor's degree in Computer Science, Engineering, or a related field.
- Proven experience (2-5 years) in server-side application development using NestJS framework.
- Strong knowledge of TypeScript and JavaScript.
- Experience with PostgreSQL or other relational databases.
- Proficiency in building and consuming RESTful APIs.
- Familiarity with Git version control system.
- Good understanding of software development principles, design patterns, and best practices.
- Excellent problem-solving and debugging skills.
- Strong communication and collaboration skills.
- Ability to work independently as well as in a team environment.
Preferred Qualifications:
- Experience with other JavaScript frameworks such as Angular or React.
- Knowledge of microservices architecture and containerization (e.g., Docker).
- Familiarity with cloud platforms like AWS, Azure, or GCP.
- Experience with testing frameworks (e.g., Jest, Jasmine).
- Understanding of Agile/Scrum development methodologies.
About Us:
Developed in formal collaboration with the University of Cambridge in May 2000, HeyMath! is an Ed-Tech company whose mission is to Raise the Game in Maths for school systems around the world. We do this using technology to deliver engaging teaching methodologies and personalised learning paths for students. HeyMath! has been successfully adopted by CBSE schools since 2004, with positive outcomes for the entire ecosystem.
Check us out at www.heymath.com
We plan to work mainly from home in 2022 and the virtual office atmosphere is collegiate, informal and friendly, with small high-impact teams making a difference to customers.
What we are looking for:
Experience in building and re-engineering cloud based solutions on AWS.
Strong knowledge of Object Oriented Programming(OOPS) and design patterns is a must. Hands-on development on Spring MVC framework.
Experience working on Java 8 or above.
Must have very good knowledge of RDBMS such as MySQL and performance tuning of the same.
Exposure to server-side and client-side caching mechanisms. Ability to debug the applications and provide instant workable solutions.
Experience working on Elastic Search / Kafka / Kubernetes or all is a nice to have.
• Opportunity to develop game-changing, globally distributed, internet advertising products used by millions worldwide.
• Contribute hands-on, own, collaborate, and deliver new features and services at a fast pace.
• Build platforms, frameworks, APIs, libraries & automated tools to facilitate rapid issue
resolution and development & deployment of new features and changes.
• Own the prioritization, scoping and scheduling processes for new products and features.
• Work with and advise management on technical aspects, make well-informed decisions.
• Improve processes, technology & the applications you own continuously by showing the team better ways of doing things and help improve skills in the team.
• Prioritize tech-debt and ensure the platforms and applications meet the latest industry
standards.
• Learn new technology & practices, coach the team and conduct training sessions – devote time for learning and continuous improvement of self and team.
• Imbibe and maintain a strong customer service-oriented attitude while designing and building products.
Who should apply for this role ?
• 5 - 9 years of experience in building or managing large scale distributed systems
• BS/MS degree in Computer Science or other relevant majors
• A track record of working on scalable applications, preferably at a major internet property or well-known startup
• Good grasp on programming fundamentals including OOP, Design Principles and Data Structures
• Excellent analytical, logical, and problem-solving skills
• Solid knowledge of Java/Python/Golang, web services (REST/JSON), NoSql Databases,
Kafka/Kinesis/Spark, Elasticsearch/Solr/Kibana
• Can exhibit passion and enthusiasm for remarkable technology (Knowledge and contribution to open source projects, Active Blog, etc. is a plus)
• Ability to learn emerging technical/business standards and apply/coach development team in proper adoption
• Deep understanding of development processes and has personally contributed to critical
product cycles
• Communicate effectively & cross-functionally with other teams
Role & Responsibilities:
- Handle multiple products/modules simultaneously, lead the team in development and support
- Lead development teams
- Daily updates to customers and Product Managers/Delivery Managers
- Participate in design discussions
- Design and Architect small modules
- Effort estimations for modules, subsystems or use cases.
- Learn new skills and mentor the new team members
- Champion best practices within the team, including code reviews
Work Experience & Skills:
- B.E/B.Tech or any relevant Masters degree from reputed college.
- Strong 5+ years of experience in Java, J2EE, Spring IOC, Spring Annotations, Spring JDBC, Jquery, Java script, HTML 5 and CSS
- Strong experience in Postgres or any SQL technology
- Experience with working on Tomcat, Apache, JBoss or any similar application server
- Should have 3+ years of experience in leading team.
- Good experience in JSON / RESTful API / Web Services.
- Experience in working on Agile methodology using Scrum and sprints
- Experience in using build tools, Maven, GIT, Bugzilla or similar tools.
- Experience in cloud technologies, Microservices and frameworks such as AWS or GPC, container technologies like Docker is a plus.
- Ability to adapt to new development environments, changing business requirements and learning new systems highly desired
- Experience in Microservices, SpringBoot and Angular is a plus.
- Experience with tuning deployed applications for scalability and performance.
- Good knowledge of deployment and scripting on Linux/Unix servers
- Strong technical documentation skills.
- Good oral and written communication skills
The key aspects of this role:
• Candidate with exceptional programming skills, problem-solving abilities and strong work
ethic.
• The candidate has to work on custom programming and web application development for
Drupal.
• Testing, maintenance and troubleshooting of existing company sites and resolving issues if
any.
• Contributing ideas and efforts towards internal projects and working as part of a team to
find solutions on various problems.
• Communicate technical ideas to business users and other teams (design, QA).
• Collaborate with team members and to work independently when needed.
• Eager to embrace current and emerging web technologies.
To be the right fit, you'll need:
• Experience of total 4+ years working on PHP and Drupal 7,8 Development (at least 2+ years
in Drupal 8)
• Strong knowledge of MySQL, jQuery, HTML5, CSS
• Experience with Drupal architecture, best practices and coding standards
• Knowledge on Views, Services etc.
• Experience in custom module and theme creation
• Familiar with sub version control systems such as Git or SVN
• Basic knowledge of environment setup for Linux distribution.










