Seeking for candidates with 5+ yrs of experience in Oracle background using PL SQL.
Responsible for writing PL/SQL Stored procedures, functions, triggers, cursors, views, Indexes, Sequences, collections, bulk binding etc
Responsible in writing complex queries with varied large data sets
Analyse, Design, Code and Debug using Oracle/PL SQL
Good in PL SQL concepts like Oracle Packages, stored procedures, functions, triggers, cursors, views, Indexes, Sequences, collections, bulk binding etc.
Ability to write efficient, complex queries against very large data sets using SQL Developer and TOAD
Expertise in pl/sql concepts- Oracle Packages, stored procedures, functions, triggers, cursors, views, Indexes, Sequences, collections, bulk binding etc
Experience in performance tuning - Strong analytical, design and debugging skills

About Careator Technologies Pvt Ltd
About
Careator Technology is an end-to-end service provider for all your Application Development, Recruitment, and Staffing related requirements. Our primary competitive advantage is our ability to provide customized solutions that cover the whole process from beginning to finish. Careator maintains a broad variety of productive partnerships with organizations of the highest tier, and the firm ensures that each of its commercial associates is provided with an effective solution.
The founders of Careator understand that the combination of people and technology is essential to the success of a business. The company places a high premium on its employees and their relationships. This is reflected in the way that it creates its operational and strategic models, how it responds to consumers, how it connects with people, and how it promotes diversity in the workplace and the community.
Connect with the team
Similar jobs
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
Job Profile
Purpose of Role: To support and maintain the existing and future applications managed by ABD (Agile Business Development) Team.
Main Responsibilities:
- To work on existing and future applications as required
- Work with ABD India Application Support and Business Support team to address production issues and/or to do development work
- Work with US ABD team to coordinate the on-going support and monthly release of C-Hub (Customer-Hub) application and other ABD Applications
- Report status to management on project progress
- Identify and escalate related issues and risks
- Coordinate with others in Development and Business Support team to implement new features of SQL Server/ MS Web based technologies
- Assess current modules and offer performance improvements techniques
- Make sure Database Design Standards/coding standards established by ABD are followed
- Constant communication with ABD leadership team in US.
- Problem Solving ability with “Can-do” attitude
- IT experience in Banking industry is preferred
Candidate Profile:
- Minimum 10 years of experience at least 3-5 years of experience in Corporate & Investment Banking area and Bachelor's degree in Engineering, Accounting, Finance, or equivalent
- Expertise with MS SQL Server development including SSIS and SSRS, Proficient in development of Stored procedure, Views, Functions etc in MS SQL Server
- Experienced with DBA kind tasks such as replication, linked server, query analyzer, DBCC commands, data transfer from one DB server to other DB Server etc
- Experienced in MS Excel VBA and macro scripting
- Knowledge of data Encryption in database


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
- 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.


