Nurlan Myrza

senior

Registration: 30.07.2022

Specialization: Data Warehouse developer

C# C++ Java Linux Python SQL Assembler Azure Java Servlet Oracle PLSQL

Portfolio

EUREST SUPPORT SERVICES LIMITED

- Repair, installation, setup and support of PC and of other office equipment - Installation and support of GIL-2 system; - WAM database administration – new equipment accounting and changes follow-up; - Shipment of equipment on Warranty Service, entry of information concerning shipped/delivered warranty equipment into Sharepoint system; - Preparation and issue of laptops and projectors. Administration of database of leased equipment and filling up of the corresponded documentation; - Weekly reporting on the work done; - Closing of work orders with full description of the work done in FootPrints and CMMS system; - Participation in network installation and setup; - Participation in PC replacement on GIL-3 Project;

TENGIZCHEVROIL BOLASHAK ATYRAU LIMITED

Support of the following applications: - Energy Components - XHQ IndX - WellView - Quorum Land - Deployment of Windows Vista - Updating computer hardware - Migration of user profiles including business data and personal storage files - Doing Pre-deployment and Post-deployment with an end users remotely - Migrating Microsoft Office application 2003 to 2007 - Verify with user whether the file requires remediation or not. - Verify MS Office application functionality in GIL2 environment (Win XP and MS Office 2003). - Test application functionality in GIL3 environment applying trusted location

TENGIZCHEVROIL LIMITED

- Experience in migrating legacy warehouse from on-premise into cloud based Microsoft Azure (Azure Data Factory, Azure Data Lake, Azure Data Bricks); - Gathering/collecting business requirements and implementing in dev/build, testing and validating data in UAT and deploying to Production environment; - Manage complex production database environments plus additional non-production instances/systems; - Design and manage data marts on top of Kalido Datawahouse (DIW); - Provide SQL tuning expertise; - Design and manage data on Kalido MDM; - ETL expertise in Kalido jobs; - Perform capacity planning and perform monitoring of nightly jobs for refreshing data in Datawarehouse; - Understand business, technical aspects and infrastructure requirements; - Create and execute index rebuild, database backup and recovery; - Work with customers regarding granting access; - Troubleshoot database issues including collecting necessary information for vendor (support team); - Mentoring new commers; - Provide help/advise for project as techlead for internal projects;

Skills

Assembler

Azure

C++

Java

Java Servlets

Linux

Python

Turbo Pascal

Work experience

Data Warehouse administrator/Data Warehouse developer

06.2015 - 07.2020 |TENGIZCHEVROIL LIMITED

Experience in migrating legacy warehouse from on-premise into cloud based Microsoft Azure (Azure Data Factory, Azure Data Lake, Azure Data Bricks). Gathering/collecting business requirements and implementing in dev/build, testing and validating data in UAT and deploying to Production environment. Manage complex production database environments plus additional non-production instances/systems; Design and manage data marts on top of Kalido Datawahouse (DIW); Provide SQL tuning expertise; Design and manage data on Kalido MDM; ETL expertise in Kalido jobs; Perform capacity planning and perform monitoring of nightly jobs for refreshing data in Datawarehouse; Understand business, technical aspects and infrastructure requirements; Create and execute index rebuild, database backup and recovery; Work with customers regarding granting access; Troubleshoot database issues including collecting necessary information for vendor (support team); Mentoring new commers; Provide help/advise for project as techlead for internal projects;

TCO IT DBA TEAM, Database Administrator

04.2011 - 06.2015 |TENGIZCHEVROIL LIMITED

