Postgres Database Developer with DBA Experience

Job Title : Python Django Developer

Location : Gurgaon (On-site)

Work Mode : 6 Days a Week (Work from Office)

Experience Level : 3+ Years

About the Role :

We are seeking a highly skilled and motivated Python Django Developer to join our team in Gurgaon. This role requires a hands-on developer with expertise in building scalable web applications and APIs using Python and Django. The ideal candidate will have a strong background in relational databases, message brokers, and distributed systems.

Key Responsibilities :

• Design, develop, and maintain robust, scalable, and secure web applications using Python and Django.
• Build and optimize back-end services, RESTful APIs, and integrations with third-party tools.
• Implement and maintain asynchronous task processing using Celery and RabbitMQ.
• Work with PostgreSQL to design and optimize database schemas and queries.
• Utilize Redis and Kafka for caching, data streaming, and other distributed system needs.
• Debug and troubleshoot issues across the application stack.
• Collaborate with cross-functional teams to gather requirements and deliver solutions.
• Ensure code quality through comprehensive testing, code reviews, and adherence to best practices.

Required Skills and Qualifications:

Technical Expertise:

• Proficiency in Python and strong experience with Django framework.
• Hands-on experience with PostgreSQL for database design and management.
• Familiarity with RabbitMQ, Celery, and Redis for asynchronous processing and caching.
• Experience with Kafka for building real-time data pipelines and event-driven architectures.

Other Skills:

• Strong understanding of software development best practices and design patterns.
• Proficiency in writing efficient, reusable, and testable code.
• Good knowledge of Linux/Unix environments.
• Familiarity with Docker and containerized deployments is a plus.

Soft Skills:

• Excellent problem-solving and analytical skills.
• Good communication and teamwork abilities.
• Ability to work independently and in a collaborative team environment.

Preferred Qualifications:

• Experience in microservices architecture.
• Exposure to DevOps tools and practices.
• Knowledge of front-end technologies like React or Angular is a bonus.

Key Responsibilities

• Develop, deploy, and maintain scalable applications using Python, NodeJS, and Golang.

• Design and implement robust messaging and event-driven systems with Kafka.

• Optimize and manage databases, including Postgres and MySQL.

• Integrate and manage caching solutions such as Redis for high performance data access.

• Containerize applications and manage deployments using Docker and Linux.

• Collaborate with cross-functional teams to implement features and troubleshoot issues.

• Explore and experiment with AI/LLM technologies to enhance product offerings.

• Contribute to DevOps processes and infrastructure optimization.

Required Skills and Experience

• 1–2 years of hands-on experience in software development.

• Proficiency in Python and NodeJS.

• Advanced expertise in Golang, Kafka, Docker, Linux, and Postgres.

• Intermediate knowledge of MySQL and Redis.

• Familiarity with AI-LLM technologies and willingness to grow in this area.

• Experience in DevOps tools and practices is a plus.

• Strong problem-solving skills and attention to detail.

• Ability to work collaboratively in a fast-paced environment.

Bachelor's or Master’s degree in Computer Science, Engineering, or a related field.

Job Summary: We are looking for a skilled SQL Developer to join our team. The ideal candidate will have a strong understanding of database management systems, experience in writing complex SQL queries, and a solid understanding of data structures and algorithms. The SQL Developer will be responsible for designing, developing, and maintaining SQL databases, ensuring their performance, availability, and security.

Key Responsibilities:

• Design, develop, and optimize SQL databases, tables, views, stored procedures, and triggers.
• Develop efficient and complex SQL queries for data extraction, transformation, and loading (ETL).
• Create and maintain database schema designs, data models, and ER diagrams.
• Analyze and optimize complex SQL queries for better performance.
• Implement indexing strategies, query optimization techniques, and other performance tuning practices.
• Ensure data integrity and security by designing and implementing database constraints, data validation rules, and security policies.
• Work with software developers, data analysts, and system administrators to integrate SQL databases with other applications and systems.
• Collaborate with business stakeholders to understand data requirements and provide solutions.
• Document database designs, stored procedures, and other database-related activities.
• Maintain accurate records of database changes, optimizations, and configurations.

Eligibility Criteria:

• Bachelor’s degree in Computer Science, Information Technology, or a related field.
• 3 to 5 years of experience as an SQL Developer or in a similar role.
• Proven experience in database design, development, and management.
• Experience with SQL Server, MySQL, PostgreSQL, or other relational database management systems.
• Proficiency in writing complex SQL queries, stored procedures, functions, and triggers.
• Strong understanding of indexing, query optimization, and performance tuning.
• Familiarity with database security best practices.
• Strong analytical and problem-solving skills.
• Excellent communication and collaboration abilities.
• Attention to detail and commitment to quality.
• Ability to work independently and in a team environment.
• Experience with cloud-based databases (e.g., AWS RDS, Azure SQL Database).
• Experience with NoSQL databases.

What We Offer:

·        Competitive salary and performance based incentives.

·        Comprehensive benefits package, including health

·        Opportunities for professional growth and career advancement.

·        A collaborative and innovative work environment.

Job Title: Senior Ruby on Rails Developer

Location: Remote (Mumbai Preferred)

Company: OpiGo

About Us:

OpiGo is an early-stage wealth tech start-up that’s changing the way people invest in the stock market. Our platform empowers users to make informed investment decisions through a cutting-edge gamified community.

Job Description:

As the Senior Ruby on Rails Developer at OpiGo, you will play a crucial role in architecting, developing, and maintaining our robust and scalable investing platform. You will work closely with the product team and other stakeholders to drive innovation and deliver exceptional user experiences.

