Marcos M Lima Email & Phone Number

San Francisco Bay Area

San Francisco Bay Area

Oracle DBA and Golden Gate Consultant at Federal Reserve Bank of San Francisco.

Mr. Lima was tasked to take on a comprehensive infrastructure assessment to understand and fix replication issues across the Oracle environments. He drafted a strategic plan to revisit every infrastructure layer due to the suboptimal replication performance. Replication latency used to be the major issue for all SEARCH/Oracle Streams servers. The chronic poor performance was directly impacting the business’ revenue goals. Mr. Lima led extensive troubleshooting efforts to mitigate replication latency across Oracle databases. The Inventory and SEARCH architecture was built on Oracle EE 11g database (HP-UX 11 / 3PAR & RAMSAN storage) replicating data into Oracle SE 11gR2 (Linux 5 servers / SSD disks). This OLTP environment used to generate over 6GB of transactions every 5 to 10 minutes. Mr. Lima identified a variety of issues: disk swapping, high disk I/O latency for archive log files (near-line disks), various underperforming SQLs, capture & apply parameter misconfigurations, ORA-0600 bugs, Oracle Text indexes corruptions, Netscaler load-balancing connection mishandling and Linux’ hugepages requirements. Because of the OS, storage and database misconfigurations, the Oracle Streams servers had to be rebuilt multiple time causing constant outages and after-hour calls. He put together a long list of recommendations to stabilize the SEARCH servers and documented his findings and troubleshooting procedures. Today replication has been current and stable 99% of the time. That issue was responsible for the majority of off-hours calls to IS&T team as well as the significant business impact due to high number of orders cancellations. Installed, configured and recovered Oracle ASM. Mr. Lima installed and configured Oracle’s Golden Gate and Quest’s Shareplex replication solutions. And, he compared their pros and cons as possible alternatives to Oracle Streams. Installed and configured an updated version for Oracle Enterprise Manager (11g) and Weblogic.

Provided senior-level leadership regarding the management and maintenance of highly complex database systems for various clients, such as: GAP, Johnson & Johnson, Williams-Sonoma, British Petroleum, Astra Zeneca and Cendant. Planned projects for database migrations and maintenance leveraging idle resources. Documented standards, processes and complex tasks such as database refresh via RMAN cloning, database archiving and space management based on raw devices. Responsible for coordinating database-related tasks with virtual teams in India and Brazil. Also responsible for administering three of the most high-profile DSS/OLTP applications at GAP: Retail Management System (RMS); Retail Reporting (ODS); and European Growth Initiative (EGI). These enterprise databases have over 20TB of allocated space combined. Initiated efforts to troubleshoot and enhance batch job performance. Redesigned and replaced inefficient Datastage processes with Oracle Datapump, SQL*Loader and shell scripts in order to improve application performance. Designed, planned and managed many database migrations and disk space reorganizations for very large databases. Efforts claimed back 6 TB of usable space saving hundreds of thousands of dollars. Participated in the annual disaster recovery project to ensure backup reliability. Mr Lima successfully restored and recovered dozens of production database backups using RMAN/Netbackup and IBM TDP/TSM. Responsible for one-way replication environment using Oracle Materialized Views. Recommended adjustments in the partitioning strategies as well as in many SQL statements to improve RMS and ODS. Created numerous PL/SQL packages and shell scripts to automate database security, monitoring and reorganization. Mr. Lima is very comfortable with PL/SQL packages and korn shell scripts development. Worked with high-availability, such as: Oracle RAC, Dataguard and IBM HACMP.

Responsible for the design, deployment and administration of the most high-profile DSS application at Williams-Sonoma: Modeling Marketing System (MMS). Helped building data model, deploying the physical model and fine-tuning table partitions and user-SQLs for performance enhancement. MMS application had been developed on Abnitio's ETL framework. During the time as technical lead for MMS, the database used to process 5TB worth of data on Netapp storage. MMS generates marketing campaigns and provides targeted catalog mailings. Also served as the primary DBA for highly transactional OLTP application like WilliamsSonoma's e-Commerce databases. Helped monitoring hundreds of thousands of transactions per minute on a two-way Oracle Streams environment between two Sun servers in the East and West coasts. Helped building and supporting Oracle Dataguard databases for RMS application. Dataguard environment was created to balance workload across OLTP transactions and reporting jobs. Coordinated and successfully implemented Oracle Grid Control 10g, which allowed database monitoring and administration from a single server. Responsible for the analysis, tuning, advanced replication, installation and configuration of the Oracle DBMS 8.x and 9i databases on AIX platforms. Provided 24x7 database support for MMS application. Also installed and configured MS SQL 7.0 database servers. Responsible for coordinating database-related tasks with virtual teams in India.

Worked at various customers, such as: ASI, BMC Software, MCI Worldcom and Agilent Technologies. While working for BMC, Mr. Lima was responsible for creating and executing Patrol DB-Unload QA Test plan. For MCI Worldcom, he was responsible for interviewing customers and building a new data model for Private Line Order Entry system which allowed nationwide customers to place online circuit orders. PLOE application was designed and deployed using HTML and JAVA servlets based on Oracle 8i Server. The architecture also included two messaging systems (MQSeries and ComFab). During Mr. Lima's assignment at ASI, he installed, configured and created the schema environment for Oracle Clinical 3.11 application. Also responsible for tuning Sun OS parameters to enable the application to perform accordingly. At Agilent Technologies, Mr. Lima worked as PL/SQL developer for a datawarehouse application.

Implemented and deployed 100+ Oracle servers across Boavista's branches. Provided 1st level Oracle Support 24x7.

Oracle and Ingres DBA

Oracle DBA

Ms, Information Systems Management

Graduated in December 2007.

Certificate, Business Administration - Mba Foundation

Completed the Certificate Program in Business Administration. The program introduces the fundamental concepts and practices of business.

Bs, Information Technology

Graduated in August 1995.