Patrick Jurgensen De Mello

Experience

• 

  IBM Global Business Services

  Jan 2011 - Aug 2021

  Oracle Database Administrator

  As an Oracle Database Administrator with over 10 years of experience at IBM, I have cultivated my expertise in the meticulous management and optimization of databases across diverse platforms such as Unix (HP-UX, SunOS, IBM AIX), Linux, and Windows. Commencing my journey in the test environment, I supported over 500 databases before progressing to the Production team, where I assumed the pivotal role of overseeing mission-critical databases as the primary contact.My role included:-Configuring Oracle Databases (10g, 11g, 12c) on various OS.-Routine DBA tasks: user auditing, lock monitoring, session identification, rollback management, tablespace, partitioning, performance optimization, and cross-server data migration.-Tuning databases: SGA optimization, I/O balancing, memory management, index creation, analysis, AWR, ASH, ADDM reports, SQL tuning, SecureFile feature, and BasicFile to SecureFile conversion.-Backup/restore routines via RMAN (full, incremental) and logical data loads/backups using IMP/EXP, Import/Export (DataPump).-Managing structures: tablespaces, datafiles, online redo-log files, control files, and archived log files.Automating DBA tasks with crontab jobs, SQL, PL/SQL scripts.-Daily troubleshooting and reporting.-Installing Oracle patches, collaborating with SA team for OS patches.-Administering users: creating, granting privileges, cloning, managing roles, password resets, and defining profiles.-Supporting code deployments: tables, stored procedures, views, sequences, functions, packages, triggers.-Proficient in Real Application Cluster (RAC) architecture.-Expert in Automatic Storage Management (ASM).-Knowledgeable in Oracle Timesten configuration, management, and support.-Proficient in Oracle GoldenGate replication (11g, 12c) Show less

• 

  Edenred

  Aug 2021 - Aug 2022

  Senior Oracle Database Administrator

  After a decade of enriching experience at IBM, I embarked on an exciting new chapter as an Oracle Sr DBA at Edenred, a company that fostered my growth and challenged me to expand my skillset. I embraced the responsibilities and duties associated with managing databases hosted in Azure Cloud servers, a testament to my adaptability and willingness to tackle new frontiers.

• 

  Timestamp

  Sept 2022 - now

  Senior Consultant I

  Passionate and results-driven Oracle Senior Consultant with a proven track record of supporting critical databases for high-profile clients in the banking sector.Currently working as the primary contact for Kyndryl on projects involving more than 400 databases across production, development, and testing environments for two major banking clients.Within 6-7 months of joining Timestamp and designating to Kyndryl, I was transitioned from frontline support to manage critical projects with demanding service-level agreements (SLAs), consistently delivering results within record time.Recognized for consistently going above and beyond to resolve complex technical issues, ensuring the smooth operation of mission-critical databases.Adept at mentoring and guiding junior team members, fostering a collaborative and high-performing environment.Passionate about staying at the forefront of Oracle technology and continuously developing my skills to deliver exceptional value to clients. Show less