
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
Job Description :
Job Title : Data Engineer
Location : Pune (Hybrid Work Model)
Experience Required : 4 to 8 Years
Role Overview :
We are seeking talented and driven Data Engineers to join our team in Pune. The ideal candidate will have a strong background in data engineering with expertise in Python, PySpark, and SQL. You will be responsible for designing, building, and maintaining scalable data pipelines and systems that empower our business intelligence and analytics initiatives.
Key Responsibilities:
- Develop, optimize, and maintain ETL pipelines and data workflows.
- Design and implement scalable data solutions using Python, PySpark, and SQL.
- Collaborate with cross-functional teams to gather and analyze data requirements.
- Ensure data quality, integrity, and security throughout the data lifecycle.
- Monitor and troubleshoot data pipelines to ensure reliability and performance.
- Work on hybrid data environments involving on-premise and cloud-based systems.
- Assist in the deployment and maintenance of big data solutions.
Required Skills and Qualifications:
- Bachelor’s degree in Computer Science, Information Technology, or related field.
- 4 to 8 Years of experience in Data Engineering or related roles.
- Proficiency in Python and PySpark for data processing and analysis.
- Strong SQL skills with experience in writing complex queries and optimizing performance.
- Familiarity with data pipeline tools and frameworks.
- Knowledge of cloud platforms such as AWS, Azure, or GCP is a plus.
- Excellent problem-solving and analytical skills.
- Strong communication and teamwork abilities.
Preferred Qualifications:
- Experience with big data technologies like Hadoop, Hive, or Spark.
- Familiarity with data visualization tools and techniques.
- Knowledge of CI/CD pipelines and DevOps practices in a data engineering context.
Work Model:
- This position follows a hybrid work model, with candidates expected to work from the Pune office as per business needs.
Why Join Us?
- Opportunity to work with cutting-edge technologies.
- Collaborative and innovative work environment.
- Competitive compensation and benefits.
- Clear career progression and growth opportunities.
Responsibilities :
- Set up marketing email automation.
- Deploy emails and email templates and analyze results.
- Set up marketing landing pages, product carts, and coupons.
- Analyze revenue from marketing campaigns and produce reports, including updates on the progress towards goals for new subscribers and renewal marketing and recommendations for improvements.
- Assist with maintaining, updating, and ensuring the accuracy of our marketing database and lists.
- Maintain and manage lead gen efforts.
- Collaborate with other team members and departments on marketing projects and opportunities.
- Write and edit marketing copy, messages, and campaigns.
- Set up print marketing materials.
- All other responsibilities as assigned.
Requirements :
- An associate degree or higher, preferably in marketing or a related field
- Excellent written and verbal communication skills
- Excellent ability to write and edit marketing copy
- Experience with email marketing
- Knowledge of basic HTML
- Ability to work in a fast-paced environment


That can include the following tasks:
- Develop and revamp creative, eye-catching websites as per the client's needs.
- Work with project managers to discuss the desired website functionality and provide solutions.
- Integrate custom templates/themes into WordPress.
- Work with various WordPress third-party plugins (Like WooCommerce, Buddypress, Elementor, and others) and customize when required.
Skills:
- Knowledge of WordPress Architecture, WooCommerce, Page Builder’s (like Elementor, Divi, Visual Composer etc), and other best practice solutions
- Knowledge of PHP, MySQL, HTML, CSS, Javascript/jQuery.
- Knowledge of child theme creation and customization as per designed based on the requirements
- Knowledge of WordPress plugin and back-end development
The ideal candidate will have strong creative skills and a portfolio of work which demonstrates their passion for illustrative design and typography. This candidate will have experiences in working with numerous different design platforms such as digital and print forms.
Responsibilities
Collaborate with the team to ensure consistency of designs across various media outlets Create compelling and effective logos, designs, print and digital media Maintain awareness of current industry and technology standards, social media, competitive landscape and market trends
Qualifications
Bachelor's degree in Graphic Design or related field 3-5 years of experience in graphic design Proficient in Adobe Creative Suite Strong communication, conceptual thinking, typography skills and design skills Portfolio of work

Responsibilities
- Build pixel-perfect, buttery smooth UIs across both mobile platforms.
- Leverage native APIs for deep integrations with both platforms.
- Diagnose and fix bugs and performance bottlenecks for performance that feels native.
- Reach out to the open source community to encourage and help implement mission-critical software fixes—React Native moves fast and often breaks things.
- Maintain code and write automated tests to ensure the product is of the highest quality.
- Transition existing React web apps to React Native.
Must skills:
Hands- on in the following:
- Java 8/J2EE
- Spring boot
- Gradle/Maven
- REST API
- ORM- hibernate/ JPA
- Unit Testing and Integration Testing- Junit/ TestNG
Good to have:
Hands-on in the following:
- CI/CD pipeline deployment
- Messaging- ActiveMQ/RabbitMQ/MQ
- DB2
- Kafka
- NoSQL framework exposure
- Ownership of site MES system and provide support to the users for having uninterrupted operations at shop floor using MES
- Set up a fully functional service desk, responsible and accountable for MES support for execution excellence.
- Understand and develop expertise on FTPS- Werum PAS|X application
- Design and simulate Master Batch Records on PAS|X application or Rockwell FTPS platform
- Understand SAP system and interface scenarios between SAP and MES systems
- Liaise between internal teams and external project teams and ensure task completion
- Responsible for the entire MES system through its lifecycle and the associated peripherals used
- Responsible for new project implementation and upgrade projects from requirement gathering stage to qualification and final delivery
- Understanding of 21CFR Part11 requirements for computerized systems and Computer system validation concepts.
- Understand end to the end production process of API Manufacturing
- Provide functional guidance to users working on the application
- Define hardware requirements for implementation of MES system
- Responsible for preparation and execution of MES administration SOPs and roles of a system administrator.
- Coordinating with the vendor support team for issue corrections and implementing corrections/ enhancements and version upgrade of Application in accordance with qualification standards and SOPs
- Interact with the business users to gather, understand the business needs; analyses process documents, analyses workflows, conduct workshops & surveys in order to document the project scope and business requirements
- Works with architects and business partners to identify technical solutions for business process improvements; Solution the client requirements balancing the value proposition and scope.
Hi! If you're selected, the day-to-day responsibilities shall include:
- Researching industry-related topics (combining various online sources and studies)
- Writing high-quality content with impeccable grammar and a unique writing tone, mainly related to home improvement/decor/garden and other closely neighboring markets
- Working on basic SEO and Google Docs for neat formatting, sourcing relevant images for the article, etc.
Note: Candidates who copy-paste content should not apply, plagiarism is checked and strictly prohibited.

