Miguel Armando Angulo
Summary
** ***** ** **-***** information technology experience in design, development, installation, implementation, customization, upgrade and support of Oracle, SqlServer databases and operating systems.
20 years of experience with Oracle technologies as Oracle DBA and SqlServer in production, development and test environments.
Having solid foundation of database management, administration, backup and disaster recovery.
In-depth knowledge and hands on experience in the Oracle and SqlServer upgrade, implementation and installation spanning on various versions and different platforms.
Accustomed to software version control, implementation, quality assurance, space allocation and management, migration, backup and recovery, data guard instance performance monitoring and tuning, application tuning, capacity planning, standards identification and compliance, problem resolution, and new product/release evaluation.
Defined database organization, standards, controls, procedures, and documentation.
Provided experienced technical consulting in the definition, design, and creation of database environments.
Advised developers and end users with database solutions to business problems, database management system facilities and capabilities, and the operation and tuning of databases.
Designed, implemented and maintained databases with respect to access methods, access time, batch processes, device allocation, validation checks, organization, protection and security, documentation and statistical methods.
Automated tools expertise and implementation for database maintenance and notification.
Created logical data models based on customer requirements and implemented the physical model in database environment.
Oracle database upgrade11gR2/10g DBA with extensive hands on experience with Oracle 11gR2 new features.
SqlServer database upgrade 2005, 2008 and 2012, extensive operational tasks.
Enjoy working in software/IT industry and performed various roles on the logical and physical side of Database Administration.
Education
Peruvian Naval Academy. (Lima-Peru). Computer Science, Information Systems Programmer/Analyst, Honors Graduate.
Computer Learning Center, Washington D.C 1990 GPA: 4.00.(Associate Degree),Oracle University, Microsoft University.
Training and Certifications
Exadata Oracle Database Servers.
Oracle GRID Control 12c.
Oracle 11gR2 Performance Tuning
Oracle 11gR2 New Features
Oracle 10gR2 Database Administration I
Oracle 10gR2 Database Administration II
Oracle 9i database Administration.
Oracle7 database Administration.
Oracle7 Performance Tuning Workshop.
Microsoft Corporation Training
SqlServer 2012
SqlServer 2008
SqlServer 2005
SqlServer 2000
PeopleSoft Certification
SELECT Certification
COGNOS Impromptu
Technical Skills
Platform and Architecture
Performance Tuning, Quality Assurance, Security Standards/Auditing, Data Modeling
Configuration/Change Management
High Availability (RAC, TDE, NETAPPS, ASM,Oracle EXADATA), RMAN Backup and Recovery, DataGuard Fail-over/Switch-over, Load Balancing, Maintenance/Alert Notification.
Non-Oracle Databases
SQL Server 2012, SQL Server 2008, SQL Server 2005, SQL Server 2000, DB2, Microsoft Access
Tools
OEM Grid Control 10g/11g/12C, Oracle Weblogic 10.3.3, Toad 11.5, Toad 8.8, Quest Software, Load Runner, Visio, Foglight
Microsoft Applications
Crystal Reports, Stat pack, Embarcadero DBArtisan 8.1.2, SELECT-Design, ERWIN
Programming Languages
MySQL, PL/SQL, SQLPlus, T-SQL, Shell Scripting, Batch Programming, SQL Loader, C++, ASP.NET, Cobol, CICS, Assembler
Applications
PeopleSoft 8.8, 8.9, 9.1, Cognos, Informatica, Sharepoint, GovWin, Dekker, STAT, ImageNow, Clarity, Deltek, Hyperion, Report Server
Engagement Experience
Project Management, Benchmark Testing, Data Modeling, Documentation, Presentations, Platform Migrations, Application tuning, Oracle and SQL Server Database Upgrade, Configuration Management, Quality Control, Technical Assessments, Installation, Database Tuning
Hardware & Operating Systems
EXADATA, Red Hat Enterprise Linux 5.5, Oracle Enterprise Linux, HP PA RISC 11.11, 11.23, Goldengate 12C, HP Itanium 6.1, Windows Server 2000,2003,2005,2008,2012, VMWare, Oracle VM
Professional Experience:
US.COURTS-Washington DC Nov 15 to Feb 16
Senior Oracle DBA
Responsibilities
Installed, create and / or clone Oracle software and databases into new infrastructure to create/refresh development and test environments from production.
Implemented and perform rman scheduled backups.
Performed database patching for bug fixes, and mitigate security vulnerabilities.
Test recovery and support continuity of standard operations procedures (SOP).
Performed Operational DBA user administration.
Automated / maintained and monitor logs.
Implemented / Documented / enhance backup and recovery procedures.
Supported deployment from Physical to Virtual Database servers, performed Database migration enhancements and bug fixes to the development, test and production environments.
Documented deployment procedures.
Performed database upgrades as needed.
Implemented Index and Tables data partitioning strategies.
Assisted various projects on Database performance tuning.
ManTech International, Fairfax, VA Jul 09 to Oct 15
Sr. Oracle / SqlServer DBA
Responsibilities
Oracle 11.2.0.3 and 11.2.0.4 Upgrade on RHEL 5.5, LINUX, EXADATA
Installed and configured Oracle 11.2.0.4 and Goldengate 12C Software in Exadata. Created 4 database nodes Instances clustered. Assist in Data Architecture for the Data Architect team using ERWIN and ER studio as data model tool.
Oracle 10.2.0.4 to 11.2.0.1, 11.2.0.4 Upgrade on RHEL 5.5
Oracle 11.2.0.1 to 11.2.0.2, 11.2.0.3 and 11.2.0.4 - Performed Oracle 11.2.0.1 to 11.2.0.2 and to 11.2.0.3 upgrade for several PeopleSoft databases and respective physical standby databases also in physical and Virtual Machines for production environment.
Performed various production performances testing in order to tune maintenance, business and batch processes. Utilized Oracle RAT for tuning processes and utilized Oracle Application Testing Suite (OAT) for simulating user load during load testing cycle.
SqlServer 2008, 2012 – Performed software installation, upgrades, database refreshes, clones, database creation, objects, users, backups and restores for the following applications:
COGNOS, SHAREPOINT, GOVWIN, HYPERION, DELTEK and REPORT SERVERS.
Oracle 10.2.0.4 to 11.2.0.1 – Performed Oracle 10.2.0.4 to 11.2.0.1 upgrade for several PeopleSoft databases and respective physical standby databases for production environment.
Performed various production performance testing in order to tune maintenance, business and batch processes.
Utilized Oracle RAT for tuning processes and utilized Oracle Application Testing Suite (OAT) for simulating user load during load testing cycle.
Incorporated several Oracle 11g New Features when applicable to the environment.
Oracle 10.2.0.4 to 11.1.0.7 Upgrade on HP Itanium 6.1
Oracle 10.2.0.4 to 11.1.0.7 – Performed Oracle 10.2.0.4 to 11.1.0.7 upgrade for 5 PeopleSoft databases with respective physical standby databases.
Performed various production performance testing to tune maintenance, business and batch processes. Utilized Oracle RAT for tuning processes and utilized Oracle Application Testing Suite (OAT) for simulating user load during load testing cycle.
Oracle 10.2.0.3 to 10.2.0.4 Upgrade on HP PA-RISC 11.23
OEM 11.1.0.1, and 12CLOUD Grid Control Installation on RHEL 5.5, LINUX
Oracle 10.2.03 to 10.2.0.4 – Performed Oracle 10.2.0.3 to 10.2.0.4 upgrade for over 50 production, test and development databases with respective physical standby databases in production environment.
OEM 11.1.0.1 and GRID12C Grid Control Installation – Performed Oracle Enterprise Manager 11.1.0.1 GridControl installation on RHEL 5.5 with the necessary Oracle Weblogic Server 10.2.3 installation.
Configured management agents and plug-ins for several Oracle and SQL Server databases as well PeopleSoft Administration functionalities. Integrated Oracle Configuration Manager and Oracle Support with all management agents. Established performance baselines, notifications, security standards and metric evaluation.
Managing 8 Oracle 10g & 2 Oracle 11g PeopleSoft production databases with 10 standby databases along with 8 Oracle 10g integrated application databases. As well as 20 SQL Server 2005 production databases hosting applications such as Sharepoint, Dekker, GovWin, etc.
Supporting Development and Test environments and more than 25 developers for their daily needs. Reformed server architecture, implemented industry standard processes, and systems monitoring to reduce database downtime. Reviewing system SLAs time to time and make sure systems are meeting SLAs. Knowledge sharing of new technologies with team by implementing oracle innovations.
COBALT GROUP Inc. Seattle, Washington Sep 08 to Jan 09
Systems Operation Support / Sr. Oracle DBA
Responsibilities
Perform database, design, modification, development, security, backup, tuning, and maintenance activities in support of computing systems for the Wave project Group.
Analyze and resolve application performance issues in coordination with customers and other Database Administrators (DBA).
Ensure integration of upgraded databases requirements and project plans between major project activities using Database tools.
Document processes and procedures and ensure compliance of organization's database standards, practices and methodologies inclusive of security, hardware, software and configuration management.
Design and develop custom interfaces, and performed Databases migration including RAC, created standby database for fail over purposes and relocated to a new operation center location.
Available for periodic unscheduled (on-call) support outside normal business hours. Using Oracle 10gR2, 9i, 8i, Sun Solaris, HP, UNIX, PL/SQL, Spotlight and Toad.
UNIVAR-USA Inc. Belleview, Washington Jun 07 to Jul 08
Sr. Oracle DBA / DB2 and SQL Server DBA
Assisting with the administration of development, test and production instances of the Oracle, DB2, and SQL Server Databases.
Installation and maintenance of Oracle software within a UNIX environment with a strong focus on data warehousing environments.
Providing highest level troubleshooting on unique problems; serving as highest level technical resource for a database technology; serving as an expert consultant to developers and customers to provide expertise on database product capabilities and constraints.
Working outside immediate discipline to coordinate a group of people in troubleshooting a wide-scale problem; serving as point-of-contact across several areas or disciplines to solve major systems outages with high impact or visibility.
ALLTEL Corporation - Western Wireless Corp., Issaquah, Washington Oct 00 to Jun 07
Sr. Oracle DBA
Responsibilities
Responsible for tuning and configuration of customer service and billing application Oracle databases from the conversion process through the move to production. Database configuration was largely untested in production trim. The application supports about 1000 concurrent users and 3.5 TB total database size.
Responsible for 20 Oracle production, Development, and Test databases and 17 SQL Server 2000 and 2005 databases for (Alltel.com, Web Content Mgmt, Billing Adjustment, Corporate Tax, Check Image, Unity point of Sales) environments.
Developed strategic direction for database implementation. RAC (Real Application Cluster) for 10gR2 databases (3 separate nodes running in on single server plus failover servers)
Developed and implemented database standards and procedures for application databases including third party vendor databases.
Performed trend analysis for capacity planning of future storage requirements.
Installed and upgraded database server applications and tools.
Database architect responsible for database objects (tables, views, indexes, etc.) in support of the application installation/development process.
Designed and maintained system security.
Performance tuning including SGA, SQL statements and physical architecture.
Planned and implemented backup and recovery procedures. (RMAN specifics)
Coordinated team activities related to the administration of databases, including organization, Documentation, long term requirements planning and operational guidelines.
Coordinated software evaluation and installation. Considering UNIX and LINIX OS platforms analysis for new hardware and software configuration.
Mentored programming groups concerning impact of application architecture on the database.
US. Department of Commerce. July 1999 – August 2000
Oracle DBA
Responsibilities
Perform oracle databases data migration and data conversion from
IBM mainframe into LINUX dedicated servers. Implement data security and maintenance scripts. Resolve application performance issues. Developed SOP Document processes and procedures, and methodologies inclusive of security, hardware, software and configuration management. 24x7 support.