PL/SQL Jobs

Responsibilities:
• Make decisions and resolve issues regarding objectives and operations of the fleet assets
in the database management area to meet business objectives.
• Prepare reports on database scalability and capacity planning as needed.
• Lead team to achieve objectives.
• Interpret and develop policies and procedures for functions with low to moderate complexity within scope of responsibility.
• Mentor and guide talent development of direct reports and assist in hiring talent.
• Work closely with the product development team from the design phase of application & throughout their Agile development journey, the future enhancements & releases
• Participate in the application stress/load test & proactively identify & resolve the DB performance (batch/OLTP) issues that can potentially breach the SLA’s when the code
moves to production
• Highlight the new DB features to the product teams that could be used in the application as future enhancements & releases
• Support the Database Migration, Upgrades as part of Technology Life Cycle Management to be compliant with organization standards
• Provide DB Capacity Analysis & provide insights to product teams on future storage & hardware requirements based on the current data growth & overall performance
• Identify aging data, propose/develop/implement data archiving, purging & partitioning solutions to manage the data growth
• Handling Database/Schema Refreshes for the lower database environments
• Understand the RTO/RPO requirements for the application & databases to define the database backup and restore policy
• Managing Database Security Audit violations & resolving them
• DB User/Access/Roles management
• Troubleshooting & fixing production DB/SQL performance issues
• Providing Oncall support, working with vendor on DB issues, bugs & provide solution
• Schedule and Co-ordinate various maintenance activities with Support teams.
• Collaborate and influence all levels of professionals including more experienced
managers.
• Work on any new DB technology/new-features, POC requirements from application team
• Help the application team in migrating their databases to public cloud (AWS).
• Establish performance standards, evaluate performance, train, and mentor team.
• Evaluate the database configuration and processes according to established policies and procedures of the organization.
• Identify and recommend opportunities for process improvement and risk control development.

Required Qualifications:
• 6+ years of DBA experience on SQL or NoSQL DB with performance Tuning
• 4+ years of experience in managing other databases like MS SQL Server, MySQL, PostgresDB & RDS on AWS.
• Hands on experience with NoSQL/Document databases and their administration.
• Experience on automation using any programming or scripting language.
• Should have at least one RDBMS certification.
• Hands on experience with Always on and High availability DBs.
• Hands on with SQL and NoSQL Database.
• Excellent understanding of the MongoDB installation, configuration, maintenance, security and audit logging.
• Experience with performance tuning and managing 1TB of Data
• Experience in backup/recovery procedures.
• Good understanding on Access Methods, Joins, different Indexes & its usage, Index scans, interpreting EXECUTION PLANS, Table/Index Statistics, Histograms, wait events etc
• Strong on PL/SQL Programming.
• Excellent communication skills
• Excellent verbal and written communication skills.
• Excellent interpersonal and customer service skills.
• Problem-solving and good analytical skills
• Communication, teamwork and negotiation skills
• Ability to work in tight deadlines under pressure
• Flexible and adaptable to changing business/technology requirements
• A sense of ownership that drives quality in everything you do
• A forward-looking attitude that keeps you aware of the latest in database & cloud technology space.

Preferred Qualifications:
• AWS/Azure/OCI cloud Certified
• Working experience on Snowflake Cloud Datawarehouse DB
• Python Programming for Automation for building dashboards
• Basic knowledge on Tableau/PowerBI for reporting.

Education:
• Finished Bachelors or Masters in Software Engineering.
• Preferred: BE/ B. Tech. / MCA / MSc. / BSc

• Design, develop, implement and maintain our core Oracle applications.
• Maintain our SQL / PLSQL processes.
• Ensure DB availability.
• Proactively manage and maintain security standards and controls by creating storage database structures with high-level security features.
• Actively seek to optimise and simplify our architecture.
• Take ownership of performance and capacity monitoring aspects of the DB.
• Execution of data migration jobs and scripts as required.
• Assist the infrastructure team in sizing hardware used for the DB.
• Support and collaborate with product developers.
• Contribute to the creation and maintenance of disaster recovery plans.
• Work closely with the application vendors, co-ordinate and manage the DBA activities.
• Own and follow up with Vendors/Stakeholders & their DBAs when required.
• Create a reliable backup strategy. Ensure database backups are appropriately
• executed and periodic restorations are exercised to ensure backup quality.
• Determine and document DB policies, procedures and standards.
• Performance testing and evaluation to ensure data security, privacy and integrity.
• Identification of bottle necks and deadlock issues.
• Ensure SLA's & operational KPI’s are met, working as necessary with internal and external support functions when major incidents occur.
• Install upgrades and security patches.
• Alter storage structures to meet the evolving needs of the company.
• Set up database user accounts.
• Train users on how to access the information in the database.
• Find and debug malfunctioning programs affecting the database integrity.
• Create autonomous database backups.
• Regularly update the database security protocols.

Desired Skills:

