- Proactive Database Monitoring & Tuning: Monitor Oracle databases (IBS, Parus, infrastructure) to detect errors, analyze query performance, and eliminate bottlenecks in high-load transactional systems. - Performance Troubleshooting: Investigate and resolve complex database issues reported by developers, business users, or identified through monitoring alerts. - Backup & Recovery Validation: Ensure data integrity and disaster recovery readiness by monitoring and validating daily Oracle backup routines. - High Availability & Disaster Recovery: Configured and managed Oracle Data Guard for physical standby replication, ensuring business continuity and minimal data loss. - Incident & Problem Management: Handle L2/L3 incidents, perform root cause analysis, and implement long-term fixes to prevent recurrence. - Unix/Linux Administration: Maintain and tune AIX and Linux operating systems to ensure stability, security, and compliance with corporate policies. - Hardware Monitoring: Oversee IBM server infrastructure to proactively identify hardware failures and performance degradation. - Security & Compliance: Perform OS-level configuration and hardening to eliminate vulnerabilities and meet audit requirements.

1. PostgreSQL Database Administration (projects for a meat processing plant and a contact center): - Greenfield implementation: Deployed PostgreSQL from scratch in production environments. - Performance tuning & analysis: Used pg_stat_statements and query analysis to identify bottlenecks, optimize indexes, and reduce query execution time. - Automation with Ansible: Wrote playbooks to automate PostgreSQL installation, Patroni cluster configuration, and PgBouncer deployment. - High Availability: Designed and managed Patroni clusters with etcd to ensure automatic failover, minimal downtime, and cluster consistency. - Connection pooling: Implemented PgBouncer to manage database connections efficiently and prevent resource exhaustion under high load. - Backup & Disaster Recovery: Implemented and tested backup strategies to guarantee data recoverability. - Observability: Built monitoring dashboards using Grafana and Prometheus for real-time performance insights. 2. Website maintenance & support 3. Automation system implementation (for a technological equipment factory) 4. Development (Parus platform)

- Core Financial Systems: Full-cycle administration of Oracle E-Business Suite R12 (Financial modules) in a high-frequency trading environment. - Middleware & Security: Comprehensive management of the Oracle middleware stack, including WebLogic, OAM (Oracle Access Manager), and SSO, ensuring secure access to financial data and applications. - Change Management & Patching: Strict adherence to change management policies for applying patches and performing zero-downtime or low-impact cloning of applications and databases. - BI & Reporting: Administration of MicroStrategy BI platform, ensuring timely and accurate delivery of financial reports to traders and analysts. - Performance Optimization: Deep-level performance tuning of Oracle databases to handle extreme transactional loads typical for a stock exchange.

1. Leadership & Architecture: - Team & Developer Management: Coordinated work with developers, defined technical requirements and problem statements for programming team. - Information Systems Deployment: Managed full lifecycle deployment of enterprise information systems across development, test, and production environments. - Solution Architecture: Participated in architectural decisions for Oracle EBS infrastructure, migration strategies, and system integrations. 2. Oracle E-Business Suite R11 Administration: - Environment Management: Maintained and cloned Oracle EBS application and database environments (Production, Test, Development). - Deployment & Customizations: Installed and integrated in-house developments; managed application of patches and updates. - Performance Monitoring: Monitored system health and resolved performance issues at the application tier. - Workflow & Security: Administered Oracle Workflow; implemented EBS security policies and user access controls. 3. Oracle EBS R11 to R12 Migration: - Migration Project: Performed full-cycle migration from EBS R11 to R12, including fresh R12 installation and schema migration. - Post-Migration Support: Applied system patches, cloned the new instance, and administered WebLogic server for R12. 4. Oracle Database Administration: - Backup & Recovery: Implemented backup strategies using RMAN and OS-level scripts. - High Availability & Disaster Recovery: Configured and managed Oracle Data Guard for physical standby replication, ensuring business continuity and minimal data loss. - Performance Tuning: Analyzed and tuned complex queries; resolved database-level performance issues. - Security: Implemented database-level security controls and user action auditing. - Scripting & Development: Wrote custom SQL scripts for various business and administrative needs. - Vendor Support: Created and managed Service Requests (SRs) with Oracle Support. 5. SAP BusinessObjects Administration: - Implementation: Installed SAP BusinessObjects BI Edge platform 4.0 from scratch. - Upgrades: Successfully upgraded the system to version 4.1 SP5. - Platform Management: Configured and managed nodes, service categories, and servers in CMC (Central Management Console). - Licensing & Deployment: Managed license acquisition via SAP support portal; published dashboards to BI portal; configured Crystal Reports 2013. 6. Additional Responsibilities & Infrastructure: - System Administration: Managed Linux Red Hat and Windows Server environments; implemented OS-level security; scheduled tasks with crontab. - Monitoring: Administered Zabbix monitoring system for proactive alerting. - Middleware & Web: Tuned OC4J; administered Apache Web Server with PHP and MySQL; installed Subversion for version control. - Database Technologies: Installed Oracle APEX; performed basic MongoDB administration. - Storage & Virtualization: Participated in EMC VNX5300 storage testing; created virtual environments using Oracle VirtualBox.

- Administration of BMC Service Desk Express (Magic) system; - Collaboration with other analysts, vendors, and business owners during application testing; - Troubleshooting and issue resolution within the ESP (Effective Support Process) team, serving as the last line of support; - Collaboration with colleagues from China and Brazil to ensure 24x7 uninterrupted operation of BMC SDE and other IT services; - Active participation in team meetings and conferences; - Implementation of ITSM processes through joint efforts of Mars IT teams and InfraVision vendor specialists; - Authoring and maintaining documentation describing the lifecycle of ITSM processes, focusing on critical areas such as Problem Management, Incident & Critical Incident Management, and Change Management; - Workload distribution and responsibility allocation among team members.

- Oracle EBS Administration: Full-cycle support of Oracle E-Business Suite (server & client side), including Discoverer, cloning (full/upgrade), patching, and maintenance using adadmin utilities. - Database Administration: Managed corporate Oracle databases — performance tuning (trace/tkprof, stats gathering), backups, password rotation, and cross-platform migration (Solaris ↔ Linux). - OS & Infrastructure: Administered Linux and Solaris systems, Sun hardware, Samba, and network configuration; handled integration with third-party applications. - Technical Support & Automation: Consulted developers and users, resolved performance issues across OS/DB/app tiers, wrote Perl/SQL scripts for automation, and worked with Oracle Metalink (SRs). - Collaboration: Intensive cross-functional teamwork and collaboration in a dynamic enterprise environment.

- Full-cycle administration: Installed, configured, and maintained Oracle JD Edwards EnterpriseOne, including Application Server and underlying Oracle databases. - User support: Provided technical assistance to clients, troubleshooting issues and ensuring smooth platform operation. - Vendor management: Collaborated with Oracle Support via Service Requests (SRs) to resolve complex technical problems.

- Database Administration: Configured and maintained databases, including standby database management, backup/recovery strategies, and performance tuning. - Data Management: Performed data migration and SQL optimization to ensure efficient data processing and integrity. - Development: Developed and maintained applications using Delphi and wrote complex PL/SQL scripts for business logic and automation. - Technical Support: Installed and configured software; resolved client issues and provided end-to-end technical assistance.

- Information System Development: Designed and built a faculty management information system from the ground up. - Database Administration: Created and administered sample Oracle databases for educational purposes; handled Oracle network configuration and database-level security. - Development: Programmed application logic in Delphi and developed database procedures using PL/SQL. - Teaching: Conducted classes and provided practical instruction to students.