- As a polyglot developer Ideally, you should have:
- 1.5+ years of development experience using any of technology java, scala, python or any similar exciting technologies.
- Hands-on experience in coding, and implementation of complex, custom-built applications Working knowledge of build tool like maven/sbt and code versioning systems like git/bitbucket/cvs/svn
- Familiarity with few databases, like MySQL, Oracle, PostgreSQL, SQL Server, NoSQL etc Great OO skills, including strong design patterns knowledge
- Good communication and ability to work in a consulting environment is essential
- Think through hard problems in a consultancy environment, and work with amazing people to make the solutions a reality Work in a dynamic, collaborative, non-hierarchical environment where your talent is valued over your job title or years of experience
- Build custom software using the latest technologies and tools Craft your own career path
- Providing solution to real problems in Bigdata world.
- RnD on using the latest tools,techniques and cloud services.
- Automating the manual-timetaking tasks.
- Hands-on coding, usually in a pair programming environment.
- Working in highly collaborative teams and building quality code
- Working in lots of different domains and client environments
- Understanding the business domain deeply
We are a team of technology agnostic, passionate people who aim to provide solution to real world Bigdata problems.
We are building solutions that will help our customers to do automatic migration of their RDBMS systems to latest BIGDATA platforms and tools such as Spark, Apex, Flink etc. For more information do visit our products webpage.
We are looking for a Senior Microsoft SQL Developer to design, develop, test, plan, implement and maintain conceptual and logical database models.
For this role, you should know how to analyze system requirements and implement migration methods for existing data. Hands-on experience with SQL Server 2012 and above is also required. Ideally, you are familiar with database design, reviewing code, writing stored procedures, creating and modifying SQL agent jobs, making structural changes to tables and views.
Ultimately, you will develop database solutions to ensure project information is stored effectively and securely.
We’re a fast-growing company with clients in the United States, UK, and Australia. You will join a team of talented developers, quality engineers, product managers whose mission is to impact above 100 million people across the world with technological services by the year 2030.
Working as Senior Microsoft SQL Developer at Navtech, you will:
- Design conceptual and logical data models and flowcharts.
- Improve system performance by conducting tests, troubleshooting, and integrating new elements.
- Design and Build database systems of high availability and quality depending on each end user’s specialized role.
- Help write and optimize in-application SQL statements.
- Handle common database procedures such as upgrade, backup, recovery, migration, etc.
- Ensure performance, security, and availability of databases.
- Use high-speed transaction recovery techniques and backup data.
- Provide proactive and reactive data management support and training to users.
- Determine, enforce and document database policies, procedures, and standards.
- Perform tests and evaluations regularly to ensure data security, privacy, and integrity.
- Monitor database performance, implement changes, and apply new patches and versions when required.
- 5+ years of experience in SQL Server Development with at least 1 year of Lead experience.
- Advanced experience in database monitoring, troubleshooting, performance tuning, and high availability strategies for SQL Server 2016, SQL Server in Cloud (AWS RDS preferred).
- Advanced skills in resolving database locking conflicts/blocking and resource utilization.
- Ability to work with other developers and engineers to analyze database performance and identify problems in areas such as execution plans, index coverage, and SQL server statistics.
- A thorough understanding of Performance Monitoring, Tuning, and Optimization, using native and third-party monitoring and troubleshooting tools.
- Advanced knowledge of SQL Server Disaster Recovery (DR) options, Always On availability groups, and experience administering Windows Server, including Active Directory, Failover clustering, database partitioning, security, and encryption (a plus).
- Experience supporting SSIS, SSRS, replication, database mirroring (a plus).
- PowerShell scripting experience with the ability to write automated scripts and strong knowledge of system tables and DMV’s is required. (a plus).
- Administering Microsoft SQL Server databases in a high transaction, 24x7 database environment (a plus).
- Experience in Postgres, No-SQL databases (a plus).
- MCSA SQL Server 2012/2016 , MCSE or MCDBA (a plus).
- Should have excellent logical, analytical, and communication skills with client interaction experience.
Benefits
- Working with industry giants while following your passion for technology.
- Competitive pay package with additional bonus and benefits.
- Performance review and Appraisal Twice a year.
- Family Health Insurance cover for self and family.
- Work with US, UK, and Europe-based industry-renowned clients for exponential technical growth.
- Work with a culturally diverse team from different geographies
5 years of architecture, design and programming experience preferably in fast-paced dynamic environment
Strong application design and implementation skills, solid understanding of the entire development cycle.
Strong background in Java/J2EE based application
Strong background in Spring/Spring boot based application
Strong background in Microservices based application
Experience working with Apache and/or Tomcat
Experience in transforming requirements to software design
Strong Experience with developing Java SAAS web applications.
Working experience in Industry Standard protocols related API Security including OAuth
Demonstrate strong design and programming skills using JSON, Web Services, XML, XSLT, PL/SQL in Unix and Windows environments.
Strong background working with Linux/UNIX environments.
Strong Shell scripting experience.
Working knowledge with Oracle, DB2 or MongoDB databases.
Passion to stay on top of the latest happenings in the tech world and an attitude to discuss and bring those into play. Strong agile/scrum development experience
Strong collaboration and communication skills within distributed project teams
Excellent written and verbal communication skills
Job Description:
- Resource should be proficient in analyzing, designing and developing applications based on the requirements provided by business counterparts
- Developing and maintaining applications developed in Java, J2EE, Struts and Spring and possessing 3-layer architecture
- Good knowledge in Spring Boot, Hibernate, Angular JS, Docker, VUE JS and AWS
- Applications development or maintenance using ORM tools such as Hibernate
- Database management which includes DB design and maintenance, mostly related to 2016 and Oracle 19c, DB2
- Should have knowledge in Unix / Linux OS.
- Should have good knowledge in Shell scripting language
- Strictly adhere to the internal SDLC process quality standards set but the organization and providing the drive to the team to achieve the KPI and SLA targets
- Flexible to work in extended time
- Candidate should have good experience on Java / J2EE, Springboot, Hibernate / JPA, Oracle query, Web Services and Rabbit MQ.
- Should have minimum of 3 to 5 years of experience. Should be able to work on enhancement, maintenance and production support.
- Good to have hands-on experience on DEVOPS & API development.
Role: Software Engineer
Location: Hyderabad
Experience: 3-5 years of experience in software development using Core Java, multi-threading, DS and Algos.
Key Requirements:
- • Develop robust Core Java code for advanced financial banking and trading applications, primarily using core Java principles around multi-threading and caching technologies.
- • Strong in Core Java concepts, JVM, API’s along with SQL and Java Message Service (JMS) skills.
- • Experience in Java server-side / backend development experience
- • Experience in Java Spring (Spring MVC, Spring batch, Spring Boot), Hibernate and JPA is a plus.
- • Knowledge of microservices development, container stack and CI/CD;

Mandatory Requirement/ Preference:
- 4 years of experience for delivering enterprise solutions or products using full SDLC
- 4 years of work experience with enterprise solutions for Microsoft platform (SQL Server, stored procedures, WCF, C#.net, Entity Framework)
- Extensive knowledge and experience with creating and maintaining stored procedure in MS SQL Server.
- Working with WEB API added advantage

