Leadership and managerial skills with results-driven, cost-effective orientation, and ability to manage resources efficiently and mentor and motivate teams to maximize levels of productivity. Well-organized, self-motivated and dedicated with strong sense of responsibility and loyalty to the organization. Excellent interpersonal and communications skills Expertise in full project life cycle development for implementation and integration. Proven ability to implement standards, procedures, and processes that improve business functionality and productivity. Solid experience in architecting and managing large-scale, enterprise-level relational database management systems with sub-second performance and high availability and scalability requirements. Over a decade of in-depth experience in database administration, backup and recovery, performance monitoring and tuning, security and compliance, capacity planning, installations, upgrades, migrations, high-availability integration, disaster recovery implementation, replication, and SQL optimization. Hands-on experience in UNIX system administration, installations, upgrades, security, performance tuning, backup/restore, DR, kernel optimization, and strong UNIX shell scripting, with good networking and SAN background. Background in object-oriented and traditional programming languages including Visual Basic.NET, ASP.NET, C, C++, C#, Java, and Perl.
Hardware and software upgrade planning
Product requirements documentation
End-to-end product lifecycles
Advanced knowledge of HTML and CSS
Budgeting and resource management
Certified Information Security Manager
Saved more than $[Amount] by renegotiating an IT outsourcing contract.
Reduced the incidence of IT issues by [Number]% globally by leading a testing initiative improvement program.
Increased core system availability to [Number]% by developing standards and architectural governance and implementing best practices.
Led a successful acquisition and the subsequent technology integration in under [Number] days.
Took over [Product] project which was late to market and $[Amount] million over budget, and successfully launched in just [Number] months.
Spearheaded a company-wide innovation initiative resulting in [Number] new product offerings in under [Number] months.
DBA ManagerDec 1999 to Current First American CoreLogic. Inc － Santa Ana, California
Manage, build, and mentor a strong DBA team of Oracle, PostgreSQL, and MS SQL server to provide professional and quality support to the organization's teams of developers, project/product managers, and analysts.
Responsible for architecting, managing, and supporting the organization's enterprise 24x7 databases infrastructure and providing high availability, fault-tolerance, scalability and security of the DB environments.
A DB infrastructure of over two hundreds enterprise Oracle, SQL server, and PostgreSQL databases, with over 70 terabytes of property, transaction, and billing data, and 3,500+ concurrent online customers, running on Solaris and Red Hat Linux platforms with EMC Symmetric and Clariion SAN storage.
Develop, maintain, and test backup and recovery and disaster recovery strategies.
Perform recovery testing using Oracle Recovery Manager (RMAN).
Monitor and fine-tune the performance of production databases to ensure high performing and consistent database response time and throughput.
Optimize resources-intensive SQL statements by maintaining current object statistics, proper indexing (Bitmaps and B-Tree), in addition to leveraging Oracle's cost-based optimizer Hints whenever necessary.
Perform Oracle installations, configurations, upgrades, migrations, and patching, leveraging newly introduced release features to improve overall database performance and administration and keep the organization on the leading-edge of technology.
Manage disk space and databases objects efficiently by implementing Oracle best practices and recommendations including Oracle Flexible Architecture (OFA) standards.
Create and maintain database security and compliance standards, user accounts and roles.
Architect, and maintain physical and logical database models using Erwin software to reflect DB changes within the databases life cycle.
Perform massive data loads to update the production databases efficiently utilizing SQL*Loader and Unix/Linux Korn shell scripting, in addition to Oracle export/import and 10g data pump utilities to move data in and out.
Develop UNIX and SQL scripts in addition to PL/SQL to automate repetitive DB administration tasks including monitoring and alerting the health of system and database/server resources.
Maintain and manage Oracle and Microsoft SQL server licenses and costs.
Annually forecasting and budgeting for existing and growing database infrastructure.
Major Accomplishments: Directed and oversaw the SAN migration of EMC DMX3000 to DMX4, increasing overall I/O throughput by 25% Re-architected and consolidated the organization's enterprise database infrastructure with Solaris/Fujitsu and Linux/HP servers, increasing system capacity and performance by 30% whilst reducing overall server allocation, maintenance, and licensing costs.
Architected, and implemented Oracle 10g database environments running on Solaris/Fujitsu and Red Hat Linux/HP platforms for enterprise level and mission-critical application environments.
Leveraged advanced Oracle technology such as Oracle Partitioning, Streams, and Spatial.
Leveraged and implemented open-source PostgreSQL databases running on Linux/HP platform to support less critical application environments.
Integrated open-source Slony replication system to provide HA and fault-tolerance solution.
Implemented and maintained Oracle Data Guard Physical Standby databases for OLTP databases to eliminate single-point-of-failures (SPOF) and ensure fault-tolerance, high availability, with minimal interruption and zero data loss in case of media/server failure.
Participated in the deployment of the EMC Symmetric disk array storage and TimeFinder technology to provide the organization with higher availability, scalability and disaster recovery solutions for our database infrastructure.
Managed the database disaster recovery (DR) plan, and supervises and performs periodic DR tests at the data center in Dallas, Texas.
Designed, built, and maintained an Oracle database to provide statistical data, in a variety of formats, to the media industry, online customers for full-market-value, and sales of properties nationwide, covering over 3,000 counties in the US.
Participated in setting up and testing Oracle 9i RAC (Real Application Clusters) solution on Sun Solaris Cluster platform, at Oracle's Labs in Atlanta, Georgia to explore more advanced scalability options.
Provided and implemented database and SQL performance tuning recommendations for online processing with milliseconds query response time requirements, and massive batch processing, increasing performance by 50%.
Re-designed, and migrated Oracle 8i (8.1.6) databases to Oracle 9i release 2 (over 10 terabytes of data).
Upgraded all databases from Oracle 8.0.5 to Oracle 8.1.6 to leverage Oracle 8i new features including transportable tablespaces, locally-managed tablespaces, and automatic transmission of archived redo logs for the Standby database implementation, as well as the capability to relocate tables and coalesce indices online.
Senior Oracle Database Administrator / ArchitectDec 1997 to Nov 1999 MedPartners-Caremark, Inc － Anaheim, California
MedPartners-(Caremark, now): a Fortune 500, and one of the nation's largest physician practice management and pharmaceutical services corporation.
The company provides primary and specialty healthcare and services to pre-paid managed care enrollees and fee-for-service patients as well as pharmacy benefit management services.
Supported and managed (24x7) production, testing, and development Oracle 8.0.5 and 7.3.4 databases (800 MB to 500 GB in size).
Performed database tuning, backup and recovery, and provided and maintained capacity growth planning.
Developed and Maintained hot online backup and recovery scripts for Oracle databases.
Performed a variety of Oracle databases/software installations, upgrades, cloning, and configuration.
Defragmented databases using export/import utilities to improve performance and save disk space.
Documented operational guidelines and procedures, and provided Oracle basic training to fellow team members.
Acted as a backup basis administrator for an SAP R/3 financial system composed of Oracle production, development, and test instances, located in the Chicago data center.
Accomplishments: Physician Credentialing Database: Created and configured a physician's database to handle credentialing for the firm's medical physicians in Southern California and Chicago regions, running Oracle 7.3.4 on AIX/ IBM RS6000 platform.
Universal Eligibility Repository Database (UER): Created and optimized the UER production database which served as a repository of patient's eligibility information to organize and consolidate all eligibility records from four various production legacy systems.
Designed and created the loading application to feed the Oracle UER database from the legacy systems, using SQL*Loader, UNIX and SQL scripting utilities.
Telephonic Utilization Management Database System (TUMS): Re-organized and tuned the TUMS production back-end database for an in-house WEB-based application which automates the manual process of the Telephone Nurse Advise System, and enables patient eligibility verification, resulting in a 60% increase of overall performance and response time.
Electronic Medical Records Database: Coordinated with the vendor, MedicaLogic, the installation and configuration of Oracle 7.3.4 on NT 4.0 as a back-end database for their product, Logician, which stores patient medical data and interface with MedPartners practice management system.
Upgraded Oracle 7.3.4 databases to the latest 8.0.5 and participated in testing the applications with the developers and QA team.
Oracle Database Administrator/ManagerMar 1996 to Dec 1997 Westfield Corporation, Inc － Los Angeles, California
Westfield Corporation: one of the world's leading shopping center organizations involved in funding, creating, and managing regional shopping centers.
Performed Oracle administration on the production and development database servers.
Analyzed UNIX system resources and Oracle 7 Server requirements to develop and implement a migration plan from Oracle 6 to Oracle 7.3 RDBMS.
Implemented UNIX OS and Oracle Server upgrades on the development and production systems.
Monitored and tuned system and database resource utilization for optimal performance.
Responsible for the development and implementation of system standards, architecture, and policy.
Developed and automated data uploads into Oracle production tables from external files such as MS-Excel, utilizing Oracle SQL*Loader, SQL scripts and, FTP.
Improved the speed and efficiency of the Oracle database by performing database reorganization, which minimized fragmentation and row chaining, using Oracle Export/Import utilities.
Developed and documented procedures and policies for system operation.
Provided managerial direction to team members in support of the Oracle servers running UNIX SVR4 platforms in a client/server LAN/WAN environment with an objective of maintaining the highest level of end-user satisfaction and most efficient productivity.
Apr 1994 to Mar 1996 UNIX Administrator Westfield Corporation, Inc － Los Angeles, California
Performed routine UNIX system administration.
Installed, upgraded, and managed the production and development UNIX servers running Oracle 6 at corporate and regional offices.
Monitored and optimized UNIX servers by analyzing system and database resources to prevent bottlenecks and maintains better system performance.
Migrated from a raw partition-based to JFS file system-based architecture for the Oracle database implementation.
Created sound system and database backups and performed successful file restores and database recovery.
Allocated UNIX system storage and planned future storage requirements for Oracle production and development database systems.
Created and modified logical and physical database storage structures and objects as necessary.
Controlled and monitored database and system security and integrity.
Participated in the implementation and testing of a strategic disaster recovery plan, including backup facilities, alternate wiring plan, and off-site media storage area, to ensure 24-hour availability of the Oracle/UNIX and NT production servers.
Documented and implemented security policies and operations procedures for the MIS-UNIX operations staff.
Performed proactive system and database maintenance.
Provided technical support and system training to end-users.
Researched and implemented PC-UNIX connectivity solution running TCP/IP on top of Ethernet-based LAN and Frame Relay WAN.
Designed and implemented user-friendly Revision Control System front-end to provide an easy-to-use revision tracking mechanism for Westfield's in-house developed programs utilizing Korn shell scripting and UNIX SCCS (Source Code Control System).
Developed a menu-driven system for operators using UNIX shell scripting to perform a variety of operational and system tasks resulting in a dramatic increase of MIS Productivity.
Planned and implemented the migration of a UNIX-based ARCNET network to a robust and fast Ethernet-based local area network, increasing the network throughput by 100%.
Coordinated the migration of Novell Netware 3.12 to Microsoft NT-based servers within our client/server environment.
UNIX AdministratorAug 1992 to Mar 1994 Southern California Gas Company － Los Angeles, California
Southern California Gas Company: The nation's largest natural gas distribution utility, serving 18 million people throughout most of Central and Southern California.
Ensured efficient and smooth operation of 250 UNIX (Intergraph, HP, and Sun) workstations/servers in a client/server CAD/CAM engineering environment.
Installed upgraded, rebuilt UNIX workstations and dedicated file printer and plotter servers.
Downloaded and updated application software via tape, local/remote CD-ROM, or floppy drives.
Created and modified shell scripts to automate repetitive and time-consuming tasks to enhance overall performance by 70%.
Performed daily and monthly system backups.
Provided technical application and system support to the end-users.
Technical Support AnalystDec 1989 to Aug 1992 Applied Computer Systems － Anaheim, California
Built, configured, and diagnosed IBM Compatibles PC clones.
Installed and updated desktop productivity software, and provided training sessions and quality support to clients.
Installed and set up Xenix on personal computers.
Analyzed clients needs and provided effective and affordable hardware/software recommendations and solutions.
Master of Science, Information Systems and TechnologyUniversity of Phoenix － Irvine, CaliforniaGPA: 4.0Information Systems and Technology 4.0
Bachelor of Information TechnologyAmerican Intercontinental University － Los Angeles, CaliforniaGPA: 4.04.0
Oracle Certified Professional (OCP)
Member, IOUG-A (Independent Oracle User Group - America)
*Technical Reviewer (volunteer), IOUG Select Magazine
*Member, LAOUG (Los Angeles Oracle User Group)
Oracle 10g,9i,8i,7,6 enterprise and standard editions. Oracle Data Guard/Standby, Oracle Streams, Oracle Partitioning, Oracle Spatial, and Oracle RAC. RMAN, SQL*Plus, PL/SQL, SQL*Loader, Oracle Export/Import, Oracle Data Pump, Oracle Enterprise Manager(OEM), LogMiner, and Flashback. Oracle PerfStats, Utlbstat/Utlestat TKProf, and Oracle Net. Microsoft SQL Server 2005, Enterprise Manager and Query Analyzer. Open-source PostgreSQL and Slony-I replication systems. PGAdmin management tool. Quest TOAD, Spotlight, Space Manager, and Schema Manager. BMC Patrol, DBArtisan, Erwin and CASE Studio, and DB Tuner. Operating Systems: Sun Solaris 8/9/10, Red Hat Linux AS 2.4/2.6 AS, IBM AIX 4.2, AT&T UNIX SVR4, Windows 2003, and Novell 3.12 Server. Hardware/Platforms: Sun E6500/4500/220, Fujitsu M series and Prime Power series 1500/850/650, IBM RS6000, NCR/AT&T 3500 UNIX systems, Intergraph 7x, RAID, EMC Symmetric 2000/3000 disk arrays, and NetApp filers. Languages: SQL, PL/SQL, Visual Basic.NET, ASP.NET, HTML, XML, ADO.NET, C/C++, Java, Korn, Bourne, Bash UNIX Shell Scripts. Network Protocols: SQL*Net, Net8, TCP/IP, FTP, NFS, IPX/SPX, SSH, SFTP. Applications: VERITAS Net Backup, Microsoft Internet Information Server (IIS), Microsoft Office suite (Access, Word, Excel, PowerPoint, Project), Visio, and AutoCAD, Visual Studio.NET, ASP.NET Web Matrix, VMware Workstation 4.