Database Administrator Jobs in Patiala - NIELIT
Job Description
National Institute of Electronics and Information Technology (NIELIT) invites application for the position Database Administrator
No. of posts: 1
Place of posting: Patiala
Monthly Consolidated Remuneration per month: Rs 50000/-
Essential Qualification(s): BE / MCA & Oracle Certification (OCAOCP) is mandatory
Duration and nature of post qualification Work Experience / skills, if required & Job role & responsibilities:
a. Minimum 7 years in the Oracle/Postgres SQL Server. Experience in Installation and Configuration of SQL Servers 2008 R2 to 2017, Postgres DB, Oracle 11G, maintenance of SQL Server, Oracle Server and Postgres DB. Good Experience in maintaining the production servers of multiple environments.
b. Creating new users on SQL server, Postgres DB, Oracle 11 G and Managing SQL Server Security. Experience in Database backup and disaster recovery procedures. Test backups to ensure we can meet the business Recovery Time Objectives (RTO).
c. Experience in Replication (Mandatory). Should have working experience on RAC, RMAN, Data Guard, Oracle 11G/12c, Postgres DB, Database administration schema, objects, restore, UNIX / Linux and troubleshooting.
d. Having knowledge of Bulk Data Merging using SQL Server Import or Export. Wizard or writing queries on SQL Server query window. Having Knowledge of job schedule. Creating and maintaining databases.
e. Monitoring, troubleshooting, and optimizing SQL Server Oracle 11g & Postgres DB performance. Having knowledge of SQL Profiler to check the Execution Plan, Performance Monitor. Monitored server performance, database, and transaction log growth, and error logs. Have the ability to work in a fast-paced environment, a good team player, and can work independently.
f. Help the database query developers on technical issues, i.e., writing queries like join or subquery, triggers, cursors, store procedures. Have knowledge of indexes. Have knowledge of Database Migration.
g. Responsible for backups/restores, monitoring. SQL, Oracle & Postgres uptime/downtime, designing, and full database recovery. Review and optimize SQL queries, store procedures, views, and triggers to help developers to achieve maximum efficiency and scalability.
h. Auditing of DML commands on SQL servers and individual database/s. Troubleshoot SQL Server service, Oracle & Postgres DB outages as they occur, including after - hours and weekends. Configure SQL Server monitoring utilities to minimize false alarms.
i. When performance issues arise, determine the most effective way to increase performance including hardware purchases, server configuration changes, or index/query changes. Creating the configuration Document for the database environment Tuning T-SQL queries to improve performance. Candidate should have good hands-on experience in SQL Data analysis using queries as well as using Microsoft Excel.
Duration (DD/MM/YY): 31/12/2021, Co-terminus with the project.
Age Limit: Max. Age Limit (years): 37 years
Application Fees: Non-refundable Application fee of Rs 500/- (Rs 250/- for SC, ST, Person with Disability (PWD) and Women candidates) is to be paid online through Debit Card /Credit Card / Netbanking only
Job Particulars
Role it software engineer
Who can apply Experienced (3+ Years)
Hiring Process Face to Face Interview
Employment TypeFull Time
Job Id1134400
Job Category IT/Software
Locality Address
State Punjab
Country India
About Company
National Institute of Electronics & Information Technology (NIELIT),(erstwhile DOEACC Society), an Autonomous Scientific Society under the administrative control of Ministry of Electronics & Information Technology (MoE&IT), Government of India, was set up to carry out Human Resource Development and related activities in the area of Information, Electronics & Communications Technology (IECT). NIELIT is engaged both in Formal & Non-Formal Education in the area of IECT besides development of industry oriented quality education and training programmes in the state-of-the-art areas.
Jobs By Location
Delhi
Noida
Mumbai
Pune
Gurgaon
Hyderabad
Bangalore
Kolkata
Ahmedabad
Chennai
Others also searched for
Job & career videos Subscribe