Job Title: PostgreSQL Developer
Location: Bangalore, India
Experience: 3 to 8 Years
Notice Period: Immediate to 45 Days
Budget: CTS Budget
Job Description:
We are seeking a skilled PostgreSQL Developer to join our team in Bangalore. The ideal candidate will have a strong background in PostgreSQL, stored procedures, and SQL queries. You will be responsible for designing, implementing, and optimizing database solutions to support our applications.
Key Responsibilities:
- Design, develop, and maintain PostgreSQL databases.
- Write and optimize complex SQL queries and stored procedures.
- Implement database solutions to support application development.
- Ensure data integrity and security.
- Collaborate with developers and other stakeholders to understand requirements and provide database solutions.
- Perform database tuning and performance optimization.
- Troubleshoot and resolve database-related issues.
Qualifications:
- 3 to 8 years of experience in PostgreSQL development.
- Strong knowledge of SQL and stored procedures.
- Experience with database design and implementation.
- Familiarity with database performance tuning and optimization.
- Excellent problem-solving skills and attention to detail.
- Ability to work independently and as part of a team.
- Good communication skills.
Preferred Qualifications:
- Experience with other database technologies.
- Knowledge of data warehousing and ETL processes.
- Familiarity with cloud-based database solutions.
![companies logos](/_next/image?url=https%3A%2F%2Fcdn.cutshort.io%2Fpublic%2Fimages%2Fhiring_companies_logos-v2.webp&w=3840&q=80)
About Vysystem pvt Ltd
Similar jobs
![skill icon](/_next/image?url=https%3A%2F%2Fcdn.cutshort.io%2Fpublic%2Fimages%2Fskill_icons%2Fruby-on-rails.png&w=32&q=75)
Job Description
This is a remote position.
Requirements
- You need to be excited about the problem that we are trying to solve
- Should have excellent command over designing systems with a minimum experience of 4 years.
- Should have experience with various database flavors and writing complex queries. We work with Postgres, Redshift, ElasticSearch, TimescaleDB, and Redis.
- Additional knowledge in Golang will be an advantage
- Strong Data Structures and Algorithms knowledge
- Should have created APIs from scratch which is being used in Production
- Should be comfortable with creating systems handling up to 100k requests per minute, and have a mindset that understands scale
- Ability to give clarity and communicate well with the team, including Product, Backend and Dev-Ops (if and when needed)
- Ability to use profiling tools well, getting to root causes of bugs fast
- Ability to pick and work on adjacent technologies if and when required (Eg: If the best performance monitoring solution needs a basic firebase setup, that should not be a blocker for you to go ahead and do so)
- Knowledge of how to set up relevant test cases
- You need to be comfortable working in a remote environment (Good internet connection and availability on phone is required)
- App Development experience
- Experience in Test Driven Development
- Ability to tell Product what creates better User Experience, ability to tell frontend what API responses will help the user get a faster load time
- Inquisitiveness to understand the system as a whole, and not only be stuck to your domain of expertise (Eg: Figure out why excessive APIs calls are being made, brainstorm with Product and Frontend team to reduce the same without harming the UX )
- Experience in working on a Social Media Product
- Good knowledge of Graphs, and their applications
- Data-Driven Approach to monitoring
Benefits
- Work timings - You are the master of your time. However, with great freedom comes great responsibility. If you have committed something to the team, we expect that you will give it your best to make sure that commitment is done and is done on time.
- Leave policy - Take a leave whenever for whatever reason you want. You don't need to explain yourself to us
- Health insurance for you and your family
Roles and Responsibilities:
- Contribute in all phases of the development lifecycle
- Write well designed, testable, efficient code
- Ensure designs comply with specifications
- Prepare and produce releases of software components
- Support continuous improvement by investigating alternatives and technologies and presenting these for architectural review
- Ensure continual knowledge management
- Adherence to the organizational guidelines and processes
Skills /Competencies: a. Bachelor/Master’s degree with good experience in computer programming b.4+ years working experience in application development using Java
Essential Skills:
- Hands on experience in designing and developing applications using Java EE platforms
- Object Oriented analysis and design using common design patterns.
- Profound insight of Java and JEE internals (Data structure, Algorithm and time complexity, Memory Management, Transaction management etc)
- Excellent knowledge of Relational Databases, SQL and ORM technologies (JPA2, Hibernate)
- Experience in the Spring Framework
- Experience in developing web applications using at least one popular web framework (JSF, Wicket, GWT, Spring MVC) and UI technology (Angular/React JS)
- Ability to operate independently while establishing strong working relationships with co-workers and cross-functional teams
- Strong organizational and prioritization skills
- Demonstrate critical attention to detail and deadlines, and are self-motivated
- Ability to adapt to changes in direction and priorities in a project and deadline-oriented environment
- Strong written and verbal English communication skills
- Problem-solving attitude
Preferred skills Good to have –
- Knowledge in any UI technology (Angular, React, JS)
- Intermediate level knowledge of Unix environment (User commands, not System Admin commands)
- Understanding of capital markets and middle/back office processes in the financial services space
![skill icon](/_next/image?url=https%3A%2F%2Fcdn.cutshort.io%2Fpublic%2Fimages%2Fskill_icons%2Fpython.png&w=32&q=75)
![skill icon](/_next/image?url=https%3A%2F%2Fcdn.cutshort.io%2Fpublic%2Fimages%2Fskill_icons%2Freact.png&w=32&q=75)
💥 What will you do?
As a Backend Engineer, you will
- Create and maintain server-side code
- Designing database schemas to support business requirements
- Building reusable code and libraries for future use
- Troubleshoot and debug applications
- Write unit tests
- Stay up to date with current best practices
- Collaborate with front end engineers
- Optimization of the application for maximum speed and scalability
- Work with stakeholders including the Executive, Product, Data, and Design teams to assist with web-application-related technical issues and support their requirements.
🙋 What are we looking for?
While we do not have a strict list of requirements for candidates interested in this role, some indicators that you would fit this role and our engineering culture are
- 2+ years of relevant work experience as a Backend engineer using Python frameworks like Django, Flask, etc
- Experience with relational databases like MySQL, PostgreSQL
- Good understanding of OOP concepts
- Understanding of code versioning tools, such as Git
- Basic understanding of front-end technologies and platforms, such as JavaScript, HTML5, and CSS3.
- Experience writing unit tests for the application is a plus
- Experience with building REST APIs
- Superior analytical, conceptual, and problem-solving skills.
- Strong verbal and written communication skills in English.
![skill icon](/_next/image?url=https%3A%2F%2Fcdn.cutshort.io%2Fpublic%2Fimages%2Fskill_icons%2Fphp.png&w=32&q=75)
1.Wordpress Development
2.PHP Programming
3.OOPS Concepts in PHP
4.Advanced custom and Security Plugins
5.Good Problem Solving skills.
6. Ability to create/tweak existing plugins
7. Ability to create multiple dashboards apart from admin dashboard
8.Good Knowledge in DB - MySQL/PostGreSQL
9.Ability to debug Frontend applications
10.Http/REST
Good to have Understanding of:
1.Wordpress Hooks
2.HTML, CSS, JS, Github tools, AWS, Basics of React JS.,Github link
3. Ability to create API over existing plugin data
![skill icon](/_next/image?url=https%3A%2F%2Fcdn.cutshort.io%2Fpublic%2Fimages%2Fskill_icons%2Fruby-on-rails.png&w=32&q=75)
As a back-end developer, you’ll work on our back-end app that is built with Ruby on Rails. You’ll help to plan and develop new features, review other people’s code, fix bugs, help in technological and business decisions, and support the internal team.
Responsibilities
- Work in our main app back end built with Ruby on Rails
- Act as an architect of new features
- Review other people's code
- Fix bugs
- Help in decisions of technology and business
- Support internal team
- Refactor code
Requirements
- At least 3 years of industry experience
- At least 1 year of experience working on Ruby on Rails projects
- Comfortable in dealing with server infrastructure and deployment processes
- Experience with continuous delivery and automated testing.
- Experience with refactoring Ruby on Rails applications
- Experience in designing, developing and maintaining APIs
- Can work for at least a couple of hours during Japanese business hours
Nice to haves
These aren’t required, but be sure to mention them in your application if you have them.
- UI/UX design principles
- Good understanding of coding best practices and design patterns
- Understanding of security technologies (encryption, authentication, OAuth 2.0)
- Contribution to open source projects
- Interest and ability to learn other coding languages as needed
- Agile Development experience
![skill icon](/_next/image?url=https%3A%2F%2Fcdn.cutshort.io%2Fpublic%2Fimages%2Fskill_icons%2Fpython.png&w=32&q=75)
![skill icon](/_next/image?url=https%3A%2F%2Fcdn.cutshort.io%2Fpublic%2Fimages%2Fskill_icons%2Fflask.png&w=32&q=75)
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
Seeking for candidates with 5+ yrs of experience in Oracle background using PL SQL.
Responsible for writing PL/SQL Stored procedures, functions, triggers, cursors, views, Indexes, Sequences, collections, bulk binding etc
Responsible in writing complex queries with varied large data sets
Analyse, Design, Code and Debug using Oracle/PL SQL
Good in PL SQL concepts like Oracle Packages, stored procedures, functions, triggers, cursors, views, Indexes, Sequences, collections, bulk binding etc.
Ability to write efficient, complex queries against very large data sets using SQL Developer and TOAD
Expertise in pl/sql concepts- Oracle Packages, stored procedures, functions, triggers, cursors, views, Indexes, Sequences, collections, bulk binding etc
Experience in performance tuning - Strong analytical, design and debugging skills
Minimum of 4+ years of experience in Java development
- Experience delivering Services (REST, SOAP) and Web applications in Micro services architecture
- Experience developing and deploying Java solutions to cloud
- Experience in Spring Boot and components of Spring framework
- Experience in a JavaScript framework such as Angular or React
- Experience in TDD using Junit or similar frameworks
· Experience in Design Patterns and service oriented architectural principles, Data structures and Algorithms.
· Individual should be an active participant in the product design and code reviews for self and team and can competently review any aspect of their product or major sub-system.
· Experience in SQL, Unix skills.
· Good communication Skill
![skill icon](/_next/image?url=https%3A%2F%2Fcdn.cutshort.io%2Fpublic%2Fimages%2Fskill_icons%2Fnet.png&w=32&q=75)
![skill icon](/_next/image?url=https%3A%2F%2Fcdn.cutshort.io%2Fpublic%2Fimages%2Fskill_icons%2Fc_sharp.png&w=32&q=75)
Experience in C#, OOps, Javascript, HTML
· Should have delivered successful end-to-end development to deployment experience on Web applications and Api’sin last 1-5 years
· Experience in SQL is a must
· Should have 1-5 years experience in backend development
· Experience in service-based development using technologies such as Web API and RESTful services.
· Proficient in writing clean, well-structured code with proper abstraction and reusability.
. Ability to work to tight deadlines, manage priorities, and take responsibility for delivering to time and quality requirements.
![skill icon](/_next/image?url=https%3A%2F%2Fcdn.cutshort.io%2Fpublic%2Fimages%2Fskill_icons%2Fnet.png&w=32&q=75)
![skill icon](/_next/image?url=https%3A%2F%2Fcdn.cutshort.io%2Fpublic%2Fimages%2Fskill_icons%2Fangular.png&w=32&q=75)
- Core .NET, C#
- HTML5, CSS3
- JavaScript
- ASP.NET (Web Forms, MVC, Web API)
- Bootstrap 3 or 4
- jQuery
- Angular 5+ working knowledge
- SQL (basic) – Desirable
- Development of applications using C#, MVC
- Development of Web Services using REST and WCF.
- Unit Testing of code using Microsoft and any other competent open-source testing
framework.
- Develop middle tier using Object Relational Model (ORM).
- Developing applications using Rapid Application Development (RAD) tools
- Design Database in SQL Server 2016 or higher.
- Ability to work under pressure and deadline.
- Candidates should be good in communication.
![icon](/_next/image?url=https%3A%2F%2Fcdn.cutshort.io%2Fpublic%2Fimages%2Fsearch.png&w=48&q=75)
![companies logos](/_next/image?url=https%3A%2F%2Fcdn.cutshort.io%2Fpublic%2Fimages%2Fhiring_companies_logos-v2.webp&w=3840&q=80)