
Postgress developer cum database architect
5-7 years experience
Knowledge and experience, specifically PostGre
- SQL
- Query Optimization / Optimization strategies (in PostGre)
- AWS - RDS Relational Databse Service
- Optional: AWS – RDS API / PostGre API

Similar jobs
Job Title : Senior Software Engineer
Location : Gurugram (Full-time)
Job Description :
- We are looking for a skilled and experienced Java Engineer to join our dynamic team.
- The ideal candidate will have 4 to 10 Years of hands-on experience in software development, with a proven experience as Java Developer with a strong focus on Spring and Spring Boot, Relational Databases and AWS technologies.
- Strong understanding of monolithic & microservices architecture. You will play a crucial role in designing, developing, and maintaining our applications.
- Ensuring their performance, quality and responsiveness.
Key Responsibilities :
● Design, develop, and maintain scalable applications using Java, Spring and Spring Boot.
● Develop and manage relational databases. Should be able to write complex SQL queries.
● Ensure the best possible performance, quality, and responsiveness of the applications.
● Have strong debugging skills to identify bottlenecks and bugs, and devise solutions to mitigate and address these issues.
● Deploy, manage, and scale applications on AWS.
● Conduct code reviews and integration testing to ensure software quality and reliability.
● Collaborate with front-end developers to integrate user-facing elements with server-side logic.
● Collaborate with cross-functional teams to define, design, and ship new features.
● Stay updated with emerging technologies and industry trends.
Qualifications :
● Bachelor’s degree in Computer Science, Information Technology, or a related field.
● 4 to 10 Years of experience in software development.
● Proficient in Java 8+, Spring and Spring Boot.
● Experience with PostgreSQL, MySQL or other relational databases.
● Experience with microservices architecture.
● Understanding of Rest API design and development.
● Hands on experience with Unit Testing frameworks such as Junit, Mockito.
● Experience with version control systems such as Git.
● Solid understanding of object-oriented programming.
● Strong problem-solving skills and attention to detail.
● Excellent communication and teamwork skills.
Preferred Qualifications :
● Strong knowledge of AWS services and best practices.
● Knowledge of containerization technologies like Docker and Kubernetes.
● Familiarity with CI/CD pipelines and DevOps practices.


About Company:
Our client is in the business of delivering cutting-edge software solutions, hardware systems, and IT services. It lends the right technological edge to governments and businesses. This enables them to achieve their organizational objectives efficiently and effectively to scale their businesses to newer heights.
Minimum Requirements/Qualifications:
(i) Minimum education qualification of MCA/ MSc (Computer Science)/BE/BTech (computers/ IT).
(ii) Must have at least 2.5 to 5 years of experience in application development, deployment, and testing. He/ She must possess a valid MySQL Developer or Java Developer certification, which is obtained at least six (06) months prior to the date of award of the contract to the firm.
(iii) Knowledge of Software Management Life Cycle and Software Testing viz unit testing, system testing & Integration Testing, etc.
(iv) Knowledge & hands-on experience of PHP & My SQL is a must. Additional knowledge of Post GreSQL, Typescript & Lit element, Java with Hibernate and Springs, SQL Server, Apache Tom Cat Server & relevant open-source technologies is required.
(v) Individuals must have hands-on experience in server operating systems viz Windows Server OS and RHEL. Knowledge of security concepts of web applications & Networking for undertaking necessary troubleshooting wrt applications accessibility.
(vi) Knowledge of Mobile Application Development
Key Responsibility Areas:
- Creation of new Course No, Term, and Term type at the beginning of each term. All associated Database tables and software procedures and functions are updated and recompiled.
- Management of Data Entry and Information access right to various users.
- AMC includes bug fixing, updating of application for any small policy changes.
- Regular Patch/update installation and coordinating with MIS team for identification and resolution of issues wrt application functioning and deployment
- Implementation of Cyber security policies and hardening of application
- Development of New functionalities in the application
- Regular Testing of running application functionalities and undertaking unit and integration testing of newly developed components.
- Support for making changes in the NDA internet web portal.
- AMC includes backing up of software, and database and storing it in other locations every week
- Online Multimedia Management System
- Software Wise Charter of Duties
- Cadet Suggestion/ Complaint Management System

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



