
Create and maintain database tables, views, indexes, and triggers.
Implement and maintain database code in the form of stored procedures, scripts, queries, views, triggers, etc.
Develop and maintain high-quality stored procedures.
Write low cost, high-quality database queries and code while maintaining data quality, privacy, and security
Profile databases, measure database performance and troubleshoot complex database issues, and IO bottlenecks.
Optimize database queries and ensure table locking/deadlocks happen in production.
Optimize large, complicated SQL statements & Stored Procedures.
Cost optimization of Amazon instances using databases.
Knowledge of database design principles, query optimization, index management, integrity checks, statistics and isolation levels
Knowledge of message queuing, indexing, and high-performance data concept
Knowledge of JSON and PostgreSQL support for JSON.
Good Grasp of ETL concepts
Work with front-end developers to define simple yet powerful APIs
Work with DBAs to ensure the efficiency of database code, integrity of data structures and quality of data content.
Coordinate with product managers and leadership teams to build effective database objects
Excellent verbal and written communication skills
Good attitude towards work and flexibility
Ability and willingness to handle multiple tasks in a fast-paced environment
Ability to evaluate alternative solutions and/or workarounds

About Validus Techfin Solutions
About
Connect with the team
Similar jobs
Designation – Nodejs Developer
Experience – Min 3+ Yrs
Location: Ahmedabad ( WFO)
We are seeking a highly skilled Senior Node.js Developer with expertise in SQL and MongoDB to join our dynamic team.
As a key member of our development team, you will be responsible for managing the interchange of data between the server and users, as well as developing server-side logic. Your primary focus will be on the development of all server-side logic, ensuring high performance and responsiveness to requests from the front-end. Additionally, your experience with both SQL and NoSQL databases will be crucial in defining and maintaining our data storage solutions.
Responsibilities:
Develop and maintain server-side applications using Node.js.
Design and implement RESTful APIs for seamless integration with front-end applications.
Collaborate with front-end developers to integrate user-facing elements with server-side logic.
Optimize applications for maximum speed and scalability.
Implement security and data protection measures.
Design and maintain database schemas for both SQL (e.g., MySQL, PostgreSQL) and NoSQL (e.g., MongoDB) databases.
Manage and mentor junior developers, providing technical guidance and support.
Stay updated with emerging technologies and industry best practices.
Requirements:
Bachelor’s degree in Computer Science, Engineering, or a related field, or equivalent work experience.
Minimum 4 years of experience in Node.js development.
Proficiency in JavaScript/TypeScript and frameworks such as Express.js.
Strong understanding of asynchronous programming and event-driven architecture.
Experience with SQL databases (e.g., MySQL, PostgreSQL) and proficiency in writing complex SQL queries.
Experience with NoSQL databases (e.g., MongoDB) and familiarity with their query languages.
Familiarity with ORM libraries (e.g., Sequelize, Mongoose) for database interaction.
Knowledge of version control systems (e.g., Git).
Understanding of CI/CD pipelines and deployment processes.
Excellent communication and teamwork skills.
Ability to lead and mentor a team of developers.
Job Summary
We are looking for a skilled Python Developer with 3 years of experience to join our
team in Bangalore. The ideal candidate should have strong expertise in Python,
Django, and PostgreSQL, along with a good understanding of backend development.
Knowledge of Java will be an added advantage.
Key Responsibilities
Develop, test, and maintain scalable backend applications using Python and
Django
Design and manage databases using PostgreSQL
Write clean, efficient, and reusable code
Collaborate with cross-functional teams to define, design, and ship new
features
Debug and resolve technical issues and optimize application performance
Participate in code reviews and ensure best coding practices
Required Skills
Strong experience in Python
Hands-on experience with Django framework
Good knowledge of PostgreSQL database
Understanding of REST APIs and web services
Familiarity with version control systems (e.g., Git)
Good to Have
Basic knowledge of Java
Experience with cloud platforms or deployment processes
Understanding of front-end technologies is a plus
Qualifications
Bachelor’s degree in Computer Science, Engineering, or related field
Additional Requirements
Immediate joiners or candidates with short notice period preferred
Strong problem-solving and analytical skills
Good communication and teamwork abilities
Position: Database Administrator (PostgreSQL)
Location: Raipur
Experience: 7 to 9 years
Salary: 15-18 LPA
Qualification: BE / B.Tech / MCA
Job Profile
· Expertise in PostgreSQL database installation, configuration, and administration.
· Experience with database security, backup, recovery, and high availability.
· Strong SQL development, query optimization, and performance-tuning skills.
· Solid understanding of logical and physical database design and data modeling.
· Ability to perform impact analysis and handle database migrations.
· Providing SQL expertise, proposing design recommendations and optimization.
· Knowledge of system administration and network administration concepts.
· Experience in enforcing database and coding standards.
· Ability to generate reports and statistics using database queries.
· Excellent problem-solving, communication, and documentation skills.
Candidate Profile
· Candidate should have very good technical skill in PostgreSQL Database Administration
· Candidate should be able to work in team & manage team members, if required
· Communication skill should be excellent
· Candidate should be smart & personality should be very good
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
- Deliver features in an end-to-end manner: technical design, development, testing, deployment, and maintenance.
- Provide technical leadership and own specific areas of the platform.
- Work closely with Product Managers to translate product requirements to engineering specifications.
- Lead code review efforts and quality efforts in your area of ownership.
- Participate in product discussions, taking ownership and initiative.
- Work independently in a fast-paced environment.
- Mentored and guide junior engineers.
Must Haves:
- Minimum 2 years of working experience in Ruby on Rails/ Python/ Node.JS.
- Strong problem-solving skills, data structures, and algorithms.
- Excellent experience on databases like MySQL, PostgreSQL, etc.
- Familiarity with tools for code reviews, version control (GIT).
- A knack for writing clean, readable Ruby/ Python/Node.JS code.
- Experience in application server hosting and monitoring.
- Understanding of fundamental design principles behind a scalable application.
Nice to Have:
- Hands-on with search platforms (Solr, Elasticsearch, etc).
- Prior experience with microservices-based architecture/SOA/distributed systems.
- Able to implement automated testing platforms and unit tests.
- Experience with common AWS service EC2, RDS, S3, SES, etc.
Key Competencies:
- Building Effective Team
- Solving Problems Creatively
- Learning Agility
- Drive For Result
Company Description
BlueOptima’s vision is to become the global reference for the optimisation of the performance of Software Engineers across all industries. We provide industry-leading objective metrics in software development. We enable large organisations to deliver better software, faster and at lower cost, with technology that pushes the limits of what has been done before.
We are a global company which has consistently doubled in headcount and revenue YoY, with no external investment. We currently are located in 4 countries: London (our HQ), Mexico, India and the US. A total number of 180+ employees (and increasing every day) from 22 different nationalities and with over 25 languages spoken.
We promote an open minded environment and encourage our employees to create their own success story in this high performance environment.
Job Description
Location: Bangalore/Gurgoan, India
Department: Engineering
Job summary:
We are seeking a Senior Software Engineer, with experience in developing scalable application components, which are remotely deployed and are used to extract and push large volumes of data in a data warehouse solution, to join our growing company and be a part of our success story.
We are looking for an individual with great attention to detail, who is genuine, confident, committed and not only passionate about technology, but is keen to own the solution end to end, and most importantly excited to work in a fun and friendly start-up environment.
The ideal candidate will be passionate about technology and getting things to work while at the same time being able to mentor (and lead) other engineers by way of example to achieve excellence in their work.
Your team: You will be working with a diverse team with members located around our different offices, with whom you will be working hand-to-hand. This team is currently based in Gurgaon and we are now looking forward to growing it in Bangalore and mid next year to Mexico with the plan of building two teams in India (Gurgaon and Bangalore) and one in Mexico (Guadalajara).
We are looking for skilled and talented engineers to join our Data Analysis and Processing (DAP) team and directly contribute to development of application components built by the team.
The DAP team works on a business critical component which is responsible for collecting required source code interaction and static metrics data from client location, and processing the large volumes of data end to end. Remote deployment and the uptime requirements only makes this component one of the most complex standalone java applications.
As a Senior Software Engineer in the DAP team, you will be directly contributing to development of the Integrator and Central Server components using Spring Boot, Hibernate and Core Java. And while contributing directly to the development of the software components, you are also expected to lead and mentor a team of next generation platform engineers.
Responsibilities and tasks:
- Analyse, Design, Develop, implement, test and maintain application software components
- Analyse client requirements and convert them into technical specs.
- Own development of features and improvement
- Identify and resolve performance bottlenecks
- Identity and resolve architectural inefficiencies in design, and create a roadmap to resolving them
- Lead and mentor a team of junior developers
- Interact with internal client facing team and provide technical support to them
- Engage with clients to provide support on your component as and when required
Qualifications
What You Need to Succeed at BlueOptima:
- Minimum Bachelor's degree in Computer Science or equivalent
- Minimum 5+ years experience with Java and J2EE/Java EE
- Minimum 2+ years experience with developing standalone Java applications
- Strong understanding of relational database, partitioning and indexing techniques, SQL
- Demonstrable experience in optimising application performance at database or any other layer
- Experience in creating high and low level design based on existing application architecture and documenting such design
- Strong understanding of Java concurrency, concurrency patterns, experience building thread-safe code
- Ability to work autonomously with minimum supervision
- Strong problem solving and analytical skills, and having a can-do attitude
- Familiarity with Agile methodologies like SCRUM, Sprints, etc and leading a Scrum a small Scrum team
- Commitment to accomplishing the task at hand and identify the fastest and most reliable way to solve a problem
- Familiarity with Linux shell and related command line tools
- Strong grasp of Unit & Integration testing
Good to have:
- A team manager, in terms of handling people and delivery which is not a must in case of technical geeks
- Making sure that the sprints and tasks are completed on time with no spill-overs and sticking to the deadline
- Preferred experience on Spring boot,, Docker, Kubernetes
- Some exposure in Linux
Additional Information
Why join our team?
Culture and Growth:
- Global team with a creative, innovative and welcoming mindset.
- Rapid career growth and opportunity to be an outstanding and visible contributor to the company's success
- Freedom to create your own success story in a high performance environment
- Training programs and Personal Development Plans for each employee
Benefits:
- Competitive Salary
- Flexible Work from Home policy - 2 days home p/w
- Free drinks and snacks in the office
- International travel opportunities
- Global annual meet up (most recent meetups have been held in Cancun and India)
- High quality equipment (Ergonomic chairs and 32’ screens)
Must haves
- At least 3 years of professional programming experience in Ruby on Rails.
- Solid fundamentals with software development, systems, troubleshooting, and teamwork
- Strong testing habits, passionate towards unit testing and TDD.
- Good understanding of RDBMS like MySQL, PostgreSQL
- Strong knowledge of git
- Good understanding of data structures
- Strong analytical and problem-solving skills
Good to have
- Experience with Javascript








