Jorge Castilla Andres available

Jorge Castilla Andres

SAP Basis Administrator and DBA Oracle

available
Profileimage by Jorge CastillaAndres SAP Basis Administrator and DBA Oracle from
  • Freelancer in
  • Graduation: Telecommunications Engineer
  • Hourly-/Daily rates: not provided
    I always have worked contracted by a company
  • Languages: English (business fluent) | French (good) | Spanish (first language)
  • Last update: 09.04.2017
KEYWORDS
ATTACHMENTS
Curriculum Vitae English
The download of this file requires a paid membership.
SKILLS

Formal Training
  ·Technical Engineering in Telecommunications (Speciality in Electronic devices)  U.P.C (completion year 1998).
  ·Certification in ITIL FOUNDATION (INFORMATION TECHNOLOGY INFRAESTRUCTURE LIBRARY) in GEDAS (October 2005).
 
Professional Experience
February 2017 – Nowadays– SAP Basis Administrator (ERP) y DBA Oracle in Consorcio Hospitalario.

  • Sap: Transports, Messages , Extend Sap Tablespace, Dumps, Archivelogs.
  • Oracle: Extend Tablespaces, Unblock users, archivelogs, backups.
  • Middleware: Deploying applications.
  • Systems: Administration Windows / Linux / LDAP.
 
Novembre 2016 – January 2017– SAP Basis Administrator in English for Ireland
  • Apply SAP notes.
  • Dumps, logs analasys
  • Configuration Workflow, SOAMANAGER, parameters, scot.
  • Create and modify Roles, users and Authorizations
  • Scheduler Backup BBDD and archivelog with db13 and brtools.
  • Create, analise, modification Jobs, RFC’s.
  • Create and modify SAP printers.
 
April 2016 – October 2016– Oracle DBA Oracle for CTTI – Generalitat Catalunya
Tasks: Administration and resolution of incidents in Oracle 12c y 11g DDBB’s
  • Oracle 12c y 11g: Patched, deployment, management, resolution of incidents and requests Ongoing Department of Oracle Database 12c with OFA and multi-tenant architecture, production environments, pre-production and development for CTTI (Generalitat). Single Instance and RAC
  • Participation in implementing new changes in Oracle databases 12c and 11g
  • Systems: Resolution of incidences of level 1 Red Hat and Windows.
  • MSSQL Server: Installing Service Pack\'s.
  • Infrastructure consisting of: (Oracle 12c, 11g, Grid Infrastucture 12c, ASM, RAC, Red Hat Linux, Windows, Enterprise Manager Cloud Control 12c)
 
October 2015 – March 2016 – Technician Application Server (AGBAR - UPC)
Tasks: Install and configure the following software:
  • OpenLDAD, GADS : Installation and configuration.
  • Weblogic, OBIEE: Configure HA, Scale Out.
  • Tomcat, Ngix,Qlik, node: Install aplications.
  • MySQL y Postgress: Dumps, Export / Import y configuration.
  • Install LAMP servers.
  • Create Docker machines, Google Cloud (PaaS and Iass)
 
