Business Development Executive

Job Title: Database Administrator (PostgreSQL) 

Experience: 3 to 6 years 

Location: Gurgaon (Hybrid) 

Employment Type: Full-time 

Job Description: 

We are seeking a skilled Database Administrator (DBA) with expertise in PostgreSQL and strong RDBMS concepts. The ideal candidate will be responsible for database performance monitoring, optimization, automation, and interaction with development teams to support business requirements. 

Key Responsibilities: 

1. Database Administration & Management 

• Manage, configure, and maintain PostgreSQL databases ensuring high availability and reliability. 
• Implement Primary-Slave replication architecture and ensure smooth data synchronization. 
• Work with AWS RDS for PostgreSQL database hosting. 
• Automate database backups and manage release versions for database changes. 
• Implement point-in-time recovery (PITR) backups in AWS RDS to ensure data integrity and disaster recovery. 

2. Performance Monitoring & Optimization 

• Regularly monitor database health and performance metrics. 
• Analyze and optimize slow queries to enhance application performance. 
• Fine-tune database performance using configuration parameters, buffers, connections, Disk IOPs, and memory. 

3. SQL Development & Optimization 

• Write, optimize, and maintain stored procedures, SQL functions, and SQL Views. 
• Implement indexing strategies to improve query performance. 

4. Collaboration & Requirement Analysis 

• Work closely with application developers and business analysts to understand new product requirements. 
• Provide recommendations on database design and architecture for scalable solutions. 

5. Database Security & Compliance 

• Implement best practices for database security, access control, and data integrity. 
• Ensure compliance with data governance and security policies. 

6. Automation & Maintenance 

• Automate database maintenance tasks such as backups, indexing, and archiving. 
• Establish monitoring and alerting systems to proactively address database issues. 

Technical Expertise Required: 

• 3 to 6 years of experience as a Database Administrator (DBA). 
• Strong knowledge of PostgreSQL and RDBMS principles. 
• Experience in writing stored procedures, SQL functions, and SQL Views. 
• Hands-on experience in query optimization and performance tuning. 
• Understanding of Primary-Slave architecture and replication setup. 
• Knowledge of database configuration tuning (buffers, connections, Disk IOPs, Memory, etc.). 
• Experience in automating database backups and version control for DB changes. 
• Familiarity with AWS RDS for PostgreSQL and point-in-time backup (PITR). 
• Experience in cloud-based database solutions (AWS RDS, Azure, GCP). 
• Strong problem-solving and analytical skills. 

Preferred Qualifications: 

• Experience in high-availability solutions and disaster recovery strategies. 
• Exposure to NoSQL databases is a plus. 
• Experience with database migrations and upgrades. 

Title/Role: Python Django Consultant

Experience: 8+ Years

Work Location: Indore / Pune /Chennai / Vadodara

Notice period: Immediate to 15 Days Max

Key Skills: Python, Django, Crispy Forms, Authentication, Bootstrap, jQuery, Server Side Rendered, SQL, Azure, React, Django DevOps

Job Description:

• Should have knowledge and created forms using Django. Crispy forms is a plus point.
• Must have leadership experience 
• Should have good understanding of function based and class based views.
• Should have good understanding about authentication (JWT and Token authentication)
• Django – at least one senior with deep Django experience. The other 1 or 2 can be mid to senior python or Django
• FrontEnd – Must have React/ Angular, CSS experience
• Database – Ideally SQL but most senior has solid DB experience
• Cloud – Azure preferred but agnostic
• Consulting / client project background ideal.

Django Stack:

• Django
• Server Side Rendered HTML
• Bootstrap
• jQuery
• Azure SQL
• Azure Active Directory
• Server Side Rendered/jQuery is older tech but is what we are ok with for internal tools. This is a good combination of late adopter agile stack integrated within an enterprise. Potentially we can push them to React for some discreet projects or pages that need more dynamism.

Django Devops:

• Should have expertise with deploying and managing Django in Azure.
• Django deployment to Azure via Docker.
• Django connection to Azure SQL.
• Django auth integration with Active Directory.
• Terraform scripts to make this setup seamless.
• Easy, proven to deployment / setup to AWS, GCP.
• Load balancing, more advanced services, task queues, etc.

Responsibilities

Develop high quality, secure, stable code for use in products and solutions for

customers, making it easier for other developers to maintain, enhance, reuse,

and localize

Work with Product Owner and/or Product Manager/Team to understand and help

refine functional requirements for new products

Develop and outline architecture and relationships between subsystems and

participates in review of those designs

Investigate and, if necessary, prototype technologies and algorithms relating to

the task

Break down a large problem into smaller components and provide a clear

solution for each piece

Ensure new code, feature or software product meets performance goals/metrics

Research external best practices and emerging technologies for possible

incorporation into company products and methodologies

Write and maintain the code following Test-Driven-Design principles

Minimum Qualifications

Bachelor’s degree in any Engineering discipline from reputed engineering

college

5 to 7 years of strong programming skills in Web and Cloud Technologies

Should have a very strong foundation in JavaScript, and must have a clear

understanding of basic web fundamentals such as prototype based inheritance,

scopes, Event Loop, Memory Management in JS, etc

Should be good at developing modular front-end applications and is expected to

have the knowledge to create good abstractions that can be reused . Should also

have in-depth understanding of latest ES6 standards such as spread operators,

arrow functions, etc

