Senior Associate DBA
ADCB
Total years of experience :10 years, 8 Months
• Installing and configuring SQL Server Binaries.
• Configuring and monitoring the High Availability features like SQL Clustering, Log Shipping, Mirroring and Always ON.
• Supporting most critical Core Banking Databases with the size of more than 14 TB.
• Handling performance related issues.
• Creating SOP and SMTD documents for the stability of the environment.
• Doing SQL Server patching such as cumulative updates and service packs on Quarterly basis.
• Performing BCP activity on yearly once and DR activity on quarterly basis.
• Performing User Management and Tablespace Management in Oracle.
• Fine tuning queries liaise with application team for the better performance.
• Doing Maintenance activities for critical databases on monthly basis.
• Monitoring DB using HP BSM tool.
• Supporting Oncall after office hours and weekend.
• Creating Maintenance Plans like Backup (Full, Differential, Log), Database Integrity Check, Maintenance Plan Cleanup, Rebuild and Reorganize the indexes. Troubleshooting the same when scheduled plan gets failed.
• Restoration of the database backup will be done whenever disaster happens to the database.
• Point in Time Recovery will be possible by doing the restoration of database in SQL Server.
• Creation of the jobs to check the Database Status, SQL Service Status, No of Active Connections, Memory and IO usage of
Each Database in SQL Server, Autogrowth of Data file as well as Log file and failed Backup jobs.
• Database Mail is configured to send the mail from SQL Server to different recipients.
• Configuring and monitoring the High Availability features like SQL Clustering.
• Creation of the users and required permission will be assigned.
• Permissions will be given for both Database role level and Server Role level.
• Proper Planning will be done to apply the SQL Service packs on SQL Cluster and Standalone to avoid manual errors.
• Security updates like FDR and QFE will also be done to fix the specific security related issues in SQL Server.
• Finding the unused databases in the SQL Server.
• Checking the Memory, IO and CPU usage of the SQL Server to attain the better performance.
• Upgrading the SQL Server Databases from lower version to higher version.
• Migration of the databases will be done if one database in the instance is needs to be moved to another instance.
• Monitoring the system availability and updating system documentation.
• Installing and configuring SSIS and SSAS packages in SQL Server.
• Converting Microsoft Access 2000 file into database file in SQL Server 2008 R2.
• Installing and configuring all versions of SQL Server.
• Have hands of experience in User Creation, Schema refresh, Creating Tablespace, Add or drop the tablespace, taking RMAN backup in Oracle.
• Restoration using RMAN Backup in Oracle.
• Handling the SQL Queries like DDL, DML and DCL commands.
• Administering the Database to attain the High Availability and Disaster Recovery Strategies.
• Taking the backups like Full Database Backup, Differential Backup and Transaction Log Backup.
• Restoring the database using backups at the time of disaster to attain Point-In-Time Recovery.
• Installation of the SQL Server 2000, 2005 and 2008 R2.
• Upgrading the database from SQL Server 2000 to 2005 and from SQL Server 2005 to 2008 R2.
• Fixing the orphaned users in SQL Server.
• Configured the Transaction Log Shipping in SQL Server 2005.
• Configured the Monitoring Server in Transaction Log Shipping in SQL Server to check the flow of data from Primary to Secondary Server.
• Created the logins for the SQL Server.
• Configuring the Database Mirroring using synchronous mode.
• Created the Maintenance plan in SQL Server 2008 R2.
• Rebuilding and Reorganize the indexes at regular intervals for better performance.
• Created the Clustered and Non-Clustered Indexes on the table for the fast retrieval of data.
• Creating and scheduling of jobs using SQL Server Agent.
• Monitored the performance of the database using SQL Server Profiler and Execution plans.
• Expertise in handling DBCC Commands.
• Checking the long running or expensive query in SQL Server to speed up the performance.