Market research Executive

Job Title : Lead Database Engineer

Location : Gurgaon Sector-43

Experience Required : 4+ Years

Employment Type : Full-Time

Summary :

We are seeking a highly skilled Lead Database Engineer with expertise in managing and optimizing database systems, primarily focusing on Amazon Aurora PostgreSQL, MySQL, and NoSQL databases. The ideal candidate will have in-depth knowledge of AWS services, database architecture, performance tuning, and security practices.

Key Responsibilities :

1. Database Administration :

• Manage and administer Amazon Aurora PostgreSQL, MySQL, and NoSQL database systems to ensure high availability, performance, and security.
• Implement robust backup and recovery procedures to maintain data integrity.

2. Optimization and Performance:

• Develop and execute optimization strategies at the database, query, collection, and table levels.
• Proactively monitor performance and fine-tune RDS parameter groups for optimal database operations.
• Conduct root cause analysis and resolve complex database performance issues.

3. AWS Services and Architecture :

• Leverage AWS services such as RDS, Aurora, and DMS to ensure seamless database operations.
• Perform database version upgrades for PostgreSQL and MySQL, integrating new features and performance enhancements.

4. Replication and Scalability:

• Implement and manage various replication strategies, including master-master and master-slave replication, ensuring data consistency and scalability.

5. Security and Access Control:

• Manage user permissions and roles, maintaining strict security protocols and access controls.

6. Collaboration:

• Work closely with development teams to optimize database design and queries, aligning database performance with application requirements.

Required Skills :

• Strong Expertise: Amazon Aurora PostgreSQL, MySQL, and NoSQL databases.
• AWS Services: Experience with RDS, Aurora, and DMS.
• Optimization: Hands-on experience in query optimization, database tuning, and performance monitoring.
• Replication Strategies: Knowledge of master-master and master-slave replication setups.
• Problem Solving: Proven ability to troubleshoot and resolve complex database issues, including root cause analysis.
• Security: Strong understanding of data security and access control practices.
• Collaboration: Ability to work with cross-functional teams and provide database-related guidance.

Preferred Qualifications :

• Certification in AWS or database management tools.
• Experience with other NoSQL databases like MongoDB or Cassandra.
• Familiarity with Agile and DevOps methodologies.

• Key Skills:
• Expert Proficiency in anyone the below programming language - Node JS, PHP or GoLang
• Expert Computer Science fundamentals like Data Structures, Algorithms, Time Complexity, and others
• Strong Microservices, REST API, Git source control, CI/CD, and other latest technology trends
• Strong System Design, DB Design proficiency
• Strong knowledge in Design Patterns, best software development practices
• Good exposure to working in Open Source stack, E-Commerce, or Fintech domain.

JD-

Client relations managers -establish, develop, and nurture lasting relationships with customers

Making sure all the leads of the clients after placing orders are met.

➢ Ensuring your existing clients are satisfied through after-sales service.

➢ Always ask them for true feedback.

➢ Servicing the client after receiving the order till the time of collection

of payment.

➢ Resolve the queries and questions of all the clients.

➢ Give or support the participants/clients about company products or

services.

➢ Acting as a point of contact for complaints and escalating issues to

the concern.

Software Languages: Advanced knowledge of JavaScript, C#, ASP.Net and SQL Server.

Job Responsibilities:

• Gain a clear understanding of customers' businesses and requirements;
• Plan execution methodology and identify fulfillment plan to address the requirements;
• Full lifecycle application development
• Designing, coding and debugging applications.
• Software analysis, code analysis, requirements analysis, software review, identification of code metrics, system risk analysis, software reliability analysis
• Support, maintain and document software functionality
• Programming analytical skill with highly logical and analytical approach
• Manage documentation by working with other teams and consolidating all required types of reports for future use and test case scenarios.
• Ability to visualize data, concepts and work flows to create diagrams, charts and illustrations to supplement documentation.
• Maintain quality service by establishing and enforcing organization standards.
• Maintain professional and technical knowledge by benchmarking state-of-the-art practices.
• Timely reporting to provide visibility of performance to goal.
• Be data driven and flexible to changes with a natural passion for problem solving.
• Maintain professional and technical knowledge by attending educational workshops; reviewing professional publications; establishing personal networks; participating in professional societies.

Key Skills required: 

