Oracle Database Administrator

1. Database Installation & Configuration:

• Install and configure Oracle and DB2 database software.

• Perform database upgrades and apply patches.

• Set up and configure database instances, users, and permissions.




2. Database Design & Implementation:

• Design, create, and manage database structures (tables, indexes, views, etc.).

• Implement and optimize database schemas and data models to support applications.




3. Database Performance Monitoring & Tuning:

• Monitor database performance and implement tuning as necessary (SQL tuning, memory optimization, indexing).

• Proactively identify and resolve database performance issues.




4. Backup & Recovery:

• Plan, implement, and test database backup and recovery solutions as per NSDL policy.

• Ensure disaster recovery procedures are in place and quarterly tested.




5. Security & Compliance:

• Implement database security measures (encryption, access control, auditing).

• Ensure compliance with internal and external security policies and regulations.




6. Troubleshooting & Support:

• Provide support for database-related issues, resolving incidents and problems.

• Work with developers to optimize queries and troubleshoot database-related application issues.




7. Automation & Scripting:

Automate routine database maintenance tasks using scripts or Oracle tools.Write and maintain scripts for database administration and operations.

8. Capacity Planning & Scaling:

Plan for database growth and scaling to ensure capacity is sufficient for business needs.Evaluate and recommend improvements in database infrastructure.

9. Documentation & Reporting:

Maintain up-to-date documentation on database configurations, procedures, and policies.Generate and provide reports on database performance, incidents, and usage.

Additional Requirements:

• Critical databases architecture designing and implementation.

• Experience with high-availability environments, including RAC, Data Guard, and GoldenGate.

• Skills: Proficiency in Oracle Database Administration (installation, configuration, and tuning).

• Strong SQL, PL/SQL, and scripting skills. Familiarity with database security practices, including auditing and encryption.

• Knowledge of backup, recovery, and disaster recovery solutions (RMAN, Data Pump, etc.).

• Understanding of database clustering, RAC, replication, and high-availability architectures.

Certifications:

• Oracle Certified Professional (OCP) in Oracle Database Administration is highly preferred.

• DB2 certification will be an added advantage.