Database Administrator Lead - PostgreSQL
ABOUT Ashnik
Established in 2009, Ashnik is a leading open-source solutions and consulting company in South East Asia and India, headquartered in Singapore. We enable digital transformation for large enterprises through our design, architecting, and solution skills. Over 100 large enterprises in the region have acknowledged our expertise in delivering solutions using key open-source technologies. Our offerings form critical part of Digital transformation, Big Data platform, Cloud and Web acceleration and IT modernization. We represent EDB, Pentaho, Docker, Couchbase, MongoDB, Elastic, NGINX, Sysdig, Redis Labs, Confluent, and HashiCorp as their key partners in the region. Our team members bring decades of experience in delivering confidence to enterprises in adopting open source software and are known for their thought leadership.
THE POSITION
Ashnik is looking for talented and passionate people to be part of the team for an upcoming project at client location.
RESPONSIBILITIES
· Monitoring database performance
· Optimizing Queries and handle escalations
· Analyse and assess the impact and risk of low to medium risk changes on high profile production databases
· Implement security features
· DR implementation and switch over
QUALIFICATION AND EXPERIENCE
· Preferably have a working experience of 4 Years and more , on production PostgreSQL DBs.
· Experience of working in a production support environment
· Engineering or Equivalent degree
· Passion for open-source technologies is desired
ADDITIONAL SKILLS
· Install & Configure PostgreSQL, Enterprise DB
· Technical capabilities PostgreSQL 9.x, 10.x, 11.x
· Server tuning
· Troubleshooting of Database issues
· Linux Shell Scripting
· Install, Configure and maintain Fail Over mechanism
· Backup - Restoration, Point in time database recovery
· A demonstrable ability to articulate and sell the benefits of modern platforms, software and technologies.
· A real passion for being curious and a continuous learner. You are someone that invests in yourself as much as you invest in your professional relationships.
LOCATION: Bangalore & Mumbai
Experience: 7 yrs plus
Package: upto 20 LPA
Similar jobs
Key Responsibility Areas:
- Develop tools and applications by producing clean, efficient code.
- Determine operational feasibility by evaluating analysis, problem definition, requirements, solution development and proposed solutions
- Perform validation and verification testing and debud code.
- Work collaboratively with others to achieve goals
- Experience working in an agile environment
Required Skills:
- Experience in implementing Object-Oriented Python, Django.
- Good understanding on Django
- Experienced in interfacing with *third party API’s using REST
- Worked with varieties of Relational Databases (RDBMS) like SQLite, MySQL, PostgreSQL.
- Experience in Version Control with Git and Bitbucket.
- Experience with JIRA the development progress and tracking deadlines of the project
Responsibilities-
- Participate in the entire application lifecycle, focusing on coding and debugging
- Write clean code to develop functional web applications
- Troubleshoot and debug applications
- Collaborate with Front-end developers to integrate user-facing elements with server-side logic
- Gather and address technical and design requirements
- Provide training and support to internal teams
- Build reusable code and libraries for future use
- Liaise with developers, designers to identify new features
- Follow emerging technologies
Requirements-
- Spent at least 3 yrs in a solid back end role
- Experience taking a problem to a product solution (module/product)
- Prior experience working with startups and understand the fast-paced, dynamic nature of work
- Javascript, NodeJS
- Client-server architecture
- OOP concepts, including design patterns
- Understanding of RDBMS (MySQL, Postgresql)
- Understanding of REST API
- Familiarity with frameworks such as ExpressJs
- Knowledge of TDD frameworks mocha, chai, jest, etc
- Knowledge of AWS (Lambda, RDS, EC2, SQS, S3, ECS, etc)
- Basic knowledge of Typescript, NextJs
- Prior experience in fin-tech
Senior Software Engineer, Java/Python (Bangalore, Remote option available)
4+ years of experience
Zepto
Why should you look at this role?
Salary 40-55 lakh per annum
Paid leave
Sick leave
Provident Fund
What Else?
- High growth startup in quick commerce space (10 min delivery)
- Given our very high hiring bar, we offer a very competitive salary and substantial equity to create everlasting wealth for our early believers as the company grows.
- Work on real world logistics problems & benefit from the rocket ship Zepto is!
Tech Team: 40-50 (200+ in few months)
About the Employer
Zepto is a fast-growing startup that delivers products in 10 minutes through an optimised network of dark stores that we're building across the country!
Just 6 months after launching, we've raised $160 million from marquee
investors in Silicon Valley and India. Our investors include Y Combinator, Nexus Venture Partners, and many more! We’ve built out one of the best startup teams in India, with Senior Executives from Uber, Flipkart, Dream11, PhonePe, Goldman Sachs, Pepperfry, and institutions like Stanford, INSEAD, IITs, and IIMs.
The magic of Zepto is our ability to consistently deliver 2,500+ products in 10 minutes flat. It's the core of what we do, and the reason why we’ve been able to grow so fast with phenomenal customer love. Our mission is simple: to make 10-minute delivery the new normal.
Funding:
Funding Zepto has raised a total of $160M in funding over 3 rounds.
Their latest funding was raised on Dec 20, 2021 from a Series C round.
Employer Reviews:
“High Ownership, Lots of Learning, Broad Roles, Accessible Leaders”
"Alot of benefits like ZeptoJoy coupon, internet bill reimbursement and cab reimbursement is also taken care of. Overtime is paid."
Reporting structure:
Software Engineer -> Sr Software Engineer -> Lead -> EM -> AD / Director / VP -> Head of Engineering -> CTO
This role would be by and large a Individual Contributor role.
Interview Process:
- Round 1. Problem Solving + CS Fundamentals (60 mins)
- DS/Algo Problems (30 mins) - You can expect 1-2 Leetcode easy/medium questions
- CS Fundamentals (30 mins)
- Round 2. Low Level Design (60 mins)
- You would be given a trivial problem and expected to work through the low level design viz class structure, interfaces, db data models etc.
- Round 3. High Level Design (60 mins)
- You will be given a trivial problem, where we would work with you to design the system for the problem statement. We expect the detailed flow of the Functionality
- Extract APIs, if any
- Database choices
- Schema design and Scale the system, if time permits
- You will be given a trivial problem, where we would work with you to design the system for the problem statement. We expect the detailed flow of the Functionality
What You will do Everyday?
- Work very closely with the Tech Leadership and lead end-to-end development.
- Closely collaborate with product, design and business teams to understand product ideas and business needs and help deliver these as a series of ultra fast experiments.
- Architect and implement backend services with high reliability and scalability.
- Contribute to system architecture and database design.
- Set up best practices for development and champion their adoption.
- Write quality documentation and handle conflicts well to build consensus.
- Learn about new technologies and incorporate them.
- Mentor young minds and foster team spirit
Your Superpowers
- 4+ years of experience with Java frameworks like Spring / Dropwizard/Play or Python frameworks like Django/Flask/FastApi and databases like PostgreSQL/MySQL/MongoDB
- Experience in building highly scalable customer-facing applications that involve implementing complex business flows and dealing with an ever-increasing scale
- Extensive experience in object-oriented design skills, knowledge of design patterns, and huge passion and ability to design intuitive module and class-level interfaces.
- Experience in service-oriented architecture design.
- Experience building at least one application from scratch.
- Experience with cache store/message broker like Redis / RabbitMQ/Kafka
- Interest in learning new languages/framework as needed.
- Worked in a startup environment with high levels of ownership and commitment.
- A growth mindset and passionate about building things from the ground up and most importantly, you should be fun to work with.
We are looking for a PHP/Laravel Developer responsible for the development and maintenance of a Social Networking Application aimed at a vast number of various Android Mobile devices. Your primary focus will be the development of the back-end and their integration with front-end services. You will work alongside other engineers and developers on different layers of the infrastructure. Therefore, commitment to collaborative problem solving, sophisticated design, and creating quality products is essential.
Roles and Responsibilities
- Translate designs and wireframes into high-quality code
- Design, build and maintain high-performance, reusable, and reliable PHP code
- Ensure the best possible performance, quality, and responsiveness of the application
- Identify and correct bottlenecks and fix bugs
- Help maintain code quality, organization, and automatization
- Follow best practices in code implementation
- Willing to work on flexible time zones if required
Desired Candidate Profile
- A degree in programming, computer science, or a related field.
- Experience working with PHP, performing unit testing, and managing APIs like REST.
- A solid understanding of application design using Laravel.
- Knowledge of database design and querying using MySQL.
- Proficiency in HTML and JavaScript.
- Practical experience using the MVC architecture.
- A portfolio of applications and programs to your name.
- Problem-solving skills and critical mindset.
- Great communication skills.
- The desire and ability to learn.
The ideal candidate is a highly resourceful and innovative developer with extensive experience in the Laravel framework. We use GIT for version control and the candidate must have experience in working in a team environment using tools like Github, Gitlab, etc.
- Perform a mix of maintenance, enhancements, and new development as required.
- Work cross-functionally to convert business needs into technical specifications.
- Help with database and backend architecture.
- Create API endpoints
Required Qualifications:
- 2+ years of experience in web development and software design
- Expertise in Laravel Framework, and MySQL databases.
- Working knowledge of GIT and Github.
- Experience with creating REST-based API endpoints
• 3+ Years of experience as a Go Developer
• Experience in ReactJS (most preferred) or AngularJS similar front end frameworks
• Experience with the Python or/and Golang (preferably both), SQL, and design/architectural
patterns
• Experience in Java or dotnet or other opensource technologies is an added advantage
• Hands-on experience on SQL, Query optimization, DB server migration
• Preferably experience in Postgre SQL or MySQL
• Knowledge of NOSQL databases will be an added advantage
• Experience in Cloud platforms like AWS, Azure with knowledge of containerization, Kubernetes is an
added advantage
• Knowledge of one or more programming languages along with HTML5/CSS3,Bootstrap
• Familiarity with architecture styles/APIs (REST, RPC)
• Understanding of Agile methodologies
• Experience with Threading, Multithreading and pipelines
• Experience in creating RESTful API’s With Golang or Python or Java in JSON, XMLs
• Experience with GitHub, Tortoise SVN Version Control
• Strong attention to detail
• Strong knowledge of asynchronous programming with the latest frameworks
• Excellent troubleshooting and communication skills
• Strong knowledge of unit testing frameworks
• Proven knowledge of ORM techniques
• Skill for writing reusable libraries Understanding of fundamental design principles for building a scalable
applicatio
Job Description
Must have Skill Sets
- Go lang + Microservices
- Familiarity with MAC/Linux environment, Shell script
- GRPC ● JavaScript & JSON
- Knowledge of microservices and architecture
- Knowledge of Uber Tech Stack would be a bonus ○ Will ensure candidate who are selected will undergo training on Uber Stack as a part of their induction to Uber
- Basic SQL knowledge
Expectations from the candidate
- Strong hands-on experience in understanding requirements and creating microservices using Go lang..
- Exceptional debugging and problem-solving skills on large codebase
- Be a proactive thinker and demonstrate keen sense to find solutions to challenging problems
- Product sense: Create more than beautiful code. Play a crucial role in choosing what we build and how we build it.
- A penchant for collaboration & a team player: Work cross collaboratively to drive impact across orgs. Be open to candid feedback for improvement. When required step up to the role of a tech-lead to ensure effective coordination and communication
- Independent to explore all the end points in UBER environment and coordinate with different Line of Business to understand the correct microservice for a business use case.
- Ability to convert a high-level PRD into a detailed ERD for execution. Coordinate with business teams to understand the functional requirement and convert it into engineering logic
Primary Skills :
4+ Years with Java
2+ with Microservices
6 months to 1 Year with Golang
Exp : 4+ Years
Location : Bangalore/Hyderabad
Max Budget : 28 Lakhs
End Client : UBER
We are looking for Django Developers who will work on a wide range of industries namely automobile, banking, education, fashion, etc.
Skills Required:
- Professional and precise communication skills.
- Creating self-contained, reusable, testable modules and components..
- Extensive knowledge of CSS and JS methods for providing performance visual effects and keeping the frame rate above 30fps at all times.
- Thorough understanding of the responsibilities of the platform, database, API, caching layer, proxies, and other web services used in the system.
- Validating user actions on the client side and providing responsive feedback.
- Writing non-blocking code, and resorting to advanced techniques such as multithreading, when needed.
- Experience with all levels of operation available to the front-end, such as from creating XHRs in vanilla JS to using a custom wrapper around resources.
- Experience with building the infrastructure for serving the front-end app and assets.
Qualifications and Experience Requirements:
- 3+ years of experience in Backend Development
- Preferred skills - Python, MySql, PostgreSQL
- Proficiency with Python, Django framework, JavaScript, CSS and HTML5.
- Knowledge of AWS Cloud Services ( EC2, AWS Lambda,Elastic Beanstalk, API Gateway, S3 etc )
- Familiar with XAMPP, LAMP etc.
Our client was founded in 1999 by Mr. D.N. Prahlad (an early employee of Infosys), to create software products. Headquartered in Bangalore, we also have offices in the USA and France.
What We're Looking For
• An unwavering attention to detail and care towards your work. We double-check PRs they submit for review. Each variable name is thought through in detail; attention is paid to how decisions made today will affect the future.
• An absolute commitment towards doing the best work of your life, while helping others to do the same. We deliver with utmost focus on the job at hand. The team works towards crafting the best products for our users, and customers. Working as a team, we take on problems out of the original scope of their work if this results in a better end product.
• You should be comfortable working in an agile environment. You are also expected to
participate in code reviews—both receiving and offering them as needed. You are needed to communicate flexibly with your team—pitching in on designs, features, and ideas for the product, wherever needed.
What is Needed for the Role
• Strong command of Java & the JVM ecosystem
• Strong command of relational databases such as PostgreSQL, Microsoft SQL Server, Oracle, etc. (both with & without ORMs)
• Strong command of HTTP
• Strong command of HTML, CSS, and JavaScript
• Extensive experience with at least one JVM based web framework (SpringBoot, Micronaut, Play, Dropwizard, etc.)
• Experience with concurrency & parallelism on the JVM
• Experience with Docker, and cloud-native concepts
• Experience with Gradle
• A good grip on Git
What You Will Work On
The specific project you work on is decided based on the list of available projects at the time. While what you work on will change over time, we assure you that you’ll work with people who care deeply about their work and deliver with great attention to detail.
Your Growth
Our growth is driven by ordinary people who have extraordinary dreams and are bold enough to pursue them. Our leadership team, including our Managing Director, is comprised primarily of people who joined us as freshers. Through our process of continuous feedback, and regular 1-1 conversation, we believe in upskilling our team, and enabling each of them to grow along paths they find satisfying.
Your Level of Experience
We do not evaluate people based on the number of years of experience they have.
Instead, we look for skills that have been gained, regardless of how long they’ve, it has taken a person to gain those skills.
However, as a point of reference, historically, we have successfully recruited candidates for this role with 1-5 years of prior experience.
Evaluation Process
The evaluation process starts with a short phone conversation.
After that, the candidate will be required to take both a technical and writing test, which will be shared with them after the phone screen.
This will be followed by 1-3 interviews, over Google Meet. We will require candidates to be alone, in a quiet place (with no background noise). They must also have a fast & reliable internet connection. They will be required to take the call on a laptop with a camera, and have their technical test code ready for perusal. We recommend using Google Chrome to join the call, and strongly urge candidates to use headphones/earphones.
Please note that the evaluation process may take up to 6 hours
This includes working on:
a) The main Django application, a large, modern, Django app built using Python 3.8 and the latest Python and Django libraries;
b) The API, built using Django Rest Framework (DRF) that is used both by our web-app and client libraries to build and run data analyses;
c) Backend code that integrates our web server with the rest of our cloud architecture, including our PaaS, data science code, general integrations such as payments, devops code, and more.
Ideally, you should have experience working on Django codebases which serve both server-side rendered pages and APIs via DRF. Frontend/full-stack knowledge is a an advantage but not essential. Familiarity with modern development practices, such as CI/CD, testing, DevOps, Docker, Linux and git would be a big plus. You must have very strong familiarity with Python development, and be excited to pick up the new technologies and skills - for instance we use Python type-hints across our codebase extensively.
You should like the idea of releasing to real customers regularly, and prioritise getting a great product into users’ hands for feedback and iteration. You will have extensive scope to build and architect the backend, and to help grow the team in the future.