Requirements:

- 5+ years of Ruby on Rails development experience.

- Strong understanding of Ruby programming language and its scope.

- Experience in building complex and scalable web applications.

- Familiarity with front-end technologies: React Native, JavaScript, HTML5, CSS3.

- Proficient in version control systems (e.g., Git, SVN).

- Expertise in relational databases (MySQL, PostgreSQL, etc.).

- Hands-on experience with Sidekiq, Redis, and background job processing systems.

- Ability to implement real-time features using WebSockets and Action Cable.

- Experience in monitoring and performance tuning with tools like New Relic.

- Knowledge of payment gateway integration and secure transaction processing.

- Experience deploying applications on cloud platforms like AWS or Google Cloud.

- Excellent interpersonal, communication, and teamwork skills.

- Understanding of Agile development methodologies and software development practices.

Preferred Qualifications:

1. Experience in the fintech industry or working on financial applications.

2. Knowledge of frontend technologies such as React Native, JavaScript, HTML5, and CSS3.

3. Experience with DevOps practices and CI/CD pipelines.

4. Familiarity with Docker and container orchestration platforms like Kubernetes.

5. Contributions to open-source projects or active participation in the developer community.

Join us in our mission to revolutionize the investing landscape and empower individuals to achieve financial success. If you are passionate about technology, innovation, and making a positive impact, we want to hear from you!

How to Apply:

If you're excited to take on this pivotal role and shape the future of OpiGo, please fill up the form: https://forms.gle/5euWxq1hBfQTDadD6

As an SSE, you will play a crucial role in designing, developing, and maintaining our backend systems

that power our platform. The ideal candidate will have a solid background in Python Django and a

strong understanding of databases, caching, and distributed systems.

● Design, develop, and maintain robust, scalable, and high-performance backend systems using

Python Django.

● Collaborate with cross-functional teams to understand business requirements and translate

them into technical solutions.

● Optimize application performance and scalability by implementing caching strategies, load

balancing, and distributed computing techniques.

● Ensure data integrity and security by implementing best practices for data storage, retrieval,

and access control.

● Develop and maintain integrations with external APIs and services to support seamless

interactions with third-party systems.

● Identify and address performance bottlenecks and other system issues to improve overall

system efficiency.

● Write clean, maintainable, and testable code following industry-standard coding practices.

● Conduct code reviews and provide constructive feedback to peers to ensure code quality and

adherence to best practices.

● Mentor junior team members and assist in their professional growth.

• Expert in Python, with knowledge of Python web framework Django
• Familiarity with some ORM (Object Relational Mapper) libraries
• Able to integrate multiple data sources and databases into one system
• Basic understanding of front-end technologies, such as JavaScript, HTML5 and CSS3
• Familiarity with event-driven programming in Python
• Strong experience on Linux
• Solid database skills in a relational database (i. e. PostgresSQL)
• Able to create database schemas that represent and support business processes
• Strong unit test and debugging skills
• Proficient understanding of code versioning tools (git)
• Experience on RESTful APIs
• Experience deploying on AWS is desirable
• Experience on Automation Builds using Jenkins and other popular frameworks
• Strong analytical and problem-solving skills paired with the ability to develop creative and efficient solutions
• Excellent interpersonal, leadership, influence and communication skills
• Experience in designing scalable micro-services is desirable

 2+ years of .NET Development experience

- Exceptional skills Experience with .NET,  technologies (WPF, Web Forms, .NET Core). Also skilled in MS SQL and PostgreSQL, Bootstrap and DevOps.

- Experience with DevExpress, Elasticsearch.Net, VS Studio is preferred SolarSearch

- Great business process understanding and written and verbal communication skills

- GitHub and Git experience.

Responsibilities:-

• Produce clean, efficient code based on specifications
• Integrate software components and third-party programs
• Verify and deploy programs and systems
• Troubleshoot, debug and upgrade existing software
• Gather and evaluate user feedback
• Recommend and execute improvements
• Ensure highest standard of performance, quality, and responsiveness of the applications.

Requirements:-

• Overall 3-7 years of software engineering experience working with web applications and backend systems.
• At least 2 years of experience in production environment working with Ruby on Rails along with common libraries such as RSpec, Sidekiq, Redis.
• Strong understanding of concepts like MVC, ORM, and RESTful
• Strong understanding of Object Oriented Programming fundamentals.
• Strong understanding of server-side templating languages like SLIM and CSS pre-processors like SASS.
• Basic understanding of front-end technologies such as JavaScript, HTML5, and CSS3.
• Strong experience working with Linux like Operating Systems and shell environments like Bash, ZSH.
• Strong knowledge of integrating multiple databases into one system.
• Basic understanding of systems architecture and fundamental design principles behind a scalable web application.
• Ability to understand business requirements, derive database schemas and translate them into technical specifications and code.
• Strong hands on experience of Relation Databases like PostgreSQL, MySQL with ability of benchmarking and performance optimisation.
• Strong knowledge of any NoSQL database like MongoDB.
• Strong experience practicing TDD and writing test cases to achieve highest code coverage.
• Experience working with search engines like Elasticsearch, Solr is a plus.
• Experience integrating third party software and payment gateways is a plus.
• Experience deploying applications to cloud and setting up CI/CD is a plus.
• Experience building container images using tools like Docker is a plus.
• Experience with any popular JavaScript frameworks like React JS, Angular JS is a plus.
• Ability to learn new languages and technologies.