Database Administrator
Current- Working as Database Administrator with Islamabad Stock Exchange.- Implemented Oracle 10g Data Guard for High Availability (HA).- Implemented backup and recovery strategies using RMAN, and Export/Import utility.- Cloned production database to the test environment using Recovery Manager (RMAN)- Responsible for proper functioning of trading database.- Database performance Tuning and Administration.- Responsible for the execution of Scripts at market start and close.-… Show more - Working as Database Administrator with Islamabad Stock Exchange.- Implemented Oracle 10g Data Guard for High Availability (HA).- Implemented backup and recovery strategies using RMAN, and Export/Import utility.- Cloned production database to the test environment using Recovery Manager (RMAN)- Responsible for proper functioning of trading database.- Database performance Tuning and Administration.- Responsible for the execution of Scripts at market start and close.- Making necessary database changes to update the database according to LSE database.- Ensure that primary database and secondary databases are synchronized.- Monitoring of trading database health and taking preventive or corrective actions as required.- Daily backup of trade related files and complete database (Hot and Cold Backup) on CD and Backup Server.- Taking Backup of Trading database also daily backup of Ultra and Proxy Applets and their log files. - Responsible for Startup and Shutdown of Database, Trading engine, Remote and backup server.- Recovering the database in case of database failure or abnormal shutdown during the trade.- Database Users creation and their privileges.- Responsible for Startup and shutdown of servers. - Develop the Reports on managerial demand.- Develop in house Financial Reports using Oracle SQL Developer as per management requirements.- Administration and support of Financial and Attendance Systems developed by SIDAT Hyder Financial and Accounting Firm. Show less