• Ideally Oracle Certified DB Professional (OCP) with more than 5 years’ experience with Oracle, preferably in a lead role.
• Technical degree preferable (B.E. / B. Tech).
• Must experience with an organisation that has 24x7 reliability on its database.
• Must have experience with Oracle Exadata.
• Must Operating system experience in Linux.
• Must hands on knowledge of Shell scripting on Linux Platform
• Must hands on knowledge of Oracle management tools (Data Guard, RMAN).
• Must hands on knowledge of SQL / PLSQL.
• Experience should include DB design (modelling and normalisation), capacity planning, performance tuning, storage management, back-up and recovery, managing schemas, report generation and DB clustering technologies.
• Knowledge of Partitioning.
• Knowledge of architecture design principles.
• Good problem solver, focused and dedicated developer with ability to work on
• your own as well as with a team.
• Hands on experience with DB standards and end user applications-translating
• capacity requirements into infrastructure deployment technology.
• Strong practical experience of ORACLE in a production environment (Ver 19c).
• Must be a self-starter with a strong attention to detail.

Java Tech Lead   

Minimum 8-10 years of experience in design, development, and deployment of JAVA/J2EE-based applications, writing PL/SQL queries/store procedures.

Strong hands-on experience in design, development, and deployment of J2EE based application database design, PL/SQL complex queries, and Store procedures XML, HTML, JavaScript, AJAX

• Expertise on XML, HTML, JavaScript, AJAX

• Proficient in handling and writing complex PL/SQL queries and Stored procedures

• preferable work experience on JBOSS as an application server or any other J2EE application server

• Should have sound knowledge in product customization, implementation, and maintenance aspects

• Foresighted & good judgment in problem-solving.

• Capable of paying attention to detail.

• Good analytical and logical thinking.

• Prioritizing and organizing

• Team Player with a positive attitude.

• Process knowledge/Technical expertise

• Good Written and Verbal communication Skills

   

  Must Have Skills : Java8 , Java 1.8 ,Microservices , Angular8 , Spring framework.

Job Description

Should have working experience between 4-8 years in Java development. Mandatory skills are good knowledge of object oriented concepts, experience of working on Spring boot application, should have worked on hibernate ORMS and candidate must have clear understanding of database concepts.  Optional skills include knowledge of angular framework and postgreSQL database

Good to have knowledge of jBPM open source workflow.

 Minimum 4-8 years of experience in design and development J2EE based applications, database design (conceptual/ logical/ physical) and writing PL/ SQL queries/ stored procedures in PostgreSQL

• Preferred to have good knowledge and hands on experience on jBPM workflow platform. Experience in DROOLS rule engine will be an added advantage
• Expertise on Angular JS, Springboot, Hibernate, JQuery frameworks
• Hands on experience in building reports using Business Intelligence and Reporting Platform (BIRT)
• Knowledge around JBOSS (WildFly), Tomcat and other application servers
• Knowledge around source code repository Tortoise SVN
• Experience in building Multitenant products
• Conceptual knowledge around Continuous Integration/ Continuous Development using Jenkins
• Good analytical and logical thinking, prioritizing and organizing
• Team player with positive attitude
• Good written and verbal communication skills

 Key Responsibilities

• Analyse SRS to understand and estimate the requirements
• Analyse change requests and estimate the requirements
• Design, development, unit testing and deployment using jBPM platform and other underlying tools and frameworks mentioned above
• Database design, writing simple or complex PL/ SQL queries/ stored procedures/ Functions/ Triggers etc. using PostgreSQL database
• Analyse L2 support issues, identify and implement the workaround/ permanent solutions within stimulated SLA
• Preparation of release document for new projects, change requests and bug fixes
• Create and leverage technical knowledge repository

•  Be a team player and strive for the success of the team and the client
• Preparation of Technical Design documents
• Work independently and progress the build of a CEMLI/RICE object from a technical design document
• Capable of working in a fast paced, dynamic, team-oriented environment
• Understanding functional documents of FIN (GL, Fixed Assets, Cash management, AP/AR) and SCM (procurement, Inventory, Order Management).

• Minimum a Bachelor’s degree.
• Oracle Apps Technical with 5+ years of Experience in development, testing and deployment of RICE components and financial modules
• Good Experience on Oracle Forms & Reports, XML / BI Publisher Reporting Tools, Interfaces (outbound /Inbound) and Workflow.
• Must have a strong experience and knowledge of Oracle E-Business Suite
• Must have strong technical experience on PL/SQL, XML Publisher reports, Java, Oracle Applications Framework (OAF)
• Knowledge on ADF
• Must be able to work independently with business users and external users and responsible for design, development, Testing support, production deployment and production support.
• Excellent organization and communication skills

Experience – 8 – 10 years

Location - NCR

Roles and Responsibilities:

System Analyst

