Technical Consultant

Role: My SQL DBA

Work Location: Noida/Hyderabad

Exp : 3+ Yrs

About the Role:

The ideal candidate would be working on the servers which impact various SaaS AI/ML products and

1000+ models in AI/ML. As a DBA administrator the server support would be provided for various

industry verticals like Finance, Telecom, Travel & Transportation, Healthcare, Government etc. This role

would give an opportunity working on multiple and complex databases for fortune 500 customers which

have impact on their data related to AI/ML products/models of the company.

About the Company:

We are America’s oldest machine learning solutions company. With offices across US, China and India,

we hire people with a broad set of technical and domain skills who can contribute to the creation of

machine learning solutions across verticals such as financial services, telecommunications, healthcare,

consumer products etc.

Preferred Qualification:

(Must have)

· Three years or above working experience, more than two years in MySQL, familiar with MySQL

database architecture.

· Have good experience in database troubleshooting and solutions for the whole system chain,

including OS, Database, storage, network, application, cloud and so on.

· Familiar with SQL tuning, know about how to split large tables in MySQL.

· Familiar with the daily backup and restore operations of MySQL, and know about the HA

principles of MySQL replication and MySQL Cluster. Experience in PostgreSQL is preferred.

· Familiar with Linux operating system, be able to write daily scripts with Shell/Python.

· Experience about NoSQL databases is preferred, such as MongoDB, Redis.

· Experience about distribution databases is preferred, such as Greenplum, Clickhouse.

· Oracle DBA or SQL Server DBA working experience is preferred.

· Careful work, strong sense of responsibility, good learning ability and team spirit.

Responsibilities:

· Responsible for the daily maintenance and troubleshooting for all Databases, such as MySQL

and postgreSQL, make sure all database system running safely and stably.

· Establish MySQL daily backup and recovery policies, and data security policies.

· Responsible for the design and implementation of Database tables, and large table split policy.

· Provided daily support to the development team and application team, such as database design

specification and performance tuning suggestions.

We are seeking a motivated and detail-oriented Intern to join our Talent Acquisition team. This internship offers hands-on experience in the recruitment process, from sourcing candidates to coordinating hiring processes. An ideal candidate is eager to learn, highly organized, and passionate about Talent Acquisition.

Key Responsibilities:

• Assist in sourcing and screening candidates through job portals, LinkedIn, and social media.
• Support the team in reviewing resumes and conducting initial candidate assessments.
• Maintain and update the applicant tracking system (ATS).
• Post job openings on various job boards and company career pages.
• Schedule and coordinate interviews between candidates and hiring managers.
• Provide administrative support to the recruitment team.

Qualifications & Skills:

• MBA in HR / Business Administration, or a related field.
• Strong communication and interpersonal skills.
• Detail-oriented with excellent organizational abilities.
• Ability to handle confidential information with professionalism.
• Proficiency in Google Suite or Microsoft Office (Word, Excel, Outlook).
• Familiarity with LinkedIn and job portals is a plus.

Job Description

Modules: Global HR, Absence Management, Payroll, Talent management, Goals and performance Management.

Skills: functional/configuration skill in both EBS HRMS & Fusion HCM modules

• To design, develop and implement software applications and systems based on users' needs. 
• Understand and analyze the technical specifications and suggest code optimization ideas. 
• Fill timesheets and complete invoicing process on or before the deadline.
• Interact with customers on a need basis and flag any requirements or issues raised by the customer to seniors in the team. 
• Develop software code as per specifications, by understanding customer requirements. 
• Track open tickets/ incidents in the queue and allocate tickets to resources. 
• Constantly review if there is a better way of doing things, which may help with economizing time or money or deliver better to the customer. 
• Adhere to the quality process ¿ update the defect logs, and test scripts, and comply with quality processes and timelines. 
• Perform self-code reviews as per standards. 
• Develop project consolidated status reports and perform all activities related to re-usage, accuracy and efficiency.
• Work alongside others, deliver own goals, and support team members in meeting theirs, thereby contributing to the overall satisfaction of the team. 
• Provide application production support as per process/RACI (Responsible, Accountable, Consulted and Informed) Matrix.

