12+ Oracle NoSQL Database Jobs in India

Database Architect & Engineer

Work Mode - Work from Home

Experience Required - 5+ Years

Immediate joiners are preferred.

Job description

Seeking a seasoned Database Architect with expertise in Oracle and/or PostgreSQL, system wide migrations, and complex query creation and optimization. The ideal candidate should have at least 5 years of experience in database management and be able to work independently. Key responsibilities include defining a schema for a new product, managing and maintaining databases, planning and executing system wide migrations, creating and optimizing complex queries, ensuring the security and integrity of the database, and providing training and support to team members. This role requires excellent communication and problem-solving skills, as well as a strong understanding of database architecture, design, and security.

Responsibilities:

- Design, implement, and maintain Oracle and PostgreSQL databases

- Expert in ETL tools, data integration, and migration processes

- Create and optimize complex SQL queries for performance and efficiency

- Develop and refine database functions, procedures, and packages

- Analyze and troubleshoot database performance issues, implementing tuning solutions

- Ensure database architecture aligns with application needs and best practices

- Collaborate with development teams on data models and database design

- Provide documentation, training and support to other team members

- Assure quality, security and compliance requirements are met as part of projects

delivery

Qualifications:

- 5+ years of experience with Oracle and/or PostgreSQL

- Experience in designing database schemas from scratch

- Experience with documentation such as ERDs and DB Relations

- Experience with system wide migrations

- Strong understanding of database architecture and design

- Experience with complex query creation and optimization

- Experience with performance tuning and troubleshooting

- Strong understanding of database security

- Experience with database backup and recovery

- Excellent communication and problem-solving skills

- Bachelor's degree in Computer Science or related field is a plus

- Experience in development of SaaS enterprise scale product

- Experience in working with globally distributed teams following Agile methodology

and Scrum.

- Experience in working with modern CI/CD tools and related ecosystem of

applications - uDeploy, Jenkins, Artifactory, Maven etc.

- Experience using source control tools like Git, SVN etc.

Key Responsibilities

• Analyze and understand business processes and requirements to develop effective technical solutions.

• Assist in the planning, designing, development, of new applications and enhancements to existing applications.

• Collaborate with IT team members, decision makers, systems owners, and end users to define business requirements and systems goals, and identify and resolve business systems issues.

• Prepare functional specification documents in accordance to new business requirements.

• Ensure compatibility and interoperability of business software applications.

• Review and analyze the effectiveness and efficiency of existing systems and develop strategies for improving or further leveraging these systems.

• Assist in the deployment of new applications and enhancements to existing applications.

• Identify, assess, and recommend software solutions and implementation partners to management.

• Perform cost-benefit and return on investment analyses for proposed systems to aid management in making implementation decisions.

• Participate and sometimes drive IT projects to ensure that system requirements and data engineering needs are addressed throughout the project life cycle.

• Create systems models including integration points, specifications, diagrams, and charts to provide direction to internal stakeholders and third parties.

• Coordinate and perform in-depth tests, including end-user reviews, for modified and new systems.

• Provide orientation and training to end users for all modified and new systems.

Qualifications & Experience

• Minimum Bachelor’s degree in Information Technology, Computer Science, or related field.

• Minimum of 5 years of experience in related fields with 3 to 4 years in systems and/or functional analysis.

• Proven experience in analysing, designing, and implementing information systems.

• Strong understanding of business processes and technical systems.

• Hands-on skills in SQL and databases (e.g. Oracle, SQL Server).

Other Prerequisites

• Excellent problem-solving skills and the ability to work under pressure. • Good project management skills.

• Excellent written and oral communication and interpersonal skills.

• Ability to conduct research into systems issues and products as required.

• Ability to communicate ideas in both technical and user-friendly language.

• Highly self motivated and directed.

• Keen attention to detail.

• Proven analytical and creative problem-solving abilities.

• Strong customer service orientation.

• Experience working in a team-oriented, collaborative environment

Bachelor’s degree in Computer Science,

