SUMMARY:

• Many years of experience in RDBMS field (MySQL server 5.x, MS SQL6.5, 7.0,2000, 2005,2008), Oracle 7, 8i,9i).
• Certified MySQL5 DBA I & II
• Database logical and physical design and implementation
• Database application support (Web servers, Apache, PeopleSoft Finance and HR, Remedy), Oracle management tools (Oracle Enterprise Manager, SQL* Plus, SQL*Net, Oracle Net8) Oracle tools (imp, exp, SQL*Loader),.
• Third party Oracle managing tools (DBArtison, Quest Instance Monitor, Schema Manager, Foglight, Iwatch), and MS SQL Enterprise Manager, ODBC, JDBC
• Stored procedures, Functions, DTS, SSIS development
• Database logical and physical design
• Log shipping setup and documentation

PROFESSIONAL EXPERIENCE:

Database Administrator

Confidential, Foster City, CA

• Manage MySQL, Microsoft SQL server monitoring, troubleshooting, performance tuning, high - availability strategies in a 24x7 production environment
• Design and implement databases on various RDBMS systems
• Linux and Window setup and administration
• Using various tools to monitor/admin. MySQL and MS SQL
• Develop and implement replication, cluster, archiving and backup and recovery strategies
• Hardware requirements and storage capacity planning for Development, Testing, QA, Staging, and Production for scalable database growth and performance
• Proactively monitor the Production Database(s) and optimize stored procedures for better performance. Resolve locking conflicts and resource utilization
• Administer, maintain, develop and recommend policies and procedures for ensuring the security and integrity of the company’s databases and systems
• Manage and Create database schemas for Relational Database Systems optimize index creation, table creation, storage allocations, etc
• Ensure all database environments Development; Testing, QA, Staging, and Production are in sync
• Design, review and implement production SQL Server database objects, models and database designs (schema)
• Identify and resolve database performance issues, database capacity issues and other distributed data issues

Database Administrator

Confidential, San Francisco, CA

• Setup and maintain MS SQL server log shipping
• Develop SQL server DTS, stored procedures, functions to transform/update/report data
• Upgraded SQL server from 2000 to 2005, migrated/redeveloped all DTS to 2005 SSIS packages
• Setup and maintain SQL server cluster
• Make recommendations for hardware configuration for database servers
• Perform data reporting/data mapping using SQL
• Setup and manage SQL server Reporting Service
• Manage all production deployment efforts and all production related maintenance tasks(e.g.
• UAT database/data setup and maintains, DBCC, re-indexing, monitoring errors, etc.)
• Insure the up-time and optimal performance of multiple database Server environments using various tools

Database Administrator /Developer

Confidential, Sunnyvale, CA

• Design, implement and manage the product Engineering databases (MS SQL7.0, 2000)
• Installed and maintained SQL server replication
• Developed data analyze tools
• Graphic User Interface, Web page design and implementation using ASP and JavaScript
• Production data import programming using Java
• Implement and manage Backup and recovery systems, setup security gates and support department’s database servers and networks

Database Administrator

Confidential, San Francisco, CA

• Oracle Database Administration. Database management in a 24x7 high-availability environment; Install/Upgrade Oracle server software; Logical/Physical Oracle database design and implementation; Backup/recovery, monitoring, performance tuning, troubleshooting, accounts and security set up; other daily database management tasks.
• Worked as core member of Peoplesoft base team on all phases of implementation for Northpoint’s first Peoplesoft system. From the beginning of Peoplesoft system planning to the successful production rollout.
• Peoplesoft System/database administration. Worked on installation, configuration and upgrading of Peoplesoft servers on Solaris 2.7 and Windows 2000. Installed and supported 12 databases for HR and Finance environment(for production, development and testing), running 24x7.
• Oracle Application Support. Supporting applications such as Remedy, Sieble, Vitria, Netserv; New application evaluation.
• Database Reporting. Setup and administer database reporting environment and application; Scripted daily data loading from production to reporting system; Setup and administer report server—Seagate Info(Crystal report server) and support more than 100 Info users.
• Administrator for Company’s production MS SQL servers. Setup and administer SQL servers in 24x7 and high-availability environment; install and upgrade, backup/recovery, monitoring, performance tuning, troubleshooting, web reporting, accounts and security setup and other daily DBA tasks
• Netserv System Administration. Worked on installation, configuration, and upgrading of all Netserv systems; user setup/maintenance, security, job scheduling, VAN communications setup and maintenance; UUCP setup and maintenance; EDI message translation, WU-FTPD setup and maintenance.
• EDI Oracle databases Administration. Developed EDI Oracle database (Running 24x7) backup/recovery procedures. Implemented Physical data layout. Performed daily administration tasks such as database space management and monitoring.
• Middleware Administration. Install, Configure, support and troubleshooting SQL* Net for TCP/IP and Oracle/SQL ODBC drivers
• Supported Winnt server and windows 2000 server.