What are the responsibilities and job description for the Database Administrator position at ProIT Inc.?
1) Candidate should have strong knowledge on Database having worked as Database Administrator
2) Candidate should have experience in trouble shooting GI, Database and performance tuning issues in RAC/Non-RAC set up.
3) Candidate should have good knowledge of UNIX environments (AIX/RHEL).
4) Strong Performance tuning experience with a good understanding of database statistics, Locks & Blocking sessions, Explain plan analysis, AWR report analysis, Server resource monitoring etc.
5) Experience on applying/maintaining GI and Database & DB security patches.
6) Should be able to create, maintain Dataguard databases, troubleshoot and fix DG issues.
7) Strong in handling all types of backups, refreshes and recovery procedures.
8) Good understanding of database partitioning, database security architecture and maintenance.
9) Responsible for making detailed technical RCA of problems, and taking appropriate remedial actions.
10) Adding and resizing of ASM disk groups.
11) Work on issues that couldn’t be resolved by L2 team.
12) Formulating Backup and Recovery strategies.
13) Database upgrades/migrations.
14) Install and configure Oracle enterprise manager Grid control.
15) Formulating Backup and Recovery strategies
16) Handle RAC databases from a design, implementation, management and technical support perspective.
17) Take ownership of performance and capacity monitoring aspects of the DB.
18) Execution of data migration jobs and scripts as required.
19) Assist the infrastructure team in sizing hardware used for the DB.
20) Contribute to the creation and maintenance of disaster recovery plans.
Job Type: Full-time
Pay: $100,000.00 - $120,000.00 per year
Benefits:
- Dental insurance
- Health insurance
- Paid time off
Schedule:
- 8 hour shift
Work Location: In person
Salary : $100,000 - $120,000