
Database Developer
at A subsidiary of a US firm , based out of Gurgaon.
Designation: Database Developer
Job Description
As a Database Developer at our company, you will be responsible for designing, testing, planning, implementing, protecting, operating, managing and maintaining our company's databases.Communication and organization skills are keys for this position,along with a problem-solution attitude. Ultimately, you should be able to ensure our database systems run effectively and securely on a daily basis
Requirement:
-
4 - 8 years of relevant experience in database management in Postgresql and at least 1 year of working experience in an AWS environment.
-
Hands on experience in database development working with PostgreSQL including stored procedures, functions, triggers, and views.
-
Experience working with Windows and Linux systems in a production setting.
-
Working knowledge of handling batch bulk data loads.
-
Proactively adopt new cloud infrastructure and technology.
-
Manage environments in AWS to ensure optimal capacity, performance, security, and availability.
-
Exposure to ElasticSearch, Snappy data is a plus.
-
Must have working knowledge of handling Disaster Recovery and Business Continuity in the AWS cloud.
-
Knowledge of JSON and PostgreSQL support for JSON.
-
Ability to efficiently write database code without compromising data quality, privacy or security.
-
Knowledge of database design principles,queryoptimization,index management,integrity checks, statistics and isolation levels
-
Experience with DB migration projects added advantage

