Technical Support Executive

Job Description: 

We are looking for an experienced SQL Developer to become a valued member of our dynamic team. In the role of SQL Developer, you will be tasked with creating top-notch database solutions, fine-tuning SQL databases, and providing support for our applications and systems. Your proficiency in SQL database design, development, and optimization will be instrumental in delivering efficient and dependable solutions to fulfil our business requirements.

Responsibilities:

 ● Create high-quality database solutions that align with the organization's requirements and standards.

● Design, manage, and fine-tune SQL databases, queries, and procedures to achieve optimal performance and scalability.

● Collaborate on the development of DBT pipelines to facilitate data transformation and modelling within our data warehouse.

● Evaluate and interpret ongoing business report requirements, gaining a clear understanding of the data necessary for insightful reporting.

● Conduct research to gather the essential data for constructing relevant and valuable reporting materials for stakeholders.

● Analyse existing SQL queries to identify areas for performance enhancements, implementing optimizations for greater efficiency.

● Propose new queries to extract meaningful insights from the data and enhance reporting capabilities.

● Develop procedures and scripts to ensure smooth data migration between systems, safeguarding data integrity.

● Deliver timely management reports on a scheduled basis to support decision-making processes.

● Investigate exceptions related to asset movements to maintain accurate and dependable data records.

Duties and Responsibilities: 

● A minimum of 3 years of hands-on experience in SQL development and administration, showcasing a strong proficiency in database management.

● A solid grasp of SQL database design, development, and optimization techniques.

● A Bachelor's degree in Computer Science, Information Technology, or a related field.

● An excellent understanding of DBT (Data Build Tool) and its practical application in data transformation and modelling.

● Proficiency in either Python or JavaScript, as these are commonly utilized for data-related tasks.

● Familiarity with NoSQL databases and their practical application in specific scenarios.

● Demonstrated commitment and pride in your work, with a focus on contributing to the company's overall success.

● Strong problem-solving skills and the ability to collaborate effectively within a team environment.

● Excellent interpersonal and communication skills that facilitate productive collaboration with colleagues and stakeholders.

● Familiarity with Agile development methodologies and tools that promote efficient project management and teamwork.

What you need to have:

· Providing technical advice and troubleshooting for end users

 · Experience in Enterprise Apple support like ABM, VPP,ACE and MDM

· Excellent OSX desktop and server support skills

· Experiencing supporting OS X desktop and server across a range of versions

· Strong experience with using and administrating JAMF

· Package Deployment, Image upgrade. Security patches &DEP

· Hands on experience with JAMF tools like Recon , Composure , remote and Admin

· Endpoint hardening via JAMF and self service management.

· Experience using terminal commands and scripts

· Great customer relationship skills

· Good written & verbal communication skills

· Being flexible and customer solution focused

· Experience in various application outlook , AD and Teams.

· Cloud knowledge

Job Description:

1. Design, implement and deliver custom solutions using the existing robotics framework.
2. Debug issues, do root-cause analysis and apply fixes.
3. Design and implement tools to facilitate application development and testing.
4. Participate in architectural improvements.
5. Work with team members in deployment and field testing.

Requirements:

1. Bachelor Degree / Masters in Engineering (ECE or CSE preferred)
2. Work experience of 3+ years in software programming.
3. Proficiency in Python programming for Linux based systems.
4. Full understanding of software engineering.
5. Basic Knowledge of Robot Operating System(ROS) is a plus.
6. Good understanding of the algorithms and control loops.
7. Working knowledge of Git: creating, merging branches, cherry-picking commits, examining the diff between two hashes. Advanced Git usage is a plus.
8. Knowledge of video streaming from edge devices is a plus.
9. Thrive in a fast-paced environment and have the ability to own the project’s tasks end-to-end with minimum hand-holding
10. Learn and adapt new technologies & skills. Work on projects independently with timely delivery & defect free approach.

Looking for a AWS Architect for our client branch in Noida

Experience: 8+ years of relevant experience

Location: Noida

Notice period : Immediate to 30 days joiners

Must have: AWS, Spark, Python, AWS Glue, AWS S3, AWS Redshift, Sage Maker, AppFlow, Data Lake Formation, AWS Security, Lambda, EMR, SQL

Good to have:

Cloud Formation, VPC, Java, Snowflake, Talend, RDS, Data Bricks

Responsibilities:

