Database Architect & Engineer
Work Mode - Work from Home
Experience Required - 5+ Years
Immediate joiners are preferred.
Job description
Seeking a seasoned Database Architect with expertise in Oracle and/or PostgreSQL, system wide migrations, and complex query creation and optimization. The ideal candidate should have at least 5 years of experience in database management and be able to work independently. Key responsibilities include defining a schema for a new product, managing and maintaining databases, planning and executing system wide migrations, creating and optimizing complex queries, ensuring the security and integrity of the database, and providing training and support to team members. This role requires excellent communication and problem-solving skills, as well as a strong understanding of database architecture, design, and security.
Responsibilities:
- Design, implement, and maintain Oracle and PostgreSQL databases
- Expert in ETL tools, data integration, and migration processes
- Create and optimize complex SQL queries for performance and efficiency
- Develop and refine database functions, procedures, and packages
- Analyze and troubleshoot database performance issues, implementing tuning solutions
- Ensure database architecture aligns with application needs and best practices
- Collaborate with development teams on data models and database design
- Provide documentation, training and support to other team members
- Assure quality, security and compliance requirements are met as part of projects
delivery
Qualifications:
- 5+ years of experience with Oracle and/or PostgreSQL
- Experience in designing database schemas from scratch
- Experience with documentation such as ERDs and DB Relations
- Experience with system wide migrations
- Strong understanding of database architecture and design
- Experience with complex query creation and optimization
- Experience with performance tuning and troubleshooting
- Strong understanding of database security
- Experience with database backup and recovery
- Excellent communication and problem-solving skills
- Bachelor's degree in Computer Science or related field is a plus
- Experience in development of SaaS enterprise scale product
- Experience in working with globally distributed teams following Agile methodology
and Scrum.
- Experience in working with modern CI/CD tools and related ecosystem of
applications - uDeploy, Jenkins, Artifactory, Maven etc.
- Experience using source control tools like Git, SVN etc.
About Immersive Infotech Private Limited
About
Company social profiles
Similar jobs
Roles and Responsibilities
1. Manage client relationships, and facilitators relationship at MHFAI for training and post-training support.
2. Ideate, design, and implement program that focused on post-training support for mental health first-aiders.
3. Leverage the new products of MHFAI to the clients that ensures implementation of mental health by building tools and guidelines (for organized groups).
4. Oversee and facilitate MHFAI instructors for training and upskilling.
5. Monitor and coordinate the MHFAI Awards program with all the stakeholders involved.
6. Draft and initiate scientific research, and create tools required at workplace to measure mental health.
7. Plan and manage webinars, events and activities to promote the idea of mental health at workplaces and educational institutions.
8. Draft, design, manage and implement guidelines / resources with focus on mental health for the benefit of organized groups.
9. Keep up-to-date with the latest trends and best practices in Learning and Development and / or mental health, and incorporate them into our training programs.
10. Manage the Learning and Development budget, ensuring that resources are allocated effectively and efficiently.
11. Provide support in other operational functions of MHFA as needed.
Requirements:
· 10-15 years in clinical work and / or mental health training
· Qualification: Education in Mental Health
· Experience in Clinical Practice / Research
· Exposure to mental health training and created content or training on Mental Health for Adult
· Experience of having previously worked in organized group is desirable
Job Description: Software Engineer
Location: Bangalore
WHO WE ARE :
As part of TIFIN's technology division, you will play a critical role in enabling the company's growth by developing highly scalable applications that provide practical solutions to clients in the financial services- domain. You will design, build, test, and maintain scalable and stable-the-shelf applications or custom-built technology solutions to meet business needs.
OUR VALUES: Go with your GUT
- Grow at the Edge: We embrace personal growth by stepping out of our comfort zones to discover our genius zones, driven by self-awareness and integrity. No excuses.
- Understanding through Listening and Speaking the Truth: Transparency, radical candor, and authenticity define our communication. We challenge ideas, but once decisions are made, we commit fully.
- I Win for Teamwin: We operate within our genius zones, taking ownership of our work and inspiring our team with energy and attitude to win together.
WHAT YOU'LL BE DOING:
- Contribute to the entire implementation process including driving the definition of improvements based on business needs and architectural improvements.
- Review code for quality and implementation of best practices.
- Promote coding, testing, and deployment best practices through hands-on research and demonstration.
- Write testable code that enables extremely high levels of code coverage.
- Ability to review frameworks and design principles toward suitability in the project context.
- Candidates who will demonstrate an ability to identify an opportunity lay out a rational plan for pursuing that opportunity, and see it through to completion.
Requirements:
- Engineering graduate with 3-5 years of experience in software product development.
- Proficient in Python, Django, Pandas, GitHub, and AWS.
- Good knowledge of PostgreSQL, and MongoDB.
- Strong Experience in designing REST APIs.
- Experience with working on scalable interactive web applications.
- A clear understanding of software design constructs and their implementation.
- Understanding of the threading limitations of Python and multi-process architecture.
- Familiarity with some ORM (Object Relational Mapper) libraries.
- Good understanding of Test Driven Development.
- Unit and Integration testing.
- Preferred exposure to the Finance domain.
- Strong written and oral communication skills.
COMPENSATION AND BENEFITS
- Competitive salary, discretionary annual bonus, and ESOP.
- Medical insurance.
- Flexible PTO policy and company-paid holidays.
- Access to our Chief Mindfulness Officer for mindfulness events and 1:1 personal coaching.
Note on Location:
While we have team centers in Boulder, New York City, San Francisco, Charlotte, and this role is based out of Bangalore
TIFIN is an equal-opportunity workplace, and we value diversity in our workforce. All qualified applicants will receive consideration for employment without regard to any discrimination.
. Capability to raise/handle the support tickets presented with the Neo4j support team for product-related issues.
. To assist in planning the backup / HA / DR activities for Neo4j databases.
. Work on new and existing product initiatives and be a driver in the definition of product direction.
. Monitor data release management actions to manage issues as they arise and identify risks and mitigation responses that could impact data analytics customers or stakeholders.
. Partner effectively and influence the team's peers to fine-tune the cipher queries and support them on the static/incremental data loads.
. Take ownership - collaborate with technical and business teams to build innovative and solutions for database problems.
. Who would set the strategy and vision to improve/enhance the database architecture to support the growing data-load
. Capability to design database models and database infrastructure for highly scalable/ reliable applications.
We are looking for an experienced React Native Developer to join the team. The ideal candidate will have experience building and maintaining mobile applications for both IOS and Android.
Responsibilities:
1. Develop new features for existing mobile applications
2. Collaborate with cross-functional teams to define, design, and ship new features
3. Write clean, maintainable, and efficient code
4. Troubleshoot and debug applications
5. Ensure the performance, quality, and responsiveness of applications
6. Continuously discover, evaluate, and implement new technologies
Requirements:
1. Strong proficiency in JavaScript, including knowledge core principles
2. Experience with Redux and other state management libraries
3. Experience with mobile development (iOS or Android)
4. Experience with navigation libraries (e.g., React Navigation)
5. Strong understanding of the mobile app development lifecycle, including experience with the app store submission process
6. Strong communication skills and ability to work well in a team environment
Job Purpose Having quick turnaround and increased test coverage is the need of the hour; hence the increased emphasis on automation testing across projects. Publicis Sapient is looking for automation experts who in addition to the expertise in the tools and techniques also have the knack to understand the business needs, ROI and accordingly create the automation strategy. Assures consistent quality of Software Applications production by developing and enforcing robust Automated Software QE strategy, practices, and processes, providing documentation and managing people. They collaborate the with the project, business and (QE) teams, to develop detailed automated scripts, test frameworks to make the overall system more effective and efficient for our clients. Responsible for the overall quality of the project through effective QE leadership and management to ensure that all deliverables in terms of time, price and quality are met. This individual must have a proven track record of success building, leading, and managing a functional and technical QE team with a strong sense of quality ownership. This is a hands-on job that requires strategic thinking and planning to provide leadership and expertise throughout the entire QA lifecycle, ensuring the success of the team's manual and automation efforts in an agile working environment. Experience Required: 4-9.5 years Role: Senior Quality Engineer Education: Full time Bachelor’s/Master’s engineering degree Role Requirements Technical skills: Must Haves • Experience with QE for distributed, highly scalable systems • Good understanding of OOPS concepts and strong programming skills in Java, Groovy or JavaScript • Hands on experience of working with at least one of GUI based test automation tools for desktop and/or mobile automation. Experience on multiple tools will be added advantage • Proficient in writing SQL queries • Familiarity with process of test automation tool selection & test approach • Experience in designing and development of automation framework and creation of scripts using best industry practices such as Page object model • Integrate test suites into the test management system and custom test harness • Familiar with implementation of design patterns, modularization, and user libraries for framework creation • Can mentor team as well as has short learning curve for new technology • Understands all aspects of Quality Engineering • Understanding of SOAP and REST principles • Thorough understanding of microservices architecture • In-depth hands-on experience of working with at least one API testing tool like RestAssured, SOAP UI, NodeJS • Hands-on experience working with Postman or similar tool • Hands-on experience in parsing complex JSON & XML and data validation using serialization techniques like POJO classes or similar • Hands-on experience in performing Request and Response Schema validation, Response codes and exceptions • Good Understanding of BDD, TDD methodologies and tools like Cucumber, TestNG, Junit or similar. • Experience in defining API E2E testing strategy, designing and development of API automation framework • Working experience on build tools Maven / Gradle, Git etc. • Experience in creating test pipeline – CI/CD Preferred: (Mostly for people being hired at the Senior Associate Career Stage) • Possess domain knowledge to identify issues across those domains, understand their impact, and drive resolution [(familiar / expert in domains like retail banking, automobile, insurance, betting, food-markets, hotel industry, healthcare) • Used /Exposure to automation tool for automating mobile applications • Used /Exposure to automation tool for non-functional testing • To setup test environment for execution on cloud environments such as Sauce labs, browser stack • Knowledge of new tools (open source & licensed) in the automation world and have the knack to explore them and keep abreast with the latest tools in the market • Expertise in creating test automation frameworks, implementing and maintaining them on a project Experience in the modern agile practices such as BDD/Cucumber , Devops • Knowledge and experience in service virtualization and tools like CA Lisa • Hands-on knowledge of setting up PACT Broker and writing PACT tests is desirable • Experience in test management tools like Xray & Zephyr and integration of test framework with these tools • Understanding of commonly used software design patterns like Builder, Factory, Singleton and Façade. Test Management: Must Haves • Able to estimate for low and medium complexity applications and have used at least one of the estimation techniques. • Able to handle/oversight a small team ranging from 2 -5 people and can guide them during the complete SDLC cycle starting from test case creation till test closure activities • Well-versed with the most of the activities in defect management process, can define/enhance the defect documentation and TAR lifecycle process independently • Have expertise to enforce/adhere defect or other processes in the team Preferred (Mostly for people being hired at the Senior Associate Career Stage) • Mentored or coached at least one person • Can define Automation Test strategy and test plan for low and medium complexity applications taking into account the business needs, ROI etc. • Able to maintain and report test coverage matrix • Able to identify device coverage for the application in question. • Can devise regression testing approach Soft Skills: • Possess excellent Communication skills (written, verbal both formal & informal) • Helps to create a positive, collaborative working environment for the team. • Quick grasping and flexibility to adapt to new technologies/processes • Ability to multi-task under pressure and work independently with minimal supervision. i.e. Ability to prioritize when under pressure • Efficiently makes tough decisions and communicates them effectively. • Independently manages operational level client meetings. Develops strong relationships with appropriate client stakeholders. Acts as the primary POC/facilitator for planned (regular) client meetings. Manages peer-level client relationships (expectations, communications, negotiations, escalation, feedback, etc.)
- This position offers lot of learning of various aspects of hiring
- Skills Expected : good communciation skills, fast learner, people skills, prompt and go getter
- Candidates with immediate joining are a plus
- Experience in IT recruitment and senior management recruitment is a plus
We are looking for a full-stack developer with 3+ years of experience in NodeJS and frontend technologies like HTML/CSS/JS + ReactJS + VueJS
- Strong Coding Skills
- Experience building scalable products
- 3+ years of experience in NodeJS with an understanding of callbacks, async/await, promises,
asynchronous functions, usage of third-party libraries, ExpressJS, PassportJS etc
- Good command over Data Structure, Algorithms
- Experience working with NoSQL & SQL Databases like Mysql, MongoDB, ElasticDB, Redis etc
- Good design skills
- The ability to produce bug-free and production-grade code
- Knowledge of Go, Docker and kuberneates is a plus.
We offer a suite of memberships and subscriptions to spice up your lifestyle. We believe in practicing an ultimate work life balance and satisfaction. Working hard doesn’t mean clocking in extra hours, it means having a zeal to contribute the best of your talents. Our people culture helps us inculcate measures and benefits which help you feel confident and happy each and every day. Whether you’d like to skill up, go off the grid, attend your favourite events or be an epitome of fitness. We have you covered round and about.
- Health Memberships
- Sports Subscriptions
- Entertainment Subscriptions
- Key Conferences and Event Passes
- Learning Stipend
- Team Lunches and Parties
- Travel Reimbursements
- ESOPs
Thast what we think would bloom up your personal life, as a gesture for helping us with your talents.
Join us to be a part of our Exciting journey to Build one Digital Identity Platform!!!
About the Company :
Richpanel is the new, modern way businesses provide customer support. We’re on a mission to make customer support fun & personal. We are a team of young, passionate techies, marketers & growth hackers that enjoy building products that people love. Majority of our clients are based out of the US
Company Inception : 2018
Company Website : https://richpanel.com/" target="_blank">https://richpanel.com/
Perks of joining our Company :
- Rockstar Coworkers
- Friendly & Energetic Environment
- 21 paid leaves
- Reward Employees with Experiences
- Free Food & Coffee
- Team Outings from time to time
- Work From Home Option Available
- Treat all employees as equals
Tech Stacks used by us :
Frontend : VueJs
Backend : NodeJs
Key skills: VueJs, HTML5, CSS3, REST Protocols, NodeJs, JEST, GraphQL.
Responsibilities:
- Participation in Company's product and implementation as a Frontend developer.
- Build the front-end for our mobile and web products
- Convert wireframes into working UI interfaces
- Write REST calls to interact with our back-end API
- Participation in research activities.
- Build reusable code and libraries for future use
Requirements:
- Keen design eye to translate wire frames into pixel perfect web pages
- Excellent JSON/DOM manipulation skills
- Should have strong key skills in HTML5, CSS and advanced JavaScript and the ability to turn design mock-ups into great looking sites with user interactions.
- Must also be up-to-date with cross-browser and cross-platform issues, have a good eye for detail and be able to work to tight deadlines
- Experience in building Scalable Apps
- Experience with third- party libraries, social media integration and APIs.
- Work on building product from scratch and improving application performance.
- Should understand and have knowledge on the application security practices/vulnerabilities
- Understands Web Products and understand Performance of the application.
- Linux and Unix Skills
- Hands on experience in collecting and analyzing/improving Application analytics
- Good understanding in User Patterns, CTRs and closely work with UX and Product team in a dynamic environment
- Understanding of server-side CSS pre-processing platforms, such as LESS and SASS
- Proficient understanding of code versioning tools, such as Git / SVN
- Good understanding of asynchronous request handling, partial page updates, and AJAX
Industry Background : Product based startup
Location : Hiranandani - Powai, Mumbai. (Remote working option available for candidates residing out of Mumbai)
Working Days & Timings : Monday to Saturday (Alternate Saturdays off), 12pm - 9pm.
Kindly apply if interested.