Больше информации по резюме будет доступно после регистрации
ЗарегистрироватьсяWas online more than two weeks ago
Candidate
Male, 44 years, born on 17 June 1980
Australia, willing to relocate (Australia), prepared for business trips
Oracle developer/DBA
4 000 $ in hand
Specializations:
- Programmer, developer
Employment: full time, part time, project work, work placement
Work schedule: full day, shift schedule, flexible schedule, remote working, rotation based work
Work experience 13 years 5 months
May 2014 — January 2017
2 years 9 months
Russia, www.netcracker.com
IT, System Integration, Internet... Show more
Senior Software Engineer, Project role: Data migration Lead, Samara(Russia), Skopje (Macedonia)
Overview:
The most significant projects were:
1. Data migration of inventory and service inventory of Voice services for Optus (Telecommunication Company in Australia). Project role: Data migration Lead (Service inventory)
Key responsibilities:
• WBS preparation
• Gathering requirements for validation and transformation rules
• Team management(up to 5 people)
• Creating SQL scripts for validation and transformation of data
• Creating SQL reports
• Analysis of different sources data
• Architecture design creation
• Data governance and management
• SQL query optimization
• Database design, creation and maintenance.
• Bug fixing of validation and transformation engine
Technologies Used:
• Oracle PL/SQL
• VB (MS Excel)
• SQL plus
• Unix shell
• Tableau
2. Data migration of inventory and service inventory of Macedonian telecom
Key responsibilities:
• Database design, creation and maintenance.
• DB architecture, system implementation and administration
• Creating SQL scripts, procedures, packages for validation and transformation of data
• Creating SQL reports
• Database performance tuning, troubleshooting, and optimization
• Bug fixing of validation and transformation engine
• SQL Queries optimization
Technologies Used:
• Oracle PL/SQL
• VB (MS Excel)
• SQL plus
• Java (generation excel reports)
Achievements:
• Mentoring and coaching new team members and junior engineers.
• Successful implementation of new report engine for time consuming preparation of reports which helped to decrease time for every validation report from 2 days to 15 minutes.
October 2016 — December 2016
3 months
NetCracker Technology, Sydney, Australia (Subcontractor of Optus Pty Limited)
Software Engineer. Project role: Data migration Lead
Overview:
Project: Data migration of inventory and service inventory of Voice services for Optus (Telecommunication company in Australia).
Key responsibilities:
• Oracle database performance tuning
• Creating SQL(Pl-SQL) reports and scripts for validations and transformation of data
• Support client’s queries
• Organize work of team in remote office (Samara, Russia)
• Gather technical requirements for validation and transformation rules.
• Analyzing network issues for access to server from application
• Data modelling and data analysis
• Bug fixing of validation engine
• Report design in MS Excel
• Customizing report engine
• Confirmation with customer validation results
• SQL optimization
Technologies Used:
• Oracle PL/SQL
• VB (MS Excel)
• SQL plus
• Unix shell
Achievements:
In addition to main on-site (Sydney) client activities I actively partook in evening (night) sessions with off-site team at nights and on weekends: meetings, mentoring, etc.
August 2012 — May 2014
1 year 10 months
LTD Tarifer
Samara, www.tarifer.ru/
Team Leader
Key responsibilities:
• Creating SQL, Pl-sql and T-sql scripts
• Oracle 11 Database administration: DBA and optimization
• System administration of servers: windows server 2008(2012), ubuntu
• Set up database environment
• Database performance tuning
• Architecture analysis and design creation
• SQL database solutions: stored procedures, functions, tables, triggers, packages.
• Using agile methodology of software development
• Database monitoring: Oracle scheduler jobs and Hostmonitor.
• Network settings and maintaining network for servers.
Technologies Used:
• Oracle SQL and PL/SQL
• Oracle RMAN, Archive log
• MySQL
• Embarcadero Delphi XE
• VB (MS Excel)
• MS SQL server 2005
• SQL plus
• Unix shell
• VBS scripts
Hostmonitor
Achievements:
• New monitoring system was proposed and implemented (Hostmonitor), which helped to proactively prevent issues in advance.
• Project management web application was implemented (Redmine) which improved a lot of project managements and task tracking.
• Controlling database DDL changes system was proposed, developed and implemented which helped to control all database changes in production environment.
September 2010 — July 2012
1 year 11 months
Sberbank
Samara, www.sberbank.ru/samara/ru/
Chief Engineer
Overview:
The main duties were to develop information and billing systems for processing of payments, reporting for bank activity.
Key responsibilities:
• Database design, creation and maintenance.
• Data migration from Oracle 9 to Oracle 11(Enterprise Edition).
• Support internal bank software
• IT support.
• Development of client-server applications: Delphi 7(client side), Oracle 11(server side)
• Support of Large Enterprise applications
Used technologies:
• Oracle PL/SQL
• Oracle 9, 11(including partitioning, flashback queries and flashback tables)
• Microsoft IIS (ASP and ASPX pages)
• MS SQL Server
• AIX
• Delphi 7
Achievements:
Successfully developed and implemented new report engine (Delphi + SQL Server) that helped to automate commonly used reports from different systems.
September 2003 — September 2010
7 years 1 month
Sberbank
Samara, www.sberbank.ru/samara/ru/
Senior Engineer
Overview:
The main duties were to develop information and billing systems for processing of payments, reporting for bank activity.
Key responsibilities:
• Database design, creation and maintenance.
• Data migration from Oracle 9 to Oracle 11(Enterprise Edition).
• Support internal bank software
• IT support.
• Development of client-server applications: Delphi 7(client side), Oracle 11(server side)
• Support of Large Enterprise applications
Used technologies:
• Oracle PL/SQL
• Oracle 9, 11(including partitioning, flashback queries and flashback tables)
• Microsoft IIS (ASP and ASPX pages)
• MS SQL Server
• AIX
• Delphi 7
Achievements:
Successfully developed and implemented new report engine (Delphi + SQL Server) that helped to automate commonly used reports from different systems.
Skills
Skill proficiency levels
About me
CAREER OVERVIEW
• Over 13 years working in the IT services.
• Strong working knowledge of relational databases and SQL.
• Practical experience in Database Administration and performance tuning (Oracle: AWR, RMAN, SQL optimization, etc.).
• Oracle Enterprise Edition skills
• Experience in Financial systems(bank software)
• Data migration and ETL experience
• Experience in team development
• Strong communication skills.
• Keen to learn new services and technologies
TECHNICAL SKILLS
• Databases: Oracle (SQL, PL-SQL, SQL tuning, DBA), MS SQL (T-SQL), MySQL.
• IDE: Pl-SQL developer, Toad, IDEA.
• Programming languages: Delphi (Object Pascal), Python (basic level), Java (basic level)
• BI Tools: Tableau, SSIS, SSRS
• OS: Windows Server (2008, 2012), Linux (Ubuntu)
• Monitoring/Alarming: Host Monitor, Oracle scheduler jobs.
• Virtualization: VMWare, VirtualBox
• Project tracking systems: Jira, redmine
• Version control systems: Git, SVN
Higher education
2009
International Institute of Market
Economist, Finances and Credit, Diploma
2002
Technical University, Automation of Information Technologies Department
IT, Computing engine, Systems, Sets and Networks, Diploma
Languages
Tests, examinations
2014
IELTS (International English Language Testing System)
English Assistant Samara(University of Cambridge ESOL Examinations (Cambridge ESOL), IDP: IELTS Australia и British Council), Average - 7
Citizenship, travel time to work
Citizenship: Russia
Permission to work: Australia, Russia
Desired travel time to work: Up to one hour