Part time or Work form home

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.

Job description – Sales & Partnerships

The goal of the role is to start and run the off-line Business Development function, to drive the company’s growth and brand presence. This is a new company function, giving you the opportunity to break new ground for the brand and be a driving force for the company’s success.

Responsibilities:

• Create and maintain a database of existing and new clients with complete details for e.g. City, Size bought, spending attributes, etc. 
• Actively reaching out to existing customers.
• To provide great customer service by sending recommendations based on customer’s size, preference and design styles
• To build strong rapport with customers to achieve sales target
• Maintain continuous relationships with existing clients, at our Store, via what’s app and email
• Achieve monthly sales targets
• Dealing with customer complaints and suggesting solutions
• Taking full ownership from beginning to the end of the direct to customer sales partnership cycle.
• Build and keep long-term relationships with customers.
• Represent the company at exhibitions and events.
• Create and share performance & sales reports with the founder
• Analyzing sales date and patterns and adapting sales strategy
• Develop a deep understanding of the product USP’s and integrate them across various content avenues to increase sales.
• Come up with extraordinary Advert ideas that convert sales
• Drive revenue growth objectives
• Lead generation through new business and existing, retained clients.
• Develop, implement, and manage a thorough and consistent process with appropriate metrics for pipeline management?
• Be on top of relevant market trends, client needs, expectations and opportunities as well as shifts in the competitive landscape.
• Create new partnerships across India with offline stores based on brand positioning – more offline marketing?
• Conceive of and execute innovative partnership ideas. – marketing?

Ideal candidate

• 2+ years’ experience in Business Development, B2C Sales, Marketing or similar roles.
• A proven track record of winning new business to deliver growth.
• Possess a strong designer ladies fashion flare and passion
• Display a driven mentality and be able to tell us how you achieve your targets.
• A strong brand and product sensibility.
• Strong communication skills to build relationships with customers, a variety of partners and clients.
• A degree in Business, Sales, Marketing, or a related field 
• A background in eCommerce, Luxury, Fashion or other creative industries is ideal

Designation – Technical Specialist L-2

Employment Type – Permanent

Education – Technical Graduate |Graduate / 12th+ Diploma.

Experience – 3 to 5 Years

Location – Bandra, Mumbai

Working – Monday to Friday

Joining – Immediately

Essential Duties and Responsibilities: (Additional duties may be assigned as required)

• Intermediate Troubleshooting of network-related incidents (link outages, peer outages, router/switch/firewall hardware failures, multicast and broadcast issues, network performance issues).
• Responsible for managing /configuring / Troubleshooting Proxy Overviewing Routing & Switching Responsible for managing /configuring / Troubleshooting Load Balancers/ Web Application Firewall, IPS/ IDS,
• Responsible for managing /configuring / Troubleshooting Proxy
• Ability to prepare SOP/HLD/LLD Documentation and Presentation.
• Work and resolve incidents with proper technical updates and artifacts Preparing a Plan of Action for Activities and New Implementations.
• Working closely with the customer IT team and collaborating with other IT staff Strict adherence to customer policies and processes Continuous guidance to the L1 team.

Required Skills: - Any 2 or more

