• Conducted SQL optimization to enhance database performance and efficiency.
• Provided support and maintenance for the backend of the retail platform, ensuring smooth operations and resolving issues promptly.
• Maintained and updated documentation to ensure accuracy, clarity, and alignment with current processes.
• Designed, implemented, and supported ETL processes utilizing Oracle Data Integrator for streamlined data integration and transformation.
• Ensured high availability and reliability of database systems through regular monitoring and proactive management.
• Collaborated with cross-functional teams to address technical challenges and contribute to system enhancements.

Technologies: Oracle DB, Oracle Data Integration. Webservices RESTFUL, SVN, Confluence, Jira.

• Implemented ETL processes using Databricks and PySpark, improving data integration and efficiency.
• Successfully implemented Azure Database, enhancing data storage and retrieval capabilities.
• Optimized and generated Stored Procedures (PL-SQL), Triggers, Functions, Indexes, Tablespaces, and Jobs, resulting in improved database performance and streamlined operations.
• Managed scheduled tasks within the database, ensuring timely execution and efficient resource allocation.
• Conducted performance tuning of the database, optimizing query execution and improving overall system performance.
• Implemented MetricStream Reports and Forms, enhancing data reporting and compliance processes.
• Maintained clear and concise documentation, facilitating ease of understanding and knowledge transfer among team members.

Technologies: SQL Server, Integration Services,JAVA, Webservices RESTFUL, Github, Jira, Confluence, Azure.

• Optimized and generated efficient stored procedures (PL-SQL), triggers, functions, indexes, tablespaces, and jobs, resulting in improved database performance and streamlined operations.
• Supported and integrated REST web services, ensuring seamless communication and data exchange between systems.
• Conducted performance tuning of the database, identifying and resolving bottlenecks to enhance overall system efficiency.
• Played a key role in the development and integration of a new application site and ERP system, contributing to increased productivity and improved business processes.
• Maintained clear and concise documentation, facilitating knowledge sharing and collaboration among team members.
• Consistently followed industry best practices and coding standards, ensuring the reliability and scalability of the database.
• Actively participated in code reviews and provided valuable feedback to enhance the quality of the codebase.

Technologies: SQL Server, Integration Services, C#, Webservices RESTFUL, Github, Jira, Confluence.

• Developed and maintained a robust REST API backend for MintWorks Digital online video game (Steam, Android, iOS)
• Supported the QA team in creating unit tests, ensuring the reliability and stability of the backend functionalities.
• Managed the migration and monitoring of the backend to different servers in the cloud, enhancing reliability and availability.
• Maintained clear and concise documentation, facilitating ease of understanding and seamless knowledge transfer between team members.
• Developed and executed Bash scripts for automation and system administration tasks.
• Ensured consistency and clarity in all technical communications, avoiding jargon and industry-specific terms.
• Diligently proofread all code and documentation, ensuring accuracy, professionalism, and error-free presentation.

Achievements:

• Successfully migrated the backend to Docker containers, resulting in improved service segmentation and scalability optimization, leading to a 35% performance improvement of supported applications within a span of 3 months.

Technologies: Python, Django - REST Framework, Websockets, Redis,
PostgreSQL, Ubuntu Linux, Docker, Github, Trello, Discord, Workplace,
Digital Ocean, Bash Scripting, Stoplight

• Provided development support for web and mobile applications, ensuring efficient and effective implementation of client requirements.
• Managed website administration tasks, including hosting, email servers, domain renewal and purchase, and SSL certificates, ensuring smooth and uninterrupted online presence for clients.
• Implemented applications for restaurant management, streamlining operations and improving efficiency for clients in the food service industry.
• Supported backend development for mobile applications, collaborating with cross-functional teams to deliver high-quality and user-friendly solutions.
• Consulted with clients to optimize their Inventory Database, providing valuable insights and recommendations for improved inventory management.
• Maintained clear and concise documentation of all projects and tasks, ensuring seamless knowledge transfer and effective collaboration with team members.
• Proactively sought opportunities for professional development, staying updated with the latest industry trends and technologies to provide the best possible solutions for clients.

Technologies: Javascript, Python, SQL Server, MySQL, Django REST
Framework, Bash Scripting, Cpanel, Hostgator.

• Analyzed and designed web systems, focusing on internal users and customers, utilizing .Net technologies (C#) to develop ERP and CRM solutions.
• Successfully migrated the database from Oracle DB to SQL Server, ensuring seamless data transfer and improved system performance.
• Designed and implemented processes for payment card management, streamlining operations and enhancing efficiency.
• Programmed and optimized stored procedures (PL-SQL), triggers, functions, indexes, tablespaces, and jobs, improving database performance and query execution time.
• Implemented ETL processes for daily data exchange with service providers (Carnet, Mastercard), ensuring accurate and timely information updates.
• Provided support for web development and integration of SOAP web services, ensuring smooth functionality and seamless integration with external systems.

Achievements:

• Achieved certification of Food Pantry Vouchers and Gasoline products before the SAT as authorized purses, through the successful implementation of required technical processes.

Technologies: SQL Server, Integration Services, Oracle DB, Javascript, ASP
.Net, C#, MySQL, Webservices SOAP.

• Monitored database performance and implemented lock-process detection and optimization techniques, ensuring smooth and efficient functioning of the system.
• Provided support for the development of Opam-Online web applications, including the management system for electronic wallets and in-house CRM.
• Managed scheduled tasks within the database, ensuring timely execution and efficient resource allocation.
• Implemented database backup and recovery procedures, safeguarding critical data and minimizing downtime in case of system failures.
• Debugged existing ETL processes and performed performance tuning to enhance data integration and processing efficiency.
• Utilized SQL-Loader for efficient loading of massive amounts of information into the database, improving data handling capabilities.
• Ensured data homologation between databases, maintaining consistency and accuracy in data across different systems.

Achivements:

• Optimized over 30 processes for the efficient handling of massive amounts of information, resulting in a significant time reduction of up to 95% in typical daily operations.

Technologies: Oracle DB, Java, Javascript, HTML, CSS, Tomcat, Toad for
Oracle, Netbeans, SVN, Oracle VirtualBox

Online education platform with more than 300 courses on technology,
marketing, entrepreneurship and personal growth.

Database Administrator Specialty