Adrian M.

Database Administrator

470 dollar
Freelancer
17 years
Bucharest, ROMANIA

My experience

More

ConfidentJanuary 2010 - Present

Designing and implementing Star-Schema & Snowflake Data Warehouses, using various design tools, diagrams etc.
    SQL (mostly Microsoft SQL Server (but also MySql and Postgres) - Transact-SQL development: creating DB objects, such as Stored Procedures, Functions, Triggers etc.);
    Developing DW/BI (Data Warehouse/Business Intelligence) modules using the Microsoft BI toolset (ETL – jobs to run SSIS (Sql Server Integration Services) packages, SSAS (Sql Server Analysis Services), SSRS (Sql Server Reporting Services), Visual Studio DB Projects), reporting and OLAP tools, such as (SAP) Crystal Reports and Logi XML (including Logi XOLAP (in-memory) and OLAP data cubes);
    Microsoft .Net desktop and ASP.Net development (VS.NET, HTML, CSS, JavaScript, JQuery)
    Various development tools, mostly freeware, DB administration scripts using many programming languages (C/C++, Perl, PHP, Java etc.)
    Maintenance for some complex PHP+MySQL+ExtJS financial and medical software
    DBA-related tasks (DB jobs, backups et
Gathering new software requirements from clients, application end-users and IT consultants
    Developing new application modules and extending the functionality of old (existing) modules
    Creating report generators, designing and implementing reporting modules
    Comprehensively and thoroughly testing the application functionality, identifying and correcting problems or suggesting possible solutions for the problems, accurately indicating the reasons why those problems appeared.

Ensuring proper training & support for application users, by solving most of the emerging problems as quickly as possible (in Java for desktop application modules and in JSP for web-based modules, using Netbeans, Eclipse with plugins etc., Oracle PL/SQL and Toad, Unix Shell commands and scripts, various XML processing tools, web development tools etc.).
    Trainer for application final users and administrators; Creating documentation, support and training materials for the application.
    Comprehensively and thoroughly testing the application functionality, particularly the communication between the application and third-party applications (e.g. SAP 4.6, SAP 6.0), identifying and correcting problems or suggesting possible solutions for the problems by accurately pin-pointing the reasons why those problems appeared.
    Solving problems inside the application and developing new functionalities for the application (in Power Builder(Sybase) and Visual C++, using Pro C/C++ precompilers, Oracle PL/SQL and Toad, Unix Shell commands and scripts) etc
More

RodipetJanuary 2005 - January 2008

•    Designing, developing, maintaining and ensuring support for desktop or web-based applications distributed in the company’s intranet using Microsoft .NET technologies (Visual C++/C#/VB.NET, ASP.NET), Crystal Reports, PHP, Java/JSP, various database engines (MySQL, MSDE, Sql Server, Oracle Express etc), various office suites (Microsoft Office with Visual Basic for Applications, Open Office etc.), automation (macro, scripting) tools (Auto Hotkey, AutoIt etc.);
•    Maintenance, optimization, extension of applications functionality with new modules and requested facilities, technical support etc. for Socrate, Charisma, Fidelio and other ERP solutions created by third-parties and used under license in Awdi Group, as well as for internal applications (partly created by myself) used for the management of resources of Awdi Group companies.
•     Administration of several SQL Server databases for the Awdi Group’s companies (maintenance operations, jobs, backup, replication, extension with various database stored objects (stored procedures, stored functions, triggers in T[ransact]-SQL (for MS SQL Server) and in PL/SQL (for Oracle)).; creating and maintaining data transfer processes between MS Sql servers (replication, batch jobs scheduled to run periodically, linked servers); creating ETL (Extract, Transform, Load) procedures for data warehouses;
•     Designing and implementing a separate database for the company’s data warehousing needs; ETL, OLAP cubes, generating many BI (Business Intelligence) reports to sustain the decision-making process.
More

Mediauno SRLJanuary 2004 - January 2005

•    PHP/MySQL/Apache, HTML, XHTML, CSS, XML (for reports and data processing etc.); Photoshop, GIMP; various web design and development IDEs, such as Microsoft Frontpage (in Windows) and Quanta (in Linux)
•    Maintenance and Optimization of the internal information system and procedures
•    Administration and extension of a computer network of approx. 20-30 computers
•    Development and maintenance of a website for online magazines and newspapers; Advertising materials.
More

eMAG.roJanuary 2004 - January 2005

Developing ERP modules to ensure the optimal management of the company’s resources (tracking &
generating orders, expenditures, invoices etc.), extending & optimizing the e-commerce website

www.emag.ro (administration part, search engine)
More

Mediauno SRLJanuary 2004 - January 2005

Developing ERP modules to ensure the optimal management of the company’s resources (tracking &
generating orders, expenditures, invoices etc.), extending & optimizing the e-commerce website

www.emag.ro (administration part, search engine)
More

TechTeam AkelaJanuary 2003 - January 2004

Testing of various software applications (including automated tests using various test automation tools, such as Microsoft Application Center Test); stress-testing websites and web-based applications, building usage statistics, graphs and reports etc.; preparing and maintaining software testing platforms
    computer administration and maintenance (mainly software)
    translations (localizations) of applications (in English, French, Romanian)
    developing AkelaRH, a human resources management application in ASP
    developing a “contacts management” program for internal use in Visual C++ with a Microsoft SQL Server Database for the desktop version and in PHP/MySql/Apache for the web-based version
    developing modules for the training and testing of pilots on Airbus planes, using ATLAS (a Multimedia Authoring program), Macromedia Director, Photoshop, GIMP, Powerpoint and Macromedia Flash

My stack

Business Intelligence

SSRS, Business Intelligence, SSIS

Technologies

Web Services, JSP

Environment of Development

Oracle SQL Developer, Eclipse, Visual Studio

IT Infrastructure

Linux

Languages

XSLT, ASP.NET MVC, MVC, VB.NET, T-SQL, C#, VBScript, HTML, ASP.NET, ASP, CSS, XML, SQL, Visual Basic, JavaScript, PHP, PL/SQL, OOP, UML, Java

Application servers

Apache

Analysis methods and tools

Agile Methodology

Frameworks

AJAX, .NET, jQuery, JDBC

Databases

MySQL, SQL Server, PostGreSQL, Database Administration, SQL Server 2000 - 2008, Microsoft SQL Server, DB2, ADO.NET

Others

Database Design

My education and trainings

BS (Bachelor Of Science) Field Of Study Business Informatics v - The academy of economic studies in Bucharest1999 - 2003

Assistant Programmer/Software Developer Field Of Study Informatics, Mathematics - Tudor Vianu Informatics College Nr. 11995 - 1998