OBJECTIVE

• Seeking a challenging career with growth opportunities in a dynamic company. To utilize my skills in managing small/medium to large group of Database Administrators and Business Intelligence users. Hands-on project management functions. Worked as a Technical and Team Lead providing leadership, coaching, training and day-to-day supervision to the Technical Support team. Responsible for leading the design, installation, implementation, upgrade, patching, maintenance and support of appropriate technology solutions and team members' productivity across different organization.
• SUMMARY
• Over 10 years of Oracle Database Administration, 7 years of Business Intelligence Administration 3 years Systems Network administration experience, with strong concentration in Oracle Database. Understanding of design, configuration, Implementation and maintenance of high-availability and scalable 10gRAC architectures. Experience in installation, configuration and administration of 10g RAC database, BI and server application on RedHat, Sun Solaris and Window OS System.
• Experience with database and application tuning using a variety of Oracle database monitoring tools, Backup and Recovery, Database Migration, Replication and Managing Databases on High Availability Sun Cluster..
• Over 14 years Technical and Team Lead experience
• Over 10 Database Administration experience
• Over 7 Business Intelligence Administration experience
• Over 5 Systems Administration experience
• Over 3 Network Administration experience
• Over 3 Websites Administration experience

TECHNICAL SKILLS

• Database : Oracle Database Server 11g/10g/ 9i/ 8i, DB2, PeopleSoft, Microsoft SQL Server 2000, 2005,
• 2008, Oracle MySQL 6.5, FOCUS, Microsoft Access
• Operating Systems : Linux- Red Hat, HP-UX 11.x, IBM AIX R/S 6000, Sun Solaris, Windows Server 2000, 2003, 2008, 2008r, CentOS 6.5, Ubuntu Enterprise Edition
• GUI/Applications : Oracle Forms, Oracle Discoverer, WebFOCUS BI Portal, Oracle SQL Navigator
• Oracle Enterprise Manager, SQL Developer Toolkit, MySQL Workbench, SQL Plus, SQL Loader, Data Pump, Oracle Grid Control, Putty, Toad, Data Guard, Microsoft SMS, Microsoft SharePoint Portal, Remedy, Microsoft Project, Microsoft Visio
• Web Development : WebFOCUS Portal, ColdFusion MX, Dreamweaver MX, 2007, Korn Shell scripting,
• Oracle SQL Scripting, PL/SQL. Reporting Tool : Oracle Fusion Middleware, Oracle EBS Business Suite, Information Builders WebFOCUS BI, Oracle Forms, Oracle Reports, Oracle Discoverer Mapping Tool : ArcGIS for Server, ArcGIS for Desktop, ArcGIS License Manager and ArGIS Portal SAN Storage : EMC SAN and , Dell SAN iSCSI PowerVault PROFESSIONAL EXPERIENCE Confidential
• Oracle DBA / Middleware Administrator Team Lead
• Overview: Administrator on FDIC Enterprise Business Intelligence Tools, design and structure access to database data and reporting to end-users. Provide database data to upper management.
• Serving as the primary Oracle database and Application DBA in both Microsoft and Linux environment, in charge with oracle Data Guard, GRID Control, EBS Patching, and cloning Admin.
• Implemented and modified table partitioning, using range-range, range-list partitioning. Created different tablespace to support the partition of data to improve performance and manageability.
• Proposed, designed, and implemented of solutions, which adhere to best practices related to business objects in data warehouse architecture, standards, methodologies, and applicable tools.
• Developed and managed project-related presentation materials.
• Perform memory, application, disk I/O tuning and eliminate database contention from table locks, latches and wait events.
• Transferred database /data by batch technique. Developed materialized views and star schemas and designed disaster recovery solutions data guard failover.
• Integrated SQL/Oracle into an infrastructure to integrate with BI tools such as Business Objects.
• Administrated and managed oracle EBS R12. Configured and setup web servers and infrastructure.
• Planned Oracle EBS upgrade refresh, backup and recovery procedures for Oracle database and EBS, Rapid install, Rapid Cloning and Patching on EBS.
• Designed Oracle backup solutions using RMAN and recovery, disaster recovery, troubleshooting and installing of database information. Maintained redo logs and archive them to tape. Monitor alert log, trace files and audit logs.
• Performed database security and user administration via roles, profile, privilege, synonyms and auditing.
• Involved in performing SQL tuning, Oracle Bug fixes and patching Oracle application server, Oracle database using Oracle oPatch.
• Installation, upgrade, and management of GRID control and GRID failover for database monitoring and database management.
• Involved in complete Software Development Life Cycle SDLC Requirement Specification, Requirement Analysis and Design, Coding and Testing, Deployment and Support.
• Led WebFOCUS team in implementing GAO Java Finding on WebFOCUS application in PIE, CIE, Quality Assurance QA and Production PROD environment.
• Developed, implemented and maintained Enterprise application architecture, process flow charts for Change Control Technical Review Board CCTRB meeting and the Change Control Board CCB meeting.
• Managed the consistent delivery of high-quality service defined by SLAs.
• Write, maintain, and files necessary system documentation and procedures by using the Agile Software Development Lifecycle SDLC
• Documented organizational policies, standards and best practices in application development, documentation, and maintenance support of Software Development Lifecycle SDLC following iterative development approach Rational Unified Process RUP .
• Managed project calendar and planned milestones, deliverables, activities to alert responsible staff and collaborators to ensure timely delivery of products and reports.

