Database Developer (PostgreSQL)

Job Description:

We are looking for a skilled and motivated Laravel Developer with 1-3 years of experience to join our dynamic development team. The ideal candidate will have hands-on experience in building modern web applications using Laravel and a strong understanding of PHP. As a Laravel Developer, you will be responsible for developing, maintaining, and optimizing various web applications, while ensuring high performance, scalability, and security.

Responsibilities:

• Build high-quality web applications from scratch using Laravel.
• Troubleshooting issues in the implementation and debug builds.
• Design, build, and maintain efficient, reusable, and reliable code to ensure the applications' best possible performance, quality, and responsiveness.
• Contribute to all phases of the development lifecycle.
• Collaborate with cross-functional teams to define, design, and ship new features.
• Continuously discover, evaluate, and implement new technologies to maximize development efficiency.
• Prepare and maintain all applications utilizing standard development tools.
• Keep abreast of new trends and best practices in web development.
• Learn new Software/frameworks/ languages/technologies with ease.
• Finalizing back-end features and testing web applications.
• Refactor, optimize, and improve the existing codebase for maintenance and scale.
• Solve complex performance problems and architectural challenges.

Requirements:

• Good working knowledge of the PHP-based MVC framework Laravel.
• Good knowledge of PHP, HTML, CSS & JavaScript, and understanding of Database concepts & working knowledge of MySQL.
• Understanding the fully synchronous behavior of PHP.
• Understanding of MVC design patterns.
• A clear understanding of RESTful API development standards.
• Passion for best design and coding practices, and a desire to develop new bold ideas.
• Understanding fundamental design principles behind a scalable application.
• Creating database schemas that represent and support business processes
• Proficient understanding of code versioning tools, such as Git
• Excellent problem-solving skills.
• Understanding and managing Linux servers & AWS/GCP
• Hands-on experience with Redis will be an added advantage

Preferred Skills:

• Experience with front-end frameworks (Vue.js, React, etc.).
• Familiarity with testing frameworks such as PHPUnit.
• Knowledge of cloud platforms and deployment (AWS, DigitalOcean, GCP, etc.).

Education:

• Bachelor's degree in Computer Science, Information Technology, or a related field (or equivalent work experience).

Benefits & Perks:

• Vibrant & engaging work culture. 
• Flexible working hours & leave policy.
• Performance-based rewards & incentives.
• Best place to learn, work & grow.
• Free coffee bar to keep the employees energetic.

Description

We are looking for a Full Stack Developer to produce scalable software solutions. You’ll be part of a cross-functional team that’s responsible for the full software development life cycle, from conception to deployment. As a Full Stack Developer, you should be comfortable with both front-end and back-end coding languages, development frameworks and third-party libraries. You should also be a team player with a knack for visual design and utility. If you’re also familiar with Agile methodologies, we’d like to meet you.

Responsibilities

• Work with development teams and product managers to ideate software solutions
• Design client-side and server-side architecture
• Build the front-end of applications through appealing visual design
• Develop and manage well-functioning databases and applications
• Write effective APIs
• Test software to ensure responsiveness and efficiency
• Troubleshoot, debug and upgrade software
• Create security and data protection settings
• Build features and applications with a mobile responsive design
• Write technical documentation
• Work with data scientists and analysts to improve software

Requirements

• Proven experience as a Full Stack Developer or similar role
• Experience developing desktop and mobile applications
• Familiarity with common stacks
• Knowledge of multiple front-end languages and libraries (e.g. HTML/ CSS, JavaScript, XML, jQuery)
• Knowledge of multiple back-end languages (e.g. PHP, Java, Python) and JavaScript frameworks (e.g. Angular, React, Node.js)
• Familiarity with databases (e.g. PostgreSQL, MySQL, MongoDB), web servers (e.g. Apache) and UI/UX design
• Excellent communication and teamwork skills
• Great attention to detail
• Organizational skills
• An analytical mind
• Degree in Computer Science, Statistics or relevant field

• Implement best practices for the engineering team across code hygiene, overall architecture design, testing, and deployment activities
• Drive technical decisions for building data pipelines, data lakes, and analyst access.
• Act as a leader within the engineering team, providing support and mentorship for teammates across functions
• Bachelor’s Degree in Computer Science or equivalent job experience
• Experienced developer in large data environments
• Experience using Git productively in a team environment
• Experience with Docker
• Experience with Amazon Web Services
• Ability to sit with business or technical SMEs to listen, learn and propose technical solutions to business problems

·       Experience using and adapting to new technologies

·       Take and understand business requirements and goals

·       Work collaboratively with project managers and stakeholders to make sure that all aspects of the project are delivered as planned

·       Strong SQL skills with MySQL or PostgreSQL

• Experience with non-relational databases and their role in web architectures desired

 Knowledge and Experience:

• Good experience with Elixir and functional programming a plus

• Several years of python experience
• Excellent analytical and problem-solving skills
• Excellent organizational skills

Proven verbal and written cross-department and customer communication skills

Primary Responsibilities:

• We need strong SQL database development skills using the MS SQL server.
• Strong skill in SQL server integration services (SSIS) for ETL development.
• Strong Experience in full life cycle database development project using SQL server.
• Experience in designing and implementing complex logical and physical data models.
• Exposure to web services & web technologies (Javascript, Jquery, CSS, HTML).
• Knowledge of other high-level languages (PERL, Python) will be an added advantage
• Nice to have SQL certification.

Good to have:

Duties And Responsibilities

