L2 Support

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.

Position: Java Developer

Experience: 3-8 Years

Location: Bengaluru

We are a multi-award-winning creative engineering company offering design and technology solutions on mobile, web and cloud platforms. We are looking for an enthusiastic and self-driven Test Engineer to join our team.

Roles and Responsibilities:

• Expert level Micro Web Services development skills using Java/J2EE/Spring
• Strong in SQL and noSQL databases (mySQL / MongoDB preferred)  Ability to develop software programs with best of design patterns , data Structures & algorithms
• Work in very challenging and high performance environment to clearly understand and provide state of the art solutions ( via design and code)
• Ability to debug complex applications and help in providing durable fixes
• While Java platform is primary, ability to understand, debug and work on other application platforms using Ruby on Rails and Python
• Responsible for delivering feature changes and functional additions that handle millions of requests per day while adhering to quality and schedule targets
• Extensive knowledge of at least 1 cloud platform (AWS, Microsoft Azure, GCP) preferably AWS.
• Strong unit testing skills for frontend and backend using any standard framework
• Exposure to application gateways and dockerized. microservices
• Good knowledge and experience with Agile, TDD or BDD methodologies

Desired Profile:

• Programing language – Java
• Framework – Spring Boot
• Good Knowledge of SQL & NoSQL DB
• AWS Cloud Knowledge
• Micro Service Architecture

Good to Have:

• Familiarity with Web Front End (Java Script/React)
• Familiarity with working in Internet of Things / Hardware integration
• Docker & Kubernetes  Serverless Architecture
• Working experience in Energy Company (Solar Panels + Battery)

#HiringAlert

We are looking " Oracle APEX " for Reputed Client @ Permanent Role.

Must Have Skills:

1.Experience in Oracle APEX, SQL / PLSQL concepts, collections, function, procedure, package and types - Mandatory

2. Experience in JASPER / OBIEE reports

Good To Have Skills:

1.Knowledge in Oracle Forms and Reports, JavaScript, HTML, CSS or any other web-based programming language is added advantage (Optional)

2.Key Responsibilities: Design develop test and implement features and code using Oracle Application Express APEX

3. Perform requirements analysis development design test and deployment of custom Oracle applications.

4. Writing SQL queries Views Materialized views PLSQL procedures functions packages triggers cursors collections Ref cursor cursor variables System reference cursor Dynamic SQL

5. Debug code and maintain PL SQL procedures and functions.

6.Optimize existing applications and scripts for both usability and performance.

7. Adherence to policies processes and procedures within your areas of responsibility

8.Evaluate new features and technologies overseeing their implementation into the environment as appropriate.

9.Ability to prioritize, manage, deliver and report on multiple projects simultaneously highly motivated and able to work against aggressive deadlines schedules.

Professional Attributes:

1. Ability to work with minimal supervision.

2. Exhibits strong ethics, positive attitude, and calm demeanor under pressure.

3. Flexible, organized and possesses the ability to work in a fast-paced environment.

Location : Chennai

OJ Commerce Inc. is a fast-growing retailer serving the US market through OJ Commerce.com and various market places such as Amazon, Walmart, and eBay. OJ Commerce is a privately held, profitable company headquartered in Miami, Florida, USA with a 100% dedicated back-office in Chennai. The workhours are flexible with predominantly India business hours with some overlap with US Eastern Time business hours based on need.

Experience: 

4+ relevant experience

Role: Individual Contributor Role.

Location : Chennai - Ekaduthangal (Work From Office)

Skill Sets:

• In-depth knowledge in MS SQL Server and related tools & technologies such as SSIS, SSRS &SSAS

• Exposure to data modelling and ability to develop complex queries & procedures

• Manage and monitor performance, capacity and security of the database

• Continuously improve the performance of the database in alliance with the Database Adminstrator by optimizing jobs, procedures & queries

Desirable Skills:

➢ Candidates with experience in ecommerce / online retail is added value.

➢ Should be comfortable in dealing with senior leadership (internal & external)

➢ Communication Skills – Excellent verbal and written communication skills with ability to explain ideas very clearly.

➢ Self–motivated and flexible, with an ability to work independently.

Traits Expected: 

• Ability to work in a fast–paced, dynamic environment with limited resources

• Problem-solver with a desire to solve complex business problems with innovative & cost–effective solutions

• Excellent analytical and problem-solving skills, with out–of–the–box thinking.

Location: Chennai

Experience: 4 years

07-13 years as an Oracle DBA with production support experience, including Oracle 10g and 11g.

07-13 years of experience as an Oracle Apps DBA with Oracle EBS 11.5.10 and R12

Strong understanding of Oracle RDBMS architecture

Hands-on experience with implementation, upgrade, and tuning of:

Large Oracle EBS environments, Oracle EBS in a production environment; throughout all stages of the lifecycle

Enterprise Manager Grid Control

Backup and recovery concepts, including RMAN

Oracle R12, Oracle RAC

Patch assessment and application in an EBS environment with activation of different modules

Performance Tuning (ie. Sql Queries)

Proven experience with multiple operating systems: Linux/Unix/Solaris/Windows

Strong verbal, written, organizational and documentation skills.

Ability to provide accurate and realistic effort estimates, commit and deliver accordingly

Ability to work in a fast paced environment with occasional non-business hours (evenings and weekends) flexibility and able to prioritize and juggle multiple projects.