Confidential

Technical Lead/Oracle DBA-MySQL Database Administrator

• Overview: Client Commercial Driver's License Division CDL - Serve as a Sr. Oracle 10g database administrator and MySQL DBA providing database maintenances and support. Project lead on the symfony and PHP website development running on Red Hat Linux virtualization Servers.
• Migrated Oracle 10g database to MySQL database for CDL project.
• Migrated and upgraded Oracle MySQL databases from version 5.1 to version 6.5 MySQL database.
• Provided database management through the maintenance of data dictionaries, data models, and performance tuning.
• Coordinated and supervise database changes and tests.
• Prepared software requirement, specifications and prototypes for translation into structured application programs. Configured, debugged, integration test and document new applications. Created and enhancements of forms, reports, underlying logic and interface components on development projects as assigned.
• Assist database administrators, data administrators, quality assurance team, system engineers, and network engineers to ensure data integrity, consistency, security and privacy.
• Assisted project manager in estimating durations for tasks, deliverables and activities.
• Developed, configured and maintained Enterprise SharePoint document libraries including enterprise lists and site collections. Perform system administration activities such as site creation, user training, backup, restore and issue resolution.
• Involved in complete Software Development Life Cycle SDLC Requirement Specification, Requirement Analysis and Design, Coding and Testing, Deployment and Support.
• Managed product development, to ensure that change is managed, implemented, analyzed and released properly throughout the Software development Lifecycle SDLC .
• Performed database, web application security and user administration via roles level profile, privilege.
• Installed, design, deploy, configure and maintain MySQL database 6.5 server, to provide a highly available and scalable database.
• Provided all aspects of database administration including Installation, Patching, Tuning, Backup Recovery, Monitoring, SQL, PL/SQL, Shell scripting for Oracle MySQL database Server across the enterprise.
• Troubleshoot database issues and monitor transaction log, backups between multiple MySQL Servers and DR Sites.
• Performance security Patching and CPU application
• Optimize performance of data heavy applications through index management and query tuning.
• Assist in the development of software and tools that use effective schema to improve analyst and customer workflows.
• Managed contracts and relations with external developers and collaborators of FMCSA communicate with project partners on project goals, requirements, and scheduling of deliverables
• Managed project calendar and planned milestones, deliverables, activities to alert responsible staff and collaborators to ensure timely delivery of products and reports.
• Developed and managed project-related presentation materials.
• Respond to internal/external project information requests.
• Maintained project meeting minutes and related materials.

Confidential Project Lead /Senior Oracle Database Administrator