The individual in this role will gather, document, and analyze client functional, transactional, and insurance business requirements across all insurance functions and third-party integrations. System Analyst will also work within a cross-functional project team to provide business analytical support and leadership from the business side.  The individual will play a highly visible, client-facing, and the consultative role and have the ability to offer system solutions to enhance client implementations and transform client workflow and business processes. Individual should be very good in mapping business functions / attributes with the Insurance rules and data.

Skills Required:

• A successful candidate in this role must:
• Good hands-on skills in Oracle, PL/SQL, TSQL
• Object oriented knowledge should be good
• Have Functional knowledge on P & C
• Overall Tech - 60% and Functional - 40%

Primary Skills:

• Good Data Mapping knowledge, RDBMS / SQL Knowledge

Secondary Skills:

• Oracle Big+

CLIENT: MNC PRODUCT-BASED COMPANY

ROLE: REACT JS

LOCATION: BANGALORE CANDIDATES ONLY APPLY.

EXPERIENCE:4 YEARS TO 7 YEARS

CTC: up to 30 LPA

NOTE: Candidates from Bangalore should only apply.

Serving notice periods (30 days)/ Immediate Joiner.

• Hands-on working knowledge and experience are required in:

.Typescript, JavaScript, HTML5, CSS

. Deep Knowledge of Frameworks like React.

.Deep Knowledge of tools like Yarn, Grunt, Gulp, npm etc.

.Knowledge of Restful APIs, JWT, and OAuth2.

.Relational Databases (PostgreSQL, MySQL, SQL, PLSQL, etc.)

.Agile Methodologies (Scrum, TDD, BDD, etc.)

.Knowledge of Benchmarking and Optimization Frameworks

.Translating designs and wireframes into high-quality and optimized code

.Knowledge of JavaScript MV-VM/MVC frameworks

.GIT/Bit Bucket, Jira, Maven/Gradle, Jenkins, Visual Studio Code.

• Experience with several of the following tools/technologies is desirable:

.Microservices Architecture

.Cloud Platforms (AWS, Azure, GCP), preferably AWS

.NoSQL Databases (Redis, Elastic Search, Mongo etc.)

.Optimizing components for maximum performance across a vast array of web-capable devices and browsers d. Knowledge of CDN will be a Bonus

• Knowledge of the following technologies is a plus:

.Other Programming Languages (Java, etc.)

. Unix/Linux environments

. Continuous Integration and Continuous Delivery Tools like Jenkins, Git, etc

Responsibilities

Analysis of mapping Documents provided by Business.

Perform technical analysis and ensures that all the standard requirements have been met.

Develop using Ab initio, and Oracle SQL and deliver in a bi-weekly Sprint model.

Develop the code by following all coding standards and performance optimization standards.

Participate in peer review and document the review comments.

Support Upper environment deployments and production failure analysis and fixes.

Eligibility

5+ years of overall IT experience.

3+ years of relevant experience in Ab Initio Development with knowledge in developing UNIX Shell Script, Oracle SQL/ PL-SQL, and Autosys roles.

Hands-on development experience with various Ab Initio components such as Rollup, Scan, join, Partition by key, Partition by Round Robin, Gather, Merge, Interleave, Lookup, etc.

Extensive experience with developing, unit testing, and break/fix support of Ab Initio ETL.

Should have experience with Oracle SQL database programming, SQL performance tuning, and relational model analysis.

Good knowledge in developing UNIX scripts, Oracle SQL/PL-SQL, and Autosys JIL Scripts.

Job Title: Oracle PL/SQL Developer

Qualification: (B.E./B.Tech/ Masters in Computer or IT)

Years of Experience: 3 – 7 Years

No. of Open Positions – 3

Job Location: Jaipur

1. Proven hands-on Database Development experience
2. Develop, design, test and implement complex database programs
3. Strong experience with oracle functions, procedures, triggers, packages & performance tuning,
4. Ensure that database programs are in compliance with V3 standards. 
5. Hands-on development using Oracle PL/SQL.
6. Performance tune SQL's, application programs and instances. 
7. Evaluation of new and upcoming technologies.
8. Providing technical assistance, problem resolution and troubleshooting support.

Job Description

Actosoft is a software development and digital marketing company that offers complete IT solutions. We are a part of the digitally-fluent force that’s improving economies, increasing businesses, and creating success stories, just like ours.

We are a collective of focused, energetic, talented, and hardworking professionals who believe in getting things done at the highest level. Our team aims to innovate, be authentic and grow in everything that we do.

The ideal candidate should be familiar with the complete software design life cycle. In addition, they should have experience in designing, coding, testing and consistently managing applications. They should be comfortable coding in multiple languages and be able to test codes to maintain high-quality coding.

Job details:

Job Location: Actosoft, Gajera Rd, beside Avalon Business Hub, Katargam, Surat, Gujarat 395004

Experience: 0 to 3 years of experience

Salary: 15,000 to 30,000 (per month)

Job Type: Full-time – Work from the Office

Working Schedule:

9:00 am to 6:00 pm (Monday to Friday)

Alternate Saturdays Off.

Job Responsibilities:

● Design, code, test, and manage various applications

