DBA
Al Baraka Islamic Bank
Total years of experience :4 years, 9 Months
Monitor and Manage SQL Server databases, Oracle 12c core banking databases
•Set up alerts for all SQL Servers and create a database to monitor the performance of the database as there is no monitoring tool for databases.
•Migrate databases from old versions of SQL Servers to the new a newer version to improve performance and centralize the database to save the licence cost.
•Coordinative with vendors for any deployments related to applications like EFTS, IMAL etc.
•Archiving and maintenance of highly critical databases during the off business hours or the BENEFIT monthly maintenance window (Third-party application to electronic money transfer)
•Built windows cluster and configured SQL 2019 failover cluster instance to migrate the databases from the old instances.
•Configure a local native backup for SQL server and VM level backup for all machines using Vaaem tool.
•Configure AlwaysOn in the newly built cluster server for HA and DR
•Deploy and test the new changes in the non-production environment before deploying to the production server.
•Make sure databases and applications are up and running post monthly windows patching.
•Provide 24x7 support for critical production systems
SQL DBA
IIS Applications
JBoss Application
Oracle 12C
SQL Server and Database level auditing in all the production servers
•Patched all the production and non-production SQL Servers
•Performing DB security, creating users, roles and assigning permission to them
Perform assessment and migration of databases to Azure using ASR, DMS, Azure Migrate
•Support latest SQL Server versions (SQL Server 2017/2016/2014) along with 2005, 2008 and 2012 including Database Engine, Integration Services, Reporting Services and Analysis Services.
•Proactive monitoring of database environment (AlwaysOn, replication, etc.) for stability, performance, availability and recoverability.
•Development, Testing, Implementation and Administration of Databases
•Performance tuning of SQL queries, query optimization, stored procedures/views, write SQL queries for insert/update.
•Working on the separation of duties in SQL Server 2014 to minimize the possibility of error and fraud
•Configure and maintain database servers and processes
•Monitor system's health and performance
•Ensure high levels of performance, availability, sustainability and security
Thomson Reuters
-Information technology -Management