Ability to work productively in a team environment and participate as a positive and cooperative team member.

MS in CS or BS/ BA in Computer Science with five years of relevant work experience.

Candidates should be flexible for Night shifts/Weekend Shifts

Preferred Skills:

Experience with Engineered Systems (ie. ODA's)

Oracle Data Guard

Oracle RAC/Multitenant architecture . WebLogic . OEM 13c/12c

R12.2 Upgrade Experience on multiple projects

Experienced with Oracle Identity Management product suite

Immediate Joiners preferred

Designation- L1 Tech Support 

Location – Kharghar

Experience -  2 to 5 years

L1 Tech Support: BE/Btech only.

• Must have minimum 2-3 years of support Experience on Financial transactions system
• Monitor and verify program execution, identification and communication of processing variances(e.g. run time, record counts, etc.) and potential issues
• Manage Production alerts and take necessary action as per the run-book
• Creation of incident tickets, and follow-up until closure as per Standard Operational Procedure
• Maintain and adhere production schedules to include ad-hoc requests
• Stopping and starting system processes
• Troubleshoot failures and determine best course of action
• Internal Stakeholder communications with respect to the daily production cycles
• Documenting all Operational activities (Known Error Database, reports, Troubleshooting steps, Operation manual, important mail communications)
• SLA Adherence.
• Good Understanding of SQL and scheduling.
• Familiarity/Experience with UNIX, LINUX, Windows environments
• Familiarity with scheduling and job monitoring tools
• Must be able to do work in all 3 shifts (morning/afternoon/night

If interested, kindly share updated resume, current CTC and Expected CTC.

Job Requirement – Sr. SQL _PBI Developer

• Minimum 6+ years of expertise in SQL Database Development including SQL queries, data structures, stored procedures, index etc.
• Excellent written and verbal communication
• Advanced knowledge and experience in T-SQL coding: query writing, stored procedures, triggers and user-defined functions.
• Advanced knowledge and experience in development and maintenance of SSIS and SSAS (Tabular and Multidimensional)
• Advanced knowledge and experience in creating dashboards and reports using PowerBI
• Advanced knowledge and experience in DAX
• Experience in creating and publishing reports using SSRS
• Experience in writing MDX queries
• Manage SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems.
• Optimize and manage SQL server databases
• Independently analyse, solve, and correct issues in real time, providing problem resolution end-to-end.
• Refine and automate regular processes, track issues, and document changes
• Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members.
• Flexible, team player, “get-it-done” personality
• Ability to organize and plan work independently
• Ability to work in a rapidly changing environment
• Ability to multi-task and context-switch effectively between different activities and teams

Optional Skills (Good to have):

• Microsoft certification in Azure data engineering

Customer / Tech Support Engineer JD

We are looking for a Customer Support Engineer/Tech Support Engineer who will be solving high-priority customer technical issues in a fast-paced environment. The support team is the foundation of everything the company does, and we take the role of supporting our merchants seriously. This is a highly cross-functional role; you'll work closely with company’s merchants to uncover their business goals and then coach them on the best ways to use the company website to achieve them. Your role would involve explaining technical concepts, providing support for overall systems testing and implementation into the production, and creating and improving documents that help customers solve their problems. If you are someone who enjoys solving merchants' technical problems, we want to hear from you.

• Participate in requirement, design discussions, and come up with solutions according to functional specifications
• Develop in-depth product expertise as a master Fulfil user and teacher
• Translate highly complex business requirements into technical solutions through efficient design and using appropriate tools and technologies
• Technical support and troubleshooting production issues and solution implementation
• Collaborating with the product team to share customer feedback, ensuring we continue to learn and improve our product and processes
• Identifying and resolving application issues, providing feedback for product improvements and overall direction
• Proactively identify areas of improvement and talk to our customers to ensure they are getting the most out of the product
• Involved in other programming and documentation including API references, guides, and tutorials
• Take an analytical approach to tracking points of friction for users, and then work with other teams to make those parts of our platform better

• Demonstrated proficiency with Python and SQL
• Relevant experience in working with eCommerce industry APIs e.g. Shopify, Magento, shipping carriers (e.g. USPS, DHL, FedEx etc), and Payment platforms
• Ability to adapt and write high-quality code that will be peer-reviewed.
• Familiarity with code versioning tools like GIT.
• Experience in working with web services i.e. HTTP, REST, JSON
• Superior interpersonal and customer support skills to provide excellent service
  
  

The IT Infrastructure Analyst is responsible for working on assigned projects and technical initiatives in an efficient/effective manner.  The IT Infrastructure Analyst must possess a high degree of technical knowledge regarding server & storage systems and associated technology tools for managing them.

The individual is expected to be able to manage and support infrastructure systems as necessary, perform troubleshooting, build new systems, and monitor data center environments.

Must have:

8-12 years’ experience in IT infrastructure management

Expertise in Dell Server Environments (Dell Hardware & Management system - Open Manage)

Expertise in VMWare (Vcentre setup and management)

Expertise in Windows server and storage

Expertise in EMC (now Dell) SAN and NAS devices

Good Linux skills (basic troubleshooting skills on Linux servers CentOS)

Good networking skills (troubleshooting skills)

Familiarity with Data Center Environmentals (Power, UPS, Cooling etc.)

Good to have:

• Experience with hyper-converged infrastructure such as Nutanix
• Experience and familiarity with Dell networking technology.
• Experience and familiarity with AWS