● Collaborate with the engineering team and product team to establish the best products

● Follow outlined standards of quality related to coding and systems

● Develop automated tests and conduct performance tuning

● Ability to create and support documentation for all new applications

● Willing to work as a team member

Qualifications:

● Bachelor's degree in Computer Science or relevant field, like MCA, BCA, or BE

● Experience developing web-based applications in C#, HTML, VBScript/ASP, and .NET

● Experience working with MS SQL Server and MySQL Knowledge of practices and procedures for full software design life cycle

● Experience in working with an agile development company

Required Skills:

● .NET Framework

● C#

● Microsoft SQL Server

● JavaScript

● jQuery

● ASP.NET MVC

● ASP.NET Web API

● HTML

● WCF Services

● PL/SQL

● Anqular

● Entity Framework

● CSS

● Ajax

● XML

Perks and Benefits:

1. Promotion every year.

2. Incredible opportunity to diversify your writing skills by working with experts on unique projects.

3. Paid sick leaves.

Website:

http://www.actosoft.in/

Job Description:  

As a L3 analyst, you will play a key role within the Application Management team, leading services for its customer(s). This service has responsibility for the smooth daily operational running of the Client platform both in the cloud and on-premises. The Client application is business critical and centrally manages data for trading, settlement, risk, client and regulatory reporting systems. As a L3 analyst, you will be responsible for supporting complex infrastructure and application issues raised by L1/L2 support teams, and business analysts. You would also be working on client requests for enhancements, fixes, maintaining custom code, and following the best practices such as Agile, DevOps, etc.

The role is a technical role requiring a good technical knowledge of SQL/PLSQ, Core Java along with good debugging skill while supporting client implementations. You should have basic understanding on Unix system and commands. The ability to troubleshoot issues, assist users and help write specifications is essential. This position also works with product management to improve the software engineering processes and practices associated with continuously building, deploying, and updating software and environments.

• Accountability and primary responsibility/duties:
• A typical day would look like as follows: -
  • 40% support issues.
  • 40% configuration/development work.
  • 20% continuous improvement, automation, CICD, so on.
• Activities would range across the lifecycle from discovery to post-implementation support.
• Understanding client’s requirement, replicate the problem and providing the solution
• Understanding and developing new requirements coming in from BAs (Business Analysts) and customers.
• Update the existing functionality based on client needs.
• Develop changes that cater to enhancing the product and/or fixing production issues
• Prepare product releases of software components. (Java/SQL-PLSQL)
• Contribute in all phases of the development cycle. (development/Deployment/Testing, peer review)
• Create technical document for all changes made.

Required Qualifications/Knowledge/Skills

• Bachelor’s degree in Computer Science or related field
• Strong basics and working experience in following technologies: -
  • Core Java.
  • SQL / PLSQL coding.
  • Object Oriented Programming concepts and data structures.
• Working knowledge on Unix platform
• Working knowledge on XSLT and XML handling
• Basic understanding App & web server working knowledge (JBOSS, WebLogic and WebSphere) and debugging skills.
• Advantageous to have:
  • Working understanding on CICD, Dev-ops technologies.
  • Queuing technologies including Kafka, MQ, Solace.
  • Scripting including Python, Unix, java.
• Hands on knowledge of Dev ops processes and tools Good interpersonal and communication skills.
  
  

Requirements:

• 4-6 years of experience in developing Enterprise Web Applications using Java/J2EE technologies with a good professional track record.
• Excellent knowledge in Core Java (J2SE) and J2EE technologies.
• Proficient knowledge in Servlets, JDBC & JSP.
• Good knowledge of Spring framework (MVC, Cloud, Data and Security. Etc) and ORM framework like JPA/Hibernate.
• Strong knowledge of Exception Handling, Collections, File I/O Streams, Interfaces, and logging mechanisms is a must.
• Experience in developing REST APIs and integration of third-party APIs.
• Proficient knowledge in SQL/PLSQL.
• Expertise in application/web server deployment and connection pooling techniques.
• Cloud deployment (AWS & Azure) will be an added advantage.
• Experience in Version Control tools like Git, Bitbucket, etc.
• Experience in data security and protocols is a must.
• Maven and IDE tools experience is a must.
• Multi-threading and serialization techniques knowledge is a must.
• Good understanding of end-to-end software development lifecycle.
• Ability to read and understand requirements and design documents.
• Good Analytical skills and should be self-driven. Good communication with interpersonal skills.
• Open to learning new technologies and domains.
• A good team player and ready to take up new challenges
• Languages: Java(J2SE), J2EE (Servlets, JSPs, JDBC)
• Databases: MySQL, Oracle, SQL Server, PostgreSQL.
• DB Script: SQL and PL/SQL
• Frameworks: Spring, Spring Boot, Jersey, Hibernate and JPA
• OS: Windows, Linux/Unix.
• Cloud Services: AWS and Azure (Good to have)
• Version Control tools: Git, Bitbucket.
• Deployment Servers: Tomcat, JBoss, and Web sphere
• Build Tools: Gradle/Maven

