Database Administrator - Postgresql

Designation: Principal Data Engineer

Experience: Experienced

Position Type: Full Time Position

Location: Hyderabad

Office Timings: 9AM to 6PM

Compensation: As Per Industry standards

About Monarch:

At Monarch, we’re leading the digital transformation of farming. Monarch Tractor augments both muscle and mind with fully loaded hardware, software, and service machinery that will spur future generations of farming technologies. With our farmer-first mentality, we are building a smart tractor that will enhance (not replace) the existing farm ecosystem, alleviate labor availability, and cost issues, and provide an avenue for competitive organic and beyond farming by providing mechanical solutions to replace harmful chemical solutions. Despite all the cutting-edge technology we will incorporate, our tractor will still plow, till, and haul better than any other tractor in its class. We have all the necessary ingredients to develop, build and scale the Monarch Tractor and digitally transform farming around the world.

Description:

Monarch Tractor likes to invite an experience Python data engineer to lead our internal data engineering team in India. This is a unique opportunity to work on computer vision AI data pipelines for electric tractors. You will be dealing with data from a farm environment like videos, images, tractor logs, GPS coordinates and map polygons. You will be responsible for collecting data for research and development. For example, this includes setting up ETL data pipelines to extract data from tractors, loading these data into the cloud and recording AI training results.

This role includes, but not limited to, the following tasks:

● Lead data engineering team

● Own and contribute to more than 50% of the data engineering code base

● Scope out new project requirements

● Costing data pipeline solutions

● Create data engineering tooling

● Design custom data structures for efficient processing of data

Data engineering skills we are looking for:

● Able to work with large amounts of text log data, image data, and video data

● Fluently use AWS cloud solutions like S3, Lambda, and EC2

● Able to work with data from Robot Operating System

Required Experience:

● 3 to 5 years of experience using Python

● 3 to 5 years of experience using PostgreSQL

● 3 to 5 years of experience using AWS EC2, S3, Lambda

● 3 to 5 years of experience using Ubuntu OS or WSL

Good to have experience:

● Ray

● Robot Operating System

What you will get:

At Monarch Tractor, you’ll play a key role on a capable, dedicated, high-performing team of rock stars. Our compensation package includes a competitive salary, excellent health, dental and vision benefits, and company equity commensurate with the role you’ll play in our success. 

Engineering Manager – Backend

Opportunity in this role / Why should you join us?

Series D funded supply chain startup.

Requirements

• Software engineering experience of greater than or equal to 7 years
• Experience managing a technical team of at least 3 people
• Exposure to consumer facing products
• Strong technical background and ability to contribute to design and review
• Familiarity with our tech stack or an analogous tech stack

Technologies Used

• Web application frameworks : Ktor, Spring Boot, Ruby on Rails, Node.js, Java Play, AWS Lambda
• Languages : Kotlin, Java, Ruby, Javascript, Python
• Datastores : PostgreSQL, Aerospike, Redis, DynamoDB, Amazon Redshift
• Communication : HTTP, Amazon SQS, Sidekiq, Amazon SNS
• Server management : Amazon ECS, Docker
• Design frameworks : Domain Driven Design, Clean Architecture, Layered Architecture

Roles and Responsibilities

This role requires a person to drive the engineering of a set of products by aligning with business and product

stakeholders and building and upskilling a team to aid in this. The responsibilities include:

Business and product alignment and planning

• Work closely with business and product stakeholders to understand and align with product initiatives and iterations.
• Help shape the engineering requirement by aligning with the product manager and fleshing out concepts and user flows.
• Formalize business requirements into roadmaps and sprints.

1. Product and system development

• Drive high level modeling and design for projects, also focusing on non-functional aspects, including but not limited to database design, communication protocols, deployment systems, etc.
• Drive adoption of design frameworks like domain driven design, clean architecture, etc., resulting in a robust layered architecture.
• Drive good code review practices, using the review process as a mentoring tool to upskill people.
• Ensure test coverage of systems, partly through unit and integration testing, and partly through blackbox testing by collaborating with the Quality Assurance team, via good testing practices.

1. Project Management

• Drive the execution of the project by delegating tasks effectively.
• Resolve blockers through technical expertise, negotiation and delegation.
• Estimate timelines and ensure adherence to them through effective sync-ups and course corrections.

1. Maintenance

• Formulate SLAs and oversee their adherence for the various systems, effectively tracking issues and performance inefficiencies.
• Performance monitoring and optimization for systems.
• Drive technical re-design, remodeling and refactoring of systems for robustness and sustainability.

1. Team Management

• Typically manage a team of 3 - 6 members and a portfolio of 3 - 6 products.
• Do periodic assessment of reportees, chart their career growth paths and train them.
• Recruit members into the team by collaborating effectively with the recruitment team.

Product Overview

You will be contributing to products concerning both customers and partner drivers. Product sectors

include:

• Growth : You’ll build tools to help boost user growth on the platform including our industry bestdriver on-boarding, training and certification system, referral system, and lead managementmmodels.
• Lifecycle Management : Build tools to help users engage with the platform better, which includes rewards and recognition module, subscription service, account management tools, partner and customer wallets and payout modules, and churn detection systems among others.
• Transaction Experience : You’ll help deliver the most delightful booking experience to our customers and drivers. As part of this team, you’ll be responsible for our core booking system, pricing and payment systems, location tracking and filtering services, fraud prevention systems, and in-app ticketing and support among others.
• Fulfilment : As part of the fulfilment team, you’ll work on systems which ensure high degree of ride fulfilment on the platform. Tools including allocation methodologies and system, dynamic pricing, dynamic partner routing, and partner re-activation tools among others.
• Enterprise Solutions : You’ll help Porter’s enterprise customers achieve delivery excellence. You’ll build tools for contract management, fleet management, fleet and route optimisation tools, alerting and monitoring tools, and analytics suite among others.