• Overview: Client Environmental Protection Agency EPA - Serve as a Project Lead and Sr. Oracle DBA providing schema development, system configuration and support for Apex application developers' in developing of the EPA Fuel applications.
• Serving as the primary DBA in both Microsoft and Linux environment, in charge with oracle Data Guard.
• Managed project calendar and planned milestones, deliverables, activities to alert responsible staff and collaborators to ensure timely delivery of products and reports.
• Developed and managed project-related presentation materials.
• Respond to internal/external project information requests.
• Maintained project meeting minutes and related materials.
• Implemented and modified table partitioning, using range-range, range-list partitioning.
• Created different tablespace to support the partition of data to improve performance and manageability.
• Managed contracts and relations with external developers and collaborators of EPA communicate with project partners on project goals, requirements, and scheduling of deliverables.
• Proposed, designed, and implemented of solutions, which adhere to best practices related to business objects in data architecture, standards, methodologies, and applicable tools.
• Provided technical expertise and actively participate in creating systems development, software, hardware, and application development standards, procedures and policies
• Monitor and tune database performance by monitoring users wait for response time, monitoring system to make sure it can keep-up with the speed business is conducted.
• Optimized hardware usage and reduce I/O issues. Make changes to database design, perform data partitioning to improve database performance to increase throughput and minimize contention to enable the largest possible workload to be processed on all databases.
• Perform memory, application, disk I/O tuning and eliminate database contention from table locks, latches and wait events
• Integrated Oracle database with Enterprise applications into an infrastructure integrate with BI tools such as Business Objects, Oracle Apex BI applications.
• Administrated and managed oracle 10g and 11g configured and setup web servers and infrastructure.
• Designed Oracle backup solutions using RMAN and recovery, disaster recovery, troubleshooting and installing of database information.
• Maintained redo logs and archive them to tape. Monitor alert log, trace files and audit logs.
• Performed database security and user administration via roles, profile, privilege, synonyms and auditing.
• Involved in performing SQL tuning, Oracle Bug fixes and patching Oracle application server, and database patching using Oracle oPatch.

Confidential

Senior Oracle Database Administrator / BI Admin-WebFOCUS

• Overview: Client Financial Management Service FMS - Governmentwide Accounting and Reporting Modernization is the system of record, replacing STAR, the current accounting system. The GWA Modernization project provides reliable, timely and useful information and streamlines the central accounting, reporting and reconciliation processes.
• Served as a Senior Oracle / DB2 DBA providing schema development, system configuration and support for application developers' in developing of the payment and processing applications.
• Designed and implement backup/recovery strategies for various database systems.
• Installed and configured Oracle 10g and 11g on Redhat, and AIX environment.
• Modified development database based on changes to application design. Relocated database instances from one server to another.
• Managed project calendar and planned milestones, deliverables, activities to alert responsible staff and collaborators to ensure timely delivery of products and reports.
• Refreshed test/development databases with production data.
• Duties include writing export/import, SQL Loader and data pump scripts for loading data to production and testing databases.
• Create data modeling for oracle databases ERD using Erwin for both Logical and physical database design.
• Implement views, triggers, and stored procedures for the database. Create SQL, PL/SQL scripts to pull data for reporting for GWA accountants and business analyst.
• Duties also included allocating system storage and planning future structures table spaces . Created primary objects tables, views, indexes, synonyms, etc... once application developers have designed an application. Enrolled users and maintained system security.
• Planned backup and recovery of database information. Maintained redo logs and archive them to tape. Monitor alert log, trace files and audit logs.
• Performed database security and user administration via roles, profile, privilege, synonyms and auditing.
• Managed contracts and relations with external developers and collaborators of FMS communicate with project partners on project goals, requirements, and scheduling of deliverables.
• Involved in performing SQL tuning.
• Provided services and supervision on all facets of production monitoring and support as well as development efforts in a dynamic data warehousing program.
• Install and configure Webfocus on to HP Unix Server.
• Support end user connects, Single Sign-On SSO and WebFOCUS a business Intelligence BI application.
• Create metadata connection to Oracle, Sybase, DB2 Databases for data sources.
• Configure Single sign on SSO for end users to access the Business Intelligence Portal.
• Develop and build financial reports using WebFOUS Developer Studio and Report Assistant.
• Implement any modifications to WebFOCUS to improve efficiency, reliability, and performance
• Design and develop dashboards and reports using WebFOCUS
• Create ad-hoc reports and use WebFOCUS for business analysis.
• Analyze, design, and develop system enhancements to meet FMS business requirements.
• Develop and maintain stored procedures, triggers, views used to display reports.
• Respond to internal/external project information requests.
• Maintained project meeting minutes and related materials.

