Dhairia Ruban

I am a engineer, working in Fli Emirates as a Principal Database Administrator
• Over 17 years of Software Development & Administration experience in various computing environments.
• 11+ years of experience in Database Administration, Architect and Developer for very large and complex databases in SQL Server 2016/2017, 2014, 2012, SQL Server 2008 R2, 2008 and 2005.
• Experience documenting business requirements and technical architecture/design while translating complex requirements and designs for development, testing and implementation.
• Expertise in Always-On Availability Groups (AAG) and HA/DR Troubleshooting.
• Hadoop Multi Node Clusters, HDFS Installation and Shell Commands.
• Prepared new established standards for SQL installations, maintenance, tuning and improving Tempdb performance.
• Prepared custom based reports for customers using Powershell scripts.
• Automated System center orchestrator /Powershell scripts for Silent SQL Installation, Health Check Report, AlwaysOn and Cluster Configuration.
• Experience at writing SQL. Familiarity with some of the more powerful SQL constructs and an appreciation of performance issues - how to write performance queries and also how to investigate and tune existing performance problems.
• Working well within a small team of highly talented people and enjoy engaging with customers directly to resolve and understand issues.
• Administering SQL Server High Availability and Disaster Recovery strategies.
• Expert in data transformation services and Bulk Loads with SSIS and BULK INSERT ETL operations.
• Implemented the new SQL Server 2012 mechanisms like data compression, online indexing, Contained Databases, security principals and AAG.
• Experience in using DMV and dynamic management functions for finding out long running queries.
• Knowledge of Windows high availability technologies (NLB, Clustering, DR, virtualisation etc)
• Experience in Disaster Recovery Planning and Security Management operations.
• Proficiency and expertise in SQL Server Replication, backup/recovery, configuration, hardware, Disaster recovery and planning.
• Hands on experience in DR processes including Log shipping and Database Mirroring.
• Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.
• Planning and Migrating the SQL Server from lower version to higher versions.
• Capacity planning and monitoring database growth.
• Experience on Data center servers and handling 2.4 TB databases.
• Handling Memory configurations for SQL Server 2014 and SQL Server 2012 on Windows 2012.
• Proficiency in using Third Party backup tools Netbackup, TSM, Commvault, Redgate and Litespeed.
• Created Linked Servers between SQL Server 2008 R2 & Oracle 9i and 10g. Also, created DTS package for data transfer between the two environments.
• Preparing SLA Metrics for team and discuss with client on monthly basis.
• Understanding or familiarity with the .NET technology stack.