PHP Developer

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.

Requirements:

• 10+ years of software development experience in java.
• Knowledge of multiple front-end languages and libraries (e. g. HTML/ CSS, JavaScript/Typescript, XML, jQuery)
• Familiarity with RESTful APIs.
• Experience with Micro Services based architecture
• Experience with Angular 5 Angular 8 and/or experience with React JS
• Strong debugging/troubleshooting skills.
• Good understanding of SDLC, Agile methodologies
• Proven experience as a Full Stack Developer.
• Experience developing desktop and mobile applications
• Familiarity with common stacks Knowledge of multiple back-end languages (e. g. C#, Java, Python) and JavaScript frameworks (e. g. Angular, React, Node.js )Familiarity with Docker and Kubernetes
• Familiarity with databases (e. g. MySQL, PostgreSQL), web servers (e. g. Tomcat, Apache).
• Excellent communication and ability to lead a 5-10 member team

Responsibilities:

• Responsible for the entire development process for the Internal IP (e.g. Quality Fusion)
• Work with development teams and product managers to ideate software solutions
• Analyzing user requirements, envisioning system features and functionality.
• Design, build, and maintain efficient, reusable, and reliable codes by setting expectations and features priorities throughout the development life cycle.
• Working with Senior leadership and stakeholders to present ideas and solutions
• Design client-side and server-side architecture
• Build the front-end of applications through appealing visual design
• Develop and manage well-functioning databases and applications
• Write effective APIsTest software to ensure responsiveness and efficiency in troubleshooting, debug and upgrade software
• Create security and data protection settings.

• Angular.JS experience
• MongoDB query and aggregation experience (not a database administrator)
• GraphQL experience
• Node.JS and Typescript experience
• CSS and SCSS experience
• CI/CD experience with GitHub actions

• Software development experience, one of Python (preferred) or Node.JS/Typescript)
• Experience with Messaging architectures - RabbitMQ (preference) or Kafka
• Experience with docker-containers 
• Experience with Apache NiFi (valued but not necessary)
• Experience with designing or implementing horizontally scalable solutions
• Experience working with RESTful APIs
• CI/CD experience with GitHub actions
• Experience with Azure cloud

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

RESPONSIBILITIES 

• BA Workstream: Ability to understand the objectives and goals of the project, and to contribute to the development of the project plan through identifying BA scope of work, advocating approach, and methodologies.
• Create BA Work Packages: Ability to breakdown the BA Scope of Work into manageable work packages to support the overall delivery of the plan.
• Scope and document requirements: Ability to understand, capture, and model functional, non-functional (operational), and interface requirements for users of a system.
• Designing and enhancing Business Processes: Ability to create maps (or models) of workflows, services design, and customer journeys for the business, organization, system, or software. Process maps are created by eliciting new requirements as well as identifying existing functionalities and processes in an organization. Documenting behavior models using use cases, user experience design, storyboards, user profiles, and user stories.
• Analysis & estimation of solution options: Ability to undertake quality initiatives and measure them with the right metrics. Be able to develop meaningful key performance indicators (KPIs).
• Training &Communications: Work with learning and comms team to provide inputs on new functionality, enhancements, process changes, etc. to drive adoption
• Digital Capability: Having had experience in, or capability to, enable customer experiences through the use of digital technologies through placing the customer at the center of everything we do.

WHAT WE'RE LOOKING FOR

• Holds a Bachelor’s Degree in Computer Science, Information Systems, Business Administration, or other related fields
• Minimum 4+ years of work experience as a BA required in Software development projects
• Industry certification in Business Analysis like CBAP, Agile business analysis, etc.
• Prior experience or a background in software development.
• High attention to detail and work ethics which encourages accuracy
• Involvement in digital transformation or multi-system integration project
• Strong written and oral communication skills with IELTS ( or any other equivalent English proficiency score of 7 or above)
• High level of computer user ability, including Ms Word, Ms Visio, Ms Excel, Ms Power Point, Outlook
• Agile qualification and experience
• Must have strong interpersonal skills and desire to work in a dynamic and fast-paced environment
• Must have the ability to work autonomously, be self-motivated, and a strong team player
• Great can-do flexible attitude that thrives in a collaborative makes it happen environment. Attitude is everything!

