Senior SQL DBA
Arab National Bank
Total years of experience :13 years, 4 Months
• Highly skilled in managing 24*7 Database Administration encompassing database planning, installation, configuration, performance tuning, disaster recovery planning, back-up & recovery, configuration of Stand By databases
• Strong exposure in installing, creating, upgrading, migrating, patching & supporting MS SQL SERVER Databases (2019, 2017, 2016, 2014, 2012, 2008 R2 & 2008) and both On-Premises and Azure Cloud
• Rich experience in configuration of SQL ALWAYSON, FAILOVER CLUSTER in various production environments, upgradation & migration of databases lower to higher version
• Proficient in:
• Administration, installation, configuration, upgrade, migration, encryption, and maintenance of SQL servers
• Integrated custom visuals based on business requirements using Power BI Desktop.
• Encrypt databases using TDE.
• Follow the Minimum Security Baseline as per the CIS Microsoft SQL Server.
• Multi-tasker & fast learner with strong planning, interpersonal, analytical and problem solving skills
Experience in Installation, Configuration, Maintenance and Administration of SQL Server 2008/2008 R2/2012/2014/2016/2017 On Premises and Azure Cloud. Migration using (DMA) and upgradation experience of different version of SQL Server Experience in performance tuning, maintenance, troubleshooting, Query Optimization, rebuilding indexes, updating statistics, Client/Server connectivity and Database Consistency Checks using DBCC Utilities, DMVs and DMFs. Experience in resolving locks deadlocks, handling different isolation levels and performance issues like CPU, I/O, Memory bottlenecks. Expertise in building and supporting HA/DR solutions namely Clustering, log shipping, mirroring. Configuration and troubleshooting the issues of clustering & mirroring. Database administration, which includes taking database backup, restoring, database refresh activities and space management. Service Pack installation (Standalone & Cluster) on different version of SQL servers. Backup database on tape and disk through EMC Networker and maintenance plan. Monitoring SQL Jobs and maintenance of job failure and fixing them. Creating Linked Server to access oracle database data. Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using DTS and SSIS Services. Installation and configuration of services like SSIS, SSRS and SSAS. Creating packages using SSIS for data extraction from Flat Files, Excel Files, and OLEDB to SQL Server.
Experience in Installation, Configuration, Maintenance and Administration of SQL Server 2008/2008 R2/2012/2014/2016/2017 On Premises and Azure Cloud. Migration using (DMA) and upgradation experience of different version of SQL Server Experience in performance tuning, maintenance, troubleshooting, Query Optimization, rebuilding indexes, updating statistics, Client/Server connectivity and Database Consistency Checks using DBCC Utilities, DMVs and DMFs. Experience in resolving locks deadlocks, handling different isolation levels and performance issues like CPU, I/O, Memory bottlenecks. Expertise in building and supporting HA/DR solutions namely Clustering, log shipping, mirroring. Configuration and troubleshooting the issues of clustering & mirroring. Database administration, which includes taking database backup, restoring, database refresh activities and space management. Service Pack installation (Standalone & Cluster) on different version of SQL servers. Backup database on tape and disk through EMC Networker and maintenance plan. Monitoring SQL Jobs and maintenance of job failure and fixing them. Creating Linked Server to access oracle database data. Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using DTS and SSIS Services. Installation and configuration of services like SSIS, SSRS and SSAS. Creating packages using SSIS for data extraction from Flat Files, Excel Files, and OLEDB to SQL Server.
Experience in Installation, Configuration, Maintenance and Administration of SQL Server 2008/2008 R2/2012.
Migration using (SSMA) and upgradation experience of different version of SQL Server
Experience in performance tuning, maintenance, troubleshooting, Query Optimization, rebuilding indexes, updating statistics, Client/Server connectivity and Database Consistency Checks using DBCC Utilities, DMVs and DMFs.
Experience in resolving locks deadlocks, handling different isolation levels and performance issues like CPU, I/O, Memory bottlenecks.
Expertise in building and supporting HA/DR solutions namely Clustering, log shipping, mirroring. Configuration and troubleshooting the issues of clustering & mirroring.
Database administration, which includes taking database backup, restoring, database refresh activities and space management.
Service Pack installation (Standalone & Cluster) on different version of SQL servers.
Install and configuration of Web hosting administration HTTP, SQL Server, MySQL, Oracle 11g, PHP, and FTP.
Used to setup and deployed staging and production sites.
Migrate web site from one to another server.
Updating DNS records of new sites and migrated sites.
Installing and configuring CMS, ExpressionEngine, Wordpress, Drupal etc.
: