You apply on Trigent Software Private Limited's website. CoreHRx takes you there after you sign in.
CoreHRx never asks candidates for money. If anyone does, .
Role at a glance
Experience
8+ years
Must-have skills
LinuxOracle DatabasesAdministrationPostgreSQLSQL
How well do your skills match this job?
Sign in to see your fit: the skills, experience and location this job asks for, checked against your profile.
Job description
Min 8+ years of experience in Oracle database administration in production environments on Solaris and Linux OS.
Replication setup, maintain and troubleshoot
Capable of performing Database Administration tasks independently in sybase 11.x, 12.x, 15.x, 16.x Sybase ASE DBA tasks of standalone and Clustered setup.
Should have some exposure to process oriented working environment with good multitasking ability.
Database event/alert monitoring, space management, user management, Database upgrades & migrations, cloning, Database backup, restore & recovery, Diagnose and resolve performance, connectivity, security and database corruption issues in a critical production environment.
Knowledgeable about Postgres database server and OS resources allocations and usage.
Translate Oracle PL/SQL constructs to Postgres PL/pgSQL, i.e., Oracle packages, global temporary files, etc.
Postgres performance/tuning analysis be able to tune Postgres PL/SQL code to meet required SLAs.
This guide is for Indian job seekers preparing for SQL rounds in data analyst, data engineer, backend developer and database roles, from freshers to experienced professionals. It has 60 questions in three levels: easy covers joins, grouping and NULLs; medium covers window functions, CTEs, indexes and isolation levels; hard covers locking, MVCC, query tuning and classic puzzles such as login streaks and medians. Answers use ANSI SQL, with MySQL 8 and PostgreSQL notes where the two differ. Write each query against your own sample tables first, then compare your result with the sample answer.
Questions you may be asked
What is the difference between WHERE and HAVING?
What is the difference between DELETE, TRUNCATE and DROP?
What is the difference between an INNER JOIN and a LEFT JOIN?
What is the difference between a primary key and a unique key?