Information Systems or related field and/or equivalent relevant experience  Three years of progressively challenging experience working as a CC&B suite Senior Developer in solution architecture, project management, system design, development testing, implementation and support  Advanced knowledge in CC&B Java, C2M, Oracle Database, CC&B data model and Oracle Utilities Application Framework  Proficient in usingHibernateQuery Language, XAIIWSWeb Services, CCB Configuration Tools, web-based languages(e.g., HTML, XML, SOAP, JavaScript, etc.) and UNIX • Extensive experience with Oracle Utilities SDK and Eclipse 3.7 and with writing high performance, multi-threaded, critical java applications over large databases including Oracle 10g and Oracle 11g.  Proficient working knowledge of SQL and relational database concepts and developing stored procedures in Oracle 10g and Oracle 11g  Knowledge and understanding of software development life cycle and industry best practices  Proficient in the use of MicrosoftOffice applications  Experience should include multi-product implementations (CC&Bintegrations with MWM, MDM, WAM, CSS, etc).  Must have experience with otherintegrationsinvolvingthe XAI IWS interfaces  Must have in-depth knowledge of field order and field activities workflow, configuration and writing custom services  Must have prior experience implementing (mobile workforce) any other third party workforce tool with CC&B  Must have prior experience implementing CC&Bwith a customer portal 

Bachelor’s degree in Computer Science, Information Systems or related field and/or equivalent relevant experience  Three years of progressively challenging experience working as a CC&B suite Senior Developer in solution architecture, project management, system design, development testing, implementation and support  Advanced knowledge in CC&B Java, C2M, Oracle Database, CC&B data model and Oracle Utilities Application Framework  Proficient in usingHibernateQuery Language, XAIIWSWeb Services, CCB Configuration Tools, web-based languages(e.g., HTML, XML, SOAP, JavaScript, etc.) and UNIX • Extensive experience with Oracle Utilities SDK and Eclipse 3.7 and with writing high performance, multi-threaded, critical java applications over large databases including Oracle 10g and Oracle 11g.  Proficient working knowledge of SQL and relational database concepts and developing stored procedures in Oracle 10g and Oracle 11g  Knowledge and understanding of software development life cycle and industry best practices  Proficient in the use of MicrosoftOffice applications  Experience should include multi-product implementations (CC&Bintegrations with MWM, MDM, WAM, CSS, etc).  Must have experience with other integrations involving the XAI IWS interfaces  Must have in-depth knowledge of field order and field activities workflow, configuration and writing custom services  Must have prior experience implementing MWM (mobile workforce) or any other third party workforce tool with CC&B  Must have prior experience implementing CC&Bwith a customer portal 

• BE/MTech/MCA/MSc
• 3+yrs Hands on Experience in TSQL / PL SQL / PG SQL or NOSQL
• Immediate joiners preferred*
• Candidates will be selected based on logical/technical and scenario-based testing

Note: Candidates who have attended the interview process with TnS in the last 6 months will not be eligible.

1. Technical Skills Desired:
   1. Experience in MS SQL Server and one of these Relational DB’s, PostgreSQL / AWS Aurora DB / MySQL / Oracle / NOSQL DBs (MongoDB / DynamoDB / DocumentDB) in an application development environment and eagerness to switch
   2. Design database tables, views, indexes
   3. Write functions and procedures for Middle Tier Development Team
   4. Work with any front-end developers in completing the database modules end to end (hands-on experience in parsing of JSON & XML in Stored Procedures would be an added advantage).
   5. Query Optimization for performance improvement
   6. Design & develop SSIS Packages or any other Transformation tools for ETL

1. Functional Skills Desired:
   1. Banking / Insurance / Retail domain would be a
   2. Interaction with a client a

1. Knowledge in a Cloud Platform (AWS / Azure)
2. Knowledge on version control system (SVN / Git)
3. Exposure to Quality and Process Management
4. Knowledge in Agile Methodology

