Sergii C.

I have work experience with Oracle (10g, 11g), MS SQL and MySQL Databases. Concerning to Oracle DB: Development - maintenance and creation of Oracle Database objects, such us: tables, views, procedure, function, packages, indexes, triggers, etc. - development of database structures; - using Analitical functions, PL/SQL Collection, Dynamic SQL in development; - hierarchical Queries; - developing and optimization queries for select data; Administration - implementation Import/Export. Using Oracle Export/Import (exp, imp), Data Pump Export/Import (expdp, impdp) Utilities and Data Pump API of PL/SQL (DBMS_DATAPUMP package); - statistics gathering with DBMS_STATS package; - partitioning of tables and indexes; - creation, granting and revoking roles and privileges on data access for user; - working with RMAN (making backups, restore, duplicate DB, repairing data block corruption); - configuring Primary and Standby DBs (Data Guard); Concerning to MySQL DB: - Creation and optimization SPs and functions. Concerning to MSSQL DB: - maintenance and creation of Database objects - SQL Server Integration Services - basic level KEY SKILLS: - Databases: Oracle 10g/11g, MySQL, MSSQL; - Database Utilities: Oracle Export/Import (exp, imp), Data Pump Export/Import (expdp, impdp), APEX Data Loader; - Programming languages: SQL, PL/SQL, T-SQL; C# (WinForms, ASP.NET - basic level); JavaScript, HTML, XML; Object Pascal; ColdFusion; - Development tools: PL/SQL Developer, Quest Software Toad, SQL*Plus, SQL Server Management Studio, SQLyog; - Operating Systems: Windows 2003/2008 Server/ 2000/NT/XP/7, Linux, Unix.