Lynn Pereira
DONCASTER,South Yorkshire
Summary
An Oracle Certified Professional DBA with over 15 years experience in administration & support of Oracle databases (8i - 19c) as well as SAP R/3 & Oracle Apps 11i, eager to leverage technical skills in cloud-based database systems.
Expertise in numerous leading Oracle technologies, coupled with a demonstrated ability to promptly master new and evolving technologies
Goal oriented and dedicated with strong problem resolution & communication skills working effectively in collaborative and self-motivated environments
Overview
24
24
years of professional experience
Work history
Senior Oracle DBA
Close Brothers Ltd.
10.2014 - 09.2023
- Supporting a landscape of 400+ non-production and 50 production database environments
- Installation & upgrades of Oracle databases from 10g through to 19c using multitenant & non mulitenant architecture along with the implementation of Oracle RAC, RAC One Node & ASM
- Techinical lead for the migration of databases from VMWare to Oracle Exadata and more recently to Oracle Cloud Infrastructure (OCI)
- Technical lead for creating database design & implementation standards for OCI, working with the architecture & project teams.
- Grid Infrastructure & Database patching
- High availability configuration & database replication using Oracle DataGuard & participating in disaster recovery exercises
- Backup strategies using Oracle RMAN integrating with Networker, Rubrik and more recently AWS
- Data replication/transformation to the data warehouse using Oracle Goldengate
- Implementing Transparent Data Encryption (TDE)
- Installation & configuration of Oracle Enterprise Manager (EM) for monitoring & reporting purposes
- Performance tuning using AWR & ASH analytics to troubleshoot database performance issues
- Configuration & installation of Oracle databases for SAP applications
- Cloning production databases for Development & Test teams
- Supporting the change management process regularly deploying application updates to pre-production & production environments
- Involved in a pilot implementation for Oracle on AWS
- Bash scripting for various automation/monitoring/daily checks
Oracle DBA
General Dynamics IT (GDIT)
01.2013 - 10.2014
- Day-to-day administration of a pre-production & production RAC environment (3-node each)
- DR setup & configuration with Data Guard
- RMAN configuration & administration
- Periodic database refreshes of the pre-production environment using either RMAN scripts or Datapump utilities
- Analyze & resolve problems experienced in pre-production & production environments
- Scripting for database monitoring & health check reports
- Deploying application scripts as part of the change management process
- Oracle patching (PSU’s)
- Performance Tuning
Oracle Database Administrator
Engage Mutual Assurance
01.2010 - 10.2011
- Technical lead for migration & upgrade of Oracle 8i databases on Windows 2003 32bit to Oracle 10g on Windows 2008 64bit
- Technical lead to analyze & resolve problems experienced in the migration & upgrade
- Technical lead for SQL tuning of queries affected by the upgrade due to optimizer changes from 8i to 10g
- Analyze & resolve problems experienced in installation, development, test & production environments
- Performance tuning (tkprof & statspack)
- Writing Windows scripts for automating database refreshes in development & test environments
- Configuring database & OS alerts using Quest Spotlight & OEM
- Standby database configuration, testing & DR setup
- Enforcing security through implementation of Oracle Security patches
- RMAN setup, configuration & administration
- Writing RMAN scripts for database backup & restore scenarios
- Implemented a RMAN disk backup strategy along with appropriate tape backups & retention policies
- RMAN database duplication
Oracle Database Administrator
Bahrain Telecommunications Company (BATELCO)
11.2002 - 09.2009
- Design, build and test databases
- Administer and support 24x7 large-scale databases, some upto 2TB in size
- Analyze & resolve problems experienced in installation, development, test & production environments
- Providing Lead DBA support & expertise to various IT projects across the organization
- SQL performance tuning (tkprof & statspack)
- Partitioning
- Maintaining change control procedures
- Database patching, cloning, migration & upgrades
- Enforcing security through auditing, listener configuration & Oracle Security patches
- Writing various SQL & Unix scripts for database monitoring & daily health checks
- Capacity planning, DR configuration & testing
- Installation & configuration of Oracle AS10g (standalone) for Java based application deployment
- Job configuration/scheduling through dbms_job & cron
- Extensive use of export/import & materialized views to maintain data across systems
- Oracle Net configuration (Oracle Names & sqlnet setup)
- Database cloning using EMC mirroring & deduplication technology
- RMAN setup, scripting, configuration & administration
- RMAN database duplication
- OEM 10g Grid Control setup, configuration & administration
Database Administrator
Central Informatics Organisation
01.2000 - 10.2002
- Database Administrator for the Central Population Register (CPR) system. The databanks are based on Oracle.
- Successfully designed and implemented a backup strategy for the CPR system, which involves both, logical and offline backups on a weekly/ monthly basis. The logical backup uses the Oracle Export utility while the offline backups are done using VERITAS Backup Exec software
- Designed, tested and implemented recovery procedures which have been successfully used in the production environment
- Designed and set up web pages for online RFI processes for a National Smartcard as part of the E-government initiative for the Kingdom
- Achieved Image transformation using Oracle interMedia overcoming major issues with back level image formats for TIFF
Education
Oracle 11g Certified Database Administrator -
Oracle University
Oracle 9i Certified Database Administrator -
Oracle University
Oracle 8i Certified Database Administrator -
Oracle University
Bachelor of Commerce (Computer Applications) -
University of Mumbai
Skills
- Database policymaking
- Database architecture
- Linux operating system
Timeline
Senior Oracle DBA
Close Brothers Ltd.
10.2014 - 09.2023
Oracle DBA
General Dynamics IT (GDIT)
01.2013 - 10.2014
Oracle Database Administrator
Engage Mutual Assurance
01.2010 - 10.2011
Oracle Database Administrator
Bahrain Telecommunications Company (BATELCO)
11.2002 - 09.2009
Database Administrator
Central Informatics Organisation
01.2000 - 10.2002
Oracle 11g Certified Database Administrator -
Oracle University
Oracle 9i Certified Database Administrator -
Oracle University
Oracle 8i Certified Database Administrator -
Oracle University
Bachelor of Commerce (Computer Applications) -
University of Mumbai
Similar Profiles
Louie Braun-CarrLouie Braun-Carr
Finance Operations Assistant at Close Brothers | Novitas LoansFinance Operations Assistant at Close Brothers | Novitas Loans
Madeleine CollinsMadeleine Collins
Operations Manager at Novitas Loans, Close Brothers LimitedOperations Manager at Novitas Loans, Close Brothers Limited
Rob SmartRob Smart
Business Architecture Analyst at Close BrothersBusiness Architecture Analyst at Close Brothers
Ellie GeddesEllie Geddes
Qualified dental nurse at Rossington Dental PracticeQualified dental nurse at Rossington Dental Practice
Fiona ChanFiona Chan
Auditor at Serve LegalAuditor at Serve Legal