1. Soft skills: (additional)
   1. Team building (attitude to train, work along, mentor juniors)
   2. Communication skills (all kinds)
   3. Quality consciousness
   4. Analytical acumen to all business requirements

Job Description & Responsibilities:

Selected engineer's day-to-day responsibilities include:

• Performs Database Administration tasks in Oracle & MS/MY SQL. Also performs basic DBA tasks in

SQL Server and DB2 environments as necessary.

• Designs and builds simple to complex database structures from data models.

• Installs, configures and patches Oracle.

• Implements HA and DR systems using Data guard and RAC.

• Builds and manages Data Guard Physical/Logical Standby Databases using Data Guard Broker

• Provides rotating 24x7 on-call support for company's Oracle, SQL Server, and DB2 environments as

necessary.

• Participates in design reviews as required to ensure database design meets application

requirements.

• Designs, maintains, documents and executes database utilities to provide information regarding

database activity.

• Proactively performs database monitoring and performance tuning tasks.

• Identify and provide solutions to performance issues in multiple database environments.

• Provides automation to standard DBA tasks. Able to develop scripts on UNIX and Windows

platforms as necessary.

• Reviews and enforces adherence to the company's Architecture, as well as database design and

usage standards.

• Understands database high availability technologies and guides the company in implementing

appropriate solutions.

• Performs other duties as assigned.

Location : Chennai, Tamil Nadu

Joining : Immediate – 15 days

Education, Experience & other requirements

• B.S. degree from an accredited university.

• Must have solid Oracle RAC , Golden Gate & Data Guard experience.

• 3+ years of extensive experience with Oracle database installation / configuration best practices

and Database upgrade/migration approaches.

• Experience installing, building, upgrading and supporting Oracle RAC environment, ASM,

Grid/Cluster.

• In-depth knowledge and hands-on experience in the installation, configuration and

troubleshooting of Oracle products and patches, including Oracle 12c, RAC, ASM, Clusterware,

GoldenGate, Dataguard, Oracle Database Appliance (ODA), Oracle Enterprise Manager 12c.

• Experience in Oracle 12c RAC based environment - architecture, installation, building, upgrading

and maintenance of Oracle RAC based environment in production.

• Extensive experience in Oracle DataGuard replication and physical standby for Disaster recovery

• Working experience of Oracle Database Appliance.

• Strong knowledge of OEM 12C grid monitoring configuration.

• Strong working experience with RMAN configuration, Job maintenance and backup & recovery

• Experience in database problem identification, problem diagnosis and resolution.

• Experience in building data architecture models and enforcing enterprise architecture standards

and guidelines.

• Excellent communication – ability to explain a technical problem to management.

• Ability to work on high performing teams and deliver under pressure situations.

Main tasks

• Implementation, operating and monitoring of LS system solutions on-premise and in the cloud
• Analysis and sustainable troubleshooting of system failures
• Support in the area of information and IT security

Qualification profile

• Successfully completed training or studies in the field of IT
• Experience in operating on-premise, public and private cloud solutions
• Young professionals are welcome
• Good English skills
• Knowledge in the following areas
• Oracle Database
• Oracle Application Server
• Oracle Linux
• Oracle Linux KVM
• Oracle Weblogic

Position Overview

Oracle Apex Engineer with good experience building reports using the latest versions of Oracle Apex

and experience in Apex Upgrade. Should have a good working knowledge of Oracle

Applications(R12).

Skills

1-2 end to end implementation/development project

Strong detail, quality, and solution orientation

5+ years of experience designing and implementing technical solutions that are aligned with

business strategy

5 years of applications development experience with Oracle APEX, Oracle SQL, PL/SQL

5+ years of Oracle APEX experience

5+ years experience in Oracle Databases

5+ years experience using PL/SQL

5+ years of JavaScript, HTML, CSS, and REST services

Oracle APEX 4.2 experience is a must and ability to Upgrade to higher versions

Ability to work on SQL performance issues

Ability to think critically and solve complex issues

Ability to work independently, while engaging the customer and providing information to the team

Strong ability to communicate both verbally and in writing with internal and external teams

