Database Administrator
Abu Dhabi Housing Authority
Total years of experience :19 years, 10 Months
Currently working at ADHA (Abu Dhabi Housing Authority) as Database Administrator and performing below responsibilities.
* Planning, implementing, configuring, and managing all database management systems in the organization.
* Reviewing existing databases configurations, tweaking performance parameters, and organizing database information into dictionaries.
* Designing and implementing high availability / disaster recovery solutions for MSSQL databases using Always-On technology.
* Coordinating with vendors and providing technical knowledge for the implementation of BI projects.
Worked at Interactive-Ltd, a subsidiary of CARMA (previously known as News Group International), as Senior Database Administrator and fulfilled the following responsibilities.
* Administering MS SQL Server (2014/2012/2008), MySQL 5.6, and PostgreSQL 9.5 databases running on MS Windows Server (2012/2008) and Amazon RDS Linux servers.
* Creating and maintaining all databases required for development, testing, staging, and production usage.
* Performing the capacity planning required to create new databases and maintain existing databases.
* Ensuring database high availability by creating and managing database replication across different servers.
* Performing data archiving of production databases and ensuring smooth data retrieval.
* Improving database performance by designing and creating data-partitioning solutions.
* Working with development team and writing back-end code on Ruby on Rails.
* Managing and documenting database users’ roles and permissions.
* Planning and automating database backups & disaster recovery processes.
* Ensuring database security and optimizing database performance.
* Resolving database performance bottlenecks by debugging database related code and queries.
* Keeping databases up to date by planning new releases and latest service packs available.
* Communicating database requirements to the development team for the design and implementation of database related code.
Worked at DM3 as Database Administrator and performed below responsibilities.
* Administration of Microsoft SQL Server (2012/2008/2005) and MySQL 5.1 databases running on Microsoft Windows Server (2012/2008/2003).
* Ensuring database backups & disaster recovery, security & protection, and performance optimization etc.
* Working closely with development team to help them write optimized queries.
* Designing database structure (data modeling) and system workflows.
* Preparing technical documentation and database dictionaries.
* Resolving performance bottlenecks and carrying out periodic database health checks.
* Installing patches & service packs to keep the system up-to-date.
* Managing and documenting changes in enterprise-level databases.
* Providing Level 2 and Level 3 technical system support.
* Developing software applications for the company in Microsoft .NET technologies.
* Gathering mobile apps (iOS & Android) requirements from management and transforming them into technical specifications.
* Coordinating mobile apps (iOS & Android) requirements with offshore development team.
* Testing mobile apps (iOS & Android) to ensure the apps are consistent and bug free.
Worked at KalSoft Limited as Database Consultant and carried out below tasks.
* Studying and assessing existing and proposed database solutions and related technologies.
* Fine-tuning databases to ensure optimal user experience.
* Developing database strategies to maintain highest database quality.
* Maintaining business continuity by implementing database disaster recovery.
* Designing, planning, and executing database high availability solutions.
* Performing database auditing, ensuring data integrity, and license compliance for all databases.
Worked at KalSoft Limited as Senior Database Engineer and completed below responsibilities.
* Designing and creating highly normalized database structures using best practices.
* Implementing data partitioning solutions to speed up data retrieval.
* Building data warehouses and OLAP cubes on MS SQL Analysis Services.
* Developing MIS reports using MS SQL Reporting Services.
* Performing data archiving and ensuring smooth data retrieval from archived databases.
* Improving data quality by writing data cleansing and de-duplication algorithms in C#.
* Providing database-related technical support to end users.
Worked at KalSoft Limited as Database Engineer and performed below responsibilities.
* Gathering and transforming system requirements into database specifications.
* Performing data modeling and creating entity relationship diagrams.
* Writing business logic in stored procedures and user-defined functions using SQL.
* Performing database development using Microsoft .NET framework.
* Debugging database related code, fine-tuning queries, and testing database scripts.
* Extracting, transforming, and loading data from different sources into database.
* Deploying databases into production and training system users.
Worked at Kolachi Advanced Technologies as Programmer and performed below responsibilities.
* Designing data flow and entity relationship diagrams for new system features.
* Performing ETL operations by extracting raw data from back-end APIs, transforming raw data into proprietary format, and loading transformed data into database.
* Debugging database stored procedures and C# scripts to ensure smooth data flow across different modules of the system.
* Optimizing database queries by identifying and creating missing indexes.
* Providing technical support to end users.
* Software Engineering * Database Designing & Programming * Compiler Construction * Algorithms * Computer Networks * Final Year Project: Data warehousing