Should have strong programming skills in Web and Cloud Technologies

Should be strong in OOAD Concepts

Should have a strong hands-on in React, Typescript

Should have Hands-on experience in any of the backend language.

Should understand latest paradigms in Front End Development such as Pub-Sub

Pattern, Redux, RxJS, Service Workers, Client Caching, Lazy Loading, Dynamic

Injection, Bundle Optimisation, etc

Should have very good hands-on knowledge of CSS3 & HTML5

Should have good knowledge of Postman API Platform

Should have experience with Amazon web services – ECS, Lambda, S3, SQS, etc

Should have Hands-on experience of developing RESTful web services and

integrating the same with heterogeneous clients

Should have Hands-on experience with Relational or NoSQL Database’s

Should have a very clear understanding of TDD is expected and should have

good exposure to writing UT's and designing UI components with testability in

mind

Should have Strong Communication and Analytical skills

Flexibility under changing conditions and the ability to multi-task between

projects

Preferred Qualifications

Hands-on experience with C++

Nice to have experience with Python

Nice to have experience with CI/CD tools like Docker, Jenkins, etc

Nice to have a hands-on & Understanding of CSS Pre-processors such as SASS,

LESS, etc

Synapsica is a growth stage HealthTech startup founded by alumni from IIT Kharagpur, AIIMS New Delhi, and IIM Ahmedabad. We believe healthcare needs to be transparent and objective, while being affordable. Every patient has the right to know exactly what is happening in their bodies and they don’t have to rely on cryptic 2 liners given to them as diagnosis.

Towards this aim, we are building an artificial intelligence enabled cloud based platform to analyze medical images and create 2.0 of advanced radiologist reporting.

We are backed by YCombinator and other marquee investors from India, US and Japan. We are proud to have GE, AIIMS, the Spinal Kinetics as our partners.

Join us, if you find this as exciting as we do!

Description:

Synapsica is looking for a Node.js/Python developer who is passionate about designing and implementing scalable solutions with highest quality. You will be responsible for creating high performance, responsive, and secure server-side programs to manage Synapsica platform. You will be responsible for designing, managing and supporting cloud platform and scaling our database. This role is ideal for you if you have a background in bakcned development and are looking for the next level of career growth in a fast paced, learning based and merit driven work environment.

Responsibilities:
- Design and development of our new platform modules from scratch. 
- Hands on implementation of our APIs and integrations. 
- Design, scaling and integration of new/existing databases.
- Ensuring the entire stack is designed and built for speed and scalability
- Design and construction of our REST APIs with best secutiry mechanisms.
- Design and implementation of continuous integration and deployment pipelines in tandem with the respective team members.
- Performance tuning and improvements in large scale systems.
- Ensuring responsiveness and cross-platform compatibility of applications.
- Owning and delivering end-to-end products, features, enhancements.

Requirements:
- Degree in Computer Science or related discipline with strong competencies in data structures, algorithms, and software design
- At least 4+ years of experience with writing Python/NodeJS/PHP/Ruby on Rails. 
- Prior experience of database design and management in MongoDB, including being up on the latest practices and associated versions.
- Experience in building highly scalable business applications, which involve implementing large complex business flows and dealing with huge amount of data.
- Familiarity with AWS (or equivalent) ecosystem with end-to-end cloud deployment.
- Experience implementing code level unit tests.
- Proficiency with Git / Version control.
- Appreciation for clean and well documented code
- Excellent verbal communication skills.
- Good problem solving skills.
- Attention to detail.
- Very high sense of ownership.
- Deep interest and passion for technology

Do you like to write clean and comprehensible code? Does it make you happy to talk to your team mates about solutions to technical challenges every day? Are you impressed with simple and elegant solutions that solve mind-boggling problems?

If we are describing you, please read on!

Who is QbD Software?

At QbD Software we build cloud-based technology that helps our customers in the Pharma, Biotech and Medical Devices industries manage everything quality, process and product related. Our customers make life-saving and live-enhancing products that make a difference in the world. Our technology helps them to get their products and services to market fast while complying with regulation requirements by providing them with a pre-validated SaaS solution.

What would your job be like at QbD Software?

You would be working closely with your fellow software developers, side-by-side, challenging each other on who comes up with the simplest and most elegant solution to a technical problem. You will move as one Scrum Development Team and look out for each other like seasoned team mates on a championship sports team.

Your responsibilities:

• Write clean, comprehensible, and well-documented code following our software development life cycle
• Determine operational feasibility by evaluating analysis, problem definition, requirements, solution development, and proposed solutions
• Provide information by collecting, analyzing, and summarizing development and service issues
• Review code for accuracy and functionality
• Support other software developers by providing advice and coaching
• Keep up-to-date with industry trends and technology developments

What you'll need:

• More than 8 years of experience as a software developer
• At least 4 years of experience with PHP, Laravel, SQL
• At least 2 years of experience with one of the following: AngularJS/React/VueJS
• You must be a team player
• Proactive and with a getting-things-done mindset

Why would you work for us?

At QbD Software, we care about results. If you can deliver then you belong with us. You will be working with a company with strong industry partners, a good track record with an exponential growth in the coming years, and colleagues with big hearts, sharp skills, and professional work ethic. We will allow you to work 100% remote so that you can balance your work and your personal life the way you want. Say goodbye to pointless commutes and traffic once and for all. Let's save the earth together.