Job Description

1.       Database administrator for Oracle, Microsoft SQL, MYSQL and other databases including database administration, backup and restoration and database performance tuning.
2.       Perform day-to-day, monthly and yearly database administration tasks.
3.       24x7 support databases.
4.       Perform performance tuning in Applications and Databases, working with development/ support teams in fixing performance issues.
5.       Provide database administration, maintenance and support activities such as installations, patching, bug and security fixes, SQL tuning, RMAN backup/restore, DB cloning, shell scripting, auditing, indexing and archival.
6.       Setting up and administration of database replications or synchronization such as SQL cluster, Oracle Data Guard, Materialized View synchronization.
7.       Monitoring and troubleshooting databases and database application service problems.
8.       Tracking of DB EOL’s/ EOS product version, plan and perform the upgrades or migrations.
9.       Monitors database activity to ensuring database security, integrity, stability and system availability.
10.   Monitoring, reporting and reviewing of Long running queries and blockings.
11.   Monitor, review and perform actions based on the database and system alerts.
12.   Provide monthly database performance and resource utilization reports.
13.   Comply, implements and supports database security regulations, policies, and guidelines.
14.   Perform maintenance fixes and patches as well as security hardening through Change Management process.
15.   Perform database capacity planning and database maintenance.
16.   Maintaining up to date database configurations changes and inventory.
 
17.   Documenting Database Management processes and SOPs.
18.   Supporting DR and BCP activities including new initiatives.
19.   Create and maintain scripts or Menu to perform database related activities.
20.   Vendor management for solutions, maintenance and support services.
21.   Project and BAU support.
22.   Constantly improve processes and procedures in database management.
23.   To undertake any other task assigned by the Superior from time to time.

Skills Required