• Proxy (Blue Coat/TrendMicro/Force point etc)
• IPS/ IDS, Proxy
• Network Devices (such as Web Proxy, micro-segmentation, DDos)
• Load Balancer (F5 / Netscaler / Array / Radware/Citrix etc)
• WAF (F5/ Netscaler / Radware/Citrix etc

Industry

• Human Resources

Employment Type

Full-time

Our Coffee is roasted in New Delhi, the centre of a new specialty coffee revolution. Experience something beyond jut a cup of caffeine.

Our coffee story is much wider, much higher and much deeper than meets the eye. We began in-depth coffee roasting during the worldwide lockdown caused by covid-19 pandemic and lass than 5 month late we founded Saltoro Coffee Roasters with an aim to serve the people great tasting coffee cultivated by Indian farm and roasted to perfection to get the quality products.

Overview: Saltoro Coffee Roasters is a boutique coffee roasting company that is passionate about sourcing, roasting, and delivering the finest quality coffee beans. With a commitment to excellence and a deep appreciation for the art of coffee, we aim to provide coffee enthusiasts with an exceptional and flavorful experience in every cup.

Responsibilities:

Lead Generation: Identify potential clients or customers through various means, such as cold calling, networking, market research, and online lead generation tools.

Market Research: Analyze market trends, customer needs, and competitor activities to identify opportunities for business growth.

Client Acquisition: Develop and maintain relationships with potential clients, understanding their needs, and presenting solutions that align with the company's products or services.

Sales Strategies: Develop and implement sales strategies and tactics to achieve and exceed sales targets.

Product Knowledge: Acquire in-depth knowledge of the company's products or services and effectively communicate their features and benefits to clients.

Presentation and Pitching: Prepare and deliver persuasive sales presentations and pitches to potential clients.

Negotiation: Negotiate contracts, pricing, and terms with clients, ensuring a mutually beneficial agreement.

Sales Reporting: Maintain accurate records of sales activities, client interactions, and progress toward sales targets. Prepare regular reports for management.

Client Relationship Management: Build and maintain strong relationships with existing clients, ensuring their satisfaction and identifying opportunities for upselling or cross-selling.

Collaboration: Collaborate with internal teams, including marketing, product development, and customer service, to ensure a seamless customer experience.

Feedback Collection: Act as a liaison between clients and the company, collecting feedback and insights to improve products, services, and customer satisfaction.

Key Skills:

Sales Skills: Strong sales and negotiation skills are essential for closing deals and growing revenue.

Communication: Excellent communication skills, both verbal and written, are necessary for conveying product information and building relationships with clients.

Market Research: The ability to conduct market research to identify potential clients and stay informed about industry developments.

Product Knowledge: In-depth knowledge of the company's products or services is crucial for effectively presenting and selling them.

Networking: Building and nurturing relationships with potential clients, industry professionals, and partners.

Adaptability: The ability to adapt to changing market conditions and client needs.

Time Management: Effective time management skills to prioritize tasks and meet sales targets.

Customer Focus: A customer-centric approach, understanding and addressing customer needs and concerns.

Problem-Solving: The ability to identify challenges and propose solutions to meet customer requirements.

Team Collaboration: Collaboration with internal teams to ensure smooth operations and customer satisfaction.

Technological Proficiency: Familiarity with CRM software and sales-related tools for managing client relationships and tracking sales activities.

Data Analysis: Basic data analysis skills to interpret sales data and make informed decisions.

Ethical Conduct: Ethical behavior and integrity in all sales and customer interactions.

Resilience: The ability to handle rejection and persist in pursuing leads and opportunities.

Goal-Oriented: A strong focus on achieving and exceeding sales targets and business objectives.

• System engineering and implementation in Python and Golang.
• Working on performance issues using creative experiments and internally developed product features.
• Research, propose, and integrate relevant open-source projects based on product objectives.
• Write organized, efficient, and well documented Python/Golang code as an example for junior engineers.
• Participation in all levels of product definition, design, implementation, testing, and deployment.
• Must include the ability to discuss abstract system architectures from ideas through implementation and
• creatively apply domain experience to solve technical challenges.
• Mentoring software engineers, fostering an environment of trust and accountability.

• A strong sense of ownership, urgency, and drive. As an integral part of the development team, you will need the
• following skills to succeed.
• Strong Python skills to develop framework(s).
• Hands-on to design & develop re-usable framework components.
• Hands-On experience on developing framework, designing re-usable framework components.
• Experience in engineering practices such as code refactoring, design patterns, design driven
• development, Continuous Integration, building highly scalable applications, application security and functional programming.

• Knowledge of Cloud native would be an advantage.
• Understanding of Kubernetes from Architecture side and also understand the Standard API.
• Code contributed to CNCF or similar community will be plus.
•  Performance benchmarking of K8’s or any cloud will be added     advantage. 

• Deep understanding of technology and passionate about what you do.
• Background in designing high performant scalable software systems with strong focus to optimize
• hardware cost.
• Solid collaborative and interpersonal skills, specifically a proven ability to effectively guide and influence within a dynamic environment.
• Strong commitment to get the most performance out of a system being worked on.
• Prior development of a large software project using service-oriented architecture operating with real time constraints.

• You will get a chance to work on cloud-native and hyper-scale products
• You will be working with industry leaders in cloud.
• You can expect a steep learning curve.
• You will get the experience of solving real time problems, eventually you become a problem solver.

• Competitive Salary
• Health Insurance
• Open Learning - 100% Reimbursement for online technical courses.
• Fast Growth - opportunities to grow quickly and surely
• Creative Freedom + Flat hierarchy
• Sponsorship to all those employees who represent company in events and meet ups.
• Flexible working hours
• 5 days week
• Hybrid Working model (Office and WFH)

• Candidates for this position can expect the hiring process as follows (subject to successful clearing of every round)
• Initial Resume screening call with our Recruiting team
• Next, candidates will be invited to solve coding exercises.
• Next, candidates will be invited for first technical interview
• Next, candidates will be invited for final technical interview
• Finally, candidates will be invited for Culture Plus interview with HR
• Candidates may be asked to interview with the Leadership team
• Successful candidates will subsequently be made an offer via email
• As always, the interviews and screening call will be conducted via a mix of telephonic and video call.

Internship Duties

As with any internship there are a mixture of duties, this internship will include some admin tasks as well as some great HR experience during your internship in a busy HR department.

Duration : 

4 months Internship part time Full time

ROLES AND RESPONSIBILITIES

• Organize and maintain personnel records
• Update internal databases (e.g. record sick or maternity leave)
• Prepare HR documents, like employment contracts and  new hire guides
• Revise company policies 
• Liaise with external partners, like insurance vendors, and ensure legal compliance
• Create regular reports and presentations on HR metrics (e.g. turnover ratios)
• Answer employees queries about HR-related issues
• Assist payroll department by providing relevant employee information (e.g. leaves of absence, sick days and work schedules)

• Participate in HR projects (e.g. help organize a job fair event)

• Gathering payroll data like working hours, leaves and bank accounts
• Screening resumes and application forms
• Assist in end to end recruitment
• Record all resumes and personnel documents in HR electronic files
• File physical HR records in HR filing cabinet
• Liaise with recruitment agencies
• Proof reading and editing consultant profiles
• Liaise with line managers recording HR issues
• Scanning and emailing HR documents
• Create Employee packs
• Coordinate Induction appointments
• Create interview appointments
• Creating job advertisements
• Phone screen applicants
• Data Entry and general administration
• Any extra duties the HR Consultant requires
• Complete appropriate paperwork for new and existing employees
• Send off training invoices to finance and liaise with them about getting it approved

• Provide administration support
• Corporate Tie ups via email, Linkedin, social media and calling for Placements 

• Understanding the product platform and its value add for related businesses
• Preparing monthly/quarterly/annualreports
• Perform other activities assigned by Management. 
• A flair for establishing an instant rapport with clients.
• Dynamic, aggressive, result oriented and a self-starter.
• Knowledge of MS office and related tools

Required Experience, Skills and Qualifications

Qualification: MBA-HR

Stipend-3000

Skills- Interpersonal skills, Communication skills, convincing skills.

• Creating, designing and developing data models
• Prepare plans for all ETL (Extract/Transformation/Load) procedures and architectures
• Validating results and creating business reports
• Monitoring and tuning data loads and queries
• Develop and prepare a schedule for a new data warehouse
• Analyze large databases and recommend appropriate optimization for the same
• Administer all requirements and design various functional specifications for data
• Provide support to the Software Development Life cycle
• Prepare various code designs and ensure efficient implementation of the same
• Evaluate all codes and ensure the quality of all project deliverables
• Monitor data warehouse work and provide subject matter expertise
• Hands-on BI practices, data structures, data modeling, SQL skills

Hard Skills for a Data Warehouse Developer:

• Hands-on experience with ETL tools e.g., DataStage, Informatica, Pentaho, Talend
• Sound knowledge of https://www.freelancermap.com/it-projects/sql-1084" target="_blank">SQL
• Experience with SQL databases such as Oracle, DB2, and SQL
• Experience using Data Warehouse platforms e.g., SAP, Birst
• Experience designing, developing, and implementing Data Warehouse solutions
• Project management and system development methodology
• Ability to proactively research solutions and best practices

Soft Skills for Data Warehouse Developers:

• Excellent Analytical skills
• Excellent verbal and written communications
• Strong organization skills
• Ability to work on a team, as well as independently