Alfonso Olivares Ortiz currently serves as a Junior Database Administrator (DBA) at SuKarne, where he plays a pivotal role in managing and optimizing the company's database systems. His expertise encompasses a wide range of database administration tasks, particularly focusing on SQL Server and Oracle databases....
Alfonso Olivares Ortiz currently serves as a Junior Database Administrator (DBA) at SuKarne, where he plays a pivotal role in managing and optimizing the company's database systems. His expertise encompasses a wide range of database administration tasks, particularly focusing on SQL Server and Oracle databases. Alfonso is responsible for administering SQL Server databases across all points of sale, ensuring that data integrity and availability are maintained at all times. His proficiency in SQL allows him to create and modify database objects efficiently, which is crucial for supporting the dynamic needs of the business.
In addition to his SQL Server responsibilities, Alfonso manages the ORACLE-Dev database, where he employs advanced tools such as the Data Pump (Expdp/Impdp) for data export and import operations. He is adept at troubleshooting Oracle-related issues, routinely checking alert log files for ORA errors and utilizing the DBMS_SQLTUNE package to optimize SQL queries for improved performance. His commitment to database health is evident through his use of the DBMS_ADDM package, which helps identify performance bottlenecks and ensures that the databases operate at peak efficiency.
Alfonso's skill set extends beyond technical capabilities; he is also proficient in customer service and project management, which enhances his ability to collaborate effectively with cross-functional teams. His fluency in English further enables him to communicate seamlessly in diverse environments. As SuKarne continues to expand its operations, Alfonso's contributions as a Junior DBA are integral to the company's strategic planning and overall success in the competitive food industry.
