Sr Developer/DBA

Profile:

A Senior Oracle DBA offering **+ years of progressive experience, specializing in high-volume, high-visibility production and development environments. Skilled in designing and preparing databases configurations for complex and resource intensive applications

Experience on architecture, design and implementation of databases for Banking, Automotive, Telecommunications and Financial Industries.

Performed roles as Project Manager, Senior Oracle DBA, Lead Database Administrator, Unix Administrator and have consistently been promoted to positions of greater responsibility.

Production maintenance and supporting (7x24).

Extensive experience implementing Disaster Recovery Plans.

Involved in coordination of distributed teams to increase productivity and reduce turnaround times.

Seeking a position where my experience and capabilities can be used to contribute to a company's objectives.

TECHNICAL SUMMARY:

POSITIONS HELD:

Senior Oracle DBA

Project Manager

Developer

DATABASES:

Oracle Expertise from 7 to 11gr2

Minor Experience with MS SQL Server and MySQL

OPERATING SYSTEMS:

Linux (Red Hat, Mandrake, SUSE, Oracle Enterprise Linux)

HP-UX, AIX and Solaris

Windows NT 4.x/ 2000 / 2003 / 2008

SOFTWARE/APPLICATIONS/UTILITIES:

Oracle Enterprise Manager / Grid Control

Other DBA Tools (like TOAD, SpotLight, AlertView, HORA 4)

Several Designer Tools (like ERWin, ER Diagram, Visio)

SQL Loader, Export/Import, impdp/expdp

Replication and Data Guard (Standby) databases

RMAN, Backup and Recovery Scripts

Tuning

Partitioning Tables and Indexes

RAC, Oracle Cluster

LANGUAGES:

SQL and PL/SQL

Unix Shell Scripting

EXPERIENCE:

Nochebuena.net (Consulting Company) (Jan 2008 - Present)

Senior Oracle DBA

Provide DBA Services to several companies to improve their performance. Setup Disaster Recovery solutions (Dataguard), Tuning, Migration Services, Backup and Recovery (with RMAN and Shell Scripts) over highly volume Terabyte Databases. Setup Oracle RAC. Some of those companies are:

• Prognos Inc (Provide Services to Retail & Consumer Packaged Goods industries)

• Stagestores.com (eCommerce)

• Credit.com (eCommerce)

• Contactual.com (eCommerce)

Fiserv (Financial Industry) (Ago 2001 - Present)

Senior Oracle DBA

Perform CORE DBA tasks such as Database Administration on Oracle 9i, 10g and 11g environments, performance tuning, Schema creation, maintenance, and troubleshooting. Administers, maintains, develops and implements policies and procedures for ensuring the security and integrity of the company database. Implements data models and database designs, data access and table maintenance codes; resolves database performance issues, database capacity issues, backups, replication, and other distributed data issues over a highly volume Terabyte Database. Setup and manage RAC environments for our customers.

* Perform CORE DBA tasks such as Database Administration on Oracle 9i/10g/11g environments, performance tuning, Schema creation, maintenance, and troubleshooting

* Identify, monitor, recommend, and implement changes to database applications ensuring satisfactory end-user response time with reliable database connectivity

* Implement physical database changes, testing, and performance tuning.

* Prepares and/or review database activity, progress, and performance reports

* Maintain Oracle SQL and PL/SQL scripts, Unix Shell Scripts, debugging and tuning

* Implement Production Control and Change Management

* Ability to pro-actively understand and manage end user/customer expectations

* Provides best practices on new technologies and implementations

* Provides expertise and makes recommendations for physical database design, architecture, testing, performance tuning, and implementation of Oracle DB

* Performance issues (track and trend overall database performance and database area, index, and drive performance).

* Recommending application code changes (processing strategies, queries, use of RDBMS features)

* Great experience applying patches and performing DB Migrations.

* Plan and Design Backup/Recovery solutions using shell scripts and RMAN.

* Ensure that the database software infrastructure is in place and up to date to support other infrastructure components (e.g., operating system and hardware) and application development.

* Maintain more than 25 databases in-house for development/QA and 6 PROD databases for our customers.

* Develop and Support Strategy to provide Remote DBA Services to our customers like Federal Reserve Bank, HSNC, Bank of New York, Bank of America, Bank of New York, etc.

Environment: Oracle8i, 9i, 10g and 11gr2, Linux, HP, AIX, SUN Solaris, Windows, PL/SQL. RMAN, RAC, Dataguard (Standby), Grid Control (OEM)

Encirq (eCommerce) (Jan 2001 –Sep 2001)

149 Bluxome St, San Francisco, CA, 94107

Senior Oracle DBA

