ABDULRABIKRAJA A
Singapore
Summary
With 14 years of experience in database administration and management, along with expertise in database security, this seasoned IT professional is seeking a role as a database administrator. Eager to leverage technical and management skills to contribute to the growth of an organization while embracing new opportunities and challenges.
Overview
15
15
years of professional experience
Work History
DBA
Synapse
01.2023 - Current
- Company Overview: Integrated Health Info System
- SQL Server cluster installation, configuration, troubleshooting
- SQL Server hardening based on the Audit requirement
- Doing Data Patch based on the Service Requests
- Support backup and recovery procedures for all MS SQL Server database systems according to industry best practices
- Managed SQL Server -based Applications
- Configured, and supported and Log Shipping and Database Mirroring strategies to support our client's
- Responsible for troubleshooting all SQL Server databases issues on production, QA, and testing environments.
- 24x7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues
- Installing SSRS and SSIS components.
- Migrating SQL 2012 to 2014, 2016, 2019.
- Support Weekly Deployment Activities liaise with Application Team
- Support Audit Requirements Based on the Request
- Hardening New and Existing SQL Server DB servers.
- Enable Database Encryption TDE for required DB servers.
- Integrated Health Info System
DBA
PCCW Solution Pte Ltd
10.2020 - 12.2022
- SQL Server cluster installation, configuration, troubleshooting
- SQL Server hardening based on the Audit requirement
- Doing Data Patch based on the Service Requests
- Support backup and recovery procedures for all MS SQL Server database systems according to industry best practices
- Managed SQL Server -based Applications
- Configured, and supported and Log Shipping and Database Mirroring strategies to support our client's
- Responsible for troubleshooting all SQL Server databases issues on production, QA, and testing environments.
- 24x7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues
- Migrating SQL 2012 to 2014, 2016, 2019.
- Support Weekly Deployment Activities liaise with Application Team
- Support Audit Requirements Based on the Request
- Hardening New and Existing SQL Server DB servers.
- Enable Database Encryption TDE for required DB servers.
DBA
Optimum Solutions Pte Ltd
11.2017 - 09.2020
- Maintained SQL Server Database; ensured accuracy of information and automated numerous functions.
- Fine tuning of database objects and server to ensure efficient data retrieval.
- Monitor and optimize system performance using SQL Profiler.
- Designed and implemented incremental and full back up policies and procedures.
- Created and implemented database design solutions in collaboration with programming team.
- Developed user defined functions and triggers to implement the requirements of the business.
- Performed database logical and physical design, maintenance, tuning, archiving, backups, replication, recovery, software upgrades, capacity planning and optimization for SQL Server database.
- Used database consistency checks using DBCC utilities.
- SQL Server cluster installation, configuration, troubleshooting
- SQL Server hardening based on the Audit requirement Monitoring and Troubleshooting database streaming.
- Handling Replication SQL DB instances.
- Writing UNIX and windows script to make an automatic report generation for health check.
- Doing Data Patch based on the Service Requests
- Support backup and recovery procedures for all MS SQL Server database systems according to industry best practices
- On call rotation, available for 24/7 support if contacted. Expected to work some weekend, and after hours
- Rebuilding Index to rectify segment fragmentation.
- Request allocation based on severity to Team members from various ticketing tool and in-house tools as well.
- Doing Database hardening as part of the new setup DB server configuration.
- Doing MS SQL Server Pack Apply based on the Microsoft Release.
DBA
Optimum Solutions Pte Ltd
06.2014 - 11.2017
- Regular monitor of servers, which includes backup job monitoring, Disk space monitoring, Services monitoring, and block monitoring.
- Involved in troubleshooting various database server issues to free up log space, update statistics, configure number of locks, create databases and match their data, log patterns with contingency. Performed many database upgrades using import/export.
- Involved in ensuring data recovery, maintenance, and data integrity and space requirements for physical database. Creating and Modifying Tables, Stored Procedures, Views, Indexes, User-defined Functions and Triggers etc as requirement on SQL Server Environments.
- Proactively monitored the database health through automated scripts for checking the database and extents growth, probing the alert log files, monitoring the rollback segments and temporary space usage.
- Provide 24/7 support as sole DBA
- Request allocation based on severity to Team members from various ticketing tool and in-house tools as well
DBA
Optimum Solutions Pte Ltd
08.2013 - 05.2014
- Managed SQL Server -based Applications
- Experienced in using SQL Server Profiler and SQL Server Agent
- Configured, and supported and Log Shipping and Database Mirroring strategies to support our client's
- Responsible for troubleshooting all SQL Server databases issues on production, QA, and testing environments.
- Participated in on-call schedule to respond to SQL Server alerts and potential production database issues.
DBA
IQ System Technologies Pvt Ltd
11.2011 - 02.2013
- Responsible for day to day tasks like re-indexing, checking integrity, backup and recovery
- Installed and configured SQL 2008 on WINDOWS 2008 systems.
- Provided MS SQL Server DBA support for all SQL Server databases.
- Maintained User Databases and System Databases.
- Planned and scheduled automated backups & performed recovery.
- Created user logins and add users to respective databases.
- Migrate and upgrade SQL Server 2008 to SQL Server 2012
- Creation of databases as per specifications given by the end users.
- User accounts, roles, and privilege administration.
- Designing and implementation of database backup, restore and recovery procedures/techniques.
DBA
Net Achievers Forum
01.2010 - 10.2011
- Installation of Oracle 10g on Linux platform.
- Creation of oracle Roles, Granting Privileges and Profiles etc.
- Check Alert Log errors and make necessary actions to rectify them.
- Frequent analysis of objects or schemas to improve the speed of the database
- Expdb / Impdb of Objects and RMAN Backup & Recovery.
- Monitor the database by collecting statistics using SQL trace.
- Creating Materialized View for Improving Performance.
- Rebuilding Index to rectify segment fragmentation.
- Analyzing Tables and Indexes to Rectifying Database Fragmentation.
- Analyze SQL statements using Explain plan.
Education
Diploma -
Tamil Nadu polytechnic college
Bachelor of Information Technology -
K.L.N.College of Information Technology
Skills
- MS SQL Server
- Windows Server 2012
- Windows Server 2016
- Windows Server 2019
- MS SQL Server 2008 R2
- MS SQL Server 2012
- MS SQL Server 2014
- MS SQL Server 2016
- MS SQL Server 2019
- Active OS Cluster
- Always On
- Database Mirroring
- Replication
- Log Shipping
- Remedy portal
- Service now
- ITSM
- JIRA
- SQL Server Always on installation
- SQL Server configuration
- SQL Server troubleshooting
- SQL Server hardening
Timeline
DBA
Synapse
01.2023 - Current
DBA
PCCW Solution Pte Ltd
10.2020 - 12.2022
DBA
Optimum Solutions Pte Ltd
11.2017 - 09.2020
DBA
Optimum Solutions Pte Ltd
06.2014 - 11.2017
DBA
Optimum Solutions Pte Ltd
08.2013 - 05.2014
DBA
IQ System Technologies Pvt Ltd
11.2011 - 02.2013
DBA
Net Achievers Forum
01.2010 - 10.2011
Bachelor of Information Technology -
K.L.N.College of Information Technology
Diploma -
Tamil Nadu polytechnic college
Similar Profiles
Kim GutierrezKim Gutierrez
Sr Director, Customer Engineering at SynapseSr Director, Customer Engineering at Synapse
Amritjot KaurAmritjot Kaur
Digital Marketing Strategist at SynapseDigital Marketing Strategist at Synapse
Mason RutlandMason Rutland
Security Engineer at Synapse HealthSecurity Engineer at Synapse Health