Profileimage by Jack Torres TECHNOLOGICAL INFRASTRUCTURE | DATABASE | IT | BI | BIG DATA | DATA SCIENCE | D.B.A. | OPEN CLOUD from Lima

Jack Torres

available

Last update: 06.09.2022

TECHNOLOGICAL INFRASTRUCTURE | DATABASE | IT | BI | BIG DATA | DATA SCIENCE | D.B.A. | OPEN CLOUD

Graduation: Industrial and Systems Engineer
Hourly-/Daily rates: show
Languages: English (Limited professional) | Spanish (Native or Bilingual)

Attachments

CV_JackTorresCaceres_EN2022.pdf

Skills

Technical Skills:

Programming
  • Python: 3.0
  • MS-Visual Basic: .Net, 6.0
  • Java: 2.0
  • PHP: 5.0, 4.0
  • HTML: 5.0, 4.0
  • Power Builder: 9.0
  • JavaScript: 2.0
  • PL/Sql
  • T-SQL
Systems:
  • AIX: 6.0, 7.0
  • HP-UX
  • Linux: Debian 4.0, Oracle Linux 5.0, RedHat 6.0
  • Windows Server: 2019, 2016, 2012, 2008, 2003
  • AS/400
Databases
  • SQL Server: 2019, 2016, 2012, 2008, 2005, 2000
  • Azure Databases
  • CosmoDB
  • Oracle: 19c, 12c, 11g, 10g
  • Mongo DB
  • DB2: 9.0
  • MySQL: 8.0, 5.0, 4.0
  • Postgresql: 9.0, 8.0
  • MS Access: 365, 2016, 2010, 2007
Databases tools
  • Sql Server Management Studio, SQL Profile, Toad.
  • Toad, Plsql Developer, AWR Reports, Sql Developer, SqlPlus, Datapump, Dataguard, Rman
  • Portal Azure, Azure Datamanagement
  • Navicat, PhpMyAdmin, Workbench
  • Squirrel, iSeries Navigator, IBM Data Server Manager
Design
  • Macromedia 8
  • UML 2.0
  • Bootstrap 3
  • Stylus
  • Jade
  • CSS: 3.0, 2.0
Soft Skills:
  • Problem solving.
  • Flexibility.
  • Creativity.
  • The capacity for abstraction and critical thinking.
  • Self-management.
  • Teamwork.
  • Communication.
Modeling:
  • Power BI
  • Tableau
  • Erwin 4.0
  • Toad Modeler
  • Argo UML
  • Lucidchart
  • Draw.io

Project history

09/2021 - Present
System Database Administrator (Remote)
Kyndryl (Banks and financial services, >10.000 employees)

Database infrastructure management. Analysis and attention to incidents and / or problems. Installation of database software. Coding, programming and execution of scripts, SQL, maintenance, index reconstruction, database optimization. Extraction and insertion of data for the BI area. Automatized repetitive tasks, test Backup/Restore. Skills: Oracle, SQL Server (2005-2019), SQL Azure, DB2, MySQL, Maria DB, Postgresql, MongoDB, SSMS, PL/SQL, T/SQL, SQL, Shell scripts. Linux, Windows Server, AIX, Unix, Cron. BMC REMEDY, Jira, Sharepoint, One note.

10/2020 - 08/2021
System Database Administrator
IBM (5000-10.000 employees)

Database infrastructure management. Analysis and attention to incidents and / or problems. Installation of database software. Coding, programming and execution of scripts, SQL, maintenance, index reconstruction, database optimization. Extraction and insertion of data for the BI area. Automatized repetitive tasks, test Backup/Restore. Skills: Oracle, SQL Server (2005-2019), SQL Azure, DB2, MySQL, Maria DB, Postgresql, MongoDB, SSMS, PL/SQL, T/SQL, SQL, Shell scripts. Linux, Windows Server, AIX, Unix, Cron. BMC REMEDY, Jira, Sharepoint, One note.

03/2019 - 09/2020
Infrastructure System Engineer (Remote)
Everis Peru (Telecommunications, 1000-5000 employees)

Manage and deploy database software. Generate reports on demand. Database maintenance, reporting and suggesting query improvements. Attention to work orders and management, analysis and attention to incidents and / or problems. Coding, programming and execution of Shell, SQL Scripts. Participate inBigData and OpenCloud projects. 24x7 support. Skills: Oracle 10g to 12c, Informix 11.x, PostgreSQL, MySQL 5.x, MariaDB 10.x, SQL Server (2000-2018). Linux, Unix. Haddop, Hive, MSMS 2019, Toad for Oracle 13, SQL Developer 13, Workbench, PgAdmin 4.

