Position: Pl/SQL Developer
Category: SQL
English level: intermediate
Years of experience: 5

I perform analytical queries every day.
I engage in debugging procedures on production client databases.
I provide consultations to clients regarding interface operation, specifically in the "Personnel Accounting" domain.
In my free time from work, I am developing in the field of Data Science. In this context, I am building my own developer environment (Linux, Docker, Virtual Machine).

I'm the one who tackles challenges and finds solutions.
My current position is Information Technology Specialist.
1)5+ years of experience in PL/SQL, primarily in an 
enterprise-level schema:
  (a) Created SQL queries and temporary analytical summaries for client needs.
  (b)Created PL/SQL scripts (anonymous blocks) for “one time” mass updates of values in the database or creation of new records from non-formatted sources.
  (c)Created user’s triggers to unify user-entered string names or correct missing dates(e.g., 1982-04-01) in the database.
  (d)Created functions to generate various values or optimize existing functions (e.g., replacing the use of the SYS_CONNECT_BY_PATH function with LISTAGG).
  (e) Optimized non-standard SQL queries by rewriting the query itself (without creating new indexes, as I was not authorized to do so), Sometimes, I was able to optimize SQL queries that used the schema's standard functionality.
  (f)Created or maintained existing procedures that were used for reports generate (returned an open cursor).
  (g)Created packages using PIPELINED table functions to generate very complex reports.
  (h)Created tables for import/export of data from Excel-like sources.
  (i)Debugged complex standard procedures in production databases to identify the causes of errors (bugs or specific records that block transaction completion).
  (j)I performed some administrative tasks such as creating a new user, killing a session, and sometimes identifying which session caused a "dead lock" on a table involved in a transaction.
2)Other Programming Languages Experience
  (a)Delphi: Developed simple event-driven procedures
  (b)TypeScript: Developed forms and form event handling procedures.
  (c)TypeScript: Developed procedures that provide action handling in a category.
  (d)TypeScript: Developed several not-very-complex categories.
  (e)C, C++, C#: Training experience (about 10 years ago).
3)Other Generalized Work Experience
  (a)FastReport 4.6 (Delphi + PL/SQL): Created, improved, and supported a large number of reports.
  (b)StimulSoft (TypeScript + PL/SQL): Created a few reports.
  (c)Provided phone support (AnyDesk) to clients on the following topics: organizational staff structure and staff accounting, in connection with the payroll module.
I am not interested in working in a role that requires me to be a "jack of all trades," simultaneously performing such different tasks as,- consulting with accountants, debugging PL/SQL code, migrating data from Excel spreadsheets to databases, creating merge requests with TypeScript elements into repositories and install apps for clients.
	I am interested in a role that focuses on enterprise-level Oracle database development.