Main menu

Stay in touch for more remote team tips

img

Database Developer

$0/hour
Request interview

Experience:

  • - Applications development, Oracle Developer/2000 (Forms&Reports): 5 years
  • - Project documentation writing, 5 years
  • - Support, consulting, training of employees, 5 years
  • - Projects coordination, 2 years
  • - Lecturer, 6 years
  • - PL/SQL, SQL, 8 years

Portfolio:

  • 2011 - 2013 Informatica Developer for Microstrategy project on behalf of Augaroo/Ciklum
  • 2012 SQL Support at PHLY insurance company
  • 2011 ETL/Oracle Developer at UBS/Luxoft
  • 2009 - 2011 Project coordinator, technical writer, tester; at Natural Codes
  • 2002 - 2011 Lecturer at Transnistrian State University
  • 2004 - 2009 Oracle developer at JSCC Moldova Steel Works
See all portfolio

Summary:

Over 8 years of experience in Database management. Specialization: RDBMS (Oracle, MS SQL, MySQL, ParAccel), ETL development in Informatica PowerCenter. ETL development (Informatica PowerCenter 9.0.1, 8.6.1), Oracle 8i, 9i, 10g, Database modeling ErWin, functional modeling Bpwin, Physical database design.

Read full summary

Resume

Key areas of experience
- ETL development (Informatica PowerCenter 9.0.1, 8.6.1)
- Oracle 8i, 9i, 10g
- Database modeling ErWin, functional modeling Bpwin
- Physical database design
- PL/SQL, SQL; (> 8 years)
- Query optimization
- MSSQL, MySQL, FoxPro, Paraccel (PADB 3.1.1)
- Unix schell/ batch scripting
- COBOL code support
- Applications development: Oracle Developer/2000 (Forms&Reports) (>5 years)
- Project documentation writing (English – Russian) (>5 years)
- Support, consulting, training of employees (>5 years)
- Projects coordination (2 years)
- Lecturer (Russian, >6 years).

Specialization
RDBMS: Oracle, MS SQL, MySQL, ParAccel
ETL development in Informatica PowerCenter
Lecturer

Languages
Russian (fluent), Ukrainian (fluent), English (technical documentation reading/writing, spoken English skills), German (A1 level)

Education
University degree – Transnistrian State University;
"Physics, Mathematics and Informatics" department;
Computer science engineer, diploma with honor

Experience

Informatica Developer for Microstrategy project on behalf of Augaroo/Ciklum, december 2011 - july 2013 (1 year 8 months)

Job responsibilities and skills:
- Informatica 9.0.1 workflows, mappings, worklets developing
- Creation of ETL control schema (automation of registering of workflows, consumers in own meta-data layer,
- Monitoring and logging of ETL processes, scheduling of workflows, errors notification)
- DWH logical and physical modeling
- Db scripts creation
- Batch scripting
- Work with Informatica MX views
- Work with Web Services Hub
- Work with different targets and sources: flat files, MySql and Paraccel dbs, Hadoop
- Versioning of workflows Technologies: Informatica Power Center 9.0, MySql 5.5.9, Paraccel PADB 3.1.1, Tortoise SVN, batch scripting, JIRA

SQL Support at PHLY insurance company December 2012 – january 2012 (2 months)

Job responsibilities and skills:
- SQL BI Support
- queries optimization
- reports for BA creation
- fixing of breaks in data and reports ETL/Oracle Developer at UBS/Luxoft february 2011
- november 2011 (10 months) Job responsibilities and skills:
- Software development for UBS Investment bank
- Database modeling, query optimization
- Informatica workflows developing
- Stored procedures, triggers, reports creation Technologies: Oracle 10g, PL/SQL Developer, SQL, PL/SQL, Informatica PowerCenter

Project coordinator, technical writer, tester; at Natural Codes, july 2009 - september 2011. (2 years 3 months)

Job responsibilities and skills:
- technical documentation writing (Russian/English)
- Database development: database modeling and creation; stored procedures writing; query optimization.
- Project team coordination: client-developer coordination, testing, project documentation writing. Technologies: MS SQL Server; HTML, MySQL, C# Lecturer at Transnistrian State University september 2002
- july 2011 (8 years 5 months) Disciplines:
- Databases – introduction;
- Information systems;
- Innovation Management;
- Oracle SQL \ PL SQL;
- Metrology, Standardization and Certification (General course).

Oracle developer at JSCC Moldova Steel Works, July 2004 - july 2009 (5 years 1 month)

Job responsibilities and skills:
- Database objects modeling, physical database design;
- forms development (Oracle Forms);
- query optimization;
- reports creation using Oracle Reports;
- preparation of technical specifications for software development, user guides creation;
- Support, consultations, trainings of company employees;
- Analysis and modeling of business processes in payroll, HR;
- Oracle Applications 11 I (11.5) Oracle 8 I (8.1.7.) support, users/forms/reports adding Technologies: Oracle Forms 6i, Oracle Reports 6i, ErWin, Bpwin, HTML; Oracle SQL, PL/SQL, FoxPro; Professional courses:
- INFORMATICA PowerCenter 8.6 Developer Level 1
- Perfomance tuning Oracle
- INFORMATICA PowerCenter 8.6 Developer Level 2

img

REQUEST INTERVIEW WITH THIS CANDIDATE

By submitting the form you are accepting our privacy policy