May 2015 - October 2015 – DBA ORACLE (PIMEC – Petita i mitjana empresa CAT)
Tasks: My tasks were:
  • Dumps Analysis, logs, block and errors updates.
  • Doing Oracle, Sql Server tunings.
  • Resolve Oracle and SQL Server incidents. (With sqlplus Create schemas, tablespaces, grants, reviwe DB logs and listener, application logs, exports/exportdp, Do imports/importdp, apply patchs with adpatch, apply .sql files.
  • Work in Producción, Preproducción, Test y Dev enviroments, ebussiness (Basic knolodgment)
  • Resolution DB incidents 2nd level.
 
September 2013 until March 2015 - Administrador SAP BASIS (AGBAR)
Functions: My tasks were:
  • Homogeneous Copies, Refresh, Upgrade Add-ons, Uso R3Trans.
  • Apply SAP notes.
  • Client Copies, Export / Import Client.
  • Dumps Analise, logs, block and update errors.
  • Analysis workload monitor transactions.
  • Workflow Configuration, SOAMANAGER, parámeters, scot.
  •  icm and java stack restart, Gateway, instancias.
·         Create and modify Authorizations and roles, mass blockades
  • Planify DB Backup Calendar and archivelog archivelog with db13 y brtools.
  • Create, analise, modify Jobs, RFC’s, Events, external comands.
·         Creation, management , SAP printers permissions
  • Transport mistakes, release orders.
·         Idocs reprocessing, RFC Transaccionals.
·         Register Objects , Developers , Open Connection SAP MarketPlace
  • Oracle: Tablespaces expansión, index rebuild and tables blocks-
  • AIX: Scripts, permissions, users
  • Windows: Cluster Windows.
  • Installation, configuration and administration of servers LAMP (Linux, Apache, PHP, MySQL).
  • Support in installations for development department.        
 
Company: ADASA SISTEMAS SAU (November 2007 until July 2013)
Professional Category: Administrator UNIX/LINUX and Oracle DBA in costumers like ACA, AGBAR, Ruralcat.
Functions: Administration of environments:
  • Oracle8i, 9i, 10g, 11g, RAC Oracle y ASM: DB Installations, Creation Physical/StandbyDB, tablespace reduced space, Datafile Creation Datafile, Tablespace expansion, DB filesystems migration, Tnsnames, Listener, UNDO and TEMP tablespace expansion, Creation of users, Export/Import schemes, Dblinks, Start/Stop DB Scripts, Rman Backup and DB recover, Archivelog Mode, Creation of Synonyms.
  • Cluster Veritas: Activated/deactivated Resources, Volumes Migration, Scripts, Installation of patches.
  • Sun Solaris and HP/UX: Volumes Expansion, Patches Installation and applications, Installation of FO libraries, Backups Boot y Ignites, NFS, Scripts, SAN Volumes Format, IP Change, Administration in General.
  • Nagios y Pandora: Administration and Scripting
  • Apache, Tomcat, JBoss, Weblogic, MYSQL: Application Deployment, Configuration
  • Systems: Config. ILO, SAN Volumes Creation, Start/Stop  CPD.
  • Business Object: Configuration ODBC INFORMIX, Report Creation, Services.
  • Windows: Permissions, Server Installation, Users, Timings, FTP, IIS.
 
Company: HOSPITAL CLINIC (July 2005 until November 2007)
Professional Category: Technical Systems in Hospital Clínic.
Functions: System Administration in IBM BLADES in environments:
  • Coordination and Administration of Installation Project, virtualization, Backup and monitoring 16 servers IBM HS21 with VMWARE ESX, Cluster Supercomputacional with OpenMosix y SAN IBM DS4300.
  • Administration LINUX SUSE, Ubuntu, Red Hat, (scripts, Apache, Tomcat, JBOSS, MYSQL, DNS, FTP) .
  • Administration NetBackup Veritas (Policies, Recoveries).
  • Administration UNIX-SOLARIS (NFS, DNS, Spool, Apache, Tomcat, Samba).
  • Administration MS SQL y Windows 2003 (Creationn DB, Export, Import)
  • Administration SAP Operation level (Operate printers, Managed of Jobs, Tablespace Expantion, Datafiles Creation).
  • Administration Oracle (EMC, NetManager, RMAN, Backups, ArchiveLogs, export, import).

 
Company: HEWLETT-PACKARD (From September 2002 until July2005).
Professional Category: Systems Technician
Functions: Belonging to IT department. Administration servers W2000.(Active Directory, DNS, WINS, DHCP, etc…) Installation and Troubleshooting in environments W2000, WNT, WXP, AD and user support in English. Installation of Ofimatic applications, SAP, Oracle, ODBC, Brio,…Use Managed tools and remote desktop: Remedy, BLT, ATM, PCanywhere, remote desktop. Use Ghost image, ERD, Partition Magic. Installation of applications to create VPN from desktops to HP. Platform 2000 users and 75 servers more or less.
 
Company:  WINTERTHUR SEGUROS (From July 2000 until July 2002)
Professional Category: Systems Engineer in Nt Systems Engineering
Functions: Domain Administration about 250 servers in Windows NT and Windows 2000 (Web servers,  proxy, printers, applications, Exchange, SNA, etc..). Resolution of 3rd level incidents, automation of process in servers NT/2000. Configuration Windows in servers which functions like PDC, BDC or independent servers. Also AD, DHCP, DNS, Wins, Raid, Cluster, Access rights, Profiles, IIS, ISA etc..
 
Company: AZERTIA (From January  1999 until July 2000)
Professional Category: Systems Technician
Functions: Users Support. Configuration of desktop and laptops in network in Windows. Users Administration of AZERTIA domain.
 
Additional Training
 
May 2015 – MySQL Introduction en Cibernàrium de Barcelona Activa
Course 60 hours Linux Advanced Administration in fomento del trabajo. (March 2007).
            Course  60 hours Oracle 10G Database Administration in fomento del trabajo. (December 2006).
Course 60 hours Oracle 9i Database Administration in fomento del trabajo. (December 2006).
            Course 475 hours Internet/Intranet/Extranet Administration in Windows 2000, Linux/Unix, Novell in Bit Informática. (October 2002).
Course 30 hours Support Windows NT Core Technologies in New Horizons. (November 2001).
Course 30 hours Support Windows NT Enterprise Technologies in New Horizons. (November 2001).
 
Languages
   Catalan: Spoken and written. (C Level)
               English: Spoken and written. (5º E.O.I, courses of conversation and phonetic)
               French: Spoken and written.
 
Computer and Communication
OS:Windows NT/2000/XP/2003, Unix, Novell, Linux.
Administration Tools: BladeLogic, VMWARE, Collation Confignia, PlateSpin, Cohesion de Cendura, Altiris.

REFERENCES

Formal Training
  ·Technical Engineering in Telecommunications (Speciality in Electronic devices)  U.P.C (completion year 1998).
  ·Certification in ITIL FOUNDATION (INFORMATION TECHNOLOGY INFRAESTRUCTURE LIBRARY) in GEDAS (October 2005).
 
Professional Experience
February 2017 – Nowadays– SAP Basis Administrator (ERP) y DBA Oracle in Consorcio Hospitalario.

  • Sap: Transports, Messages , Extend Sap Tablespace, Dumps, Archivelogs.
  • Oracle: Extend Tablespaces, Unblock users, archivelogs, backups.
  • Middleware: Deploying applications.
  • Systems: Administration Windows / Linux / LDAP.
 
Novembre 2016 – January 2017– SAP Basis Administrator in English for Ireland
  • Apply SAP notes.
  • Dumps, logs analasys
  • Configuration Workflow, SOAMANAGER, parameters, scot.
  • Create and modify Roles, users and Authorizations
  • Scheduler Backup BBDD and archivelog with db13 and brtools.
  • Create, analise, modification Jobs, RFC’s.
  • Create and modify SAP printers.
 
April 2016 – October 2016– Oracle DBA Oracle for CTTI – Generalitat Catalunya
Tasks: Administration and resolution of incidents in Oracle 12c y 11g DDBB’s
  • Oracle 12c y 11g: Patched, deployment, management, resolution of incidents and requests Ongoing Department of Oracle Database 12c with OFA and multi-tenant architecture, production environments, pre-production and development for CTTI (Generalitat). Single Instance and RAC
  • Participation in implementing new changes in Oracle databases 12c and 11g
  • Systems: Resolution of incidences of level 1 Red Hat and Windows.
  • MSSQL Server: Installing Service Pack's.
  • Infrastructure consisting of: (Oracle 12c, 11g, Grid Infrastucture 12c, ASM, RAC, Red Hat Linux, Windows, Enterprise Manager Cloud Control 12c)
 
October 2015 – March 2016 – Technician Application Server (AGBAR - UPC)
Tasks: Install and configure the following software:
  • OpenLDAD, GADS : Installation and configuration.
  • Weblogic, OBIEE: Configure HA, Scale Out.
  • Tomcat, Ngix,Qlik, node: Install aplications.
  • MySQL y Postgress: Dumps, Export / Import y configuration.
  • Install LAMP servers.
  • Create Docker machines, Google Cloud (PaaS and Iass)
 
May 2015 - October 2015 – DBA ORACLE (PIMEC – Petita i mitjana empresa CAT)
Tasks: My tasks were:
  • Dumps Analysis, logs, block and errors updates.
  • Doing Oracle, Sql Server tunings.
  • Resolve Oracle and SQL Server incidents. (With sqlplus Create schemas, tablespaces, grants, reviwe DB logs and listener, application logs, exports/exportdp, Do imports/importdp, apply patchs with adpatch, apply .sql files.
  • Work in Producción, Preproducción, Test y Dev enviroments, ebussiness (Basic knolodgment)
  • Resolution DB incidents 2nd level.
 
September 2013 until March 2015 - Administrador SAP BASIS (AGBAR)
Functions: My tasks were:
  • Homogeneous Copies, Refresh, Upgrade Add-ons, Uso R3Trans.
  • Apply SAP notes.
  • Client Copies, Export / Import Client.
  • Dumps Analise, logs, block and update errors.
  • Analysis workload monitor transactions.
  • Workflow Configuration, SOAMANAGER, parámeters, scot.
  •  icm and java stack restart, Gateway, instancias.
·         Create and modify Authorizations and roles, mass blockades
  • Planify DB Backup Calendar and archivelog archivelog with db13 y brtools.
  • Create, analise, modify Jobs, RFC’s, Events, external comands.
·         Creation, management , SAP printers permissions
  • Transport mistakes, release orders.
·         Idocs reprocessing, RFC Transaccionals.
·         Register Objects , Developers , Open Connection SAP MarketPlace
  • Oracle: Tablespaces expansión, index rebuild and tables blocks-
  • AIX: Scripts, permissions, users
  • Windows: Cluster Windows.
  • Installation, configuration and administration of servers LAMP (Linux, Apache, PHP, MySQL).
  • Support in installations for development department.        
 
Company: ADASA SISTEMAS SAU (November 2007 until July 2013)
Professional Category: Administrator UNIX/LINUX and Oracle DBA in costumers like ACA, AGBAR, Ruralcat.
Functions: Administration of environments:
  • Oracle8i, 9i, 10g, 11g, RAC Oracle y ASM: DB Installations, Creation Physical/StandbyDB, tablespace reduced space, Datafile Creation Datafile, Tablespace expansion, DB filesystems migration, Tnsnames, Listener, UNDO and TEMP tablespace expansion, Creation of users, Export/Import schemes, Dblinks, Start/Stop DB Scripts, Rman Backup and DB recover, Archivelog Mode, Creation of Synonyms.
  • Cluster Veritas: Activated/deactivated Resources, Volumes Migration, Scripts, Installation of patches.
  • Sun Solaris and HP/UX: Volumes Expansion, Patches Installation and applications, Installation of FO libraries, Backups Boot y Ignites, NFS, Scripts, SAN Volumes Format, IP Change, Administration in General.
  • Nagios y Pandora: Administration and Scripting
  • Apache, Tomcat, JBoss, Weblogic, MYSQL: Application Deployment, Configuration
  • Systems: Config. ILO, SAN Volumes Creation, Start/Stop  CPD.
  • Business Object: Configuration ODBC INFORMIX, Report Creation, Services.
  • Windows: Permissions, Server Installation, Users, Timings, FTP, IIS.
 
Company: HOSPITAL CLINIC (July 2005 until November 2007)
Professional Category: Technical Systems in Hospital Clínic.
Functions: System Administration in IBM BLADES in environments:
  • Coordination and Administration of Installation Project, virtualization, Backup and monitoring 16 servers IBM HS21 with VMWARE ESX, Cluster Supercomputacional with OpenMosix y SAN IBM DS4300.
  • Administration LINUX SUSE, Ubuntu, Red Hat, (scripts, Apache, Tomcat, JBOSS, MYSQL, DNS, FTP) .
  • Administration NetBackup Veritas (Policies, Recoveries).
  • Administration UNIX-SOLARIS (NFS, DNS, Spool, Apache, Tomcat, Samba).
  • Administration MS SQL y Windows 2003 (Creationn DB, Export, Import)
  • Administration SAP Operation level (Operate printers, Managed of Jobs, Tablespace Expantion, Datafiles Creation).
  • Administration Oracle (EMC, NetManager, RMAN, Backups, ArchiveLogs, export, import).

 
Company: HEWLETT-PACKARD (From September 2002 until July2005).
Professional Category: Systems Technician
Functions: Belonging to IT department. Administration servers W2000.(Active Directory, DNS, WINS, DHCP, etc…) Installation and Troubleshooting in environments W2000, WNT, WXP, AD and user support in English. Installation of Ofimatic applications, SAP, Oracle, ODBC, Brio,…Use Managed tools and remote desktop: Remedy, BLT, ATM, PCanywhere, remote desktop. Use Ghost image, ERD, Partition Magic. Installation of applications to create VPN from desktops to HP. Platform 2000 users and 75 servers more or less.
 
Company:  WINTERTHUR SEGUROS (From July 2000 until July 2002)
Professional Category: Systems Engineer in Nt Systems Engineering
Functions: Domain Administration about 250 servers in Windows NT and Windows 2000 (Web servers,  proxy, printers, applications, Exchange, SNA, etc..). Resolution of 3rd level incidents, automation of process in servers NT/2000. Configuration Windows in servers which functions like PDC, BDC or independent servers. Also AD, DHCP, DNS, Wins, Raid, Cluster, Access rights, Profiles, IIS, ISA etc..
 
Company: AZERTIA (From January  1999 until July 2000)
Professional Category: Systems Technician
Functions: Users Support. Configuration of desktop and laptops in network in Windows. Users Administration of AZERTIA domain.
 
Additional Training
 
May 2015 – MySQL Introduction en Cibernàrium de Barcelona Activa
Course 60 hours Linux Advanced Administration in fomento del trabajo. (March 2007).
            Course  60 hours Oracle 10G Database Administration in fomento del trabajo. (December 2006).
Course 60 hours Oracle 9i Database Administration in fomento del trabajo. (December 2006).
            Course 475 hours Internet/Intranet/Extranet Administration in Windows 2000, Linux/Unix, Novell in Bit Informática. (October 2002).
Course 30 hours Support Windows NT Core Technologies in New Horizons. (November 2001).
Course 30 hours Support Windows NT Enterprise Technologies in New Horizons. (November 2001).
 
Languages
   Catalan: Spoken and written. (C Level)
               English: Spoken and written. (5º E.O.I, courses of conversation and phonetic)
               French: Spoken and written.
 
Computer and Communication
OS:Windows NT/2000/XP/2003, Unix, Novell, Linux.
Administration Tools: BladeLogic, VMWARE, Collation Confignia, PlateSpin, Cohesion de Cendura, Altiris.

TIME AND SPATIAL FLEXIBILITY
Barcelona and sorround
OTHER
I could work by teleworking from my home to the rest of the world.
GET IN TOUCH

I accept the Conditions

I accept the terms of the privacy policy

Note: sending your contact request is free of charge