Database Developer (PostgreSQL)

Job brief 

We are looking for a qualified Database developer to design stable and reliable databases, according to our company’s needs. You will be responsible for developing, testing, improving and maintaining new and existing databases to help users retrieve data effectively.

As part of our IT team, you will work closely with developers to ensure system consistency. You will also collaborate with administrators and clients to provide technical support and identify new requirements. 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.

Responsibilities

• Design stable, reliable and effective databases
• Optimize and maintain legacy systems
• Modify databases according to requests and perform tests
• Solve database usage issues and malfunctions
• Liaise with developers to improve applications and establish best practices
• Gather user requirements and identify new features
• Develop technical and training manuals
• Provide data management support to users
• Ensure all database programs meet company and performance requirements
• Research and suggest new database products, services and protocols

Requirements

• Proven work experience as a Database developer (5+ Years)
• In-depth understanding of data management (e.g. permissions, recovery, security and monitoring)
• Knowledge of software development and user interface web applications
• Advanced proficiency and hands on experience with T-SQL, Stored Procedures, Cursors, Triggers, Schedulers etc.
• Familiarity working with MS SQL Server, MySQL, .Net Framework, java
• Excellent analytical and organization skills
• An ability to understand front-end users’ requirements and a problem-solving attitude
• Ability to craft detailed technical manuals.
• Excellent verbal and written communication skills
• BE/MCA/MSc Degree in Computer Science or relevant field.

Responsibilies
• 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

**Technology Vision**

The B2B manufacturing industry has a lack of digitisation globally. NowPurchase is building layers of technology to help improve the productivity and profits of the manufacturer. For this we are building the OS (Operating System) that will seamlessly connect factory equipment such as furnaces and spectrometers to our software systems that provide real time optimisations.

The end-game is to use this interconnected system to do great production planning and autonomous procurement of their raw materials. The Heart of NowPurchase will be a marketplace consisting of these smart factories and raw material suppliers.

Here a video that explains our product journey:

[https://www.loom.com/share/ccd0ed9e7bc349d7bba851d762253c21](https://www.loom.com/share/ccd0ed9e7bc349d7bba851d762253c21)

 **Role Description**

NowPurchase is looking to add an immensely talented Backend Developer that will help us invent, design, refine and deliver products that will meet the above vision.

- Expect to build a lot of services and APIs in the cloud and stand-alone IoT devices to serve both the browser as well as native IoT enabled terminals that will be placed at the manufacturers' premises.
- Expect designing algorithms that model the metallurgy of the manufacturing processes as well as using tools such as linear programming, machine learning etc.

 **What are the expectations from this role?**

- Deliver high quality modular code deployed to serve web, mobile and native IoT enabled terminals that leverage REST-based services and real time sockets. This would include algorithms for real time optimizations that are critical for the manufacturing process.
- You are empowered to work directly with leadership and the product team to make decisions about your code and future of the product.
- Have a strong emphasis on shipping features quickly without sacrificing code quality. Be ready to build a lot of MVPs that will go through iteration or be completely scrapped depending on the outcome at the customer end.
- Own your Agile projects and responsible for software design to implementation and deployment. Maintain sprints, delivery timelines and contribute to better managing the engineering team.
- Collaborate on the end to end design and implementation of the platform, including data modeling, systems architecture, data security, access controls, architecture, user experience, deployment, automation, and monitoring.
- Maintain a high level of data integrity, quality and security checks.
- Develop data pipelines and RESTful services that are distributed, robust and highly performant.
- Build a culture of simplicity and pragmatism, which is reflected in your elegant code that other developers emulate and you ensure through thorough code reviews and processes.

 **Qualifications and Experience**

- 1+ years of demonstrated software engineering experience in an agile environment designing, architecting and implementing robust scalable systems preferably for modern SaaS application
- Experience with modern server-side programming languages such as Python, Scala, Go. Experience with web frameworks such as Django Rest Framework, Flask.
- Experience with architecting asynchronous services with design patters leveraging PostgreSQL, MongoDB, Redis, Celery for storage and multi-tenant servers over AWS Elastic BeanStalk.

 **Compensation & Benefits**

- **Cash Compensation:** As per industry standards & pedigree of candidate
- **ESOPs:** 10% of NowPurchase is dedicated to current & future team members. Your package would entail some ESOPs so that you own a part of the company and grow along with it.
- **Medical Insurance:** Benefits of group insurance of 3 lakhs for family including parents, spouse, children
- **Generous leave structure and WFHs** including Marriage, Maternity & Paternity leaves
- **Complete Relocation Expenses:** We are building a unicorn out of the city of Joy (Kolkata). We will pay for everything you spend to relocate here.

 **Possible Growth path**

Backend Developer > Senior Backend End Engineer > Engineering Manager > VP of Engineering

## **Tech Stack**

- React/Redux
- Python/Django/Celery
- Git, AWS, ELB (Elastic Beanstalk), Netlify
- PostgreSQL/Redis/S3

 **Hiring Process**

1. Screening of applicants & initial telephonic call with Manager -HR
2. F2F/Video Interview with Engineering Manager and Cofounder CTO
3. Take home written assessment
4. F2F/Video Interview with Cofounder CEO
5. Email communication on final feedback

The end to end process shall take less than 10 days. We pride ourselves on being transparent & moving fast.

*Candidates who accept an offer may join within 1 hour, 1 week or up to 45days of signing - though, we have a preference for as short a gap period between signing and joining since we're at the most exciting part of our journey - laying the foundation for the NowPurchase platform!*

This person MUST have:
- B.E Computer Science or equivalent
- 3 years experience with the Django framework
- Experience with building APIs (REST or GraphQL)
- Strong Troubleshooting and debugging skills
- React.js knowledge would be an added bonus
- Understanding on how to use a database like Postgres (prefered choice), SQLite,
MongoDB, MySQL.
- Sound knowledge of object-oriented design and analysis.
- A strong passion for writing simple, clean and efficient code.
- Proficient understanding of code versioning tools Git.
- Strong communication skills.

Experience:
- Min 3 year experience
- Startup experience is a must.
Location:
- Remote developer
Timings:
- 40 hours a week but with 4 hours a day overlapping with client timezone. Typically
clients are in California PST Timezone.
Position:
- Full time/Direct

Other Benefits
- We have great benefits such as PF, medical insurance, 12 annual company holidays, 12
PTO leaves per year, annual increments, Diwali bonus, spot bonuses and other
incentives etc.
- We dont believe in locking in people with large notice periods. You will stay here
because you love the company. We have only a 15 days notice period.

What we are looking for:
Speed, passion, attention to details, get it done attitude, long term association and 1st principal thinking and lastly team player with ZERO insecurities. Learning opportunities will surely be huge.

Responsibilities:
1. Build new services to meet critical product and business needs.
2. Design scalable systems to solve problems with modern cloud technology and industry best practices.
3. Articulate a long-term vision for maintaining and scaling our backend systems and the teams running them.
4. Work with engineers, designers, product managers and senior leadership to turn our product and technical vision into a tangible roadmap every quarter.
5. Write high quality, well tested code to meet the needs of your customers.


Requirements & Qualifications
1. 3-7 years of recent hands-on coding and software design.
2. Bachelor degree or more in Computer Science or a related field.
3. A track record of projects completed on time – you are a flawless executor, not a procrastinator.
4. You find satisfaction in a job well done and want to solve head-scratching challenges.
5. Experience with all phases of the software development life cycle, best practices and Agile Software Development.
6. Solid OOP and software design knowledge – you should know how to create software that’s extensible, reusable and meets desired architectural objectives.
7. Establish Back-End Software Engineer best practices.
8. Working experience with NodeJS, PostgreSQL, In memory Database like Redis, Messaging Queues like RabbitMQ/Kafka

Role : Sr. Backend Developer /Lead
Years of Exp : 4 - 8yrs
Job Location: Mumbai/Bangalore

Job description:

We are looking for a Sr. Back end web developer/Lead passionate towards building high
performance web applications which can scale for B2C businesses. We are looking for
self-driven individuals who love to find innovative solutions and can perform under pressure. An eye for details and being proud of produced code are the must have attributes for this job.

Responsibilities.
●You will be responsible for converting Product team requirements to modular, testable and efficient code.
●You will be required to design and implement data storage solutions (Databases, caching
layers etc).
●You will also be required to cater to NFRs related to security and performance.

Skills
●At least 5 years of experience in working on NodeJS/Java/Ruby
●Proficiency in RDBMS such as MySQL/PostgreSQL.
●Experience of building/deploying applications on AWS is a definite advantage.
●Familiarity with some ORM (Object Relational Mapper) libraries like Sequelize is required.
●Experience in some NoSQL databases (e.g. DynamoDB/Elasticsearch/Redis Cache etc) is a definite plus.
●Good understanding on architectural patterns (e.g. MVC) is required.
●Good communication and analytical skills are the basic needs for this role.
●An urge to create awesome applications that people will enjoy using is a must.
●Other technologies : MySQL , Redis, AWS, Microservices, REST API .
●Knowledge of Javascript is preferable.
●AWS or some cloud experience.
●Should have built web application technology.
●Should have understanding of DevOps and Database.
●Should have done application performance tuning.

Qualification:
●Engineering graduates from Tier I or II institutes.
●B.E/ B.Tech/ MCA/ ME/ M.Tech

About the Company LEAF is safety technology company started from February 2015 with the mission to solve the problem of human safety by disrupting the largely unorganized security market. LEAF launched their first product Safer, a smart safety wearable in 2015 to solve the problem of women safety which was sold in more than 25 countries. LEAF was a part of Prime Minister Modi's delegation to silicon valley as the Top 10 Innovators of India. With first Indian company to win prestigious Million Dollar X Prize Award at United Nations, Leaf is on the mission to make Billion people safe. Skillset: Node.js, PostGIS, and experience with AWS PostgreSQL and MongoDB Loopback framework Self-driven, and passionate to make an impact in the world What kind of person we are looking Experience integration of data storage solutions like MongoDB and nosql cloud data store. Work as part of a team developing applications and services using Agile development methods Writing reusable, testable, and efficient code Code, test and operate node.js based services Design and implementation of low-latency, high-availability, and performant applications Strong knowledge of Node.js and frameworks like Loopback. Good understanding of server-side templating languages such as Jade, EJS. Strong understanding of front-end technologies such as Angular JS, HTML5 and CSS. Deployed and managed critical applications using a number of AWS services like (not limited to) S3, EC2, Route 53, Lambda etc. User authentication and authorization between multiple systems, servers, and environments Understanding of fundamental design principles behind scalable applications Creating database schemas that represent and support business processes Integration of multiple data sources and databases into one system Understanding differences between multiple delivery platforms, such as mobile vs. desktop, and optimizing output to match the specific platform Proficient understanding of code versioning tools, such as Gitlab, Github, Bitbucket etc. Location: GK-1, New Delhi Salary- To be discussed directly post interview. Contact: Avinash Bansal, Director (+91-8447206702)

We conceptualize, architect, build and run scalable and complex, modern day full stack technology platforms