Oracle DBA in Internet based environments: heavy transaction rates, absolute requirement for 24X7. Terabytes databases. Working hard in design and sizing so downtime or even degraded performance is minimized. Performed Database modeling, design, sizing, tuning and loading (using import or SQL Loader). Create and maintain tablespaces and schemas; provide support to developers. Experience with high volumes of information. Maintaining 3 Production, 6 development, 4 QA and 1-datawarehouse environments. Some of my duties here:

• Install ORACLE software, install patches, create, tune, and upgrade databases.

• Design of backup/recovery strategies.

• Improve recovery process using Replication, Backup/Recovery (operating system and RMAN) and Standby Databases.

• Review and enhanced instance cloning techniques.

• Implement monitoring scripts for critical applications functions.

• Tune SQL and database parameters; balance I/O.

• Partitioned tables and indexes. Identify and resolve redundant indexing.

• Make selected changes to improve security, recoverability, and ease-of-use.

• Assist Developers in tuning SQL and acquiring skills with Oracle.

Environment: Oracle8i, DBA Studio, HP, SUN Solaris, Windows, PL/SQL.

XPEDIOR Corporation (eCommerce) (May 2000 – Dec 2000)

44 Montgomery Street, San Francisco, CA, 94107

Senior Oracle DBA

Support to developers and managers in the West Coast (Dallas, San Francisco, San Jose and Los Angeles). Provide DBA Services over web-based projects that were using Oracle. Performing several tasks related to the design, development and implementation phases of the projects. Some of our clients were VISA, Business Wire Connect, Best Buy, Citibank, Bank of America, Pricewaterhouse, Bayer, IBM, HP, etc.

In charge of the maintenance of 10 databases for development, 2 for QA and 2 for production.

• Designing the logical and physical models to be used in several projects.

• Installing databases and creating all the objects there.

• Optimizes physical storage access.

• Tune databases and SQL statements.

• Maintain database security, user roles and access profiles.

• Design and use several failover Strategies like Backup and Replication.

• Develop scripts to monitor all the databases automatically.

• Change internal methodologies to use the New Features of Oracle 8.1.6 and 8.1.7

Environment: Oracle8.1.x, Oracle Enterprise Manager, Apache Server, C, PL/SQL, Java, SUN Solaris, HP, NT 4.0.

ORACLE Corporation (1998 – May 2000)

500 Oracle Parkway, Redwood Shores, CA, 94065

Oracle DBA and UNIX Administrator tasks

CRM Group (Dec. 1999 – May 2000)

Provided database administration for CRM Group.

• Perform general system administration duties on Sun Solaris and HP-UX platform (like administrate disks and users, install several applications)

• Performed OS and database backup and recoveries

• Automated DBA tasks utilizing UNIX shell scripts.

• Tune databases queries and optimizes physical storage access.

• Maintain database security, user roles and access profiles.

Y2K Group (1998 - Jan 2000)

Working in the Y2K Project with testers and developers for all the products that Oracle was using internally all around the world like Metalink, Voyager, SMS, ITS, etc.

Our group tested 12 internal applications. I installed and tuned those databases. Responsibilities include:

• Perform general system administration duties on Sun Solaris and HP-UX platform (like administrate disks and users, install several applications)

• Administer Oracle databases on HP/UX and Solaris systems.

• Install, upgrade and maintain Oracle Products and third party software

• Administer database backup procedures and perform database recovery.

• Document DBA procedures and standards.

• Maintain database security, user roles and access profiles.

• Perform capacity planning and sizing for new database applications.

• Patch administration, security and Y2K Compliance.

• Support application developers with schema design and SQL performance tuning.

• Provide DBA support to QA.

• Modify database structure, as needed by application evolution.

• Install and maintain Oracle Web Application Server 3.0 and 4.0, Apache Server and web applications.

Environment: NT 4.0, Oracle 7.3.4, 8.0.4.2 and Oracle8.1.5, Oracle Enterprise Manager, Oracle Web Application Server 3.0 and 4.0, Apache Server, Forms 4.5, Reports 2.1, ‘C’ Files, PL/SQL, SUN Solaris 2.5.1, HP-UX 10.20 and 11.00.

SPECIAL RECOGNITIONS:

2003, 04, 05, 06, 07, 08, and 10 : Recognitions for my performance at Fiserv.

3rd Quarter 2004 : Recognition as the best Employee of the Quarter

2004 : Recognition as the best Employee of the year

EDUCATION:

• Oracle 10g RAC for Administrators Training (San Francisco, CA) (2008)

• Oracle Backup and Recovery - Oracle Training (Belmont, CA) (2005)

• OCP (Oracle Certification Exam) Oracle 8i, GPA: 80, Belmont, CA (1999)

• Certified Oracle 8 DBA by Tek Metrics

• Oracle Application Server (OAS): Administration - Oracle Training (Belmont, CA)

• BS License in Information System Analysis. - Catholic University – Argentina

• I am Green Card holder, excellent health and fluent in Spanish and basic Portuguese.

Contact this candidate