• Mentor Data Architect & Team and also able to Architect and implement ETL and data movement solutions like ELT/ETL/Data pipelines.
• Apply industry best practices, security, manage compliance, adopt appropriate design patterns etc
• Able to work and manage tests, monitors, manage and validate data warehouse activity including data extraction, transformation, movement, loading, cleansing, and updating processes.
• Able to code, test and dataset implementation and maintain and define data engineering standards
• Architect, Design and implement database solutions related to Big Data, Real-time/ Data Ingestion, Data Warehouse, SQL/NoSQL
• Architect, Design and implement automated workflows and routines using workflow scheduling tools
• Identify and Automate to optimize the performance.
• Conduct appropriate functional and performance testing to identify bottlenecks and data quality issues.
• Be able to implement slowly changing dimensions as well as transaction, accumulating snapshot, and periodic snapshot fact tables.
• Collaborate with business users, EDW team members, and other developers throughout the organization to help everyone understand issues that affect the data warehouse.

Peacock Engineering Ltd is a Gold-accredited IBM Premier Business Partner which has amassed over 300 person years of experience implementing business critical EAM (Enterprise Asset Management) solutions across a range of industries such as oil & gas, pharmaceuticals, utilities, facilities management, transport, and power generation. 

Peacock Engineering Ltd specialise in providing consultancy services and support for the IBM Maximo EAM software product and maintain a pool of highly experienced and capable consultants fully conversant with IBM Maximo and its functionality, capabilities, and opportunities for customisation to meet business need. 

Peacock Engineering’s Technical Services team is now looking for an IBM Maximo Technical Professional to support the growing demand for Maximo enterprise asset management solutions, working from our office in Bangalore.

• Technical expert in IBM Maximo EAM technology.
• Should be well versed in MBO customizations for Maximo 7.x version.
• Advanced JAVA, SQL knowledge.
• Maximo building and deploying to various instances.
• Business process management using workflow design and management.
• Expert Knowledge of Maximo Integration Framework (MIF).
• Provide technical services over the entire lifecycle of a project.
• communication skills (verbal and written) possess the ability to multi-task.
• Maximo installations and upgrade work experience
• Participate in solution architecture design.
• Perform application and solution development to meet project requirements.
• Develop and document detailed technical designs to meet business requirements.
• Manage multiple technical environments and support the development and testing processes.
• Lead or assist in data conversion and migration efforts.
• Configure Maximo and assist in the development of interfaces to external systems.
• Identify areas of customization and optimization and provide solutions that meet the business requirements.
• Conduct system testing, as necessary.

Skill Requirements - Essential:

• Tech. in Computer Science, Engineering or Business-related field and/or equivalent work experience.
• Strong Maximo technical knowledge required to help execute numerous projects.
• Minimum eight (8) years of work experience in a technical position with the implementation and utilization of fully integrated enterprise asset management system.
• Proficient to convert functional requirements into technical specifications, and configure, tailor and or customize the solutions including building interfaces.
• Ability to create and update advanced technical documentation.
• Strong communication skills and the ability to work well in a project team environment.
• Drafting/Reviewing Functional Specifications
• Drafting/Reviewing Technical Specifications

Skill Requirements - Preferable:

• To bring industry knowledge world class capabilities innovation and cutting-edge technology to our clients in the Resources industry to deliver business value.
• To work with leading Resources client’s major customers and suppliers to develop and execute projects and reliability strategies.
• To harness extensive knowledge combined with an integrated suite of methods people and assets to deliver sustainable long-term solution.
• IBM Maximo 7.x certification

• Professional and committed, with a disciplined approach to work.
• Motivated and driven by finding and providing solutions to problems.
• Polite, tactful, helpful, empathic nature, able to deliver to the needs of customers.
• Has respect for others and their views.
• Technology minded and focused, enthusiastic about technologies.
• Analytical, able to raise from the detail and see the bigger picture.
• Dedicated to continually updating and upgrading own knowledge.
• Carries a mind-set of continuous improvement, constantly looking for better and more efficient ways of doing things.
• Values quality at the centre of all things in work.

Due to considerable amount of virtual working and interaction with colleagues and customers in different physical locations internationally, it is essential that the successful applicant has the drive and ethic to succeed working in small teams physically but in larger efforts virtually.  Self-drive to communicate constantly using web collaboration and video conferencing is essential.

As an employee, you will be encouraged to continually develop your capability & attain certifications to reflect your growth as an individual.