• 4+ years of rich experience in the software development with advanced knowledge of JavaScript, C#, ASP.Net and SQL Server.
• A self-starter with the ability to work independently and as part of a team.
• Ability to work well in a results oriented environment with firm deadlines;
• Ability to perform multiple tasks effectively while being results-driven and patient
• Able to work both independently and as part of a team
• High degree of attention to detail and trustworthiness
• Strong analytical skills
• Capable of making timely, independent decisions
• Excellent oral, written and interpersonal communications skill
• Ability to think outside the box and generate and implement new ideas.
• Natural interest in team building and leadership with coaching/training skills.
• Excellent organizational skills

Skills  

• Experience in building or implementing requirements on ZOHO CRM plus products, Zoho Creator, Zoho Projects, Zoho Work-drive, Zoho one 
• Experience in writing Zoho custom functions, with a deep understanding of Deluge, preferred 

• Experience and knowledge of relational databases including work with MongoDB, or other common RDBMS 

Job Responsibilities 

• Deliver technology solutions that are critical to the day-to-day operations and continued growth of the business 
• Participate in requirements-gathering sessions with business users 
• Document requirements for new features, data capture, process functions, reports, and training 

• Functional and System Knowledge 
• CRM customization and assisting CRM Implementation 
• Scripting/Configuring in Zoho CRM / Creator / Desk and other Zoho apps 
• Writing custom functions/ basic integrations/testing and implementing extensions custom functions for ZOHO CRM, Creator, and other Zoho Apps 
• Configuring APIs integration with various systems and Zoho Testing, creation of screens, functionality, and UI in Zoho Creator. 

• Understand system integrations and dependencies 
• Analyze the impact of changes on systems and integrations 
• Process mapping and workflow creation 
• Must have a Functional & Technical Understanding of Zoho applications. 
• Managing all Zoho applications for internal teams including - workflows, knowledge base setup, and user access management. 

• Understand requirements by function and setup processes in Zoho 
• Ensure smooth running of existing applications and handle any kind of challenge being faced by the team 
• Setup knowledge for users by the team, to learn and execute their set of processes 
• Identify opportunities for integration with external apps 
• Act as internal Zoho Support/Zoho creator desk to troubleshoot queries/issues 

• Train users to utilize their specific Zoho apps for their use case 
• Planned, implement, and manage process change initiatives with respective department heads. 
• Configuration of core Zoho Applications like CRM, Desk, Creator, Project, Campaign, etc. 
• Act as internal Zoho Support desk to troubleshoot queries/issues. 
• Conduct monthly reviews with teams to understand adoption/improvements 

• Plan, implement, and manage process change initiatives with respective department heads 
• Use data and reports to make evidence-based decisions to increase Zoho adoption 

Desired Candidate Profile 

• Excellent communication skills. 
• Minimum 3 years experience in Zoho Application. 

• Hands-off experience/inclination to work with Zoho applications. 
• Configuration on Zoho CRM, Desk, Project 
• Workflow / Custom Functions / Blueprint configuration on Zoho. 
• Understanding of Business Processes

• • At least 3 to 5 years of experience in .Net.
  • The candidate should be a system thinker.
  • Strong knowledge of at least one of the .NET languages (e.g. C#, Visual Basic .NET) and HTML5/CSS3.
  • Enjoy Event-Driven Design Patterns and Event Sourcing.
  • Familiar with Document Store Databases (like Cosmos DB / Mongo DB).
  • Knowledge in Modular Architecture and Microservices.
  • Comfortable leading large technical projects.
  • Knowledge of any cloud services AWS, Azure, Google Cloud.
  • Good understanding of ASP.NET framework, SQL Server and design/architectural patterns (e.g. Model-View-Controller (MVC)).
  • Experience with architecture styles/APIs (REST, RPC).
  • Understanding of Agile methodologies.
  • Strive for continuous improvement and build continuous integration, continuous development, and constant deployment pipeline (CI/CD Pipeline).

• Bachelor’s Degree in Computer Science or Information Technology
  
  

• Excellent writing skills
• Proficient in Web use, Outlook and Microsoft Office
• Travel as needed

Experience with Hibernate and Spring.

•   Experience with Spring-boot, spring MVC
• Experience with all phases of the Software Development Lifecycle, including system analysis, design, coding, testing, debugging and documentation
• Teamwork & collaboration skills to work across organizations
• Problem solving skills to develop quick yet sound solutions to resolve complex issues
• Programming Language(s): Java, J2EE, JSON, HTML, DHTML, HTML 5, XML, EXTJS.
• Experience with XML/HTTP and Web Services
• Experience with HTML, JSP, CSS, JQuery / Ajax / JSON,
•     Experience /Knowledge of Angular, React.
• Experience building J2EE based Web Applications
• Experience with MySql.