Confidential

Project Lead Evening Shift Manager

• Overview: NOAA Fisheries Office for Law Enforcement provides enforcement of laws that protect and conserve living marine resources and their natural habitat. The database System and front-end application Vessel Monitoring System VMS - SMARTRAC , tracks vessels positioning and provides agents with this information. Applications Managed - Oracle 10g RAC, SQL Loader, Data Pump, Oracle Grid Control, Microsoft SharePoint Server, SharePoint Portal, Microsoft SMS, Microsoft Exchange Server, VPN Terminal Server, ArcGIS Server , ,Microsoft Project, Microsoft Visio. OS: RedHat and Window 2003, 2008 Servers and Microsoft SQL Server.
• Installed, configured and deployed 2 sets of 2 Node Oracle 10gR2 10.2.0.1 RAC environment running on Windows 2003 servers.
• Configured Oracle Enterprise Manager to support and manage RAC database. Applied patches 10.2.0.3 to RAC environment to resolve issues with Oracle EM DB control.
• Configured Oracle 10g Streams Replication to capture and replicate data from NOAA offices in Silver Spring, MD to NOAA offices in Seattle, Washington office and distribute feeds to all NOAA regional offices.
• Installed and configured Oracle OCFS2, created partitions on Shared Disk Storage to accommodate CRS Voting disk, CRS Oracle Cluster Registry and OCFS for Oracle database files/redo logs, control files and spfile.ora.
• Setup STRMADMIN user, capture, and apply queues, db links and propagation processes. Instantiated objects using SCN flashback/export/import process.
• Configured and perform RMAN backups and recovery, import exports, setup Streams BI-DIRECTIONAL Replication.
• Perform daily monitoring of streams replication to verify data loads are synchronized within all NOAA regional environments.
• Setup RMAN for Backup and Flush recovery area.
• Responsible for systems availability, reliability, and data integrity of infrastructure services to include, Oracle databases, SQL Databases, SharePoint Portal, Terminal Services/Remote Desktop Services, DNS, DHCP, WINS, File, Print and Web/Application servers.
• Supported, administer, troubleshoot, and configured, system security, installation, deployment, maintenance, and high availability design for Enterprise SharePoint Server.
• Enforced SharePoint best practices and optimization, site creation, user training, ensuring proper backups and restores as necessary.
• Created and designed change control procedure been used by Office for Law Enforcement.
• Installed, configured and deployed SQL Servers on different environment running Windows 2003 servers, Windows 2008. Configured, designed and documented Server Automation.
• Managed Window Systems Management tools used to monitor the network, Monitored Systems and build Standards. Setup RMAN for Backup and Flush recovery area.
• Designed and updating Disaster Recovery policies and procedures for DR sites.
• Translated client requirements and customer requests into viable products using effective change and configuration management
• Respond to internal/external project information requests.
• Maintained project meeting minutes and related materials.

Confidential

Team Lead Windows System Administrator SQL Server Database Administrator

• Overview: Homs Home Ownership Management System is a web based ColdFusion application, developed in-house using ColdFusion. This is a system for electronic Client submission of personal information to be reviewed by a HUD-approved nonprofit homeownership counseling organization.
• Provided long-range capacity and requirements planning and played key role in the design, development and implementation of high availability solutions for the HOMS Application.
• Application Server Administrator providing day to day upkeep of SQL databases.
• Provide technical and operational network support to the HomeFree-USA clients and employees.
• Administer windows 2003 domain controller, windows 2003 exchange server, windows 2000 terminal server, DHCP server and windows 2003 backup server. Troubleshooting all servers, SQL database
• Manage HomeFree-USA website and SQL database backend database server.
• Maintain and improve existing TCP/IP network infrastructure at our branch.
• Perform regular backup of the entire network using VERITAS Exec 11d, and 12 Tape Backup.
• Monitors and tunes the systems to achieve optimum performance levels.
• Perform SQL Database performance tuning, database and applications patches.