DellSr Database Administrator
May. 2009 - Aug. 2011Plano,Texas• Handled numerous clients transitioning into the Dell model for physical and logical support (knowledge transfer from client in regards to the current state of the environment, hardware and software, information gathering, critical best practices, exceptions logging, monitoring setup, updates to the environment and steady state support). • Managed over 400 SQL Server (2000, 2005, 2008,2012) and 50 Oracle environments. • Installed SQL Server Versions and Oracle 10g for new environments on Windows Server 2003 and AIX 5.0, HPUX 11, Red Hat Enterprise Linux 5. • Experienced with configuring RMAN backup\recovery and executing Data Pump export and import methods. • Configured Oracle Enterprise Manager and Grid Control for online database administration (user security privileges, table spaces, objects, etc.). • Supported High Availability Methods Oracle Clusterware and RAC 10g,11g on multiple nodes including dataguard and managing ASM instances as well. • Created and tested backup plans for all databases SQL Server (Database maintenance plans) & Oracle (RMAN 9i, 10g and OEM). • Installation and configuration for monitoring for the SQL Server (NetIQ) which included adding alerts for baselines, setting thresholds and schedules and actively monitoring activity for NetIQ, responsible for troubleshooting and restoring incidents reported through NetIQ. • Maintained environments including upgrading different versions, performance tuning and proactively checking data availability, and ensuring data standards such as: storage, archiving, backup and recovery procedures are functioning correctly. • Wrote database documentation, including data standards, and procedures. • Worked closely with IT project managers, database programmers and application developers to effectively maintain the environments. Assisting with developing and supporting the applications and providing daily 24x7 on-call support for environments.