.NET C# developer provides custom web application development using the .NET Framework, C#, VB.NET , ASP.NET , SQL Server and other advanced components of Microsoft technology and provide training to programmer analysts who support the web services manager' responsibilities.

Responsibilities:

 The tool development also involves working with SQL queries and web front end

Designing, developing, and testing web applications with .Net HTML, CSS and other technologies

Design and development of software applications (primarily web based) used in various areas of the bank (such as Loans processing, Treasury, Middle Office )

Manages the architecture, design, and coding of software for TFI from concept to finished product, in order to answer the needs of the Strategies, Sales, and Trading departments

Consults with end users within the Strategies, Sales, and Trading departments to identify where technology can automate current processes to enhance revenues and cut cost

Maintains currency in technical skills and all relevant fixed income industry sector factors

May lead the work of others and provide ideas which help to enhance TFI software applications

Software design & development principles such as SOLID, Domain-Driven-Design and Object-Oriented Development

ORM frameworks, particularly the Entity Framework

• Should have strong knowledge and hands-on experience in JDK 1.8+ 
•  Should have worked in Struts, Ajax, Spring MVC, Spring Boot and Angular 
• Should have strong expertise in SOA and Microservices • Experience in Insurance domain would be an added advantage
• The responsibilities of Java technical leads include working with developers to ensure quality network frameworks, mentoring junior level staff, and identifying issues that affect product delivery.
• Experience of Software Engineering Process and in Design J2EE Design Patterns.
• Code Review and Best practices, Unit Testing
• Team mentoring

• MUST HAVES:
1. Top  Mandatory Skills: 6+ Years in: JAVA / J2EE, Spring MVC ,Springboot, Microservices
2. Domain Experience:- BFSI (Minimum 2 yrs latest)
3. Joining time / Notice Period: Immediately

We are looking for a Java Developer with experience in building high-performing, scalable, enterprise-grade applications. . You'll be required to apply your depth of knowledge and expertise to all aspects of the software development lifecycle, as well as partner continuously with your many stakeholders daily to stay focused on common goals You will be part of a talented software team that works on mission-critical applications

Responsibility

• Write automated test cases to test code.
• Excellent teamwork skills with an ability to get the work done with minimal
• Experience with multiple mobile platforms is a plus.
• A passion and will to accept any new technical challenge that may come across.
• Linux scripting and SSH terminal
• Conceptual, Working knowledge of - DBMS, SQL, PL/SQL.
• Ability to write clean and documented code.

• A team player can provide technical expertise for a small team of developers.
• Strong hands-on and experience in core Java - Java/J2EE
• Design and implement new features, create UI, debugging, and data modeling.
• To update and sync with other team members daily.
• Ability to communicate effectively, both written and oral, at all levels to various technical and non-technical audiences
• Testing all applications against software and hardware versions. Provide timely turnaround and documentation of things implemented.

Additional preferred skills * JSP/Servlets OR JQuery/HTML5 AND JavaScript

Requirements:-

• Working knowledge of - MySQL.
• Working experience on Struts/Spring.
• Experience with web services standards and related technologies - SOAP/Rest, AJAX, JSON, and XML.

• You would be responsible for Developing SQL Databases, automation of business reports and Developing Business Dashboard using BI Tools.
• Development of high quality database solutions 
• Create complex functions, scripts, stored procedures and triggers to support application development.  
• Develop, implement and optimize stored procedures and functions using T-SQL
• Review and interpret ongoing business report requirements
• Build appropriate and useful reporting deliverables
• Analyze existing SQL queries for performance improvements
• Fix any issues related to database performance and provide corrective measures.  
• MIS Automation
• Provide timely scheduled management reporting
• Create Business dashboard using Tableau BI Tool

Requirement / Desired Skills:

• 5+ years of business Analyst / SQL developer experience in Fintech,internet,consulting etc industry
• Excellent understanding of T-SQL programming
• Excellent understanding of Microsoft SQL Server 
• Good knowledge of HTML and JavaScript 
• SQL Server Reporting Services and SQL Server Analysis Services
• Knowledge of any of the BI Tool (Tableau, PowerBI or Qlikview)

Position: Full Stack Developer

Location: Remote

Experience: 2-3 Years

.Net Core, Angular / AngularJS, PL/SQL is must

Skill Set:

• .Net Core, Angular JS - skills are a must
• Must have done WebAPI's.
• Implemented single Sign on - added advantage
• A bit of Pl/sql or Sql is an added advantage
• Must be aware of Agile Methodologies
• Must be aware of code versioning tool like GitHub/Bitbucket
• Exposure to tools like JIRA/Confluence is an added advantage
• Must be aware of Dependcy Injection pattern

• Over all 2-4 years’ experience in Inventory Management System and customization with third party systems,
• Atleast 2  years of hands on experience in Cramer 8 or Above version and customisations using Cramer integrations.
• Java/PL SQL Development hands on experience.

