SQL Developer

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.

Procedure is hiring for Drover.

This is not a DevOps/SRE/cloud-migration role — this is a hands-on backend engineering and architecture role where you build the platform powering our hardware at scale.

About Drover

Ranching is getting harder. Increased labor costs and a volatile climate are placing mounting pressure to provide for a growing population. Drover is empowering ranchers to efficiently and sustainably feed the world by making it cheaper and easier to manage livestock, unlock productivity gains, and reduce carbon footprint with rotational grazing. Not only is this a $46B opportunity, you'll be working on a climate solution with the potential for real, meaningful impact.

We use patent-pending low-voltage electrical muscle stimulation (EMS) to steer and contain cows, replacing the need for physical fences or electric shock. We are building something that has never been done before, and we have hundreds of ranches on our waitlist.

Drover is founded by Callum Taylor (ex-Harvard), who comes from 5 generations of ranching, and Samuel Aubin, both of whom grew up in Australian ranching towns and have an intricate understanding of the problem space. We are well-funded and supported by Workshop Ventures, a VC firm with experience in building unicorn IoT companies.

We're looking to assemble a team of exceptional talent with a high eagerness to dive headfirst into understanding the challenges and opportunities within ranching.

About The Role

As our founding cloud engineer, you will be responsible for building and scaling the infrastructure that powers our IoT platform, connecting thousands of devices across ranches nationwide.

Because we are an early-stage startup, you will have high levels of ownership in what you build. You will play a pivotal part in architecting our cloud infrastructure, building robust APIs, and ensuring our systems can scale reliably. We are looking for someone who is excited about solving complex technical challenges at the intersection of IoT, agriculture, and cloud computing.

What You'll Do

• Develop Drover IoT cloud architecture from the ground up (it’s a green field project)
• Design and implement services to support wearable devices, mobile app, and backend API
• Implement data processing and storage pipelines
• Create and maintain Infrastructure-as-Code
• Support the engineering team across all aspects of early-stage development -- after all, this is a startup

Requirements

• 5+ years of experience developing cloud architecture on AWS
• In-depth understanding of various AWS services, especially those related to IoT
• Expertise in cloud-hosted, event-driven, serverless architectures
• Expertise in programming languages suitable for AWS micro-services (eg: TypeScript, Python)
• Experience with networking and socket programming
• Experience with Kubernetes or similar orchestration platforms
• Experience with Infrastructure-as-Code tools (e.g., Terraform, AWS CDK)
• Familiarity with relational databases (PostgreSQL)
• Familiarity with Continuous Integration and Continuous Deployment (CI/CD)

Nice To Have

• Bachelor’s or Master’s degree in Computer Science, Software Engineering, Electrical Engineering, or a related field

As Back end developer, we expect you to be motivated in solving real-life complex problems and create compelling experiences for our Resellers. Being a small company we have a culture of creative problem solving, intellectual design, fast-paced development, and passionate product delivery. Enhance or build Restful web services for our mobile app.

Responsibilities:

• Develop server-side components, REST APIs
• Assume ownership for existing and new modules including design, development, and unit testing for enhancements of existing modules and development of new modules.
• Analyse problems logically and exercise sound judgment in defining, evaluating, and solving difficult technical and operational problems where solutions may be of a precedent-establishing nature.
• Lead the design and architectural improvements
• Participate and collaborate with team members in design discussions, determines areas of complexity, potential risks to successful implementation, suggest enhancements to architecture, implement POCs, and enhance application.
• Reduce technical debt with quality coding

Requirements:

• A solid grounding in Computer Science fundamentals (based on a BS or MS in CS or related field) from IITs and Premier Engineering College.
• Excellent Object Orientation, coupled with excellent problem solving and debugging skills.
• Highly skilled at Java and related technologies, including Java Frameworks like Spring-boot or Drop wizard, RESTful web services, JSON, Servlet, JSP, MySQL, MongoDB, Kafka, AWS Solr.
• Must have hands-on experience in building scalable and secure back end systems.
• Have hands-on experience with systems that are asynchronous, RESTful and demand concurrency
• Good to have knowledge of best software engineering practices for all stages of the software development life cycle, including coding standards, code reviews, testing, deployment.

Note : This job is for immediate joining. Please apply ONLY IF you can join immediately.

Experience :- Junior role : 1 to 3 years/Senior : 5 to 7 Years

Industry: FinTech / BFSI

Functional Area: Core Platform Programming, Maintenance

Role Category: Programming & Design

Role: Software Developer

Employment Type: Permanent Job, Full Time

Overview:

We are looking to hire Java developers who are well versed with Spring Boot, Hibernate, and RDBMS such as MySQL.

As we continue to grow our apps and site, we are looking for somebody to join our Engineering team and help build out the next set of kick-ass features.

If selected, you get to be a part of a small but committed group of technologists who are trying to improve how events are ticketed and marketed in India.

About the role:

• 2+ years of experience on Java, Spring Boot, Hibernate in medium to large-scale projects
• Must have experience with at least some flavours of both SQL (MySQL, Postgres) and NoSQL (MongoDB, ElasticSearch, Redis, DynamoDB etc) datastores in production
• Must have experience with Kafka or similar message queue systems in production
• Stellar problem solving skills
• Hunger to learn new things and ability to grasp new concepts quickly
• Ability to move quickly without breaking things too much (we are dreamers)
• Ability to work under immense pressure which is balanced by a sense of responsibility and ownership
• Should be able to groom juniors and take them to the next level

Perks :

• You get to work at a fun filled atmosphere
• Have ample chances of learning leadership, mentor-ship skills
• A solid salary package along with chance to get ESOPs 

Salary Range : 6 LPA to 12 LPA 

(based on qualifications, experience and skills)