• Minimum 3 years of working experience in database related projects.
• Working experience on any of the leading Database management systems viz., Oracle,SQL-Server, etc. (Experience on Postgres database systems will be an added advantage).
• Adequate Database Development skills & should be proficient in SQL coding.
• Working experience in Database SQL Optimization/Performance Tuning.
• Working experience on any of the Database Programming languages viz., PL/SQL, PL/pgSQL,T-SQL,etc.
• Flexible to learn, adopt & scale to any data centric technologies as per the evolving Organizational product strategies.

• Good to have skill sets of the Candidate:
• Working experience on Data Warehouse projects or exhibits sound knowledge over the concepts.
• Working experience on Data Analytics/Reporting/ETL or exhibits sound knowledge over the concepts.
• Database agnostic approach to data/database solutions.
• Exhibits sound knowledge on Big-data/Hadoop, Kafka, Map-Reduce programming, NoSQL,etc.

Role 1 : Core Java

Experience  - 5 – 10 years

Location – Mumbai ( NKP) / Weworks

Primary Skills / Must have:

• Knows Java Programming Language (Java 7, 8) with Object-Oriented Design and Spring Framework. Understanding of RESTFul Services development.
• Has a good understanding of asynchronous requests, multithreading and related issues and ways to resolve them.
• Has a good understanding of web and web programming principles, cookies, sessions etc.
• Familiar with tomcat, servlet model and their limitations.
• Has a good understanding of basic algorithms and data structures.
• Good analytical skills, problem-solving skills and willingness to learn.
• Good communication and collaboration skills. Willing to ask questions.
• Team player.

 Secondary Skills / Desired skills

• Modern web development tools including JavaScript frameworks such as Angular JS and CSS frameworks such as Bootstrap.
• Familiarity with Git and Linux/Unix commands.

Role 2 – JAVA + Linux + SQL Server combination of skills - Bangalore

Experience  – 4 – 9 years

Location – Bangalore  ( RMZ Ecoworld)

Required Technical Skills:

• Strong Java experience.
• Experienced in Agile development lifecycle.
• Hands-on experience with Programming language: Python, and SQL
• Experience in database platforms : DB2/Sybase/MSSQL server.
• Working knowledge of Linux/Unix.
• Working knowledge of Java spring framework,Angular 7/8,GIT.

Desired Technical Skills:

• Working experience on Actimize RCM solution.
• Knowledge of testing automation tools like selenium.
• Good knowledge of Actimize AIS solution
• CI/CD

Required Aptitudes

• Ability to take on challenges and open to learning new technologies.
• Ability to work on multiple projects at the same time.
• Passion for innovation and find creative solutions to complex business problems.
• Team player.

Educational qualification and experience:

• Bachelor degree in engineering/computer science or MCA from recognized institution
• Minimum 3 years of development experience in required technical skills.

Role 3 – Java+ Spring + Azure  ( Mandatory)

Location – Bangalore

Experience – 4 – 7 years

Role 4 – Java Fullstack

Experience  - 5 – 9 years

Location – Mumbai ( NKP)

No of open role – 4

Mandatory Skills – Core Java , Full stack and Unix

Responsibilities Include:

Ø  Work closely with Business Analysts to understand User and Functional Requirements

Ø  Conduct Technical Design, create Design Prototype and Design Specifications. Be able to understand business needs and translate into technology solutions

Ø  Implement the requirements using the latest firm wide technologies and approved global solutions

Ø  Perform Unit Testing and, wherever applicable, collaborate with QA Engineer on System / Integration / QA / Regression / Performance / Capacity Testing, and create testing documentation

Ø  Coordinate with users on User Acceptance Testing and provide testing support

Required technical skills:

Ø  Minimum 3-4 years of hands-on experience in software development

Ø  Good programming skills using Java

Ø  Excellent relational database skills on Sybase / DB2 & Unix Shell Scripting

Ø  Good knowledge and solid experience in Agile software development

Ø  Good knowledge, skills and abilities to perform high quality software testing

Ø  Experience on Axiom / XML / SOAP / Informatica is preferred but not essential

Required professional skills:

Ø  Enthusiasm for and interest in learning and applying new technologies to solve real world business problems

Ø  Pursuit for perfect delivery quality in a zero-error-tolerance environment

Ø  Strong analytical and problem solving skills

Ø  Good communication skills including ability to explain technical issues to non-technical people

Ø  Highly organized, self-motivated, result-oriented, and proactive with capability to work with minimal supervision

Ø  A strong can-do attitude

Ø  Creative and flexible while observing policies, rules and standards

Demonstrate highly proficient written and verbal communication skills in the English language

Role 5 – Core Java / Java backend hands on developer

Location – Mumbai and Banglare

Experience  - 5  – 10 years /