Field Sales Executive

 Job Description For Database Engineer

Job Title: Database Engineer(MySQL)

Company: Mydbops 

About Us:

As a seasoned industry leader for 8 years in open-source database management, we specialise in providing unparalleled solutions and services for MySQL, MariaDB, MongoDB, PostgreSQL, TiDB, Cassandra, and more. At Mydbops, we are committed to providing exceptional service and building lasting relationships with our customers. Mydbops takes pride in being a PCI DSS-certified and ISO-certified company, reflecting our unwavering commitment to maintaining the highest standards of security and operational excellence.

Role Overview:

You will work in a fast-paced environment where we are responsible for the most critical systems. Our external teams ( Customers ) count on us to keep their MySQL database running and we are vital to the success of their business. You will troubleshoot and resolve customer issues related to the DB system's availability and performance.  You will develop relationships with customers, comprehend and fulfil their needs, and maintain their satisfaction through regular communication and engagement with their environments.

Responsibility :

• The major focus is on handling all the alerts in MDS MySQL.
• Optimising the complex SQL Queries.
• On-Demand Query Optimization.
• Monthly Query optimization assigned ( based on customer list ).
• Get into Client calls on Performance issues and other tasks.
• Reaching the DBE-2 and DBRE's for escalations.
• Assisting and mentoring the ADBEs.
• Efficient troubleshooting using MySQL MDS Internal tools 
• Writing the technical and process documents.
• Managing the client-based operations documents to ease scheduled & repeated tasks for the database engineering team.

Skills Required :

• Teamwork in a fast-paced environment.
• Alarm resolution expert
• Good in SQL language.
• Linux commands for day-to-day operations.
• Kernel tuning and Linux performance tools
• Expertise in MySQL backup tools
• mysqldump
• mydumper/myloader
• Xtrabackup.
• mariabackup
• Knowledge on AWS basic operations
• log collections
• S3 Push
• AWS Workspace
• Deep Skills in query optimization, index tuning and implementing the database features for SQL optimisation.
• Polite, friendly and professional; this position requires significant customer interaction and teamwork.
• Process-oriented and teamwork play a pivotal role.
• Excellent and strong written and spoken English Communication Skills.
• Strong work ethic and accepts feedback from others.
• Strong understanding of MySQL architecture, storage engines (InnoDB, MyISAM), and replication (Binlog Based And  GTID).
• Good understanding of database security practices (users, roles, encryption, authentication mechanisms).
• Strong problem-solving and troubleshooting skills.
• Experience with monitoring tools such as PMM (Percona Monitoring and Management), Prometheus, Grafana

Good to Have (Optional but Preferred): Experience with AWS RDS/Aurora MySQL.

Why Join Us:

• Opportunity to work in a dynamic and growing industry.
• Learning and development opportunities to enhance your career.
• A collaborative work environment with a supportive team.

Job Details:

• Job Type: Full-time opportunity 
• Work Days - 6 days
• Work time: Rotational shift
• Mode of Employment - Work From Home

Job Description below :

Required Skills

BSc/B.E./B.Tech in Computer Science or an equivalent field.

7-10 years' solid commercial experience in software development using experience using Java8, Spring boot, Hibernate, Spring Cloud and related frameworks.

Experience with Angular 8+ versions, B.J‹JS 6, IS/TypeScript

Knowledge of HTML/CSS

Good understanding of Design Patterns

Proficiency with SQL database development, including data modelling and DB performance tuning

Ability to work with customers, gather requirements and create solutions independently

Active participation within and among teams and colleagues distributed globally

Excellent problem-solving skills, in particular a methodical approach to dealing with problems across distributed systems.

Agile development experience

Desired Skills

Experience with angular forms

Experience with dynamic forms/ dynamic angular components

Experience with java Spring boot

Knowledge of Kafka Stream Processing

Understanding of secure software development concepts, especially in a cloud platform

Good communication skills.

Strong organisational skills.

Understanding of test management and automation software (e.g. ALM, Jira, JMeter).

Familiarity with Agile frameworks and Regression testing.

Previous experience within the Financial domain.

Responsibilities:

• Lead technical processes and designs with a focus on reliability, scalability, and maintainability.

• Review developmentteam code to ensure quality and adherence to standards.

• Mentor junior developers and foster talent development.

• Collaborate with Infrastructure teams for optimal hosting environments.

• Define scalability and performance benchmarks for applications.

• Ensure compliance with performance, privacy, and security requirements.

• Validate test plans for security and performance adherence.

• Support business and technical presentations related to technology solutions.

• Mitigate risks by following procedures and monitoring controls.

• Develop cost-effective solutions aligned with business requirements.

• Implement best practices consistent with corporate standards.

• Partner with cross-functionalteams to ensure project success.

• Manage software development lifecycle and drive process improvements.

• Estimate costs for modules/projects, including effort and expenses.

• Research and evaluate technologies for solution design.

• Construct end-to-end application architecture.

Qualifications:

• Bachelor's degree required; Master’s or equivalent experience preferred.

• Minimum of 6 years of related experience.

• 6+ years of active development experience in Java/J2EE-based applications.

• Expertise in Hibernate, JPA, Spring, and Spring MVC.

• Exposure to XML/XSD, JSON, and similar data presentation components.

