dba topics: 2020

We have a vacancy for the post of Web Designer + HTML Developer. Minimum 2 years experience required. Location is based in Kochi. If interested, please submit your resumes via our careers page below:

#Jobs 11 Sep 2020: #Jobs #Allianz technology #Trivandrum#Ready joiners only

Dated : 12th Sep 2020

#Jobs #Allianz technology #Trivandrum#Ready joiners only

#Selinium testers with 2 -6.5 experience

#Jobs 11 Sep 2020: Andriod & IOS developer, Senior Engineer & project manager

Wanted Andriod & IOS developer, Senior Engineer & project manager

knowledge in ANDROID, IOS, JAVA, JAVASCRIPT, PEARL, PYTHON, C#, SQL SERVER, T-SQL.

#Jobs 11 Sep 2020: #Angular Developer SQL, Node JS, JQuery.

Requirements for GSTi India Kochi Infopark.

Requirement: Angular Developer

Qualification:B Tech/MSc/MCA

#Jobs 11 Sep 2020:# Experion Technologies #Node JS Developer

Experion Technologies

1. Project Role : Full Stack React Node JS Developer

Primary Skills : Node JS, React Js/React, JAVAScript

#Jobs 11 Sep 2020: Php Developer and Misc

We have PHP vacancy for frameworks (CodeIgniter, Laravel )

send resume to hr@dimindinnovations.co.in

Looking for a Php Developer urgently

#Jobs 11 Sep 2020: #consultant - oil & gas utilities/ infosys consulting

#consultant - oil & gas utilities/ infosys consulting

#Oracle PDH consultant

#vendavo consultant

#Jobs 11 Sep 2020: #Infosys #Trivandrum #quality assurance manager

#Jobs #Infosys #Trivandrum

#quality assurance manager

#data privacy and protection

#Jobs 09 Sep 2020: Auberon Technology Pvt Ltd, SmartCity, Kochi

Auberon Technology Pvt Ltd, SmartCity, Kochi

We are hiring Database Developers who can join immediately

#Jobs 09 Sep 2020:Job opportunity in Saudi Arabia #HR Executive

Excellent Job opportunity in Saudi Arabia !!

Al Madina Markets, One of the leading Hypermarket/Supermarket Chain which have outlets across Saudi Arabia is recruiting

#Jobs 09 Sep 2020: Node JS JD

Requirement: Node JS JD

Job description roles and Responsibilities

Experience in developing production Node.js applications with

#Jobs 09 Sep 2020: UI Developer with ReactJS and Node.js

Please share with your friends and refer candidates:

The client is Hitachi.

Role: UI Developer with ReactJS and Node.js

#Jobs 09 Sep 2020: #Trivandrum Way.com

Trivandrum Way.com

----------------------------

Location : Technopark, Trivandrum

Our Current Openings:

#Jobs 09 Sep 2020:.NET and Angular: Python-dJango: FRESHER/INTERNS

Experion Technologies Openings for .NET and Angular

Technology Lead

Lead Engineer

#Jobs 09 Sep 2020: IBS openings: #.Net Developer/Solution Architect/Sr Tech Lead

IBS openings

--------------------

Senior .Net Developer/Solution Architect/Sr Tech Lead -.NEt(8-13 years of experience ). Contact praveen.suseelan@ibsplc.com

#Jobs 09 Sep 2020: Trivandrum Job openings

Trivandrum openings

------------------------------

Spericorn

--------------

UX designer 2+ years

#Jobs 09 Sep 2020: Looking for Angular Developers:

Looking for Angular Developers:

· Experience in developing Angular 7/6/5/4 Applications

· 2-5 Years of experience in web application development

#Jobs 09 Sep 2020: Looking for Experienced Java Resources:

Looking for Experienced Java Resources:

• Experienced in working Agile projects with 6-9 years of experience

• Experienced in Solution and Technical Design

#Jobs 09 Sep 2020: .Net Core + Microservices Developers Requirements

.Net Core + Microservices Developers Requirements

================================

• Exp : 3-8 Yrs.

• Qlfn : B.E/B.Tech, M.E/M.Tech, MCA

#Jobs 07 Sep 2020: Php, Magento, UI/UX designer, Web developer, Manual testing : #Immediate

Dated: 07 Sept 2020

1. Php, Magento 2.3.X (certifcation will be a plus)

