Senior specialist, Database support
National Bank Of Kuwait - Nbk
مجموع سنوات الخبرة :16 years, 2 أشهر
Exadata and database admin and support on EDW project
● Use Elasticsearch and logstash to build solution for student
search in MOE application
● Build dashboard to monitor Exadata metrics using python and
prometheus and Grafana
● Exadata patching and database upgrade
● Move Exadata from old to new data center
● Build Big data team to use big data technologies with Realsoft
analytics projects
● Working in Tabadol project in DSCD Sharjah to integrate 6
government agencies with warehouse database, the warehouse is
Hive and I am using sqoop to ETL data from RDBMS (MSSQL) to
HDFS
● Build analysis report for each agency data in Tabadol project
● Presenting in Microsoft event and talk about Hadoop ecosystems
using HDInsight cloud
● Build database model and integration process for Miyahuna
project
● Data cleansing and integration in LTRC project
● Migrate VIVA telecom database (53 TB) from Exadata v2 to
Exadata X4 using Data guard
● Working with al-khawarizmi team as database architect
● Senior DBA & Exadata admin outsource in MOMRA
● Install and deploy more than one Oracle RAC environment
● Migrate all SQL server’s instances to the new Failover cluster
environment
● Migrate oracle database from HP-UX to EXADATA
● Create centralized SQL server failover cluster
• Perform database design that includes database structures, packages, stored procedures/triggers, indexing/index tuning and based on these to perform database sizing and generate scripts to update database structure
• Install and configure all databases required for development, testing, and production usage ( ORACLE, MSSQL)
• Perform general technical trouble shooting in databases (ORACLE, MSSQL ) and give consultation to development teams
• Work with support team and provide 7x24 support when required
• Experience in Performance Tuning, Query Optimization, using OEM, data dictionary Performance Monitor, DMVs, SQL Profiler and other related monitoring and troubleshooting tools.
• Develop and maintain the admin website ensuring strong functionality and optimization using Java Servlet, ASP.NET, HTML, JQuery
• Design report for projects using Crystal report dependencies in Java and ASP.NET
• Design chart for projects using High charts plug-in
• Using JQuery plug-in e.g. FlexiGrid, popup plug-in and others
Projects
• Roam Analyze report and analysis application
• Roam Salute reporting application
• Migrate database from SQL server 2000 to SQL server 2012
• Installing and configure ORACLE RAC environment for test and development
• Perform a data release (once data versioning is established) and to utilize given references from the internet and purchased data.
• Responsible for maintaining GSM data for use in Globitel products/projects
• Using My SQL and SQL Server 2005 and oracle to maintain Databases
• Listing out the database record retrieval events and writing SQL queries for each kind of record retrieval
• Perform database design that includes database structures, packages, stored procedures/triggers, indexing/index tuning and based on these to perform database sizing and generate scripts to update database structure
• Create and maintain (Oracle, SQL Server, MYSQL ) various database objects, including SPs, Triggers
Projects
• create interface for GGData project using oracle form and report
• Develop a routine process to maintain GGData Database and other projects
• Build a structure for GGData database on oracle and SQL Server
• Maintenance computer (Hardware, software troubleshooting), operation network.
• Make daily, weekly, monthly report for problem that finish.
