Seifolah G.

DATABASE ADMINISTRATOR

176 dollar
Freelancer
15 ans
Other, IRAN, ISLAMIC REPUBLIC OF

Mon expérience

Voir plus

ARYA SASOL POLYMER COMPANYJanuary 2015 - Présent

Maintenance Oracle databases.
Setup and refresh multiple environment on window and Linux,
Backup and restore databases.
Monitoring and performance tuning databases.
Setup mirroring, SQL server HA, manage Oracle standby active data guard. Developing Plsql packages.
Monitoring databases, manage users, storage, jobs and backups. Data migration and transformation.

Install and configure Centos6,7
Manage disks, users, services in Centos 6,7

Setup Oracle Cloud controller 13c.
Monitoring oracle, sql database and os using cloud controller.
Tuning database using SQL advisor, tuning set in oracle cloud controller.

Migrate several oracle database from windows to Linux OS.
Upgrade several oracle database from 11g to 12c

Setup and configure Zabbix & Grafana to monitor hosts and process in Linux and windows.
Create and maintenance Grafana dashboards.

DWH & BI
Setup data warehouse using oracle , creating stage, repo layer and
Fact & Dimensions using star schema.
Setup and maintenance ETL jobs for import data from several source into data warehouse.
Setup and maintenance Oracle Business Intelligence Enterprise Edition (OBIEE).
Develop dashboards, analytics, KPI, Scorecards. Manage Security on OBIEE.
Create and Manage OBIEE Repository.
Develop dashboard on Qlickview.
Develop reports using T-SQL in DWH for application teams.
Tuning queries and view created by developer in DWH.
Voir plus

ARYA SASOL POLYMER COMPANYJanuary 2012 - January 2015

Installed, upgraded and configured SQL Server 2014/2012/2008/2005/200 for several applications with latest service packs.
Migrated SQL server 2000/2005/2008 to SQL Server 2014 in Microsoft Windows Server 2012.
Implemented SQL Server Always On High Availability and DR using Windows cluster.
Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.
Troubleshooting and tuning databases for its performance and concurrency.
Reviewing Database user privileges, Inactive user accounts.
Monitoring CPU /memory resource usage and SQL Server disk management.

IFS ERP administration including: manage users, roles, events, reports, etc.
Install, configure oracle 11.2g on windows for several applications
Develop reports in IFS ERP using T-SQL
Responsible for the installation and configuration Oracle database servers.
24x7 production database administration and on call support in off hours.
Support & maintain the Production/Development databases on various servers
Enterprise Manager Cloud Control 12c.
Oracle Active Data Guard.
Monitoring and Troubleshooting Databases
Worked with application developers to debug PL/SQL procedures, Tuning
Voir plus

ASPCJanuary 2010 - January 2012

As an application team, I was responsible for coordinate IT software, contractors and business requirements.
Develop Human Resource Job Recruit website using .net mvc, entity framework.
Develop .net CE application for logistic warehouse.
Develop several win application using C# for service desk teams to manage Directory service users.
Backup and maintenance Sql Server databases.
Support Logistic warehouse, HR and payroll by prepare Business requirement documents for required software.
Manage software contractors for delivery builds, fix bugs, and getting new application for business.
Voir plus

NOORE DANESHJanuary 2008 - January 2010

Develop a large scale web application for medical School of shiraz including several technologies: asp.net ,Mono, MySQL , Text sharp, Telerik, JavaScript, CSS
Develop MySQL procedure, functions and report to support applications requirements.
Develop Noore Danesh company website using asp.net, HTML, JavaScript, CSS
Voir plus

BEFORJanuary 2008 - January 2008

Develop windows and web projects using several technologies:
Win application: C# win, ado.net, Visual basic,
Develop Web app using : asp.net , Joomla
Develop multi language Joomla extension for Flight agency
Develop chemistry simulation using C++
Develop simple game using C++ and DirectX

Mes compétences

Zabbix, Windows Server, Visual Basic, Troubleshooting, SQL, Software Development, Software Design, QlikView, Oracle PL/SQL, Oracle, MySQL, MVC, Microsoft SQL Server 2008, Microsoft SQL Server 2005, Microsoft SQL Server, Linux, jQuery, JavaScript, Java, ITIL, HTML, Git, ETL, Entity Framework, Design, Debugging, Database Design, Database Administration, Data Warehousing, Data Migration, CSS, CentOS, C++, Business Intelligence, Bootstrap, ASP.NET MVC 5, ASP.NET Core 2.0, Analytics, .NET