Role Description

We are hiring young and passionate Business Development executive to contribute to the growth of our company. The ideal candidate will have experience in all stages of the sales cycle. They should be confident in building new client relationships and maintaining existing ones. They should have evidence of strong skills and possess good negotiation skills.

You will be part of a talented team that works on mission-critical applications, and your roles and responsibilities include generating leads and business for the organization while providing expertise in the sales and marketing department.

Job Responsibilities

• Good Experience in Lead generations from upwork, GURU and PPH
• Understand the client's requirements and acquisition.
• knowledge related to all modern technologies required for web and mobile apps development.
• Excellent communication skills (Written and verbal) are required.

Benefits:

• Rotational shift/ as per business requirements
• 5 days a week
• Performance bonus

Mactores is a trusted leader among businesses in providing modern data platform solutions. Since 2008, Mactores have been enabling businesses to accelerate their value through automation by providing End-to-End Data Solutions that are automated, agile, and secure. We collaborate with customers to strategize, navigate, and accelerate an ideal path forward with a digital transformation via assessments, migration, or modernization.

We are looking for a DataOps Engineer with expertise while operating a data lake. Amazon S3, Amazon EMR, and Apache Airflow for workflow management are used to build the data lake.

You have experience of building and running data lake platforms on AWS. You have exposure to operating PySpark-based ETL Jobs in Apache Airflow and Amazon EMR. Expertise in monitoring services like Amazon CloudWatch.

If you love solving problems using yo, professional services background, usual and fun office environment that actively steers clear of rigid "corporate" culture, focuses on productivity and creativity, and allows you to be part of a world-class team while still being yourself.

What you will do?

• Operate the current data lake deployed on AWS with Amazon S3, Amazon EMR, and Apache Airflow
• Debug and fix production issues in PySpark.
• Determine the RCA (Root cause analysis) for production issues.
• Collaborate with product teams for L3/L4 production issues in PySpark.
• Contribute to enhancing the ETL efficiency
• Build CloudWatch dashboards for optimizing the operational efficiencies
• Handle escalation tickets from L1 Monitoring engineers
• Assign the tickets to L1 engineers based on their expertise

What are we looking for?

• AWS data Ops engineer.
• Overall 5+ years of exp in the software industry Exp in developing architecture data applications using python or scala, Airflow, and Kafka on AWS Data platform Experience and expertise.
• Must have set up or led the project to enable Data Ops on AWS or any other cloud data platform.
• Strong data engineering experience on Cloud platform, preferably AWS.
• Experience with data pipelines designed for reuse and use parameterization.
• Experience of pipelines was designed to solve common ETL problems.
• Understanding or experience on various AWS services can be codified for enabling DataOps like Amazon EMR, Apache Airflow.
• Experience in building data pipelines using CI/CD infrastructure.
• Understanding of Infrastructure as code for DataOps ennoblement.
• Ability to work with ambiguity and create quick PoCs.

You will be preferred if

• Expertise in Amazon EMR, Apache Airflow, Terraform, CloudWatch
• Exposure to MLOps using Amazon Sagemaker is a plus.
• AWS Solutions Architect Professional or Associate Level Certificate
• AWS DevOps Professional Certificate

Life at Mactores

We care about creating a culture that makes a real difference in the lives of every Mactorian. Our 10 Core Leadership Principles that honor Decision-making, Leadership, Collaboration, and Curiosity drive how we work.

1. Be one step ahead

2. Deliver the best

3. Be bold

4. Pay attention to the detail

5. Enjoy the challenge

6. Be curious and take action

7. Take leadership

8. Own it

9. Deliver value

10. Be collaborative

We would like you to read more details about the work culture on https://mactores.com/careers 