06/2017 - 03/2019
Systems Consultant (Remote)
Experis ManpowerGroup (Telecommunications, 1000-5000 employees)

Lead Executing Engineers. Manage, Maintain and Tune databases. Review and execute changes. Provide 7x24 support. Attention to work orders and management, analysis and attention to incidents and / or problems. Achievements: Create and/or configure new DB instances. Manage data storage structure and user management. Adjust parameters to improve database performance. Execute queries and scripts for the applicant area, report failures to the development analyst in charge. Verify and schedule tasks. Perform troubleshooting tasks. Other designated functions. Skills: Oracle 10g to 12c, PL/SQL, Queries, Crontab, Linux and Unix.

08/2016 - 05/2017
IT Consultant
SOA Professionals (Telecommunications, 10-50 employees)

Manage databases. Tune databases. Review and execute database changes. Sopporte 24x7. Achievements: Participate in projects: OAC. Install Database Engine, create instances, configure infrastructure, storage, and user management. Install software. Create stored procedures and monitoring Job schedules. Fine-tune querys, and database performance parameters. Execute scripts, manage development failures. Perform troubleshooting tasks. Other designated functions. Skills: Oracle 10g to 12c, Oracle client 12c, Unix, Linux, Cron, PL/SQL, Shell scripts.

09/2014 - 03/2016
IT Consultant
Background IT (Internet and Information Technology, 10-50 employees)

Manage and maintain databases. Migration of the Serveris. Automate debugging tasks and alerts. Code review - MUNDOCI project. Extraction and insertion of data for the BI area. Migrate databases. Clone databases. Optimize queries, adjust performance parameters. Review and execution of changes, manage errors. Revision and improvement of ETLs. Skills: Oracle 10g, SQL Server 2012 and MySQL 5, PL/SQL, T-SQL, Shell Script, Oracle Linux 6, MSSQL 2014, Toad 9. Power i7/i8 AS400. Systems Xhis, Ofisis and Preventiva.

01/2012 - 12/2014
Freelance Programmer Analyst (Remote)
APLUS2 SAC (Other, 10-50 employees)

Manage, develop and implement custom web solutions, including the analysis, design, modeling and implementation of the database. Clients: Mega Ramirez, Mi Richard, Victory Inca Petroleum and A&Q General Contractors. Achievements: App good construction practices, custom SW Open Source, client budgets module, image gallery, content management module of the institutional portal. Skills: SQL, Erwin, XHTML, HTML5, Javascript, CSS, DHTML, PHP, MySQL, WordPress, Joomla, Moodle, Media Wiki, ActionScript, ASPX.

08/2007 - 09/2014
Systems Assistant – Production
CMAC PIURA (Banks and financial services, 1000-5000 employees)

Manage systems and database. Sremote support. Execution and monitoring of Bath processes. Generate reports and development of queries. Research and implementation of Open Source and Knowledge Management Software. Operational troubleshooting. Requirements management. Orafter assigned functions. Skills: DB2, SQL Server, MySQL, PostgreSQL, Glassfish, Tomcat, Apache, PHP, Java, RPG Idle, Visual basic, Visual Fox, Linux. SIAF, SGCRED (Credit Management System), Glassfish, Moodle, Media Wiki. Operating Systems (Red Hat, AS/400, Windows Server)

Local Availability

Only available in these countries: Peru
  • Travel availability
  • Freelance

Other

Industrial and Systems Engineer, with experience in database and server administration. Knowledge in analysis, design, development and implementation of systems and applications. Experience providing remote support at the software level. Implementation of IT projects, update and migration of servers. Skills: Systems analyst, designer and programmer. Mastery of web and desktop languages. Mastery of design and illustration software. Modification and creation of templates of open source systems, installation of CMS-type Open source software.
Profileimage by Jack Torres TECHNOLOGICAL INFRASTRUCTURE | DATABASE | IT | BI | BIG DATA | DATA SCIENCE | D.B.A. | OPEN CLOUD from Lima TECHNOLOGICAL INFRASTRUCTURE | DATABASE | IT | BI | BIG DATA | DATA SCIENCE | D.B.A. | OPEN CLOUD
Register