Ability to prioritize across multiple projects and meet deadlines

Experience adapting in a dynamic work environment

Experience working in a customer-focused environment

Ability to troubleshooting issue

Proficiency in analysis, design, development, testing, implementation, and maintenance of

applications in Oracle Application Express (APEX).

Excellent conceptual knowledge of Oracle 11g.

Rich experience in writing SQL queries, Views, Materialized views, PL/SQL procedures, functions,

packages, triggers, cursors, collections, Ref cursor, cursor variables, System reference cursor,

Dynamic SQL.

Good knowledge of using PL/SQL Wrappers to protect the PL/SQL procedures and packages.

Essential duties and responsibilities include the following. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

• Work on a remote cross-functional team where you’ll play a critical role in designing, planning, development, deployment and observing your code in production.   
• Develop high performance, highly scalable and accessible web applications. Our web app is used by over 20 million educators, students and parents worldwide.  
• Meet tight deadlines in a rapid application development environment.  
• Collaborate with Product Management, Design, and Operations teams to create and deliver tested features to production.  
• Collaborate with specialists across web, mobile, and operations to achieve a better user experience for our product.  
• Be able to assess and bring in industry information into your decisions and learn new technologies: AWS is releasing new tools every day, there are new open source libraries to vet and you will be a party to helping us vet and pick the best tool for the job.  
• Be willing to work in any area of the codebase if needed, this can include JavaScript/TypeScript/Node, PHP, Java or other technologies.  
• Help staff, build, and form the culture around a team of 5 engineers, a product manager, designer, QAs and associated supporting roles.

Qualifications include:

• Strong CS fundamentals including familiarity with data structures and especially the asynchronous challenges that face JavaScript developers today.   
• Experience developing in at least 2 server side languages (PHP, node.js, …)  
• Experience developing in at least 1 client side JS framework (ReactJS, Angular, …)  
• Experience testing software in alignment with the Test Pyramid.  
• Experience with datastores, either SQL (MySQL preferred) or NoSQL, and the ability to talk deeply about them.  
• Able to identify the source of complex problems occurring as a result of multiple systems interacting (experience with observability tools such as datadog/newrelic is a plus).   
• Experience working on a team of 5 engineers plus supporting roles (e.g. QA, design, etc), preferably as a Senior Software Engineer.  
• Experience with code review, being able to sign-off on another team member’s code ensuring high quality standards.  
• Be self-sustained even when tackling the highest profile, most difficult work across the organization.  
• Willingness to accept responsibility and be accountable not only for your own work but the work of the team as a whole.  
• Experience working with other people’s code, how to dig into it and make tactical changes with minimal side effects.  
• A solid understanding of how to break down user stories and give estimates that include accessibility and security requirements.  
• Be able to see roadblocks far ahead, across many vectors of risk  
• Be a true team player! Ensuring their knowledge and expertise is shared amongst other team members and even cross-team and be willing to seek out opportunities to mentor teammates.  
• A commitment to learning about anything you don’t know on your own and without much supervision.  
• Superior communications, organization and relationship building skills — you’re going to be working on cross-team efforts, so this is essential.  
• Self-motivation as well as ability and desire to learn new technologies, applications, processes, and environments.  
• A belief that delivering code to production is just one step in the process. Observing and owning the code you wrote goes hand in hand with construction.  
• A desire to take on whatever challenge is most important. This could be tackling something you are familiar with, or it could require a deep dive into a whole new world. The key is having the right attitude.   

1. Strong fundamentals OOPS concepts, Exception Handling, Coding Standards, Logging

2. Creating custom, general use modules and components which extend the elements and modules of core Angular. 

3. Creating configuration, build, and test scripts for Continuous Integration environments

4. Communicating with external web services and processing data

5. Experience with offline storage threading and performance tuning

6. Review code and maintain the code quality and suggest best practices

7. Knowledge and experience on data science and programming languages

8. Demonstrable abilities to optimize code. Strong analytical skills for effective problem solving