Database AdministrationPostgres, Oracle, Kafka+Debezium

Chief specialist (Smart Vista, WAY4) Smart Vista Payment System administration (Full stack: Front Office, Back-Office, Card generation, HSM Support, Fraud and Dispute Management, VISA-MasterCard-AMEX-UPI Certification) Oracle Database administration PL-SQL Development Migration acquiring and issuing from WAY4 to Smart Vista System

Payment System Implementation

IT director Planning and implementing projects (NSPK integration, VISA certification, UPI implementation, Master Card and etc.) Direct all information technology and network system deployment and maintenance including all IT infrastructure, wireless communications, PC systems, local networks and mobile environment Recruit, hire and train IT staff, project managers, engineer and network administrators Develop strategic direction for the information systems plan including technology deployment plans and departmental budgets Develop and maintain the infrastructure and IT systems Creating operational policies, procedures, standards, guidelines and best practicesPL-SQL Developer Created lots of Triggers for validation Creating lots of procedure, package, and functions Performance tuning of the SQL queries to improve data conversion process Perform Unit Testing, Integration Testing and Performance Testing Load the data from Excel file to oracle database Tune SQL queries and perform code debugging using TOAD Conducting Oracle database and SQL code tuning to improve performance of the application Develop Crystal Reports Develop custom reports that were formatted according to the user requirements Manage performance and tuning of SQL queries and fixing the slow running queries with utilities like Explain, Trace, and Stored OutlinesDatabase Administrator Create and deploy database continuity and redundancy plans including backup and recovery processes Standby Server management Deploy security protocols, profiles, passwords and privileges Install, patch and upgrade existing applications Controlling migrations of programs, database changes, reference data changes and menu changes through the development life cycle Problem solving with demonstrated success analyzing complex technical issues and rapidly finding solutions Creating and maintenance of all databases that are required for developm

Develop and enhance programs using Delphi 7.0, SQL code, contributing to solutionsthat streamlined processes, increased accuracy and lowered costs Enhance company reporting subsystem that provided new functionality to reportingfunctions that were previously unavailable Develop new procedures for requirements gathering, needs analysis, testing, scriptingand documentation to strengthen quality and functionality of business-criticalapplications using SQL code Retrieve and modify data within the system

Develop new and creative applications for the web-based aspects of the University Develop and program workflow of the University (created database and software) Automate Human resource management, accountant department, university’sschedule management and etc.