Coding backend for a stock analysis platform in Nodejs. You don’t.t need any experience or understanding of stocks for this position.
Nodejs - candidate must have good experience working with Nodejs and have a deep understanding of space -time complexity for writing optimized code in typescript
Typescript- candidate must know typescript and have good experience with it.
MongoDB and PostgreSQL - candidate must have experience working with both technologies. understanding of both technologies and designing scalable and optimized database structures

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

1. 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.
2. We work a solid 6-8 hour days and don't slave away 24/7.
3. 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.
4. We deploy several times a day and rely on a good test suite to ensure we're not making life hard for our colleagues.
5. We don't expect anyone to know everything, but we are curious and learn along the way.
6. 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:

1. You have 3 (or more) years of experience building and maintaining cloud applications.
2. You have built APIs with Python, Flask, Django or FastAPI before.
3. You have experience working with relational databases like PostgresSQL or MySQL and have spent time writing SQL queries for large datasets.
4. Experience in writing Unit tests with pytest.
5. You have worked with Docker, docker-compose.
6. Familiarity with the AWS ECS stack.

We want you to care about

1. Good object oriented design
2. Performant APIs
3. Analysing why queries are slow and how to go about improving them.
4. Understanding DNS, Load balancing, Caching and Hashing.
5. Customer data and privacy.

Our API Stack services use:

1. Python 3.8+, Typescript
2. FastAPI, Flask, HapiJs
3. PostgresSQL, MySQL
4. Redis
5. Celery
6. Pytest, Jest for unit testing.
7. Gitlab CI/CD
8. Amazon ECS container services

Responsibilities:-

• Produce clean, efficient code based on specifications
• Integrate software components and third-party programs
• Verify and deploy programs and systems
• Troubleshoot, debug and upgrade existing software
• Gather and evaluate user feedback
• Recommend and execute improvements
• Ensure highest standard of performance, quality, and responsiveness of the applications.

Requirements:-

• Overall 3-7 years of software engineering experience working with web applications and backend systems.
• At least 2 years of experience in production environment working with Ruby on Rails along with common libraries such as RSpec, Sidekiq, Redis.
• Strong understanding of concepts like MVC, ORM, and RESTful
• Strong understanding of Object Oriented Programming fundamentals.
• Strong understanding of server-side templating languages like SLIM and CSS pre-processors like SASS.
• Basic understanding of front-end technologies such as JavaScript, HTML5, and CSS3.
• Strong experience working with Linux like Operating Systems and shell environments like Bash, ZSH.
• Strong knowledge of integrating multiple databases into one system.
• Basic understanding of systems architecture and fundamental design principles behind a scalable web application.
• Ability to understand business requirements, derive database schemas and translate them into technical specifications and code.
• Strong hands on experience of Relation Databases like PostgreSQL, MySQL with ability of benchmarking and performance optimisation.
• Strong knowledge of any NoSQL database like MongoDB.
• Strong experience practicing TDD and writing test cases to achieve highest code coverage.
• Experience working with search engines like Elasticsearch, Solr is a plus.
• Experience integrating third party software and payment gateways is a plus.
• Experience deploying applications to cloud and setting up CI/CD is a plus.
• Experience building container images using tools like Docker is a plus.
• Experience with any popular JavaScript frameworks like React JS, Angular JS is a plus.
• Ability to learn new languages and technologies.

• Team with top-notch engineers, product managers, program managers, DevOps and QA following agile development methodologies
• Review functional requirements, providing technical feedback on feasibility and architectural approach and framework.
• Design and develop web / mobile applications
• Create Prototype and/or Proof of Concepts (POCs) when necessary
• Act in a technical leadership capacity: Mentor junior engineers and new team members, perform code reviews and apply technical expertise to challenging programming and design problems
• Utilize Agile Development, SCRUM / Pair / Extreme Programming methodologies
• Design and develop supporting components and microservices for the backend tiers focusing on fault-tolerance and scalability in a multi-tenant enterprise environment
• Maintain and improve the functionality and performance of the existing web applications
• Help shape and execute the technical roadmap to develop next generation features; integrate corporate- and product-level architecture principles and goals into the teams project work through designs, implementation strategies, and project planning.
• Drive a culture of quality, technical curiosity, continuous improvement, and evidence-based data driven decision making in the organization.
• Execute other Duties as assigned

• 3+ years of experience developing Backend, API and data-based applications/software
• Experience with one of the major relational databases (MySQL, Oracle, Postgres) and NoSQL databases (Mongo DB, Cassandra, Dynamo DB or such)
• Expert object-oriented programming experience using Java
• Strong OO design and programming skills in Java, Hibernate, JPA, Spring Boot
• Worked in Maven, JPA, REST services, Postman
• Working knowledge on Spring Security / Spring Batch / ZUUL / Eureka / Hysterix
• Exposure with Frontend technologies (React.js, Angular or Ruby-on-Rails)
• Require experience and Strong understanding of entire Software Development Life Cycle (SDLC), Agile (Scrum), Software design/architecture process, unit testing & Test-Driven Development (TDD)
• Experience with web services (consuming or creating)
• Experience managing Cloud infrastructure (resources and service) in AWS, Azure and/or GCP
• Strong knowledge of SOA, object-oriented programming, design patterns, multi-threaded application development
• Experience in reporting and analytics, queuing and real-time streaming systems
• Git or similar distributed SCM tools experience.

Job type: Permanent with ACL Digital

Client: Concentrix

Required skills:

• MySQL, or Postgres
• Linux systems
• Agile Methodologies
• Good communication skills