2 Years+

Joining: Immediate

#Jobs 07 Sep 2020: Project Manager and Head HR

We are hiring strong Project Manager with ecommerce background . Looking for Immediate joiners. Refer any of you friends. Can reach me on 9742447799 / venu.akella@gspann.com

#Jobs 07 Sep 2020: Developers, .Net Technologies and Others

Looking for developers of 2-3 years experience and who are strong in Angular 4.0 and above, jQuery, Bootstrap, JavaScript, MVC, CSS & HTML for a software company Azinova in trivandrum

#Jobs 07 Sep 2020 HR Executive position

Urgent opening for HR Executive position

Location : Technopark , Trivandrum

#Jobs 04 Sep 2020: GRC Security admin professionals

We are hiring GRC Security admin professionals

Exp level : 8 to 16Yrs

#Jobs 04 Sep 2020: Rulestream/Teamcentre PLM Architect professionals

Looking For Rulestream/Teamcentre PLM Architect professionals

Exp level :8 to 16Yrs

Location:-Bangalore, Whitefield

#Jobs 04 Sep 2020: Looking for backend developer

Looking for backend developer

1. 1.5 - 2 year experienced in php frameworks(mainly in Laravel )

2. experienced in creating custom project from scartch

#Jobs 04 Sep 2020: # Adams iTec #Angular JS , Codeigniter /Full stack Developer / Node js

Adams iTec

Kochi Ernakulam

Hiring :- Developers skilled in

#Jobs 04 Sep 2020:10+ years #java based web

Job Description : 10+ years experience in java based web development with significant experience in Architecting application,

#Jobs 04 Sep 2020: Oracle professionals

We are hiring below Oracle professionals

• Oracle SOA + OIC - 5+ years of experience

• OJET - 5+ years of experience

#Jobs 02 Sep 2020: Capgemini hiring for Selenium with Java for #Mumbai location

Capgemini hiring for Selenium with Java for #Mumbai location

Send resume kashika.trivedi@capgemini.com

#Jobs 02 Sep 2020: Polus is looking for Senior Fullstack Developers

Polus is looking for Senior Fullstack Developers for one of our existing US based client.

The basic requirements are: Senior experience (7+ years) with C#,

#Jobs 02 Sep 2020: Microsoft Senior Software Engineer hiring

Microsoft Senior Software Engineer hiring

Job Description:

#Jobs 02 Sep 2020:@#DevOps engineer#TCS

There is immediate requirement in TCS for people with experience from 3 to 10 years experience DevOps engineer on any cloud computing and technology platform.

#Jobs 02 Sep 2020:@#Freelance Web Developer

Dated : 2nd Sep 2020

#Freelance #Jobs

Position: Web Developer (Remote)

#Jobs 27 Aug 2020:@ ACCUBITS TECHNOLOGIES Inc

Send resumes to : mahadevan@accubits.com

Urgent Requirement on contract basis

#Jobs 28 Aug 2020:@ Infosys #Trivandrum #Bangalore

#Job openings @ Infosys #Trivandrum #Bangalore

1. Java Tech Arch- 10-15yrs Exp

#Jobs 28 Aug 2020: Looking for Java Developers

Looking for Java Developers

Experience : 2 - 5 years

