. The ideal candidate must have experience to manage, secure, and maintain databases but also support the development team by writing
optimized stored procedures
,
queries
,
functions
, and
database objects
to support application development and performance improvement.
ROLES & RESPONSIBILITIES: -
Design, develop, and maintain database objects including
functions, stored procedures, triggers, views
, and
indexes
in PostgreSQL and Oracle.
Create and manage
database tables
,
schemas
, and relationships using appropriate
SQL commands
.
Perform
query performance tuning
and
optimization
to ensure fast and efficient data access.
Work with
cursors
and advanced
PL/SQL
constructs for iterative data operations and complex data manipulation.
Conduct data analysis, troubleshoot issues, and optimize existing queries and stored code.
Design and implement
joins
and complex SQL queries for report generation and application requirements.
Collaborate with application developers and business analysts to support data needs and ensure smooth integration.
Implement
performance monitoring
, indexing strategies, and data integrity checks.
Participate in code reviews, peer feedback, and documentation of database development processes.
Required Skills & Qualifications:
Strong experience in
PostgreSQL and Oracle
database development.
In-depth knowledge of
SQL and PL/SQL programming
.
Hands-on experience with
stored procedures, functions, triggers, views
, and
indexes
.
Proficient in
performance tuning
and
query optimization techniques
.
Experience with
cursors
, joins (INNER, OUTER, LEFT, RIGHT), and advanced SQL queries.
Ability to create, manage, and maintain
database tables
and structures.
Knowledge of
SQL commands
for data manipulation and definition
Excellent problem-solving skills and attention to detail.
Qualification:
UG:
B. Tech/B.E. in Information Technology, Computer Science & Engineering, Electronics and Communication Engineering, Related field
PG:
MTech. in Computer Science & Engineering, Information Technology, Electronics and Communication Engineering, MCA, MS/M.Sc(Science)
Job Types: Full-time, Contractual / Temporary
Pay: ?25,000.00 - ?50,000.00 per month
Application Question(s):
Total how many years of experience do you have for the Database Developer ?
What is your current CTC ?
What is your salary expectation ?
What is your official notice period ?
Location:
Chandigarh, Chandigarh (Required)
Work Location: In person
Beware of fraud agents! do not pay money to get a job
MNCJobsIndia.com will not be responsible for any payment made to a third-party. All Terms of Use are applicable.