TCO IT DBA TEAM, Database Administrator • Perform routine IT duties to gain experience and familiarization with methods and practices, and developknowledge. • Assignments include preparing, modifying, installing and testing more advanced but well defined modifications to application and database programs and tools. • Operational role expanded to include collaboration with peers or higher level Application Support Engineer or group supervisor/team lead to achieve individual goals • Interact with internal and external users. This includes meetings to define/clarify application specifications, and provide technical support. • Using DBA procedure as daily checklist to monitor oracle databases and increase availability • Work with Quorum Land, SQL, Oracle 11g, JDE E1, ArcSDE primary DBA, Merak primary DBA, etc. • Working closely with both the Application specialists and the IT departments of TCO, supporting the ERP Technical Team Lead • Provide SAP Basis Administration and WAS (Web Application Server) support • Maintain the technical environments used by other ERP Systems (SmartStream Business Object) • Resolve technical and business issues within the standard problem escalation process using Call Logging system and responding immediately to any critical conditions and proactively to any developing conditions, including Database locking (track, document, and correct • Document processes and procedures regarding system maintenance and installation configuration • management of changes – preparing the documents for the testing and implementing to the production system and validation • Apply upgrades and updates including service packs, Oracle and SQL servers DBs. • Monitor and optimize response times of ERP Systems including Oracle and SQL databases • Support the ERP Security officer and enforce security of system data access - Develop and implement system backup and recovery strategy -V • SQL Server and Oracle Database administration • Unix administration, • Perform on-go

TCO IT ESA TEAM, Programmer

03.2010 - 04.2011 |TENGIZCHEVROIL BOLASHAK ATYRAU LIMITED,

TCO IT ESA TEAM, Programmer Support of the following applications: • Energy Components • XHQ IndX • WellView • Quorum Land

GLOBAL INFORMATION LINK 3 PROJECT VDOC (Virtual Deployment Organization Center) Engineer

03.2009 - 02.2010 |TENGIZCHEVROIL BOLASHAK ATYRAU LIMITED

• Deployment of Windows Vista • Updating computer hardware • Migration of user profiles including business data and personal storage files • Doing Pre-deployment and Post-deployment with an end users remotely

TCO GIL3 MS OFFICE REMEDIATION TEAM Engineer

02.2009 - 10.2009 |TENGIZCHEVROIL BOLASHAK ATYRAU LIMITED

• Migrating Microsoft Office application 2003 to 2007 • Verify with user whether the file requires remediation or not. • Verify MS Office application functionality in GIL2 environment (Win XP and MS Office • 2003). • Test application functionality in GIL3 environment applying trusted location

IT specialist - HELP DESK

02.2008 - 02.2009 |EUREST SUPPORT SERVICES LIMITED

• Repair, installation, setup and support of PC and of other office equipment • Installation and support of GIL-2 system; • WAM database administration – new equipment accounting and changes follow-up; • Shipment of equipment on Warranty Service, entry of information concerning shipped/delivered warranty equipment into Sharepoint system; • Preparation and issue of laptops and projectors. Administration of database of leased equipment and filling up of the corresponded documentation; • Weekly reporting on the work done; • Closing of work orders with full description of the work done in FootPrints and CMMS system; • Participation in network installation and setup; • Participation in PC replacement on GIL-3 Project;

Translator/Interpreter

08.2007 - 02.2008 |TEST COMPANY, Tengiz oilfield, Kazakhstan

Provided all necessary oil industry related translation and interpretation services.

Programmer

04.2007 - 08.2007 |CONTECH-SOFT LIMITED

• Developed software applications for generating a variety of reports in financial, stock-exchange, procurement/warehousing, etc. • Interfacing with other programmers in cases of developing large complex software systems (was a requirement).

Programmer

05.2006 - 08.2006 |WORK AND TRAVEL

• Performed software testing through actual operation and testing of various software to identify faults and verify their operability and user-friendly format.

Safety Engineer

05.2003 - 07.2003 |HANDICAP CONSTRUCTION COMPANY

• Handled safety implementation in the company ensuring all requirements and compliance are met.

Programmer and System Administrator

12.2001 - 05.2003 |PCD CONSTRUCTION COMPANY

• Performed installation and maintenance of software and network set-up, hardware and software troubleshooting. • Administered users’ computer and network requirements providing all necessary service and consulting.

Educational background

Automated Control Systems and Computer Software

Till 2006

Tomsk State University of Control Systems and Radioelectronics,

Languages

EnglishAdvancedKazakhNativeRussianProficient