Database Administrator (PostgreSQL)

A B.Tech/M.Tech in Computer Sc, a SDE should have 1-3 years of experience in SW solution development. We are specifically looking for a SDE who:

• is highly proficient in Java Coreand Spring boot applications including making high quality, highly performing code under JVM environment. 
• has good working knowledge in design of n-Tier databases (Postgres, NoSQL DBs e.g. Cassandra/MongoDB)
• has worked in agile development environment under open source gitlab including testing, change management
• is highly proficient in OOD, extensibility, usability, understand data pre-processing
• has exposure to full life cycle of product implementation and deployment of enterprise products driving a subsystem including development under gitlab or github.
• [Desirable] Ability to optimize an ML solution for accuracy and scale
• [Desirable] has experience in working with Advanced Java

Are you interested in creating outstanding, reliable and scalable software?

We at Lynkzo are creating a modern omni channel communication platform for companies to meet the changing requirements in the market.

We are looking for someone who:

• has hands-on experience with creating/working on scalable applications in Nodejs using various frameworks like Express, Hapi, Fastify, etc and can structure a fairly large codebase properly.
• has been working as a backend developer for 3+ years.
• has great experience working in both SQL and NoSQL databases.
• can extensively test the entirety of the application.
• can convert real-world business challenges into effective technical solutions.
• has experience working with an agile/scrum team.
• can work independently with limited supervision.

*Experience in AWS will be good to have.

Location: Hybrid (Bangalore Office)

Experience: 3-5 years of relevant experience

Contract Duration: Full Time

Qualification: Bachelor's degree in Technology or Engineering

About Us:

The BHIVE Group is a leader in revolutionizing enterprise-grade managed offices and coworking spaces for enterprises, democratizing investments in Bengaluru. With an extensive network in prime locations of Bengaluru and Mumbai, and expertise in investment, the group redefines commercial real estate and financial services. BHIVE Workspace offers a collaborative ecosystem with over 27+ properties, 46,000 seats, and spread across 1.8 million sq. ft, catering to corporates, MNCs, entrepreneurs, and businesses of all sizes.

Role Summary:

We are seeking a skilled Backend Engineer with a strong foundation in Python and the FastAPI framework. You will be pivotal in developing, implementing, and maintaining the server-side logic of our web applications, APIs, and other software systems. This role involves crafting robust backend solutions that ensure high performance, scalability, and security.

Key Responsibilities:

• API Development: Design, develop, and maintain scalable APIs using Python 3.x and FastAPI. Ensure robust data validation, security measures, and error handling.
• Database Management: Utilize ORM libraries to model complex data structures, perform CRUD operations, craft optimized queries, and manage database migrations.
• Authentication and Authorization: Integrate secure authentication and authorization mechanisms to protect sensitive data and ensure secure access.
• System Performance: Monitor and optimize system performance to ensure high availability and scalability. Implement performance tuning strategies and resolve bottlenecks.
• Collaboration: Work closely with front-end developers to integrate user-facing elements with server-side logic. Foster a collaborative environment to drive innovation and continuous improvement.
• Code Quality and Testing: Maintain high code quality through comprehensive testing, including unit, integration, and end-to-end tests. Adhere to industry standards and best practices.
• Documentation: Ensure clear and concise documentation of the codebase, APIs, and system architecture. Utilize FastAPI's strengths for automatic documentation and dependency injection.
• Innovation: Stay up-to-date with the latest trends and advancements in backend development. Embrace new technologies and methodologies to enhance the development process.

Key Competencies:

• Proficient in Python programming with a deep understanding of FastAPI and ORM libraries.
• Strong problem-solving, debugging, and critical thinking skills.
• Advanced testing proficiency to ensure code reliability and stability.
• Effective communication and collaboration skills.
• Ability to leverage FastAPI for automatic documentation, dependency injection, and asynchronous operations.
• Commitment to industry standards and best practices in backend development.

Employee Benefits:

• ESOP Policy: Strong employee-friendly ESOP policy, applicable based on performance.
• Training and Development: Continuous training and development opportunities to enhance your career.
• Networking Opportunities: Access to multiple BHIVE events, providing great opportunities for professional networking.
• Comprehensive Benefits Package: Including performance-based awards, competitive compensation, health benefits, financial security, and professional development opportunities.

Our Mission:

To be amongst the most loved and admired real estate companies of India by 2033.

Our Vision:

Helping people live a better quality of life through all our initiatives.

Why Choose BHIVE:

• Supportive Environment: We strive to create a supportive and rewarding work environment where employees feel valued, empowered, and motivated to excel.
• Equal Opportunity Employer: BHIVE is committed to diversity, inclusion, and fostering a supportive work environment. We value unique styles, experiences, identities, ideas, and opinions.
• Growth Opportunities: BHIVE invests in employee development, providing ample opportunities for professional advancement.
• Impactful Work: Joining BHIVE means contributing to a significant impact on the startup ecosystem in India.

