Oracle PL SQL senior developer Middle full stack web develop

Summary:
* 10+ years of experience in database development
* 6+ years of experience in client - side web development
* 6+ years of experience in leading a team of up to 5
* Oracle SQL, PL/SQL development
* Oracle APEX development
* Oracle database and SQL query performance tuning
* Database migration experience
* HTML, CSS, Javascript, AngularJS, Bootstrap client - side development
* Fluent English proved by an IELTS certificate score of overall 7
* Fluent native Russian

Technical skills:
* 10+ years experience developing software based on Oracle DBMS 10. x – 12. x SE and EE.
* Designing databases, developing business logic using PL/SQL code. Analysis and tuning of SQL queries, PL/SQL functions and procedures for better performance. Handling high - loaded databases with guaranteed response time for a number of requests/procedures.
* Working with partitioning, external tables, embedded PL/SQL packages, network communication: e - mail, HTTP, SMTP. Creating in - house PL/SQL packages for working with well - spread network protocols: FTP, SMPP. Parsing and/or generating the data in the format XML, CSV, HTML, MS Excel. Implementing the data exchange through db links to Oracle and MS SQL, using two phase transactions.
* Tuning the performance of SQL requests by means of changing, hinting and paralleling them; analyzing execution plans; observing wait events, optimizer statistics; changing data structures; balancing the workload between CPUs, RAM, I/O speed.
* Dealing with the data warehouses which contain tables with hundreds of billions of records and are installed to high - performance servers: up to 64 CPU cores, up to 256 Gb RAM, up to 30 Tb disk space.
* Tuning Oracle DBMS settings for better performance.
* 5+ years of developing the web applications based on the server - side Oracle APEX 4 - 5. x web framework. Using embedded RESTful API to provide external systems with data.
* 5+ years of developing the client - side of web applications in HTML, CSS, Javascript, AngularJS, jQuery. 4+ years of experience using JSON, Websockets.
* Sustaining the software products based on Oracle DBMS, Postgres DBMS.
* GIT, Subversion, JIRA

Accomplishments:
* Led all the software engineering processes of three fraud management systems, used to detect and suppress diverse kinds of fraud, for one of top national cellular network operators.
* Created single - page web applications based on Oracle APEX with the client - side written in AngularJS, Bootstrap
* Developed the ETL systems processing and transfering the data from billing to three - part systems.
* Transferred a database from Sybase Anywhere 8.0 DBMS to Oracle 10.2 DBMS. In addition, rewrote and adapted all the Delphi applications related to the database.

Additional skills:
* Proficient in Delphi, Sybase Anywhere DBMS software developer (5+ y. ) PHP+MySQL (1+ y. ) and creating java servlets.

Professional experience:
* Principal PL/SQL developer 7 Oct, 2019 – till the present time LLC Bercut, Saint - Petersburg, Russia
* Team Leader 1 Oct, 2013 – 4 Oct, 2019 LLC MFI Soft, Nizhny Novgorod, Russia
* Database Developer 14 Jun, 2011 - 30 Sep, 2013 LLC MFI Soft, Nizhny Novgorod, Russia
* Database Developer 23 Aug, 2005 – 10 Jun, 2011 State organization “Federal Registration Service”, Nizhny Novgorod, Russia

Education:
Master' s Degree with a Major in computing, graduated from State Technical University, Nizhny Novgorod, Russia in 2001