
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

4+ years development experience on Python engineering with Fast API.
Good hands-on experience on Docker.
Experience on REST API, Flask API, Fast API is must
Experience on Writing on effective and scalable code. •
Experience on Unit Testing using PyTest or equivalent framework
Experience on Multi threading & Authentication/authorization techniques.
Experience on Cloud (AWS) services.
Experience on PostgreSQL. •
We are seeking a skilled and motivated Software Engineer with over 3 years of experience in designing and developing web-based applications using Node.js.
Key Responsibilities
- Design, develop, and maintain web-based applications using Node.js.
- Build scalable, high-performance RESTful APIs using Express.js or Restify frameworks.
- Develop and maintain robust SQL database systems, leveraging Sequelize ORM.
- Ensure responsiveness of applications across various devices and platforms.
- Collaborate with cross-functional teams during the product development lifecycle, including prototyping, hardening, and testing phases.
- Work with real-time communication technologies and ensure seamless integration.
- Learn and adapt to alternative technologies as needed to meet project requirements.
Required Skills & Experience
- 3+ years of experience in web application development using Node.js.
- Proficiency with frameworks such as Express.js or Restify.
- Strong expertise in SQL databases and experience with Sequelize ORM.
- In-depth understanding of JavaScript, browser technologies, and real-time communication.
- Hands-on experience in developing responsive web applications.
- Experience with React Native (a plus).
- Proficiency in Java.
- Familiarity with product development lifecycle, including prototyping, testing, and deployment.
Additional Skills & Experience
- Experience with NoSQL databases such as MongoDB or Cassandra.
- Knowledge of internationalization (i18n) and latest UI/UX design trends.
- Familiarity with JavaScript libraries/frameworks like ReactJS or VueJS.
- Experience integrating payment gateways for various countries.
- Strong communication skills and ability to facilitate group discussions effectively.
- Eagerness to contribute to product functionality and user experience designs.
Education Requirements
- Bachelor's or Master's degree in Computer Science or a related field.
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.
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.
As an engineer, you will help with the implementation, and launch of many key product features. You will get an opportunity to work on a wide range of technologies (including Spring, AWS Elastic Search, Lambda, ECS, Redis, Spark, Kafka etc.) and apply new technologies for solving problems. You will have an influence on defining product features, drive operational excellence, and spearhead the best practices that enable a quality product. You will get to work with skilled and motivated engineers who are already contributing to building high-scale and high-available systems.
If you are looking for an opportunity to work on leading technologies and would like to build product technology that can cater millions of customers inclined towards providing them the best experience, and relish large ownership and diverse technologies, join our team today!
What You'll Do:
- Creating detailed design, working on development and performing code reviews.
- Implementing validation and support activities in line with architecture requirements
- Help the team translate the business requirements into R&D tasks and manage the roadmap of the R&D tasks.
- Designing, building, and implementation of the product; participating in requirements elicitation, validation of architecture, creation and review of high and low level design, assigning and reviewing tasks for product implementation.
- Work closely with product managers, UX designers and end users and integrating software components into a fully functional system
- Ownership of product/feature end-to-end for all phases from the development to the production.
- Ensuring the developed features are scalable and highly available with no quality concerns.
- Work closely with senior engineers for refining the and implementation.
- Management and execution against project plans and delivery commitments.
- Assist directly and indirectly in the continual hiring and development of technical talent.
- Create and execute appropriate quality plans, project plans, test strategies and processes for development activities in concert with business and project management efforts.
The ideal candidate is a passionate engineer about delivering experiences that delight customers and creating solutions that are robust. He/she should be able to commit and own the deliveries end-to-end.
What You'll Need:
- A Bachelor's degree in Computer Science or related technical discipline.
- 2-3+ years of Software Development experience with proficiency in Java or equivalent object-oriented languages, coupled with design and SOA
- Fluency with Java, and Spring is good.
- Experience in JEE applications and frameworks like struts, spring, mybatis, maven, gradle
- Strong knowledge of Data Structures, Algorithms and CS fundamentals.
- Experience in at least one shell scripting language, SQL, SQL Server, PostgreSQL and data modeling skills
- Excellent analytical and reasoning skills
- Ability to learn new domains and deliver output
- Hands on Experience with the core AWS services
- Experience working with CI/CD tools (Jenkins, Spinnaker, Nexus, GitLab, TeamCity, GoCD, etc.)
- Expertise in at least one of the following:
- Kafka, ZeroMQ, AWS SNS/SQS, or equivalent streaming technology
- Distributed cache/in memory data grids like Redis, Hazelcast, Ignite, or Memcached
- Distributed column store databases like Snowflake, Cassandra, or HBase
- Spark, Flink, Beam, or equivalent streaming data processing frameworks
- Proficient with writing and reviewing Python and other object-oriented language(s) are a plus
- Experience building automations and CICD pipelines (integration, testing, deployment)
- Experience with Kubernetes would be a plus.
- Good understanding of working with distributed teams using Agile: Scrum, Kanban
- Strong interpersonal skills as well as excellent written and verbal communication skills
• Attention to detail and quality, and the ability to work well in and across teams