The ideal candidate will be familiar with the full software design life cycle. They should have experience in designing, coding, testing and consistently managing applications They should be comfortable coding in a number of languages and have an ability to test code in order to maintain high-quality code.

Responsibilities

• Design, code, test and manage various applications
• Collaborate with engineering team and product team to establish best products
• Follow outlined standards of quality related to code and systems
• Develop automated tests and conduct performance tuning

Qualifications

• Bachelor of Science in Information Technology
• 1+ years of experience working with .NET, Asp.net or relevant experiences
• Experience developing web-based applications in Asp.net, Dot net Core, jQuery, HTML5, Rest base API integration
• Understanding DB,PL/SQL, Webform
• Experience working in agile development environment

Java Tech Lead 

Minimum 8-10 years of experience in design, development, and deployment of JAVA/J2EE-based applications, writing PL/SQL queries/store procedures.

Strong hands-on experience in design, development, and deployment of J2EE based application database design, PL/SQL complex queries, and Store procedures XML, HTML, JavaScript, AJAX

• Expertise on XML, HTML, JavaScript, AJAX

• Proficient in handling and writing complex PL/SQL queries and Stored procedures

• preferable work experience on JBOSS as an application server or any other J2EE application server

• Should have sound knowledge in product customization, implementation, and maintenance aspects

• Foresighted & good judgment in problem-solving.

• Capable of paying attention to detail.

• Good analytical and logical thinking.

• Prioritizing and organizing

• Team Player with a positive attitude.

• Process knowledge/Technical expertise

• Good Written and Verbal communication Skills

- Writing queries used for front- end applications (websites, desktop applications)

- Designing and coding database tables to store the application data

.- Data modeling to visualize database structure.

- Reviewing query performance and optimizing code.

• Java,Jdbc,J2ee,Ajax,jquery,Spring,Hibernate, Restful Web Services, JAVASCRIPT, HTML, CSS 
• T-SQL and PL/SQL 
• Strong experience in core java 
• Experience in OOAD frameworks, Spring Integration, Hibernate, JSP, Tiles, Applets, Servlets 
• Extensive development experience with PL/PGSQL (PostgreSQL) 
• Good experience in code optimization, performance tuning, debugging 
• Web/App server: TOMCAT/JBOSS/WAS 
• Knowledge of OOPS concepts, SDLC, and design patterns 
• Good Analytical ability and Problem Solving Skills 
• Good communication skills in both written and verbal 
• Java Certification will be an added advantage 

The ideal candidate will be responsible for creating, installing and managing our databases. You will ensure optimal database performance by analyzing database issues and monitoring database performance.

What will I be doing?

• A professional Database Administrator (DBA) will be responsible for the architecture, performance, integrity, and security of a database.
• Design and build highly available microsoft MySQL and SQL solutions, making use of log shipping, mirroring and always on technologies
• Ensure performance, security, and availability of databases
• Prepare documentation and specifications
• Handle common database procedures such as upgrade, backup, recovery, migration, etc.
• Design, create and implement database systems based on the end user's requirements.
• Collaborate with other team members and stakeholders
• Collaborate with the engineering and production support teams to create forward-looking service improvement plans and roadmaps.
• Installation, configuration and upgrading of application software and related products

 What Skill do I need ?

• Minimum 5 years of experience in database administration, information technology, database architecture, or a related field
• Installation, configuration and upgrading of MS SQL/Oracle/MySQL/ Server software and related products
• Strong proficiency with Microsoft SQL, and ideally its variants in other popular RDBMS
• Skilled at optimizing large complicated SQL statements
• Proven working experience as a Database Administrator and expert in MongoDB
• Install server software, configure database servers, monitor and maintain system health and security
• Excellent knowledge of data backup, recovery, security, integrity
• Familiarity with database design, documentation and coding
• Previous experience with DBA case tools (frontend/backend) and third-party tools
• Problem solving skills and ability to think algorithmically
• Experience with large databases and complex process models

Required Qualification :

• Bachelor's Degree or equivalent experience in Computer Science, Technology, or a related field of study
• Proven knowledge of SQL Servers, Cpanels, MySQL
• Strong analytical, problem-solving, and decision-making skills
• Advanced working SQL and MySQL knowledge and experience working with relational databases, query authoring (SQL)
• Excellent knowledge of Performance tuning, DB administration, data backup, recovery, security, integrity
• Experience working with both structured and unstructured data.
• Excellent problem-solving and analytical skills
• Good communication, teamwork and negotiation skills

• 4-15 year experience in Application Support
• Must have good knowledge in Java/J2EE, Microservices, PL/SQL, Unix
• Good to have knowledge in Agile, JIRA, Splunk, Service Now
• Good understanding and hands-on experience in Incident, Problem and Change Management
• Provide technical leadership to the team & contribute in the skill development within team
  Interact with internal teams and client stakeholders to trouble shoot the tickets/incident and manage other support activities
