| Confidential Sr. Oracle DBA Work on Logical and Physical Database Design Model diagrams for esMD project. esMD is an information technology system which facilitates the delivery of electronic medical documentation from a Medicare Provider to a Medicare Contractor. - Participate in the design, create, and maintenance of Oracle relational database.
- Work on Logical Database Design for database model diagrams.
- Write SQL scripts to create database tables, indixes , triggers, sequences, and public synonyms for database Physical emplementation.
- Support development team in emplementing changes.
- Administers all database objects, including tables, clusters, indexes, views, sequences, packages and procedures.
- Assists with impact analysis of any changes made to the database objects.
- Troubleshoots with problems regarding the databases, applications and development tools.
Confidential Sr. Database Applications DBA - Play the same roles and perform the same duties as I was employed by the Unisys Corporation from June 2007 May 2009, including the followings:
- Install, upgrade, clone, patch Oracle 10g databases, Oracle 10g RAC databases, Oracle 11i Business Suites and Oracle J2EE Application servers, and Oracle SSO/OID servers and OID database on Solaris 10 platforms
- Perform on-call duty to manage, trouble-shoot, and support a production system consisting of multi-terabyte Oracle 10g databases, Oracle Application Servers/Weblogic Servers, and Oracle 11i E-Business Suites, SSO/OID servers on a rotational and 24X7 basis
- Install, configure, and tune Oracle 32-bit 10g on Windows 2003
- Upgrade Oracle 32-bit 10g Windows 2003 to Oracle 64-bit 10g Windows 2003 x64
- Install, configure, and tune Oracle 64-bit 10g on Windows 2003 x64
- Installed/configured Oracle 10g RAC/ASM on Linux Redhat 2.6
- Trouble-shoot and performance-tune the Oracle 10g databases via Enterprise Manager, AWR, ADDM, ASH report utilities, sql developer, TOAD and other techniques and utilities
- Plan/Clone pre-production environment from production including Oracle 10g databases, Oracle J2EE applications, and Oracle E-Business Suites 11i all tiers , SSO/OID Servers, Oracle BI, Oracle Discverer, SOA/BPEL servers, OBIEE servers
- Manage, trouble-shoot, and support pre-production environment including Oracle 10g databases, Oracle J2EE applications, and Oracle E-Business Suites 11i all tiers , SSO/OID Servers, Oracle BI, Oracle Discverer, SOA/BPEL servers, OBIEE servers
- Plan/Clone development environment from production consisting of Oracle Application Servers, SSO/OID servers, and E-Business Suites 11i all tiers
- Manage, support, and trouble-shoot development environment consisting of Oracle 10g/11g databases, Oracle EBS, Oracle J2EE applications, SSO/OID servers.
- Plan, deploy, configure, performance-tune Oracle 10g, 11g database, and J2EE applications and E-Business applications
- Integrate and configure Oracle E-Business Suites and Oracle J2EE applications with Oracle SSO/OID servers
- Install, configure, and manage Foglight for Application Monitoring
Confidential Sr. Database Administrator - Provide day to day support for Oracle 10g Database and Applications servers, Web Cache, Load Balancer in the mission critical 7X24 production environment with Oracle Automatic Storage Management ASM and Oracle RAC using Grid Control and Solaris 10 Operating System.
- Support daily Data Ware House oracle database operations and synchronization jobs from PeopleSoft System. Clone, setup and refresh Dataware House database production, development and test environment using rman.
- Support Disaster Recovery System using ASM and RAC.
- Perform oracle database backup, restore and database cloning using Rman.
- Responsible for daily database and application performance tuning, database security hardening, quarterly critical patch and psu updating.
- Responsible for Oracle Software installation, Oracle Grid Control installation, configuration, upgrade, Oracle RAC and ASM intallation, configuration, oracle database cloning, database configuration, data upload and trouble shooting for rdbms, crs and asm.
- Support capacity planning of the enterprise infrastructure, including planning for upgrade or growth of existing environment s and reviews/establishes risk assessment and change control procedures.
- Install and configure Quest Software to mornitor database instances, application operations and performance analysis using foglight.
- Design, install and configure oracle Information Life Cycle Management System.
- Install and Configure Oracle Data Warehouse Builder OWB and migrade data to the data warehouse.
Confidential Sr. Database Applications DBA - Provide day to day support for Oracle 11i Applications, Oracle Applications servers, Web Cache, Load Balancer, Oracle Internet directory single sign on , Oracle 9i and 10g databases in the mission critical 24/7 production environment
- Maintains Oracle Application Server 10g with Oracle E-Business Suite Release 11i
- Use dmctl and opmnctl utilities to monitor, deploy, create OC4J containers for 10gAS application
- Migrated several databases size 500GB -1.2TB and Applications to new servers using RMAN.
- Evaluates new releases of Oracle and its tools, and third party products to ensure that the site is running the products that are most appropriate.
- Developed and implemented project plan to migrate and upgrade oracle database 9.x to 10g and Oracle application server 10gR2 9.0.4 to 10.1.2 , cloning/refreshing instances from production to testing or development environment.
- Define Database Backup, Recovery and Disaster Recovery procedures using RMAN, flashback and guarantee restore point.
- Install and support Oracle database, Oracle application servers, WebCache, Portal, Single Sign On, Oracle Discoverer, Oracle Reports and third party hosted applications under multiple server setups, for development, test and production environments.
- Use AD utilities including adpatch, adadmin, autoconfig, etc for maintaining Oracle 11i Apps.
- Apply CPU Patches to Oracle E-Business Suite Databases and Applications.
- Install, upgrade and configure Oracle Application Express 2.2-3.01
- Install and Configure Oracle Grid to monitor all production databases and applications.
- Ensure service availability by proactively monitoring log entries, disk usage, memory usage, CPU utilization, network bandwidth, and other resources.
- Support capacity planning of the enterprise infrastructure, including planning for upgrade or growth of existing environment s and reviews/establishes risk assessment and change control procedures.
- Hardening Oracle environnements per TSA database Security auditing recommendations.
- Monitor and maintain multiple database instances development, test and production , tablespace structure and application file systems, archiving and managing concurrent programs. Maintain and monitor Oracle database environment using Oracle grid control and quest foglight
- Assist with establishing policies and procedures pertaining to database management, security, maintenance and utilization.
- Provide DBA support in the areas of performance tuning, bug fixing, capacity planning, connectivity issues and data management for all environments
- Provides comprehensive technical advice and consultation to senior management officials concerning the effective use and management of computer systems and databases.
- Implements technology upgrades, reviews and evaluates new system design, analyzes oracle and other associated code in ensure that when implemented meets Agency standards.
- Responsible for working with application developers, system administrators and management to ensure that any new product usage or release upgrade takes place with minimal impact on test and production environments
- Participate in various technical discussions, technical architecture overviews/strategies, and technology recommendations to various clients.
- Maintain documentation of all production policies, procedures, server configurations, error logs, maintenance records and product troubleshooting instructions
- Carry on Call Blackberry for emergency production support.
Confidential SR. ORACLE DATABASE APPLICATION CONSULTANT - Maintained Oracle Application Server 10g with Oracle E-Business Suite Release 11i
- Provided day to day support for mission critical databases and multi application environments
- Led in Planning and Setting up 10g databases for Flashback guaranteed restore point
- Performed code deployment to development, test and production environments
- Led performance monitoring and fine tuning of the system for optimal performance and proactively plan and manage all aspects of Oracle database
- Plan and implement the backup and recovery procedures for the Oracle applications systems
- Setup, upgrade and maintain Oracle 10g Grid Control.
- Performed database troubleshooting and tuning using ADDM, AWR Report and Statpack
- Identify, troubleshoot, resolve, document and communicate issues that affect the systems, servers and database related products.
Confidential Oracle DBA Team Lead Duties and responsibilities are the same as in Dynamics Research Corporation as below Same projects and same customer due to Lockheed Martin took over DRC's project with AFIS . Confidential Oracle DBA Team Lead - Lead and manage the project of establishing and maintaining database backup and disaster Recovery Planning and implementation with Veritas Netbackup, include designing and configuring mission critical backup and recovery strategy using Oracle Data Guard for the 7x24 production system.
- Coordinate project processes and controls for data projects, including define new requirements in managing and coordinating technical aspects of data and database analysis design, development/migration, build and testing managing logical database design and physical implementation for development and production advising Program leadership issues - both realized and contingent - that impact, or will possibly impact the program, and recommending solutions to problems such as issues surrounding database management and administration
- Develop a well-documented procedure for software installation, standby database setup, and geographic switchover. The successful completion of this project resulted in high software quality, smooth production processes, and significant cost savings on consulting services from the software vendor.
- Manage a performance enhancement project, and led a development team to identify performance bottlenecks, analyze existing design and implementation for business requirements, and design a new data uploading/downloading process using PL/SQL and JAVA. Over the course of this special assignment, I was responsible for planning the work schedules for three DBAs/Unix Administrators and five developers, establishing deadlines and priorities, and reallocating work load based on time frames. As a result of this project, the performance of the data loading process was improved by nearly one hundred fold and the project was completed and passed the client acceptance test on time. This is used to convert data from multiple existing data systems to a single enterprise system
- Managed Oracle 9i 10g Databases, Sun Solaris systems, Oracle 9i Data Guard, Oracle 10g Grid Congrol, Oracle Enterprise Manager and Oracle Recovery Manager for the development of pre-production and production environment.
- Oversee database and unix operating system staff, duties include to train junior database administrators, allocate workload to staff and supervise their performance to ensure all works and performances are done in accordance with the DOD System and Database Security Standards and Implementation Guidelines STIG and performance requirements implementing and maintaining database security and database availability and troubleshoot
- Assigned as a Database Team Lead on multi platforms such as UNIX HP and Solaris and NT to support multi-tier applications using JSP, WEBLOGIC, and COLDFUSION. Main duties are to manage designing, developing, implementing, and tuning of databases for DoD organizations such as Office of Assistant Secretary of Defense OASD PA and American Forces Information Service AFIS . Activities involved:
- Received A Certification of Appreciation on the Operation Enduring Iraqi Freedom issued by Victoria Clarke, Assistant Secretary of Defense for Public Affairs, Department of Defense, January, 2003
- Received the DRC Outstanding Service Award for Database Support and Data Recovery in May 2003 and October 2004, respectively.
Confidential Oracle DBA/Senior Test Engineer Working as Oracle Database Administrator on multi platforms using JSP, CORBA, and EJB. Activities include installing software, designing and creating oracle database, configuring Oracle network to achieve failover and load balance installing and configuring database to support Oracle ConText/Video or interMedia servers logical database design and physical implementation and application testing data extraction and load routines migrating databases from multi-platforms to HP/Solaris Unix and NT for oracle 8i 9i database backup and disaster Recovery Planning and implementation database performance tuning database sizing and data archiving and interfacing with users and developers to define new requirements maintaining system security and database availability, and troubleshooting. Confidential System Engineer/DBA Worked as a contractor to support National Cash Register's NCR Enterprise Data Distribution EDD Update. EDD is a set of Postal Service national files that support Point of Service POS ONE. EDD data files are passed to the POS ONE systems in the field according to a schedule defined by the POS ONE Program Office. My duties included providing technical support to maintain database operation and ensure a high level of database integrity enrolling users, maintaining system security and database availability. Patch adding/modifying, backup, recovery, and conducting performance turning comparing the data files using stored procedures, testing to confirm data are successfully updated so that they are either maintained or tracked by the United States Postal Office USPS oracle database. Confidential System Analyser/Team Lead - Participated in the various phases of the system development life cycle, supporting the development and modification of utilities for data population. PVCS Tracker was being used to document and track problem reports. Worked with project managers and production managers to ensure database performance quality.
- Performed system requirement analysis, data analysis data conversion mapping by developing Testability Assessment Report TAR . Designed test data by developing Test Plan. Implemented test data by executing Test Scripts, and reported test results by writing Test Reports. Performed validation on the software quality and accuracy of data conversion for migration of Legacy data to a modernized object-oriented relational database system Oracle 8 .
- Assigned in QA team as a Team Lead to work on the CRD Modernization large project Central Registration Depository for the National Association of Securities Dealers Regulation NASD-R . The CRD system is a redesign of the current system that provides registration and licensing of NASD member firms and their representatives in the securities industry.
|
Privacy Policy