As a Software Development Engineer at Amazon, you have industry-leading technical abilities and demonstrate breadth and depth of knowledge. You build software to deliver business impact, making smart technology choices. You work in a team and drive things forward. 

Top Skills

•    You write high quality, maintainable, and robust code, often in Java or C++.

•    You recognize and adopt best practices in software engineering: design, testing, version control, documentation, build, deployment, and operations.

•    You have experience building scalable software systems that are high-performance, highly-available, highly transactional, low latency and massively distributed.

Roles & Responsibilities

•    You solve problems at their root, stepping back to understand the broader context.

•    You develop pragmatic solutions and build flexible systems that balance engineering complexity and timely delivery, creating business impact.

•    You understand a broad range of data structures and algorithms and apply them to deliver high-performing applications.

•    You recognize and use design patterns to solve business problems.

•    You understand how operating systems work, perform and scale.

•    You continually align your work with Amazon’s business objectives and seek to deliver business value.

•    You collaborate to ensure that decisions are based on the merit of the proposal, not the proposer.

•    You proactively support knowledge-sharing and build good working relationships within the team and with others in Amazon.

•    You communicate clearly with your team and with other groups and listen effectively. 

Skills & Experience

•    Bachelors or Masters in Computer Science or relevant technical field.

•    Experience in software development and full product life-cycle.

•    Excellent programming skills in any object oriented programming languages - preferably Java, C/C++/C#, Perl, Python, or Ruby.

•    Strong knowledge of data structures, algorithms, and designing for performance, scalability, and availability.

•    Proficiency in SQL and data modeling.

• Leverage native APIs for deep integrations
• Solving any challenges that might appear on the way
• Diagnose and fix bugs and performance bottlenecks for performance that feels native
• Maintain code and write automated tests of quality that sets the benchmark for your future colleagues

• 2+ years of relevant industry experience in React Native
• A deep understanding of JavaScript
• Familiarity with video recording, playback, and uploading libraries
• Experience with Native Android app deployment
• Familiarity with modern front-end build pipelines and tools
• Familiarity with Socket.io is a plus
• Familiarity with RESTful APIs
• Strong UX/UI design exposure and experience in making apps work intuitively and with pixel perfect interface
• Highly accountable and takes ownership, with a collaborative attitude, and a lifelong learner
• Familiarity with code versioning tools (such as Git)

• Should have good hands-on experience in Informatica MDM Customer 360, Data Integration(ETL) using PowerCenter, Data Quality.
• Must have strong skills in Data Analysis, Data Mapping for ETL processes, and Data Modeling.
• Experience with the SIF framework including real-time integration
• Should have experience in building C360 Insights using Informatica
• Should have good experience in creating performant design using Mapplets, Mappings, Workflows for Data Quality(cleansing), ETL.
• Should have experience in building different data warehouse architecture like Enterprise,
• Federated, and Multi-Tier architecture.
• Should have experience in configuring Informatica Data Director in reference to the Data
• Governance of users, IT Managers, and Data Stewards.
• Should have good knowledge in developing complex PL/SQL queries.
• Should have working experience on UNIX and shell scripting to run the Informatica workflows and to control the ETL flow.
• Should know about Informatica Server installation and knowledge on the Administration console.
• Working experience with Developer with Administration is added knowledge.
• Working experience in Amazon Web Services (AWS) is an added advantage. Particularly on AWS S3, Data pipeline, Lambda, Kinesis, DynamoDB, and EMR.
• Should be responsible for the creation of automated BI solutions, including requirements, design,development, testing, and deployment