Assess and Develop long-term strategic goals for databases in conjunction with data owners and department managers.
Design and implement redundant systems, policies, and procedures for disaster recovery and data archiving to ensure effective protection and integrity of data assets.
Work with application development team to develop database architectures, coding standards, and quality assurance policies and procedures.
Manage and administer the various Oracle databases installed at the bank and ensuring that the configuration of these databases are in line with the baseline security documents and other industry standards.
Ensure high availability (24*7) of databases used in the bank.
Install and configure Oracle RAC databases on UNIX (Solaris, HP-UX, Linux) & Windows platform.
DR configuration & maintenance of databases
Conduct research and make recommendations on database products, services, protocols, and standards in support of procurement and development efforts.
Installation of Oracle RAC databases and creation of databases for new projects.
Upgrading the Database to the latest version available.
Migration of database’s across platforms whenever required.
Apply & test the latest database patches across multiple environments.
Configuring DR environment for Oracle databases.
Monitor the databases, backups, DR environment on daily basis and ensure that the RTO/RPO is maintained as per the BCP / DR documents.
Tune the databases for high performance and security.
Respond to and resolve database access and performance issues.
Monitor, optimize and allocate physical data storage for database systems.
Manage changes by ensuring that problem management and change management procedures are adhered to and problems tracked to resolution
Monitor database system details within the database, including stored procedures and execution time, and implement efficiency improvements.
Ensure that the databases are complied with baseline security document.
Support Database of various applications used in Test, DR & Production environment.