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
Similar jobs
Excellent knowledge in Core Java (J2SE) and J2EE technologies.
Hands-on experience with RESTful services, API design are must.
Knowledge of microservices architecture is must.
Knowledge of design patterns is must.
Strong knowledge in Exception handling and logging mechanism is must.
Agile scrum participation experience. Work experience with several agile teams on an application built
with microservices and event-based architectures to be deployed on hybrid (on-prem/cloud)
environments.
Good knowledge of Spring framework (MVC, Cloud, Data and Security. Etc) and ORM framework like
JPA/Hibernate.
Experience in managing the Source Code Base through Version Control tool like SVN, GitHub,
Bitbucket, etc.
Experience in using and configuration of Continuous Integration tools Jenkins, Travis, GitLab, etc.
Experience in design and development of SaaS/PaaS based architecture and tenancy models.
Experience in SaaS/PaaS based application development used by a high volume of
subscribers/customers.
Awareness and understanding of data security and privacy.
Experience in performing Java Code Review using review tools like SonarQube, etc.
Good understanding of end-to-end software development lifecycle. Ability to read and understand
requirements and design documents.
Good Analytical skills and should be self-driven.
Good communication with inter-personal skills.
Open for learning new technologies and domain.
A good team player and ready to take up new challenges. Active communication and coordination with
Clients and Internal stake holder
Requirements: Skills and Qualifications
6-8 years of experience in developing Java/J2EE based Enterprise Web Applications
Languages: Java, J2EE, and Python
Databases: MySQL, Oracle, SQL Server, PostgreSQL, Redshift, MongoDB
DB Script: SQL and PL/SQL
Frameworks: Spring, Spring Boot, Jersey, Hibernate and JPA
OS: Windows, Linux/Unix.
Cloud Services: AWS and Azure
Version Controls/ Devops tools: Git, Bitbucket and Jenkins.
Message brokers: RabbitMQ, and Kafka
Deployment Servers: Tomcat, Docker, and Kubernetes
Build Tools: Gradle/Maven
as Postgres, MySQL or MongoDB. Candidates must have an understanding of Microservices and deploying of applications to cloud infrastructure such as AWS, Azure or GCP using git, Docker and
CI/CD pipelines. Candidates must be open to learning new technologies and must be problem solvers.
The job being offered is with a leading Indian Bank as a Client-side deployment where the candidates would be working directly at the Client’s location, reporting directly to the Client’s team leads. The job entails working on exciting new projects at scale.
Location Delhi NCR
Opening Immediate
Search Context
Over 1.8 billion non-salaried informal sector workers globally, and roughly 700m Indians are
not eligible for pension or other social protection benefits. Without an urgent and effective
response to pension exclusion, they face the grim prospect of extreme poverty for over 20
years once they are too old to work.
pinBox is the only global pensionTech committed exclusively to mass-scale digital micropension inclusion among self-employed women and youth. We deploy our white-labelled,
API-enabled pension administration and delivery platform, our unique deployment model and
a simple and intuitive UI/UX to make access to regulated pension, savings and insurance
products easy and simple for non-salaried informal sector workers. We're working actively
with governments, regulators, multilateral aid agencies and leading financial inclusion
stakeholders in Asia and Africa. The pinBox model is already operating in Rwanda, Kenya
and India. We will expand to Bangladesh, Uganda, Chile, Indonesia and Nigeria by 2023.
Governments and pension regulators use the our pensionTech to jumpstart digital micropension and insurance inclusion among informal sector workers. Pension funds and insurers
use our pensionTech to build a mass market for their products beyond their traditional agentled customer base. Banks, MNOs, cooperatives, MFIs, fintech firms and gig-platforms use
our plug-and-play pensionTech to instantly offer an integrated social protection solution to
their clients, members and employees without any new investments in IT or capacity
enhancement.
We’ve recently completed our first equity fundraise to enhance our engineering, business
and delivery capacity and embark on the next stage of pinBox pensionTech development
and expansion. By 2025, we aim to enable and assist 100 million excluded individuals to
start saving for their old age in a secure, affordable and well-regulated environment.
pinBox is looking for senior software engineers who are deeply passionate about using IT to
solve difficult, real-life problems at scale across multiple countries.
The Senior Software Engineer will be expected to
1. Design, code, test, deploy and maintain applications to satisfy business requirements,
2. Plan and implement technical efforts through all phases of the software development
process,
3. Collaborate cross-functionally to make continuous improvements to the pinBox
pensionTech platform,
4. Help drive engineering plans through a broad approach to engineering quality
(consistent and thoughtful patterns, improved observability, unit and integration testing,
etc.),
5. Adhere to national and global architecture standards, risk management and security
policies,
6. Monitor the performance of applications and work with developers to continuously
improve and optimize performance.
The ideal candidate processes
1. An undergraduate degree in engineering,
2. At least 6 years’ experience as a software engineer or in a similar role,
3. Experience working with distributed version control systems such as Git / Mercurial
4. Frontend: Experience with HTML, CSS, bootstrap, Javascript, Jquery is necessary.
Experience with React / Angular will be an advantage,
5. Backend: Experience with Django/Python, PostgreSQL or any other RDBMS is
mandatory. Experience with Redis will be an advantage,
6. Experience in working with AWS / Azure / Google Cloud,
7. As our applications use a number of third party micro-services, experience with REST
APIs, as also with the Indian digital finance ecosystem (UPI, e-KYC) will be both
necessary and an advantage,
8. Critical thinking and problem-solving skills, and
9. Excellent teamwork and interpersonal skills, a keen eye for detail and the ability to
function effectively and proactively under tight deadlines.
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
As an Associate Software Engineer, you will have the opportunity to collaborate on the creation and maintenance of scalable, high-quality software as we grow. You'll work closely with the CTO and quickly gain skills and responsibilities as the team and the technical requirements grow.
Primary Responsibilities
- Develop RESTful APIs leveraging Django classes, ORM and Postgres Database
- Develop solutions that meet business objectives while leveraging industry best practices
- Write high-quality source code to program complete applications within deadlines
- Troubleshoot and debug applications
Technical Competencies
- Expertise with Python language
- Experience with Django: maintaining APIs
- Familiarity using Git, code repositories, branching and merging strategies
- Ability to break down complex concepts, tasks, or problems into more simple, understandable language and action plans
- Excellent communication skills, and attention to detail
- Good Documentation skills
Perks
- Work from home
- Flexible work schedule
- Flexible standup meetings
Interview Process
- Two technical rounds with Senior Developer and CTO
- Cultural Fit interview with Project Manager
Please do not apply if you don't have professional Django work experience.
Fulfil’s software engineers develop the next-generation technologies that change how millions of customer orders are fulfilled by merchants. Our products need to handle information at massive scale. We're looking for engineers who bring fresh ideas from all areas into our technology.
As a senior software engineer, you will work on our python based ORM and applications that scales to handle millions of transactions every hour. This is mission critical software and your primary focus will be building robust and scalable solutions that are easy to maintain.
In this role, you will be collaborating closely with the rest of the team working on different layers of infrastructure in an international environment. Therefore, a commitment to collaborative problem solving, sophisticated design, and quality product are important.
What You’ll Do:
- Own definition and implementation of API interfaces (REST and GraphQL). We take pride in our 100% open API with over 600 endpoints.
- Implement simple solutions to complex business logic that enables our merchants to manage financials, orders and shipments across millions of transactions.
- Build reusable components and packages for future use.
- Translate specs and user stories into reviewable, test covered patches.
- Peer review code and refactor existing code.
- Integrate with our eCommerce partners (Shopify, BigCommerce, Amazon), shipping partners (UPS, USPS, FedEx, DHL) and EDI.
- Manage Kubernetes and Docker based global deployment of our infrastructure.
Requirements We’re Looking for Someone With:
- Experience working with ORMs like SQLAlchemy or Django (2-3 years)
- Experience with SQL and databases (Postgres preferred)
- Experience in developing large server side applications and microservices
- Ability to create high quality code
- Experience with python testing tools (pytest) and test automation
- Familiarity with code versioning tools like GIT
- Strong sense of ownership and leadership quality
- Experienced in the tools of our web stack- Python, Celery, Postgres, Redis, RabbitMQ
Nice to Haves:
- Prior experience at a growth stage Internet/Software company
- Experience with ReactJS, Google Cloud, Heroku
- Cloud deployment and scaling experience
We're looking for someone to join a team dedicated to building performant APIs and backend services that deal with large volumes of data for the company's flagship, global consumer product. Small, high-impact teams require conscious planning and decision-making when it comes to design, architecture, and product features. So, it's essential that you enjoy working in such an environment.
We're a team that cares about simplicity and being able to build reliable, deterministic systems and platforms. Hence, our choice of tooling is usually battle-tested reliable software with a robust test suite.
How we work
- You won't deal with the hustle culture. We're focused on building well-thought-out, stable and reliable software and we try our best to ensure everyone understands the big picture and the immediate goals.
- We work a solid 6-8 hour days and don't slave away 24/7.
- We're a remote engineering team. This makes effective communication extremely important. Our teams have benefitted greatly from good written communication. This includes everything from the product specification to the API spec. We spend a lot of time writing READMEs. As a result our engineers work with greater clarity and planning.
- We deploy several times a day and rely on a good test suite to ensure we're not making life hard for our colleagues.
- We don't expect anyone to know everything, but we are curious and learn along the way.
- We learn about the fitness space and what it means to really be fit and not just Instagram fit.
The Python Backend Engineer position may be a good fit for you if:
- You have 3 (or more) years of experience building and maintaining cloud applications.
- You have built APIs with Python, Flask, Django or FastAPI before.
- You have experience working with relational databases like PostgresSQL or MySQL and have spent time writing SQL queries for large datasets.
- Experience in writing Unit tests with pytest.
- You have worked with Docker, docker-compose.
- Familiarity with the AWS ECS stack.
We want you to care about
- Good object oriented design
- Performant APIs
- Analysing why queries are slow and how to go about improving them.
- Understanding DNS, Load balancing, Caching and Hashing.
- Customer data and privacy.
Our API Stack services use:
- Python 3.8+, Typescript
- FastAPI, Flask, HapiJs
- PostgresSQL, MySQL
- Redis
- Celery
- Pytest, Jest for unit testing.
- Gitlab CI/CD
- Amazon ECS container services
- 10 + years of experience and expertise in database and systems architecture design, development and implementation;
- Expertise and experience in data structures, indexing, query, and retrieval;
- Excellent data management skills including ensuring data integrity, data access, security and archiving procedures;
- Knowledge of the language technology and video extraction research domains to be able to converse fluently with the research communities to transform research requirements into concrete formalisms.
- Experience in cross platform development for multiple variants of Unix, Linux including 32 and 64 bit
- Experience with NoSQL, SQL databases, statistics and algorithms
- Strong oral and written communication skills
- Design, implement and test novel database architecture designs to accommodate the multimodal data types used in Client managed technology evaluations
- Administer and monitor database and address data security solutions as applicable
- Design and develop efficient techniques for fast, optimized data access and transfer of distributed or networked database systems
- Design, implement and test novel data structures, data search, query and retrieval solutions to enable access to and processing of the multimodal data types used in Client managed technology evaluations
Designation: Database Developer
Job Description
As a Database Developer at our company, you will be responsible for designing, testing, planning, implementing, protecting, operating, managing and maintaining our company's databases.Communication and organization skills are keys for this position,along with a problem-solution attitude. Ultimately, you should be able to ensure our database systems run effectively and securely on a daily basis
Requirement:
-
4 - 8 years of relevant experience in database management in Postgresql and at least 1 year of working experience in an AWS environment.
-
Hands on experience in database development working with PostgreSQL including stored procedures, functions, triggers, and views.
-
Experience working with Windows and Linux systems in a production setting.
-
Working knowledge of handling batch bulk data loads.
-
Proactively adopt new cloud infrastructure and technology.
-
Manage environments in AWS to ensure optimal capacity, performance, security, and availability.
-
Exposure to ElasticSearch, Snappy data is a plus.
-
Must have working knowledge of handling Disaster Recovery and Business Continuity in the AWS cloud.
-
Knowledge of JSON and PostgreSQL support for JSON.
-
Ability to efficiently write database code without compromising data quality, privacy or security.
-
Knowledge of database design principles,queryoptimization,index management,integrity checks, statistics and isolation levels
-
Experience with DB migration projects added advantage