Разработчик Oracle / PL / SQL

Был больше месяца назад

По договорённости

76 лет (родился 20 июня 1949)

Москва, готов к переезду: Псков

Занятость

не указано

Гражданство

не указано

Контакты

Телефон

Почта

Будут доступны после открытия

Фото, имя и контакты доступны только авторизованным пользователям

Опыт работы 12 лет и 8 месяцев

- Апрель 2013 – работает сейчас
- 12 лет и 8 месяцев
Sr. Database Engineer
Aeris Communications
Обязанности и достижения:
• Conversion of critical and resource consuming reports from Oracle to MySQL involving automatic generation of data migration/refreshing scripts and performance tuning. • Responsible for continuous design and development of in-house proprietary Oracle based systems (Device provisioning and Billing) utilizing PL/SQL Oracle 9i and 11g supporting Java based Web Services. Intensive usage of Oracle external tables with tight error handling mechanism to ensure the smooth restart-ability of processes handling large amount of input data being loaded (ETL) into Oracle data bases. Responsible for providing the database design guidelines to ensure the efficient and scalable solution implementation, delegating, providing the guidelines, and monitoring the development performed by the off-shore resources to ensure the high quality of code and data standards. Performance tuning of SQL and PL/SQL modules. Creating and maintaining Software System Documentation. • Working with Oracle ODI/Hadoop/Hive team by producing/tuning SQL utilizing External Tables to take the advantage from High Performance load to Oracle Database using ODI with Oracle Loader for Hadoop and Oracle SQL Connector for HDFS. • Playing a key role in providing for various reporting and data analytical tools for Operations, Sales, and Finance teams. Responsibilities include analysis, DB design, and implementation of proprietary data warehousing and reporting tools to allow for flexible metrics to accommodate the ongoing new Business requirements. • Designed and developed source repository structure for al Oracle components alone with Release Management methodology to accommodate Agile/Scrum development Sprint cycles. • Designed and developed infrastructure and dynamic code generators to create PL/SQL blocks for Unit Testing, Regression Testing, and QA Testing of stored PL/SQL modules contributing for RAD (Rapid Application Development) Tool Set. • Designed and implemented Oracle/RabbitMQ Integration methodology involving PL/SQL and Java components to dynamically generate the Exchange/Queue and post messages depicting CRUD activities on Oracle tables. This allows to offload the information to a 3rd party independent consumer utilizing different server (s).

Образование

- Неполное высшее образование
- Дневная/Очная
- 1983
Upsala College, NJ USA
Факультет: Structured Programming

Обо мне

Дополнительные сведения:

ORACLE8i/9i/10g/11g, SQL, SQL*PLUS, PL/SQL, MySQL, Forms/Reports V6i/9i, XML Publisher (BIP), Oracle Workflow Builder, Oracle AOL, Perl, CGI, JAVA, J2EE, HTML, JavaScript, JSON, XML, YAML, JDeveloper 10g, Intellij IDEA, ORACLE 11i, OAS, IAS, Jakarta/Tomcat, BRIO, ORACLE Utilities, SQL/Net, ERWIN, Oracle Designer, TOAD, UNIX/VI, ED, “C”, Informatica, Oracle Warehouse Builder, JIRA, Test Director, Kintana, PerForce, Clear Case, CVS, PVCS, GIT, Bitbucket, SVN, RabbitMQ.