Ildar YakupovSenior support engineer
Almost 5 years of database experience I really like to learn and try new things with SQL and PL/SQL queries. Throughout his professional career, he interacted with various databases: - Started with simple sql queries, - Uploaded data for reconciliation of reports of various government agencies, - Created reports - Wrote complex queries using join, tables from different databases, - Created and populated create, update, insert, delete tables - Wrote small pl/sql queries with loops, for loops and cursors, - Made minor changes to the package body, - Created tasks for automatic statistics collection. In the course of my professional activity, I accompanied, supported and implemented new functionality for several large banks, both from the side of the bank and from the side of the vendor. I am constantly developing, studying materials on the Internet, attending trainings within the company, team building and other events, thanks to which I develop as an IT specialist. In my free time, I actively study English with a tutor and undergo basic training in the Python programming language In the future, I want to add interaction with programming languages ​​to my professional activities. I am currently Turkey-based and am open to remote work opportunities worldwide and relocation mail: fosdas665@gmail.com Telegram: https://t.me/Ildaryakupovv
Tech stack
Linux RHEL/CentOS (6)
JIRA (6)
SQL (6)
Atlassian Confluence (6)
Infrastructure monitoring (6)
Oracle PL/SQL (5)
IT Support (4)
Banking & Finance (3)
Apache Tomcat (3)
Jenkins (2)
JSON (2)
Ansible (2)
PostgreSQL (2)
MySQL
PL/SQL
Linux
Python
Bash
Zabbix
Experience
Lead software engineer for an international business service provider for telecom and tech companiesNexign
06/2022 - Currently

Maintenance and support of systems, implementation of new functionality Analysis of failures in client systems, analysis of logs (Ansible) Working with databases: Oracle SQL - writing complex queries (select, aggregate functions (count, sum, min, max, avg), case, join, between, rownum, group by, having, order by, partition) Oracle PL/SQL - writing simple commands (create, update, insert, delete, declare, loop, for, dbms_output) PostgreSQL - writing simple queries Clickhouse - writing simple queries Monitoring and diagnostics of systems (Grafana) Before installing new functionality, automated testing and further analysis of failed tests (Testrail, Jenkins, Allure) Analysis of incidents (3rd line), analysis of errors and elimination of accidents (5 levels) Simulation of errors on test environments via OAPI requests, JSON Constant interaction with many teams (Developers, analysts, testers, 2nd line) Work in operating systems Windows, Linux Working with Atlassian Jira, Confluence

SQL
Oracle PL/SQL
JIRA
Atlassian Confluence
Linux RHEL/CentOS
Infrastructure monitoring
PostgreSQL
JSON
Jenkins
Ansible
Lead specialist in software implementation/maintenance at a major developer of software for banksDiasoft LLC
11/2021 - 01/2022

• Helped implement/deploy the company's software products to banks • Facilitated installation, configuration, and testing of new banking software products • Analyzed and eliminated errors, analyzed logs • Launched solutions into commercial operation • Worked with MS SQL databases to field queries • Jira Atlassian, Confluence, Websphere

SQL
Linux RHEL/CentOS
JIRA
Atlassian Confluence
Infrastructure monitoring
IT Support
Banking & Finance
Leading specialist of a processing center at a regional commercial bank LLC KBER Bank of Kazan
10/2019 - 11/2021

• Maintained the system performance (Compass Plus) of the processing center (front-end and back-end) • Monitored of transactions of cards of MIR and Visa payment networks • Identified and eliminated errors in unsuccessful transactions • Monitored the performance of ATMs, conducted test operations • Tested images of new versions • Issued bank cards, set up card products, limits • Addressed queries from different databases • Tested the functionality of new versions • Monitored and increased the database size by adding new database files • Worked on Windows (7,8,10) and linux (mintOS, Ubuntu) systems • Set up and processed tasks in Directum, Outlook, WinSCP, and PuTTY • Jira Atlassian, Confluence, Tomcat

SQL
Oracle PL/SQL
Infrastructure monitoring
Linux RHEL/CentOS
Apache Tomcat
JIRA
Atlassian Confluence
IT Support
Banking & Finance
Processing center specialist at a large regional bankLLC Bank Avers
09/2017 - 09/2018

• Supported and maintained the system performance (Smart Vista) of the processing center (front-end, back-end) • Oversaw transactions performed (Visa payment networks, NSPK) B2B, B2C Set up notifications (email, SMS, push) • Conducted fraud monitoring • Tested the functionality of new versions and checked for errors in old versions • Set up and processed tasks in Directum

SQL
Infrastructure monitoring
IT Support
JIRA
Atlassian Confluence
Linux RHEL/CentOS
Education
Bachelors degree, Computer Software EngineeringKazan National Research Technical University named after A.N.Tupolev – KAI
09/2016 - 07/2020
Specialized secondary, Programming in computer systems and complexes College of Information Technologies at the Kazan Scientific Research Technical University named after V.I. A.N. Tupolev - Kazan
08/2012 - 07/2016