Database Specialist
Intigral - United Arab Emirates
مجموع سنوات الخبرة :15 years, 5 أشهر
• Working AWS RDS Maria DB, PostgreSQL, Redshift.
• Create Users and assign permissions based on the level of database access the user would need.
• Handle python ETL operational part, schedule python script through cronjob.
• Administrator ETL Matillion project.
• Manage cluster MS SQL server on Cloud Rackspace.
• Administration Amazon Redshift data warehouse.
• Knowledge in AWS Technologies such as : EC2, RDS, S3, Aurora, Redshift
• Write query for reporting.
• Query optimization and suggestion to developer.
Have 10+ years of experience in database administrator, development and support in MS SQL Server environments
Strong experience in Database Administration in SQL Server 2008/2008R2/2012/2014 )
Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and DMV function
Troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues etc.
SQL Development - write and troubleshoot SQL Code and design (procedure, functions, tables, views)
Experience with backups, restores and recovery models
Knowledge of indexes, index management, and statistics
Knowledge of High Availability (HA) and Disaster Recovery (DR) options for MSSQL Server.
• Creating complex Stored Procedures, Triggers, Views, Cursors & Indexes to facilitate efficient data manipulation & data integrity
• Writing complex T-SQL queries using joins and writing query using data manipulation function and aggregate function
• Data Operations like Inserting, Updating and Deleting Records
• Creating and Updating Indexes to keep up the SQL Server Performance
• Extracting, Transforming & Loading (ETL) data from Excel, Flat file, MySQL to MS SQL Server, using SQL Server Integration Services (SSIS)
• Reports generation like Drill-Down Reports and Drill-Through Reports, Parameterized Reports, Cascaded Parameterized Reports and Sub Reports using SQL Server Reporting Services (SSRS) base on client requirement
• SSRS installation and configuration and deployment of SSRS report on production Servers
• Understanding of Data Modeling in data warehouse environment such as star schema and snow flake schema
• Analysis of data using advance level of pivot table and using custom formula in pivot table
• Data manipulation and analysis in varied formats (e.g. SQL, Excel, Access)
• Preparing daily report, weekly report, monthly report and quarterly review to senior management.
• Generate, maintain, analyze & present daily/ weekly/ monthly calls service reports.
• Analysis of warranty and customer satisfaction report.
• Handle 66 APS across India with zone wise and their performance for management.
• Calculating TAT report and Root Cause Analysis (RCA) for ASP’s.
• Design reporting formats to provide accurate information in a clear and concise manner.
• Make project performance reports and analyzing them from project prospect.
• Standardize similar reports across clients, departments and teams.
• Maintain all details of service agreements with clients.
• Maintain all technical agent details and preparing their performance report and project KPI report.
• SLA tracking on the daily basis.