Julia Astakhova - Резюме IT engineer

September 2019 – Now
PJSC Sberbank
Position:
Lead Development Engineer, Customer Care Division, IT Department

October 2011 – September 2019
VTB Bank (public joint-stock company)
Position:
Chief Engineer, Software Deployment & Support Division, IT Department
Chief Engineer, Division of Investment Business Automatization, IT Department
Expert, Division of Investment Business Automatization, IT Department
Expert, Division of Information Services Support, IT Department
Expert, Division of Corporate Business Application Support, IT Department

March 2011 – August 2011
The Pension Fund of the Russian Federation
Position:
Leading expert, Automatization Division

September 2010 – January 2011
JSC "First Processing Bank" ( subsequently renamed as JSC "QIWI Bank")
Position:
Programmer, Banking System Division, Department of Banking Technology

August 2008 – June 2010
PJSC "Joint-Stock Commercial Bank "Primorye”
Position:
Database Administrator, Banking Software Division

2008 Far East Federal University
Information Systems at the Economic field, Master Degree (MA Equivalent)


2014 Namseoul University (NSU)
Korean Language


Certificates:

2019, EF English First School in Tverskaya, EF Level 12 - UPPER INTERMEDIATE - CEFR Level B2
2019, RDTEKH Training Center, O12cAPLS Oracle Database 12c R2: Advanced PL/SQL
2017, Computer Training Center «Specialist» at Bauman Moscow State Technical University, Oracle Database 11g: SQL tuning
2017, Computer Training Center «Specialist» at Bauman Moscow State Technical University, M10972B: Microsoft IIS Web Server administration
2015, MS Trainer Consulting Company, Microsoft Excel. Formulas and functions
2014, Computer Training Center «Specialist» at Bauman Moscow State Technical University, Oracle 11g. Database Administration. Part I
2014, Computer Training Center «Specialist» at Bauman Moscow State Technical University, Oracle 11g. Database Administration. Part II
2014, Computer Training Center «Specialist» at Bauman Moscow State Technical University, Oracle 11g. Performance Tuning
2014, Korean Culture Center in Moscow, Korean Language. Level K3-2
2014, Namseoul Institute of International Culture & Exchange Chair, Korean Language & Culture

10 years of experience supporting bank software
10 years of experience in Windows Systems Engineering/Administration/Help Desk Experienced in Microsoft environments of 9000 end users
Strong technical prowess, including understanding of algorithms, systems architecture
Expertise in feature definition, design and feasibility Identify and automate repeatable manual tasks
Identify recurring problems and build solutions to automate and remediate the issues
Monitoring and managing the reports/SLAs of dev work and documentation is maintained
8 years of experience supporting applications on UNIX/LINUX operating Has experience supporting with 20-30 banking business applications/systems Experience 1st & 2nd level support
Basic experience with managing Active Directory
Knowledge of Desktop applications; Windows 7/8/10; Server 2008R2/2012R2 Virtualization experience with VMware
Experience with Oracle 8i, 9i, 10g, 11g, 12c in a UNIX\LINUX environment
Extended knowledge and experience with SQL Server database, back-ups, recoveries, etc.Active DirectoryLinux

Functional skill areas:
Automating application deployments with TeamCity (AutoMate 10) Logs analyzing and querying (Elasticsearch, Kibana)
Log parsing using Log Parser Studio
DB experience (Oracle, MS SQL, MySQL) Basic skill in DB2 databases
Oracle с MQ: MGW, PG4MQ
Oracle DB skill areas:
SQL queries performance tuning
Shrink and compress tables/indexes
DB wait events (locks, tx-locks, mutex, latch, etc.) analyzing Analyzing and reclaiming free space in tablespaces
Index usage monitoring
Finding unusable DB objects
Analyzing query execution plan
Session tracing
Evaluating DB performance coefficients
Detail analyzing sql query execution using Oracle Enterprise Manager Diagnosing problem points based on ASH and AWR reports Monitoring and performance statistic setting
SQL tuning using SQL Tuning Advisor Building sql profiles and baselines