The Path to Joining the Mactores Team

At Mactores, our recruitment process is structured around three distinct stages:

Pre-Employment Assessment: 

You will be invited to participate in a series of pre-employment evaluations to assess your technical proficiency and suitability for the role.

Managerial Interview: The hiring manager will engage with you in multiple discussions, lasting anywhere from 30 minutes to an hour, to assess your technical skills, hands-on experience, leadership potential, and communication abilities.

HR Discussion: During this 30-minute session, you'll have the opportunity to discuss the offer and next steps with a member of the HR team.

At Mactores, we are committed to providing equal opportunities in all of our employment practices, and we do not discriminate based on race, religion, gender, national origin, age, disability, marital status, military status, genetic information, or any other category protected by federal, state, and local laws. This policy extends to all aspects of the employment relationship, including recruitment, compensation, promotions, transfers, disciplinary action, layoff, training, and social and recreational programs. All employment decisions will be made in compliance with these principles.

As an Associate Software Engineer, you will have the opportunity to collaborate on the creation and maintenance of scalable, high-quality software as we grow. You'll work closely with the CTO and quickly gain skills and responsibilities as the team and the technical requirements grow.

Primary Responsibilities

• Develop RESTful APIs leveraging Django classes, ORM and Postgres Database
• Develop solutions that meet business objectives while leveraging industry best practices
• Write high-quality source code to program complete applications within deadlines
• Troubleshoot and debug applications

Technical Competencies

• Expertise with Python language
• Experience with Django: maintaining APIs
• Familiarity using Git, code repositories, branching and merging strategies
• Ability to break down complex concepts, tasks, or problems into more simple, understandable language and action plans
• Excellent communication skills, and attention to detail
• Good Documentation skills

Perks

• Work from home
• Flexible work schedule
• Flexible standup meetings

Interview Process

• Two technical rounds with Senior Developer and CTO
• Cultural Fit interview with Project Manager

Please do not apply if you don't have professional Django work experience.

• 2+ years of relevant experience in Android Development.
• Should be strong in Android fundamentals (including UI design), OOP & Java fundamentals.
• Should be strong in Kotlin fundamentals and coroutines.
• Familiar with Android Architectures, Multithreading Concepts, Testing framework like JUnit, Espresso, Mockito and Reactive Programming.
• Familiar with Dependency Injection and memory optimization techniques.
• Practitioner of SOLID principles.
• Working experience in Compose and KMM (Kotlin Multiplatform Mobile) is an addon
• Should have been part of a team which has shipped at-least one App and lived through the process without too many scars
• Stellar problem solving skills
• Hunger to learn new things and ability to grasp new concepts quickly
• Ability to move quickly without breaking things too much (we are dreamers)
• Passion for developing awesome user experiences
• Ability to work under pressure which is balanced by a sense of responsibility and ownership.

Qualification Required:

• Minimum 2 year of work experience
• Graduate or Diploma in related field
• Relevant experience candidates will be highly preferred

Skills Required:

• Objective c and Swift language Mandatory
• Strong knowledge of Fundamental, Design Pattern,
• iOS framework - Core Data, Core Animation,
• Offline Storage, Threading
• Knowledge of UI / UX Standards, Apple Design Principles and Interface Guidelines
• Understanding of code versioning tool Git
• JSON, Xml Reading, Rest API calling, Push Notification, cocoa pods, cocoa-touch

What to Expect:

• Flexible Approach when working in a team
• Time management skills and ability to do multitasking
• Accuracy and attention to details
• Candidates with self-motivation & Dedicated towards work
• Should be able to handle iOS Development projects from the first day

Benefits:

• Enjoying and friendly work environment
• 21 paid leaves in a year
• Good career growth opportunities and can a long-term association with the organization
• Fixed yearly appraisals based on performance
• No Formal dress code policy (Decent Casuals is ok with us)
• Company follows Flexi hours Policy