Project Overview: We are looking for expert level Postgres database developer to work on a software application development project for a fortune 500 US based telecom client. The application is web based and used across multiple teams to support their business processes. The developer will be responsible for developing various components of the Postgres database and for light administration of the database.

Key Responsibilities: Collaborate with onshore, offshore and other team members to understand the user stories and develop code. Develop and execute scripts to unit test. Collaborate with onshore developers, product owner and the client team to perform work in an integrated manner.

Professional Attributes: Should have the ability to work independently and seek guidance as and when necessary - Should have good communication skills - Flexible working in different time zones if necessary - Good team player - Mentoring juniors

Experience preferred:

• Extensive experience in Postgres database development (expert level)
• Experience in Postgres administration.
• Must have working experience with GIS data functionality
• Experience handling large datasets (50-100M tables)
• Preferred – exposure to Azure or AWS
• Must have skillsets for database performance tuning
• Familiarity with web applications
• Ability to work independently with minimal oversight
• Experience working cohesively in integrated teams
• Good interpersonal, communication, documentation and presentation skills.
• Prior experience working in agile environments
• Ability to communicate effectively both orally and in writing with clients, Business Analysts and Developers
• Strong analytical, problem-solving and conceptual skills
• Excellent organizational skills; attention to detail
• Ability to resolve project issues effectively and efficiently
• Ability to prioritize workload and consistently meet deadlines
• Experience working with onshore-offshore model

• 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

We are looking for a Node.js Developer responsible for managing the interchange of data between the server and the users. Your primary focus will be the development of all server-side logic, definition, and maintenance of the central database, and ensuring high performance and responsiveness to requests from the front-end. You will also be responsible for integrating the front-end elements built by your co-workers into the application. Therefore, a basic understanding of front-end technologies is necessary as well.

• 2+ years of experience with Node.js/Express.js or similar framework
• 1+ years of experience with MongoDB
• 1+ years of experience creating REST APIs and backend systems
• Experience with Docker is a plus
• Integration of user-facing elements developed by front-end developers with server-side logic
• Writing reusable, testable, and efficient code
• Design and implementation of low-latency, high-availability, and performant applications
• Implementation of security and data protection
• Server Setup/AWS/GCP experience is a plus
• Creating APIs and backend systems
• Scraping sites and creating backend dashboards for data management
• Backend infrastructure management and deployment

Responsibilities:

• Developing and maintaining all server-side network components.
• Ensuring optimal performance of the central database and responsiveness to front-end requests.
• Collaborating with front-end developers on the integration of elements.
• Designing customer-facing UI and back-end services for various business processes.
• Developing high-performance applications by writing testable, reusable, and efficient code.
• Implementing effective security protocols, data protection measures, and storage solutions.
• Running diagnostic tests, repairing defects, and providing technical support.
• Documenting Node.js processes, including database schemas, as well as preparing reports.
• Recommending and implementing improvements to processes and technologies.
• Keeping informed of advancements in the field of Node.js development.

Requirements:

• Bachelor's degree in computer science, information science, or similar.
• At least two years of experience as a Node.js developer.
• Extensive knowledge of JavaScript, web stacks, libraries, and frameworks.
• Superb interpersonal, communication, and collaboration skills.
• Exceptional analytical and problem-solving aptitude.
• Great organizational and time management skills.
• Availability to resolve urgent web application issues outside of business hours.

Office Location: Goregaon Mumbai

Position description:

4+ years of experience in database development.

Primary Responsibilities:

• Understand requirements from front end applications developers
• Write advanced queries, stored procedures, cursors, functions & triggers
• Conduct code reviews
• Work with high-traffic application servers
• Complete understanding of various DB like Postgresql, Mongo DB, MySQL 
• Ability to identify root cause and mitigate issues
• Ability to lead a team of DB developers

Required Skills:

Mandatory: Passionate about sports, Problem solving, Team player, Target & Result oriented, Strong communication skills

Functional: Oracle SQL, PostgreSQL Development - TSQL, Advance Queries, Query Optimization, Stored Procedures, Triggers & Cursors, Database Design, Indexes, Joins, ETL tools like SSAS, SSIS, High Data Volume Processing, DB Backup/Recovery.

• 7 years of hands-on experience on database development
• Very strong and hands-on in Oracle Database and PL/SQL development
• Hands on experience in designing solutions and developing for data migration projects using Oracle PL/SQL
• Experience with Oracle Argus Safety, ArisG and other Safety/Clinical systems
• Working experience in development of ETL process, DB Design and Data Structures
• Excellent knowledge of Relational Databases, Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based) , Object type, Stored Procedures, Functions, Packages and Triggers, Dynamic SQL, Set transaction, pl/sql Cursor variables with Ref Cursor
  Excellent written and verbal communication skills