• Good communications skills are necessary, must be team player and inquisitive.
• Strong customer service and support focus with a desire to deliver a high-quality service
• Ability to multi-task, work under pressure and to tight deadlines
• Flexible in working outside of office business hours at short notice (as required)
• Should be able to examine the system and identify the areas for Service Improvements & Value adds.

Oracle Apex Developer:

• No. of Position: 3
• Budget: 12 - 16 LPA all inclusive depending on experience bracket
• Work Location – For Mumbai candidate it will be Mahape - Navi Mumbai; candidates from Pan India who are not ready to relocate can permanently WFH.
• Joining Time – Immediate to 45 Days
• US Client – Long term logistics domain project
• Opportunity to work with a team of 20+ Apex experts on the latest Apex technologies in the market
• Onsite opportunity for tenured employees

Experience:

• 5-8 years’ experience in Oracle PL SQL & Oracle Apex; (Majority of Oracle Apex experienced required)
• Preferred Education: B. Tech / B. E - Any Specialization, Computers (OR) BCA (AND/OR) MCA                                 

Core Competencies:

• Experience working on Oracle PL/SQL Programming and DB features
• Proficient in Oracle Apex components is a must
• Experience in Javascript, Jquery and CSS
• Knowledge of Page zero concept, shared components, Page rendering & processing, Interactive reports
• Exposure to DBA activities like Table space management, Export/Import etc.
• Experience in Unix Shell scripting
• Exposure to any reporting tool
• Good communication skills
• Ability to take responsibility and handle pressure 
• Ability to think creatively and solve complex problems 
• Self-motivated, fast learner with the ability to operate independently 
• Team player with strong interpersonal skills and a willingness to help others 
• Ability to thrive in a cross-functional team on business-critical projects 
• Intrinsically cares about the quality of work 
• Organized and focused on delivering tasks within defined deadlines

Specific Responsibilities:

• Would work in design, develop, enhance, test and maintain software applications
• Design and develop SQL scripts, stored procedures, packages, parameterized queries and objects using tools like Toad, SQL Developer, Pl/SQL developer
• Build and maintain Application database schema/objects and account for data migration/upgrades across versions
• Identify and automate routine maintenance tasks
• Optimizing DB queries, stored procedures, Data structures, Indexes and DB Normalization.
• Certify all queries written by software developers to ensure optimal execution of the queries
• Research, investigate and evaluate potential database solutions to business problems/requirements
• Write Test cases for developed queries/functions using PLSQL and Quest code tester.

Experience: 8+ years

Job Type: Full Time

Job Location: Ahmedabad

Technical project manager act as the primary point of contact for our clients. You will ensure teams are successful in their delivery through proven technical and interpersonal abilities. In this role, you will bring a strategic mindset to projects and ensure top-quality results from the team.

What we offer

• Open, positive, and learning culture surrounded with tech-savvy and helpful colleagues with a growth mindset
• Best-in-industry salary standards
• 5 days work week
• Family health insurance cover
• No politics and value-driven culture 
• Occasional Work From Home even in non-COVID19 times
• Contribute to large scale distributed systems used by fortune 100 companies

Must have

• 4+ years of development experience (preferably Java)
• 2+ years of experience in Agile project management (or a scrum master) and leading development and QA teams
• Experience working with off-shore clients (US/EU) with strong knowledge of Agile & SCRUM processes
• Provide effective mentoring & coaching on technical, soft skills, and process aspects to the team
• People orientated approach to leadership that keeps the team motivated and focused on the goals
• Strong communication and management skills with the ability to find innovative ways to resolve problems
• Hands-on approach to technical problem solving and debugging

• Proactive and inherent nature of working with ownership

Good to have

• Frontend development experience with CSS, JavaScript (ES6) or modern JS frameworks like AngularJS/React/VueJS
• Performance optimization experience with SQL
• Experience with ElasticSearch/Solr, NOSQL, messaging system
• Prior experience working as a tech lead, team lead or software architect

Roles and Responsibilities

• Actively participating in client calls for requirement grooming and designing
• Participate in design discussions with fellow team members and client
• Present groomed tickets and design to team members for design discussion
• Lead Scrum meetings and provide team support during sprint planning and execution.
• Ensure project processes (e.g. code reviews, QA, deployment reviews) are followed religiously
• Identify individual and team strength and improvement areas
• Build strong rapport with team members to understand them deeply at the individual level
• Set quarterly objectives and key results (OKRs) for individuals
• Conduct performance review meetings
• Mentor junior team members, level them up and inspire to deliver extraordinary impact together

• Improve software development operations by proactively finding gaps in processes

• Build a trusting relationship with customers and teams

• Negotiate and get buy-in of sprint scope from customers & team

• Come up with pragmatic solutions to improve software quality and drive the change if approved by the customer.

• Manage KPIs & rigorous feedback cycles (through one-on-one meetings with peers) that help align with individual and organization growth.

Join us for building great teams and intuitive projects together!