Similar jobs
Minimum exp: 2 years (Full-time)
Primary and Must have skills:
- Deep hands on working experience in Node. JS
- Firebase functions like notifications, real-time data update etc.
- Html, CSS, JavaScript, Jquery
- Firebase, AWS/Heroku, SQL/NoSQL Databases with Server side integration
- Can create and implement API on node js.
- API development and management
- Documentation & Efficient Code Management
- Handled large amounts of firebase data in the reporting backend
- Product Management & Product Ownership Orientation
Good to have skills (Additional):
- Online payment systems,
- Online Learning platforms
- Licensing, Encryption, Reporting & Analytics
Personality skills:
- Non Distracted, Focussed and Disciplined
- Analytical, Problem-solving and Calculative aptitude
- Humility to Learn, share & keep improving
- Professional, Organized & a Team Player
- Understands importance of excellent and proactive communication in all formats
About iDream Education:
Our Roots and Vision
iDream Education is an ed-tech startup with a vision to facilitate universal access to learning and growth. Our solutions are designed to break the learning barriers of languages, boards, location or socio-economic status, and empower everyone to Learn Unlimited.
Our Core Values and Work Principles
At iDream Education, we are a purpose driven startup and are building a team aligned to our vision, culture and values.
Our core work values & principles are:
- Oneness - We believe in the fundamental oneness of all existence, and all our work, solutions, designs, content and business approach is based on this underlying principle of Oneness.
- Equal Opportunities - We stand for equal growth opportunities for everyone in the company and in our user/partner/customer ecosystem.
- Always Learning - Our culture is to always keep learning and improving with humility and self confidence.
- Exponential Growth & Evolution - We aspire the company, our team members and our users to grow exponentially in all dimensions and keep evolving everyday.
- Collective Responsibility - Our culture aspires to empower every team member to take ownership and responsibility of the collective vision and its manifestation.
Skills, Experience & Personality Fitment for this Profile
- Deep and Practical experience with Node. JS (primary work component), Firebase, AWS/Heroku, SQL/NoSQL Databases with Server side integration.
- Minimum of 2 years of deep hands-on experience with web based solutions, backend development, APIs and web development in node.JS, firebase, basic understanding of android and flutter will be a plus but not necessary.
- Should have worked on a web based backend in Node.JS for preferably an android app based solution which had scaled to a large number of users. Developed, managed and scaled usage/analytics and reporting of end user based solutions.
- Capable of creating and implementing API on node js. Should have deep hands-on experience in developing and managing APIs.
- Should have practical experience of integrating and managing online payment systems, and build and manage online learning platforms with login, video security, online payment and reports.
- Possess energies and capabilities to experience tremendous growth in learning, deep dive development, take end to end responsibility of the products and join hands to scale our solutions together with our team.
- Personality Traits we respect - An undistracted mind, an aspiration for holistic growth, humility, discipline, clear and adequate communication and self confidence to learn and do anything.
Role and Responsibilities of this Profile
- You shall be working on and taking responsibility for our central content and reporting backend, which is the heart of our tech platform.
- Should have good command on Firebase functions like notifications, real-time data update etc.
- The backend shall be evolved into a content integration platform with internal teams and external partners working on a common backend for all content and courses updation, integration and management.
- You shall be responsible for taking ownership of the current web and backend solutions and defining, building and scaling them as per growth plans along with the product managers and the current team.
- All web and server side development and enhancements as per product growth vision and management plans.
- Please know that we are in a growth stage of our app and tablet based products and therefore a lot of responsibility and ownership taking work will be expected on the tech and product front.
Some Important Aspects of this Profile you should know
- This role would involve a lot of self-driven sharp and focussed work with end-to-end responsibility of the products.
- We are in a fast growth phase and therefore the need of the hour is a hands-on and fast paced approach to work with best of skills/communication and discipline.
- This role requires very responsible and efficient communication in all formats, verbal, written, messaging, email and documentation.
- This role suits you best if you wish to do deep and focussed work in a product company and be a part of the initial core team that builds a globally scalable edtech platform.
- We aspire to onboard a Node.js developer who wishes to spend at least 2-3 years in deep product building/scaling and gain unprecedented experience and growth while growing the products and iDream Education.
Job Type: Full-time, Work at office (Please note, this is not a remote working role / No Work from home for this role currently)
Job Location: Sec-32, Gurugram, India
Remuneration: The CTC will be a combination of fixed monthly salary plus an annual bonus. Proposed CTC would be depending on the experience and fitment.Skills:
Strong knowledge of MYSQL/PostGreSQL; Knowledge of MongoDB, Redis, Couch DB is preferred.
Expertise in application development, databases, version control, and deployment. Skill - Node.js,
Experience of AWS or GCP - especially services such as Lambda or google app engine
Solid grasp of Service-oriented architecture. Web Services implementation on a medium to large scale
Solid understanding of scaling mobile app services. Having worked the backend of an Android app is preferred
Culture:
Ability to work independently with minimal supervision
Happy to deal with, and contribute to, an environment of daily builds Has worked in small teams, is versatile. Work within short timelines and be receptive to business needs. Can work closely with Digital, Product, Operations teams.
Desirable Social Attributes:
Has contributed to one or more Open Source projects through own initiative. Has provided a high quality answer to a question posted on StackOverflow.
Role:
As a Software Developer who would work independently, the candidate is expected actively acquire problems and deliver solutions as well as guide the team technically. Such a problem solver would obviously be a self starter with a high level of curiosity rather than a programming language specialist.
He/she would be required to produce software of the highest quality through self-discipline, clear and engaged communication, and attention to detail. The role would include custom web application development on (most typically on Node.js and PHP/Python), databases (most typically MySql and MongoDb), version control (github), testing (necessarily through test scripts written before code is written), daily builds and eventual deployment onto AWS or GCP.
Attributes of the ideal candidate:
Highly productive software developer with the proven aptitude to understand and apply technology
Determination to succeed despite obstacles and challenges, and a positive attitude favoring achievement of goals over open-ended investigation
Always learning, evolving, and sharing what you know
Inspired by complex, varied problems and rapid change
Open-minded, flexible, and curious about new and better ideas
JOB DESCRIPTION
Nature of Work:
This being an advanced level position in the S/W development team the individual is expected to:
∙ Participate as a team member in all phases of the S/W lifecycle, including the analysis and design of S/W systems.
∙ Participate in a detailed level of coding, code walk – through and unit testing of S/W modules.
∙ Participate in integrated testing of product/ package.
∙ Participate in difficult and typical coding assignments with responsibility of a small module consisting of 3 – 5 members.
∙ Participate in exploration/ feasibility study of products.
∙ Have a thorough understanding of the assigned product/ project.
∙ Participate in generating technical documentation of products/ packages.
∙ Providing technical training to the juniors.
∙ Manage allocated resources, keep compliance with discipline and decorum of the organization.
∙ Keep compliance with Systems and Procedures.∙ Thorough knowledge of current technological trends in Web based Software
∙ Strong Working knowledge of JSF/JSP, Servlets, Spring, Web application development and Core Java
• Working knowledge of working with databases using EJB.
• Knowledge of Bug Tracking tool such as Jira, Bugzilla and source code version control systems (SVN, GIT)
• Knowledge of working in Scrum methodology.
• Good to have knowledge of SonarQube and Web Security Aspects.
• Knowledge of Responsive Front End Development using HTML5, JavaScript, CSS3, JQuery, Ajax and JSON.
• Should be able to write test cases for the feature.
∙ Ability to gather and analyze data & draw logical conclusions
∙ Understanding of company’s vision & goals, business operations∙ Clear and concise oral and written communication skills
∙ Ability to establish and maintain effective work relationships at
all levels
∙ Great passion for S/W development.
∙ Ability to mentor and guide the juniors. Java/J2EE with strong SpringBoot
Very good knowledge of using annotations with SpringBoot
Very good knowledge of using java functional programming concepts in
SpringBoot
Should have database knowledge
Knowledge of Spring Cloud would be a plus.
ROLES & RESPONSIBILITIES
Hands-on experience in Core Java, J2EE, Jasper, Spring, Spring Boot,
Spring Security.
Hands-on experience in Front-end technologies like JavaScript
Understanding of HTML5, CSS3, BootStrap, Material UI, and CSS preprocessors including Sass and LESS.
Understanding of basic prototype design and UI /UX design.
Exposure to working with datastores - SQL or NoSQL.
Good understanding of coding standards & best practices.
Good communication skills
• Microsoft: http://asp.net/" target="_blank">ASP.NET Core, Azure, C#/Web API
The key aspects of this role:
- Candidate with exceptional programming skills, problem-solving abilities and strong work ethic.
- The candidate has to work on custom programming and web application development for Drupal.
- Testing, maintenance and troubleshooting of existing company sites and resolving issues if any.
- Contributing ideas and efforts towards internal projects and working as part of a team to find solutions on various problems.
- Communicate technical ideas to business users and other teams (design, QA). • Collaborate with team members and to work independently when needed. • Eager to embrace current and emerging web technologies.
To be the right fit, you'll need:
- Experience of total 4+ years working on PHP and Drupal 7,8 Development (at least 2+ years in Drupal 8)
- Strong knowledge of MySQL, jQuery, HTML5, CSS
- Experience with Drupal architecture, best practices and coding standards
- Knowledge on Views, Services etc.
- Experience in custom module and theme creation
- Familiar with sub version control systems such as Git or SVN
- Basic knowledge of environment setup for Linux distribution
Primary Duties
• Build a broad knowledge across various systems and processes via knowledge transfer and capture any missing information on the wiki
• Gather software requirements by talking to various stakeholders and document them
• Implement software solutions after discussing the requirements and taking direction from the Technical lead and talking to other colleagues within and outside the team
• Provide necessary effort and time estimates for tasks to aid scheduling and prioritization
• Provide necessary 3rd line support to the Operations teams including software fixes as needed
• Work on any BAU development activity including on-boarding new data sets and delivering new markets into the system
• Work with external vendors from time to time to gather necessary requirements for new data or changes to existing data specifications
• Maintain pro-active communication with relevant stakeholders and keep them updated on progress
General
- Any other duties commensurate with the post holder’s position and seniority; and
- All employees should understand that it is their personal responsibility to comply with all organisational, statutory and regulatory policies and procedures.
Experience, Knowledge & Skills
Essential
- 4+ years’ experience of programming in Java.
- 4+ years’ experience working with SQL including complex queries, stored procedures, views, database design and solid understanding of database concepts (preferably SQL Server)
- Experience of both Linux and Windows environments, scripting and tools
- Willing to carry out operational data tasks alongside developing new solutions
- Well organised with the ability to prioritise and manage multiple streams of work
- Excellent communication skills
Beneficial
- Experience working with Cloud environments (preferably AWS)
- Experience in handling financial data sets and familiarity with financial instruments (equities, futures, FX)
- Experience working with data pipelines and building ETL solutions
- Experience working with tools like Flink, Kafka and Tableau
Educational & Professional Qualifications
- Educated to degree (or equivalent) level or higher.
- A degree with mathematical and computing content (e.g. Computer Science, Maths, Physics)
What essential skills you need
▪ 8-11 years’ experience in back end Java/J2EE application development.
▪ Expertise in developing internet web applications using Java/J2EE technologies.
▪ Experience of working in a service-oriented architecture and web-based development.
▪ Experience in writing XSD, Wiz-dull including parsers like SAX, DOM.
▪ Experience in different modules of Spring framework like Dependency Injection (IoC), Spring MVC, Spring ORM along with JPA.
▪ Experience in Java Version 7.0+. Good experience with JMS, Spring & Hibernate.
▪ Experience in identifying database solutions for a given problem, preferably MySQL.
▪ Demonstrated ability to analyze business/functional requirements, develop well-structured, maintainable code, delivered on time, with automated tests. We are an XP/Agile development team.
▪ Hands on experience on tools like Log4j, JUnit, Mockito, SVN, Maven, Covertura.
▪ Knowledge in Java queuing system.
▪ Extensive Experience in using MVC (Model View Controller) architecture for developing applications using JSP, JSTL, Java Beans and Servlets.
▪ Hands on experience in using Application/Web servers like JBoss and Tomcat servers. Worked on databases like Oracle/MYSQL/NoSQL/HQL.
▪ Experience with e-commerce, retail, analytics, advertising, or media would be an advantage
Aimed at building a massive parallel economy, This For That, is looking for highly driven engineers to build out a world class product. The product is in its early stages so there’s a lot to learn and build from scratch. You will get to work alongside seasoned business and marketing professionals and become part of the core engineering team.
Ideal skills:
1) 2-5 years of professional JavaScript development experience
2) Understanding of asynchronous programming and its quirks and workarounds
3) Comfortable working through the entire stack from the user interface through systems levels
4) Understanding accessibility and security compliance
5) Strong Logical and Analytical Skills
6) Experience in consuming web services (REST) and processing data (JSON)
7) Experience with SQLite, NoSQL, Redis or other databases
8) Proven experience in building API services using NodeJS Express and related frameworks
9) Good understanding of NodeJS asynchronous runtime
10) Good understanding of JS concepts on callbacks and closures
11) Experience in debugging issues related to memory leaks
12) Experience in building highly scalable and high throughput services with sub-second response times
13) Experience with ElasticSearch/Solr
14) Experience working in a collaborative team environment
15) Ability to understand and analyse issues across multiple vendors and interfaces
16) Experience with NoSQL queries
17) Experience with AWS
18) Experience in managing/mentoring small teams
In depth knowledge of all of the above is not mandatory but the nature of the work will involve learning and getting involved with all of the above. You would be working directly with key members of the management team to define and drive technical strategy.
Experience in the mobile space is mandatory. Please only apply if you have been part of building a mobile product. Since our product is mobile only, it is essential that you understand implications on the front end.