- Previous working experience as a MySQL Developer for at least 3 years
- Identify opportunities for improved performance in SQL operations and implementations
- Oversee the operations of the production and staging environments databases
- Give design recommendations for database functions that meet business operating standards while improving the efficiency of business processes
- Train and mentor junior personnel on best practices
Candidate Profile:
- Bachelor’s/Master’s degree in Engineering, Computer Science
- At least 5+ years of relevant experience as a database programmer
- Excellent MySQL/PostgreSQL/MS-SQL development skills
- Experience in writing stored views, procedures, triggers etc.
- Excellent knowledge in RDBMS (important features)
- Strong problem-solving skills, technical troubleshooting, and diagnosing
- Solid knowledge of RDBMS and NoSQL technologies
- Experience in developing back-ends for enterprise systems
- Knowledge of debugging, performance and optimization techniques
- Experience in RDBMS technologies like MySQL, PostgreSQL etc.
- Experience in No SQL technologies like MongoDB, Cassandra etc.
- Knowledge of Caching DB like Redis, Memcached etc.
- Knowledge of Search DB like Solr, Elasticsearch etc.
- Demonstrated ability to deliver in a fast-paced environment.


- Python knowledge: object-oriented programming: inheritance, abstract classes, dataclass, dependency injection, design patterns: comand-query, repository, adapter, hexagonal architecture, swagger/Open API, flask, connexion
- Experience on AWS services: lambda, ecs, sqs, s3, dynamodb, auroradb
- Experience with following libraries boto3, behave, pytest, moto, localstack, docker
- Basic knowledge about terraform, gitlab ci
- Experience with SQL DB
• Hands on RDBMS experience with Oracle/ PostgreSQL/ MySQL/SQL
Server including transaction management, SQL programming, data
modelling, etc.
• Must have proven track record of logical data modeling and physical
data modeling
• Experienced in using ORM frameworks like Hibernate, etc.
• Basic understanding of NoSQL systems like Redis (Key-Value store),
MongoDB (Document store), Elasticsearch (Search / Document store)
• Design, Development & Deployment of Microservices using Spring
Boot or any other framework.
• Understanding of building EDA-based (Event Driven Architecture)
systems.
• Basic understanding of any public cloud (AWS, Azure, GCP)
• Ability to design & architect a system that exhibits basic
characteristics like modularity, configurability / extensibility, scalability
& availability.
• Maven / Gradle
• Experience in using & configuring Jenkins.
• Experience in using & configuring SonarQube.
Essential Requirements
• Hands-on with Java Platform (1.5 & above) having proficiency in OOPs
concepts, Collections,
• Generics, Streams, Multi-threading (Executor Framework), Functional
Programming.
• Design & Development of REST Web Services (Spring MVC / REST /
Jersey / Apache CXF, etc.)
• Hands-on experience using Spring framework (4.x & above)
• Core / Beans
• MVC / REST
• Security
• Spring Data / JPA
• Spring Test / JUnit
• JMS
standing of Java and the different frameworks like Spring, etc., and have experience working on Cloud and Containers.
The Developer will perform duties and tasks to support a complete life cycle management (example: Analysis, Technical
Requirements, Design, Coding, Testing and implementation of Systems, etc.).
The Developer will work closely with the Product and Technical teams across different regions primarily Europe and will
be part of an Agile Team. The role includes research and Continuous Development of new Products based on new Tech-
nologies. This position collaborates with the operations team routinely and henceforth excellent English communication
skills (bothwritten and verbal) are essential.
A clean coder who will always leave the code in better shape than they found it.
A curious person who never stops learning and loves to try new things, even when theydon’t succeed on the
first try
A team-oriented developer with the motivation to bring out the best in others
A person who shares our appreciation for transparency and is willing to share theirexperience and knowledge
for the benefit of the team
Someone who is willing to take a stand for something they believe in.
Somebody that takes pride in their work and knows that development is a craftsmanship
Duties & Responsibilities
Conducts systems and requirements analysis, creates and contributes to task lists, cost and time analysis
Performs assigned functions and tasks to meet project plan and quality review requirements.
Raises issues as appropriate to support effective resolutions.
Analyzes specifications and user requirements to perform assigned applications development work.
Assists with system and componentdesigns to meet requirements.
Participates and documents design and code reviews to improve quality.
Analyzes, designs, codes, tests, and documents to develop application software.
Develops unit tests and unit test plans to deliver quality code.
Performs applications maintenance and support functions to support problem resolution.
Qualifications:
• Bachelor’s degree in Computer Science or IT related field
• 4-7 years of experience working across different product domains in a product development/engineering role
• Good communication skills necessary to manage business requests and work with different teams across differ-
ent geographies and time-zones; experience working with remote and distributed teams will be an added ad-
vantage
• Hands-on working knowledge and experience is requiredin:
a. Java (Spring, Spring Boot, etc.)
b. Experience working in GCP or AWS or Azure
c. Experience working in Containers & Unix Platforms
d. Relational Databases (PostgreSQL, MySQL, SQL, etc.)
e. Messaging (RabbitMQ, ActiveMQ, Kafka etc.)
f. Agile Methodologies (Scrum, TDD, BDD, etc.)
g. Understanding of Microservices Architecture, Domain Driver Design, Test Driven Development and
Secure Design patterns and architecture is a must
h. Data Structures and Algorithms using Java or other Programing Languages
i. Strong organizational skills
j. Agile Methodologies (Scrum, TDD, BDD, etc.)
• Experience with several of the following tools/technologies is desirable:
a. GIT (Bit Bucket, Gitlab, etc.), Jira, Gradle, Maven, Jenkins, SharePoint, Eclipse/IntelliJ.
b. Multiple Java technologies around Spring, Spring Bootetc.
c. Design Patterns and implementing the Design Patterns
d. Development of Complex Application and System Architectures
e. NoSQL Databases (Redis, Mongo, etc.)
f. Experience working with CI/CD pipelines with for example GitHub Actions.
• Knowledge of the following technologies is a plus:
a. Other Programming Languages (NodeJS, etc.)
b. Continuous Integration and Continuous Delivery Tools like Jenkins, Git, etc.
c. Application Servers like Tomcat, etc.
d. HTML5, CSS, AJAX, React
e. Full stack development
f. Secure Development based on OWASP standards
Back End Developer
Qualification : Engineering /Master degree in Computer Science/Electronics/Electrical/Information
Technology Experience : 3- 6 years Skill Sets :
-
The server part of client-server programming
-
Strong database schema skills, querying, joins, triggers, stored procedures
-
Programming languages and frameworks: Javascript and NodeJS languages: PHP, Node,
-
Relational databases such as MySql, SQL Server, Postgres, NoSQL database MongoDB
-
REST-compliant APIs
-
Big Data processing
-
Experience in Agile SCRUM method of development
-
Familiar with GIT and Devops tools and technologies
-
Spring Boot, JavaScript, MongoDB, Maria DB, Microservice , Devops, Rest API, Postman, AWS, Nginx, Redis, Docker
Our client was founded in 1999 by Mr. D.N. Prahlad (an early employee of Infosys), to create software products. Headquartered in Bangalore, we also have offices in the USA and France.
What We're Looking For
• An unwavering attention to detail and care towards your work. We double-check PRs they submit for review. Each variable name is thought through in detail; attention is paid to how decisions made today will affect the future.
• An absolute commitment towards doing the best work of your life, while helping others to do the same. We deliver with utmost focus on the job at hand. The team works towards crafting the best products for our users, and customers. Working as a team, we take on problems out of the original scope of their work if this results in a better end product.
• You should be comfortable working in an agile environment. You are also expected to
participate in code reviews—both receiving and offering them as needed. You are needed to communicate flexibly with your team—pitching in on designs, features, and ideas for the product, wherever needed.
What is Needed for the Role
• Strong command of Java & the JVM ecosystem
• Strong command of relational databases such as PostgreSQL, Microsoft SQL Server, Oracle, etc. (both with & without ORMs)
• Strong command of HTTP
• Strong command of HTML, CSS, and JavaScript
• Extensive experience with at least one JVM based web framework (SpringBoot, Micronaut, Play, Dropwizard, etc.)
• Experience with concurrency & parallelism on the JVM
• Experience with Docker, and cloud-native concepts
• Experience with Gradle
• A good grip on Git
What You Will Work On
The specific project you work on is decided based on the list of available projects at the time. While what you work on will change over time, we assure you that you’ll work with people who care deeply about their work and deliver with great attention to detail.
Your Growth
Our growth is driven by ordinary people who have extraordinary dreams and are bold enough to pursue them. Our leadership team, including our Managing Director, is comprised primarily of people who joined us as freshers. Through our process of continuous feedback, and regular 1-1 conversation, we believe in upskilling our team, and enabling each of them to grow along paths they find satisfying.
Your Level of Experience
We do not evaluate people based on the number of years of experience they have.
Instead, we look for skills that have been gained, regardless of how long they’ve, it has taken a person to gain those skills.
However, as a point of reference, historically, we have successfully recruited candidates for this role with 1-5 years of prior experience.
Evaluation Process
The evaluation process starts with a short phone conversation.
After that, the candidate will be required to take both a technical and writing test, which will be shared with them after the phone screen.
This will be followed by 1-3 interviews, over Google Meet. We will require candidates to be alone, in a quiet place (with no background noise). They must also have a fast & reliable internet connection. They will be required to take the call on a laptop with a camera, and have their technical test code ready for perusal. We recommend using Google Chrome to join the call, and strongly urge candidates to use headphones/earphones.
Please note that the evaluation process may take up to 6 hours
Exposure to Angular would be an added advantage
Should be willing to work in challenging environment for a start up company