• Role: Oracle EBS Lead Technical/Techno Functional 
• Experience: 8+ Years
• CTC: No bar for the right talent

Requirements:

• Oracle E-Business Suite (Implementation, Upgrade and/or Support): 12+ years
• Oracle SCM and procurement Experience
• Strong Communication and inter personnel skills. Prepare and deliver communications to various audiences, including business and IT leadership
• Lead, development and Customization's of Oracle E-Business suite RICEWF (Reports, Interfaces, Conversions, Extensions, Workflows & Forms) components using Oracle technologies like Oracle PL/SQL, Oracle workflow, XML/BI publisher, Oracle Reports & Forms 10g, Form Personalization, WEB ADI, OA Framework (OAF).

Job Description:
7+ years of experience as a Techno-Functional specialist supporting a finance organization with an emphasis on project management.

Must have 2-3 Project implementation and more than one support experience in Oracle EBS R12.

Expert level knowledge of Oracle Applications Framework, Oracle Workflow, Oracle Forms, Oracle Report, XML Report, PLSQL

Functional knowledge in financial module like, GL,AP, AR PO, Project is must Extensive use of oracle APIs and interfaces Experience in performance tuning of the code Experience in shell scripting.

Worked on Oracle Alert, AME, OAM ,DFF etc Good to have ADF experience Good to have ORDS experience Good to have exposure in cloud technology.

Responsibilities:
Act as a senior liaison between Business partners and IT communities Facilitate cross-functional teams through business process and application initiatives from requirements definition to prototyping, design, development, testing, training, and deployment.

Create technical designs to support business requirements.

Lead the development of technical solutions. Communicate project status and escalate issues to management. Develop and execute system test plans and scenarios.

Assist in preparing training materials for deployment of applications, modules, enhancements and bug fixes.

Assist in developing baseline datasets and reports to support testing of technical solutions.

JD for ASP.Net with C# and Azure

Soft Skill:

Self driven, Motivated, Hardworking, Proactive, Good communication skill and documentation skill, should have experience in gathering business requirement and documentation. Should be a team player

Technical Skills:

A must:- ASP.Net MVC, Javascript, Jquery, Windows Azure, SQL Server, PL/SQL, ASP.NET using C# - SD [Primary], API creation PL SQL, Azure

Desirable: - Knowledge on MVC dot net core

- Developing the web based software using computer programming languages such as Asp.net, Sql Server, MVC, Entity framework.

- Creating and maintaining the ASP.NET based websites and their web applications as per the initial guidelines of the client.

The Position Summary

In this role, you will work with Huron and client team members throughout the entire implementation lifecycle, including planning, configuration, design, build, testing, training, change management, go-live, and post-production support.  The Consulting Associate will be responsible for all aspects of Oracle EPM Cloud system implementation including requirement gathering, application design, application configuration, and implementation.

Must have skill: Require

Java: Core Java, Spring Framework, RESTful API

Front End: Angular, React js

Database: Oracle, PL/SQL

Application Server: WebLogic

**Should be Aware of**

CI/CD pipeline

Good to have the Testing Tools knowledge

Sonarqube, Junit, Mockito

Interested kindly share cv at adityawadhera(dot)[email protected] hcg(dot)com

Education: BE / B.Tech- EEE/ECE/E&I/ Instrumentation and Control
Experience: 3-6 years in the graduates.
Minimum 3+ years of experience in Industrial Automation applications for manufacturing environment.

Domain knowledge: In areas of Industrial Automation technology tools – PLC/DCS/SCADA/HMI for Manufacturing in one or more of the following verticals: Chemicals, Glass, Construction products, Automotive, Abrasives, ceramics industries.

Requirements:

• To be part of Digital Manufacturing and Industry 4.0 projects across Saint Gobain group of companies
• Design and develop Industrial automation applications for discrete, process and hybrid Manufacturing
• Experience in working with various Automation OEM or systems Integrators- Rockwell/Siemens/Schneider
• Experience in providing the network architecture for connectivity of PLC/DCS/OPC/HMI for software integration
• Experience in Industrial automation tools- feature selection, product evaluation for cost effective solution
• Expertise in Industrial automation - Best Practices, Industry Standards and integration methodologies
• Experience in various SCADA platforms such as - GE Proficy, Wonderware, Siemens Win CC, RA Factory Talk
• Collaborate with multi-functional teams to provide Industrial Automation solutions for Digital Manufacturing
• Part of end to end project of automation right from design to delivery of the project.

• Basic knowledge of Oracle Forms and reports - (Must)
• Good experience on SQL*Loader.
• Should Knowledge on Agile / Scrum.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Using SQL developer tool we debugged the code and unit test
• Knowledge of oracle programming
• MySQL, Oracle,
• Knowledge of Unix platform
• PostgreSQL
• advance database knowledge.
• Writing PL/SQL and PL/MySQL
• Coding support
• Debugging & Project module management
• Deployment and fine-tuning as per team lead.