- 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


*Performs analysis of functional and business requirements
*Applies in-depth or broad technical knowledge to maintain data engineering functions performs solution design.
*Applies the company, open source, and 3rd party technologies to highly complex infrastructure and software solutions.
*Introduce new product features and enhance the platform
*Ability to translate business reporting requirements into a production report.
- Design, develop and manage data on various open-source SQL databases
- End-to-end performance tuning of Oracle, MariaDB, MySQL, PostgreSQL, and Aurora against very large data sets
- Database cluster connectivity and security
- Conduct database training
- Software installation and configuration
- Database patching and upgrading
- Using monitoring and management tools
- Troubleshoot various issues with other dba’s/developers
- Point of Contact for Vendor escalation
- Point of Contact for professional service to Customers
- Cross-platform migration from Oracle to MySQL/MariaDB/PostgreSQL/Aurora
- Support the creation, maintenance, and implementation of procedures regarding how problems are identified, received, documented, distributed, and corrected
- Ensures project documentation is complete, current, and stored appropriately
- Manages day-to-day project and scope changes
- Communicate and coordinate database changes, backups, and downtime to users
- Identifies potential security issues and recommend strategies to ensure database security
- Research and evaluate new technologies
- Proactively monitor systems for optimum performance and capacity constraints
- Establish standards and best practices for SQL
- Interact with and coach developers in SQL scripting
- Perform database backup and recovery
- Provides 24x7 support for enterprise database systems
- Must provide mentoring and training to other staff members
- Write procedural documentation including requirements for databases
- Develop and coordinate knowledge transfer
- Establishes enterprise-wide uniform infrastructure, including supporting defined departmental content processes and creating guidelines for content deployment
- Interacts with business units to gather, define, and organize the delivery of business solutions Data
- Modeling, design & implementation based on established standards
- Automate manual tasks
- Candidate with a college degree and relevant work experience
- 7+ years of hands-on DBA experience with Oracle, MySQL, MariaDB, and PostgreSQL and supporting tools
- Strong experience with Linux is required, including command-line editors, scripting (shell, Python, Perl, etc.)
- Experience in database performance tuning and strong SQL tuning skills
- Experience in database and cross-platform upgrades required Experience in all aspects of the software development lifecycle including requirements gathering, design, coding, testing and production support
- Must be familiar with RDBMS concepts, practices, and procedures
- Must have knowledge of network connectivity
- Extensive experience with Export/Import, Backup and Recovery
- Extensive experience with Database Replication Master/Slave, Master/Master (BDR)
- Extensive experience with MySQL (MariaDB, Percona) Galera cluster
- Experience with MaxScale
- Proficient in SQL Language
- Knowledge of ServiceNow, or similar Ticket Management Software
- Knowledge of SAN infrastructure including HP and NetApp
- Ability to work on projects at a time
- Knowledge of middle-tier application servers
- Strong troubleshooting and problem resolution skills
- Good knowledge of Data Modeling
- Knowledge of XML and JDBC
- Experience of NoSQL databases (Cassandra, Oracle NoSQL, MongoDB) is a plus
- Certifications on MySQL, PostgreSQL, and Aurora


We’re looking for a Ruby on Rails Software Engineer/Shopify App Developer who has experience working with the Shopify platform and is able to work on a Shopify app.
Your Daily Challenges
When we welcome you aboard we’ll introduce you to your Team, which consists of a front-end developer, a Shopify App Marketer who grew 2 apps to million dollar annual revenue, and a product manager.
These are the people you’ll work closely with on Product development day-to-day. Once you get settled in and learn more about the team, your day to day activities will look something like this:
- Own the end-to-end development cycle for the Shopify app you’ll be working on.
- Coordinate with fellow developers to get things done on time.
- Implement high quality code in an agile, test driven development environment
- Review exception reports to identify and fix bugs
- Development of new apps and features
- Maintenance of existing features
- Collaboration with cross-functional teams
- Contributions of ideas to improve the product
Your Experience
- 3-5 years of experience with Ruby on Rails
- Experience with Shopify app development
- Familiar with Sidekiq, PostgreSQL
- Good understanding of HTML and CSS (positioning and styling)
- Excellent communication skills
- Takes pride in writing clean, organized, efficient code
- An eye for detail
- Experience with vanilla JavaScript and React a plus
- Experience working in an entrepreneurial/startup environment
Your Compensation
- The compensation range for this role is INR 14-18 LPA (~25K USD) + up to 5% equity.
- The compensation varies with experience and qualifications.
- This is a full-time remote/work from home position.
Thanks for the time you took to read about this opportunity.