• Familiarity with microservices architecture and distributed systems.

• Experience developing and working with REST APIs using the Spring Boot framework.

• Knowledge of IBM MQ and messaging protocols like JMS.

• Proficiency in Unix/Linux OS and shell scripting.

• Strong database and PL/SQL skills.

• Experience with CI/CD tools such as GIT, Jenkins, JoCoCo, and Maven.

• UI framework experience with Angular, NodeJS, and NPM is a plus.

• Familiarity with CSS, HTML, JavaScript, and related UI frameworks (jQuery, React, Angular) is a plus.

• Understanding of Agile development methodology.

Job Insights - Must-Have Skills:

• Minimum of 6 years of related experience.

• 6+ years of active Java/J2EE development experience.

• Expertise in Hibernate, JPA, Spring, and Spring MVC.

• Familiarity with microservices architecture.

• Experience developing REST APIs using Spring Boot.

Job Description:

As an Azure Data Engineer, your role will involve designing, developing, and maintaining data solutions on the Azure platform. You will be responsible for building and optimizing data pipelines, ensuring data quality and reliability, and implementing data processing and transformation logic. Your expertise in Azure Databricks, Python, SQL, Azure Data Factory (ADF), PySpark, and Scala will be essential for performing the following key responsibilities:

Designing and developing data pipelines: You will design and implement scalable and efficient data pipelines using Azure Databricks, PySpark, and Scala. This includes data ingestion, data transformation, and data loading processes.

Data modeling and database design: You will design and implement data models to support efficient data storage, retrieval, and analysis. This may involve working with relational databases, data lakes, or other storage solutions on the Azure platform.

Data integration and orchestration: You will leverage Azure Data Factory (ADF) to orchestrate data integration workflows and manage data movement across various data sources and targets. This includes scheduling and monitoring data pipelines.

Data quality and governance: You will implement data quality checks, validation rules, and data governance processes to ensure data accuracy, consistency, and compliance with relevant regulations and standards.

Performance optimization: You will optimize data pipelines and queries to improve overall system performance and reduce processing time. This may involve tuning SQL queries, optimizing data transformation logic, and leveraging caching techniques.

Monitoring and troubleshooting: You will monitor data pipelines, identify performance bottlenecks, and troubleshoot issues related to data ingestion, processing, and transformation. You will work closely with cross-functional teams to resolve data-related problems.

Documentation and collaboration: You will document data pipelines, data flows, and data transformation processes. You will collaborate with data scientists, analysts, and other stakeholders to understand their data requirements and provide data engineering support.

Skills and Qualifications:

Strong experience with Azure Databricks, Python, SQL, ADF, PySpark, and Scala.

Proficiency in designing and developing data pipelines and ETL processes.

Solid understanding of data modeling concepts and database design principles.

Familiarity with data integration and orchestration using Azure Data Factory.

Knowledge of data quality management and data governance practices.

Experience with performance tuning and optimization of data pipelines.

Strong problem-solving and troubleshooting skills related to data engineering.

Excellent collaboration and communication skills to work effectively in cross-functional teams.

Understanding of cloud computing principles and experience with Azure services.

Essential Responsibilities:

• Software analysis, design, development, and customizations of software applications on IBMi
• Develop Design and test cases
• Prepare project technical delivery documents such as Technical Design Documents, analysis, documents, Unit Test Reports, and others
• Actively participate in software quality Engineering process activities
• Stakeholder interactions daily
• Mentor junior resources and provide technical guidance as and when required
• Production Support and other maintenance activities on IBMi
• Participate in daily stand-up or equivalent calls
• Provide accurate timely status reports
• Work under agile frameworks including but not limited to Kanban and Scrum
• Any experience of support IBMi-based ERP packages would be added advantage
• Perform the production code promotional and other change management activities
• Providing technical leadership to project team members and responding to inquiries regarding errors or questions about programs

Job Requirements:

• Minimum Bachelor’s Graduate in Engineering or equivalent
• 10+ years of total experience is required
• Excellent written and oral communication skills

Essential skillset:

• Operating System: OS/400,WINDOWS
• Languages : RPGLE, COBOL, CL400,CLLE, STORED PROCEDURE
• Database : DB2/400
• ERP : MPICS, BPCS

• Interact with IT & BFSI companies for recruitment of trained candidates from the company.
• Develop and maintain top-level relationships with designated accounts to establish a clear and comprehensive understanding of customer needs
• Develop, expand, maintain and report on a pipeline of qualified recruitment opportunities.
• Design and implement strategies for expanding the company’s B2B segment.
• Build, mentor, and lead an effective B2B sales team.
• Conduct and host talks with Senior Management of corporates.
• Prepare operational, recruitment reports fortnightly and present them to senior management.
• Work closely with the Training Team and provide inputs on the latest requirements.
• Take initiatives, identify pain points, improvement areas, and work towards achieving a solution

Job Qualifications:

• Proficient Key Accounts portfolio management
• 4-6 years of B2B Sales experience
• Proficiency in CRM and lead management
• Education - MBA from premier institutes
• Efficient project management skills
• Excellent verbal and written communication skills
• Leadership alignment and experience, mentor and lead team
• Ability to work with data and uncover insights into the consumer mindset