• 0-2 years exp in Product Support Role.
• Need to Understand the product and features, to demonstrate them to the end users.
• Sound knowledge of Java and SQL
• Need to Analyze and Resolve the Product specific queries, MySQL.
• Consistently Deliver customer requirements.
• Engage with the Development team and manage the progress of cases.
• Should be able to cope with a high-pressure work environment.
• The working model will be 24X7.

Must require

• Good Communication both verbal and written
• Analytical skills
• Team player

Job Responsibilities

·        Responsibilities for this position include but are not limited to, the following.

·        Development experience 3-6 years

·        Experience working with Azure cloud-hosted web applications and technologies.

·        Design and develop back-end microservices and REST APIs for connected devices, web applications, and mobile applications.

·        Stay up to date on relevant technologies, plug into user groups, and understand trends and opportunities that ensure we are using the best techniques and tools.

• Meeting with the software development team to define the scope and scale of software projects.
• Designing software system architecture.
• Completing data structures and design patterns.
• Designing and implementing scalable web services, applications, and APIs.
• Developing and maintaining internal software tools.
• Writing low-level and high-level code.
• Troubleshooting and bug fixing.
• Identifying bottlenecks and improving software efficiency.
• Collaborating with the design team on developing micro-services.
• Writing technical documents.
• Be an active professional in continuous learning resulting in enhancement in organizational objectives.
• Provide technical support to all internal teams and customers as it relates to the product.

Requirements:

• Bachelor’s degree in computer engineering or computer science.
• Previous experience as a full stack engineer and IoT Products.
• Advanced knowledge of front-end languages including HTML5, CSS, JavaScript, Angular, React.
• Proficient in back-end languages including Nodejs and basic knowledge of Java, C#.
• Experience with cloud computing APIs and Cloud Providers such as Azure or AWS.

·        Working knowledge of database systems (Cassandra, CosmosDB, Redis, PostgreSQL)

·        Messaging systems (RabbitMQ, MQTT, Kafka)

·        Cloud-based distributed application scaling & data processing in the cloud

·        Agile / Scrum methodology

• Advanced troubleshooting skills.
• Familiarity with JavaScript frameworks.
• Good communication skills.

High-level project management skills.

• 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

A.P.T Portfolio, a high frequency trading firm that specialises in Quantitative Trading & Investment Strategies.Founded in November 2009, it has been a major liquidity provider in global Stock markets. 

As a manager, you would be incharge of managing the devops team and your remit shall include the following

• Private Cloud - Design & maintain a high performance and reliable network architecture to support  HPC applications
• Scheduling Tool - Implement and maintain a HPC scheduling technology like Kubernetes, Hadoop YARN  Mesos, HTCondor or Nomad for processing & scheduling analytical jobs. Implement controls which allow analytical jobs to seamlessly utilize ideal capacity on the private cloud. 
• Security - Implementing best security practices and implementing data isolation policy between different divisions internally. 
• Capacity Sizing - Monitor private cloud usage and share details with different teams. Plan capacity enhancements on a quarterly basis. 
• Storage solution - Optimize storage solutions like NetApp, EMC, Quobyte for analytical jobs. Monitor their performance on a daily basis to identify issues early.
• NFS - Implement and optimize latest version of NFS for our use case. 
• Public Cloud - Drive AWS/Google-Cloud utilization in the firm for increasing efficiency, improving collaboration and for reducing cost. Maintain the environment for our existing use cases. Further explore potential areas of using public cloud within the firm. 
• BackUps  - Identify and automate  back up of all crucial data/binary/code etc in a secured manner at such duration warranted by the use case. Ensure that recovery from back-up is tested and seamless. 
•  Access Control  - Maintain password less access control and improve security over time. Minimize failures for automated job due to unsuccessful logins. 
•  Operating System  -Plan, test and roll out new operating system for all production, simulation and desktop environments. Work closely with developers to highlight new performance enhancements capabilities of new versions. 
•  Configuration management  -Work closely with DevOps/ development team to freeze configurations/playbook for various teams & internal applications. Deploy and maintain standard tools such as Ansible, Puppet, chef etc for the same. 
•  Data Storage & Security Planning  - Maintain a tight control of root access on various devices. Ensure root access is rolled back as soon the desired objective is achieved.
• Audit access logs on devices. Use third party tools to put in a monitoring mechanism for early detection of any suspicious activity. 
• Maintaining all third party tools used for development and collaboration - This shall include maintaining a fault tolerant   environment for GIT/Perforce, productivity tools such as Slack/Microsoft team, build tools like Jenkins/Bamboo etc

Qualifications 

• Bachelors or Masters Level Degree, preferably in CSE/IT
• 10+ years of relevant experience in sys-admin function
• Must have strong knowledge of IT Infrastructure, Linux, Networking and grid.
• Must have strong grasp of automation & Data management tools.
• Efficient in scripting languages and python

Desirables

• Professional attitude, co-operative and mature approach to work, must be focused, structured and well considered, troubleshooting skills.
•  Exhibit a high level of individual initiative and ownership, effectively collaborate with other team members.

APT Portfolio is an equal opportunity employer