• Should be strong in Java and related web technologies (Java, J2EE,

#Jobs 28 Aug 2020: @ACCUBITS TECHNOLOGIES Inc: Node.JS development

Urgent Requirement for Node JS Developers

Email : mahadevan@accubits.com

hr@accubits.com

#Jobs 28 Aug 2020: Dy. manager procurement

Vacancy as below-

Dy manager procurement for expertise in hydraulic and electrical commodity of excavators/backhoe loader.

#Jobs 28 Aug 2020: @ Oracle Trivandrum : Senior Java Microservice Developer

Oracle Trivandrum has opening for profiles with 5+ years of expertise in Java/J2EE based microservice with docker and kubernetes exposure.

#Jobs 28 Aug 2020: Accountant Job opening:

Accountant Job opening:

Construction Proprietorship Firm

Department: Accounts

#Jobs 28 Aug 2020: @ Way #Technopark Trivandrum

Please share your profiles with Sbnlalpnr@gmail.com

Our Current Openings:

Script to Check ASM Diskgroup Compatibility

COMPATIBLE.ASM (v$asm_diskgroup. COMPATIBILITY) – The minimum version of the ASM software that can access the disk group. In 11g,

Script to Check Disk group Freespace & Mount Status

SQL Script

set pages 1000 lines 120
col NAME for a16

SQL Script to Check Disk Group & Disks Details

SQL Script

set pages 1000 lines 333
col PATH for a50

SQL Script to Find out ASM Disk Details

Here is the SQL script to find out ASM Disk Details.

set pages 10000 lines 250 
column path format a55

Direct Method to Create Database Link Without Using TNSnames.ora

Normal method – Using TNSnames service name

This method requires the TNS entry to be added in the TNSnames.ora file as mentioned below.

SQL Script to Check Oracle Logfile Size, Status and Location

SQL Script

set pagesize 30 linesize 100
column member format a60
column status format a10
column size_MB format '999,999'

Database Creation using dbca failed with Oracle Net Services configuration failed. The exit code is 1

Error Description:

Database creation using dbca utility failed with following error.

netca command failed with ProfileException: Could not create Profile: TNS-04414: File error

Error Description:

Oracle netca command failed with following error.

[oracle@TESTBOX CDB]$ netca

India Driving License Renewal New Process Through sarathi.parivahan.gov.in/ Portal

There is a change in the driving license renewal process in all the states in India. It is became the common portal for all the states. Earlier there were individual portal for different states.

Scripts to Check RMAN Backup Status and Progress

SQL 1.
SQL to check the RMAN backups status

set pages 1000 
set lines 222
col STATUS format a9

Datapump expdp impdp New Feature – Print Content of Parfile to Logfile

From Oracle 12.2 release onwards, when you use the parfile option to expdp or impdp it will write the content of the parfile to the logfile in below format.

Connect to Oracle Database Running in Linux

Step 1. Identify the database running in the server

[oracle@TESTBOX exp]$ ps -ef|grep pmon|grep -v grep
oracle   25167     1  0 Jul18 ?        00:00:10 ora_pmon_cdb

Script to Check ASM Disk Usage Details

SQL Query

set lines 250 
set pages 9999 
column path format a50

Execute Oracle SQLs from Linux Command Prompt and Exit

Method 1
Execute single SQL command from the prompt

[oracle@TESTBOX exp]$ echo 'select count(*) from tab;' | sqlplus / as sysdba

Command to List the Oracle Databases Running on Linux Server

Generally we use ps -ef|grep pmon command to list the databases running on the database server. In this post I am going to mention

Commands to Delete Old Aged Oracle Trace Files(.trc, .trm) and Audit(.aud) Files

In this post I am going to explain the command to delete old trace, Audit files. You have to periodically clean up these trace, audit file locations to avoid the file system get filled with files.

Create Restore and Drop Oracle Restore Point - Types and Benefits

Restore Point

It is a name associated with the SCN in the database. Using this restore point we can revert to the SCN which is pointing to the restore point even if you make some changes to the database.

In this post I am going to demonstrate the table recovery using RMAN. There are chances to drop tables accidentally by developer. In this cases DBA asked to recovery the dropped table from the backup.

SQL to Create Script to Analyze All Schema Tables and Indexes in Oracle Database

This script to generate the script to analyze all the tables in the specified schema(s)

Method 1. Using dbms_stats

SQL to Set Tablespace Quota for Oracle User

Create a tablespace - USER_DATA

create tablespace user_data 
datafile '/u02/oradata/CDB/user_data_01.dbf' size 500m;

How to Find out / Identify Trace File for the Current or Other Oracle User Session

In this post I am going to help you to identify the trace file name for the current oracle session.

Method 1. Using v$diag_info table

Trace Current Oracle Session – Different Methods

Method 1. Using alter session command

ALTER SESSION SET sql_trace=TRUE;
ALTER SESSION SET sql_trace=FALSE;

SQL Query to Find Blocking Sessions and SQL Text for Last One Day from History

set pages 1000 lines 222
col sql_id for a17
col inst_id for '99'
col sql_text for a60

SQL Query to Find SQLIDs Spend on CPU/Wait/IO

This query is used to find out the SQLIDs spend on the CPU, Wait and IO.

SQL:-

set pages 1000 lines 220
col SQL_ID for a 15
select

– Number of Processing Units in the server which is a main component of a server.

Archive