Oracle Database Administrator / MS SQL Administrator/Software Engineer
Hewlett Packard Philippines
Total years of experience :25 years, 11 Months
Currently supporting the ORTEC MS SQL server dba jobs and file handling operations. Currently innovating and automating procedures and applications that will reduce the time to troubleshoot or analyze the problem or workaround. Currently ITILv3 Certified. Creates and maintains all databases required for development, testing, education and production usage.
Performs the capacity planning required to create and maintain the databases. The DBA works closely with system administration staff because computers often have applications or tools on them in addition to the Oracle Databases.
Performs ongoing tuning of the database instances. Install new versions of the Oracle RDBMS and its tools and any other tools that access the Oracle database.
Plans and implements backup and recovery of the Oracle database. Controls migrations of programs, database changes, reference data changes and menu changes through the development life cycle. Implements and enforces security for all of the Oracle Databases. Performs database re-organizations as required to assist performance and ensure maximum uptime of the database. Puts standards in place to ensure that all application design and code is produced with proper integrity, security and performance. The DBA will perform reviews on the design and code frequently to ensure the site standards are being adhered to.
Evaluates releases of Oracle and its tools, and third party products to ensure that the site is running the products that are most appropriate. Planning is also performed by the DBA, along with the application developers and System administrators, to ensure that any new product usage or release upgrade takes place with minimal impact.
Provides technical support to application development teams. This is usually in the form of a help desk. The DBA is usually the point of contact for Oracle Corporation. Enforces and maintains database constraints to ensure integrity of the database. 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.
Create new database users as required. Manage sharing of resources amongst applications. The DBA may have the ultimate responsibility for the physical database design. Install, patch and maintain all Oracle software, tune all Oracle instance components including SQL and PL/SQL, approve all production schema changes, approve changes to database design, control all migrations of Oracle schema objects, design and implement a backup & recovery system and implement Oracle failover technology
Coordinates and clarifies with the OLA (Operational Level Agreement) and SLA (Service Level Agreement) with the SLM (Service Level Manager), process owner and other higher level job admin delegations
Troubleshoot and resolve application specific database incidents escalated by support teams ad drive problem management by initiating root cause analysis and implementing permanent fixes to problems. Tune and optimize database performance and perform regular database maintenance activities. Review and execute application specific database routine service requests and conduct application specific DBA trainings and/or qualification exams
Participate in CAB or change management meetings and provide inputs to database related changes Participate in design review meetings and provide recommendations to database related changes. Provide consultancy to other HP support team on application specific database related matters. Create and submit regular DBA service reports to designated individuals/groups. Create, review, maintain, and deploy DBA documentations (e.g. KEDB, Data Model, and other technical database documents)
Application DBA focuses on database design and the ongoing support and administration of databases for a specific application or subset of applications
Application DBA writes and debugs complex SQL and understands the best ways to incorporate database requests into application programs. Application DBA performs database change management, performance tuning, and most of the other roles of the DBA and better focus on an individual application, which can result in better service to the developers of that application.
Application DBA is more often viewed as an integral component of the development team and therefore is better informed about new development plans and changes. Because the application DBA works consistently on a specific set of applications, he can acquire a better overall understanding of how each application works, enabling him to better support the needs of the application developers with a more comprehensive understanding of the application, an application DBA will have a better understanding of how the application impacts the overall business. This knowledge will likely result in the execution of DBA tasks to better support the organization.
Application DBA understands the details and nuances of SQL coding for performance and be able to design databases for performance. A performance analyst will have very detailed technical knowledge of the DBMS so that he can make appropriate changes to DBMS and system parameters when required. The performance analyst must be able to speak to application developers in their language in order to help them facilitate appropriate program changes for performance. Application DBA is usually the most skilled, senior member of the DBA staff, a role that he has grown into due to his experience and the respect he has gained in past tuning endeavors.
Troubleshoot and resolve application specific database incidents escalated by support teams ad drive problem management by initiating root cause analysis and implementing permanent fixes to problems
Tune and optimize database performance and perform regular database maintenance activities. Review and execute application specific database routine service requests and conduct application specific DBA trainings and/or qualification exams
Participate in CAB or change management meetings and provide inputs to database related changes Participate in design review meetings and provide recommendations to database related changes
Provide consultancy to other HP support team on application specific database related matters. Create and submit regular DBA service reports to designated individuals/groups. Create, review, maintain, and deploy DBA documentations (e.g. KEDB, Data Model, and other technical database documents)
Coordinate with System DBA group in resolving database infrastructure issues and Interface with 3rd party vendor for technical support. Work as a member of a 24x7 DBA operations team
Provides DBA monitoring activities such as UNIX file-system monitoring, backup space monitoring, oracle table-space and datafile monitoring, oracle session and long-operation monitoring, RMAN backup monitoring, reseting of Oracle user password(s) in ORACLE database8i/9i/10g and Application11i TOAD and Oracle Apps.
Provides DBA RMAN backups activities such as incremental and full backup using *.sh scripts and editing the status and configuration of the backup. Provides DBA support activities in the technical tech team such as error solving of DBA Problems and gathering of everyday process.
System Monitoring of Oracle Database in Development, Quality Assurance, Production mostly in server environment in UNIX and system Monitoring of Non-ORACLE Application such as Cognos, Innovis, Vastera and Shareplex. File system and Tablespace Monitoring during shifts Development, Quality Assurance, Production mostly in server environment in UNIX.
Collaboration with the fellow DBA(s) and SENIOR DBA(s) in terms of assistance and job delegation
Creating work plan process and procedures and training the newly hired DBA(s) in ORACLE familiarization and DBA activity. ORACLE Dataguard Monitoring / Rebuilding
Troubleshoot and resolve application specific database incidents escalated by support teams ad drive problem management by initiating root cause analysis and implementing permanent fixes to problems. Tune and optimize database performance and perform regular database maintenance activities. Review and execute application specific database routine service requests and conduct application specific DBA trainings and/or qualification exams
Participate in CAB or change management meetings and provide inputs to database related changes Participate in design review meetings and provide recommendations to database related changes Performs the capacity planning required to create and maintain the databases. The DBA works closely with system administration staff because computers often have applications or tools on them in addition to the Oracle Databases.
Performs ongoing tuning of the database instances. Install new versions of the Oracle RDBMS and its tools and any other tools that access the Oracle database. Evaluates releases of Oracle and its tools, and third party products to ensure that the site is running the products that are most appropriate. Planning is also performed by the DBA, along with the application developers and System administrators, to ensure that any new product usage or release upgrade takes place with minimal impact.
Provides technical support to application development teams. This is usually in the form of a help desk. The DBA is usually the point of contact for Oracle Corporation. Enforces and maintains database constraints to ensure integrity of the database. 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.
Create new database users as required. Manage sharing of resources amongst applications. The DBA may have the ultimate responsibility for the physical database design. Install, patch and maintain all Oracle software, tune all Oracle instance components including SQL and PL/SQL, approve all production schema changes, approve changes to database design, control all migrations of Oracle schema objects, design and implement a backup & recovery system and implement Oracle failover technology
Analyses batch performances, session’s locks and most DBA tasks. Collaborates with the on-shore DBA, Managers and Application Developers regarding with the batch problems, server problems, and oracle errors. Providing primary and secondary support during weekends.
Consults with the team members about Platform patches, Security updates and critical DBA task requested by the on-shore. Provides DBA operations and DBA activities in the "PeopleSoft Enterprise HRMS and Student Administration Australia 7.6 to HRMS and Campus Solutions 8.9MP1 Upgrade"
Provides DBA operations and DBA activities in the "PeopleSoft Enterprise HRMS and Campus Solutions 8.9 Maintenance Pack 1 to 9.0 Upgrade"
Provides DBA monitoring activities such as UNIX file-system monitoring, backup space monitoring, oracle table-space and datafile monitoring, oracle session and long-operation monitoring, RMAN backup monitoring, reseting of Oracle user password(s) in ORACLE database8i/9i/10g and Application11i TOAD and Oracle Apps.
Provides DBA RMAN backups activities such as incremental and full backup using *.sh scripts and editing the status and configuration of the backup. Provides DBA support activities in the PEOPLESOFT technical tech team such as error solving of DBA Problems and gathering of everyday process.
System Monitoring of Oracle Database in Development, Quality Assurance, Production mostly in server environment in UNIX and system Monitoring of Non-ORACLE Application such as Cognos, Innovis, Vastera and Shareplex. File system and Tablespace Monitoring during shifts Development, Quality Assurance, Production mostly in server environment in UNIX.
Collaboration with the fellow DBA(s) and SENIOR DBA(s) in terms of assistance and job delegation
Creating work plan process and procedures and training the newly hired DBA(s) in ORACLE familiarization and DBA activity. ORACLE Dataguard Monitoring / Rebuilding and HP Data Protector Backup and ORACLE RAC ( Real Application Clusters). Coordinating SLA Tickets such as Remedy, Clarify, SUGAR CRM and other ticketing system.
System Monitoring of Oracle Database in Development, Quality Assurance, Production mostly in server environment in UNIX and system Monitoring of Non-ORACLE Application such as Cognos, Innovis, Vastera and Shareplex. File system and Tablespace Monitoring during shifts Development, Quality Assurance, Production mostly in server environment in UNIX.
Collaboration with the fellow DBA(s) and SENIOR DBA(s) in terms of assistance and job delegation. Creating work plan process and procedures and training the newly hired DBA(s) in ORACLE familiarization and DBA activity. ORACLE Dataguard Monitoring / Rebuilding. Focuses on database design and the ongoing support and administration of databases for a specific application or subset of applications.
Analyzes and debugs complex SQL and understands the best ways to incorporate database requests into application programs. Application DBA performs database change management, performance tuning, and most of the other roles of the DBA and better focus on an individual application, which can result in better service to the developers of that application. DBA is more often viewed as an integral component of the development team and therefore is better informed about new development plans and changes. Because the application DBA works consistently on a specific set of applications, he can acquire a better overall understanding of how each application works, enabling him to better support the needs of the application developers with a more comprehensive understanding of the application, an application DBA will have a better understanding of how the application impacts the overall business.
Supporting the SQL Server databases and ensuring their performance, availability and security
Ensuring availability and performance of the databases that support the system.
Ensuring that the associated hardware resources allocated to the databases and to ensure high resilience and performance tuning. Proactively monitor the database systems to ensure secure services with minimum downtime (both SQL Server and Oracle interface).
Responsible for providing trend analysis to management team to enable them to make informed decisions regarding resource management. Troubleshooting and problem solving of SQL Server Issues, improvement and maintenance of the databases to include rollout and upgrades. Backup/restore tasks, job monitoring, replication management, DTS/SSIS development, performance optimization tasks and efforts.
Converting mysql database / php web application into ms sql 2000 database / asp.net vb.net application
Taught students/clients a wide IT Courses such as Visual Basic 6.0 / .Net, Visual C++ 6.0 / .Net, Visual C#.Net, C, C++, Assembly, Oracle PL/SQL, ASP, ASP.Net, JAVAScript, VBScript, Visual Foxpro 6.0, Discreet 3D Studio MAX 6.0, Adobe Photoshop 7.0, Microsoft FrontPage 6.0 & Macromedia Flash MX/ DreamWeaver MX and other computer courses.
Serves as a SYSTEM CONSULTANT/ADVISER to clients, who are working to companies from small to large firms such as DEVELOPMENT BANK OF THE DATA CENTER INC., ePDS Inc., PHOENIX ELECTRONICS EQUIPMENT RENTAL SERVICES, PRU LIFE U.K., MARITIME RESOURCES MANAGEMENT LTD and many more which includes inquiries to the new/existing system, making real-time applications by applying to the course outline when it comes to theoretical/technical aspects, deals with customer with consultant suggestions and right solutions
Oracle Database 8i Installation, Oracle Database 9i Installation, Oracle SQL Configuration. Analyses batch performances, session’s locks and most DBA tasks.
Oracle 6.0 Forms & Report, Technical Installation of Lotus Notes Client-Server, Alchemy and other Client-Server Configurations, import and export of dump file(s) and monitoring of VERITAS backups.
Job monitoring and developer support. The duties of an assistant database administrator are the technical features and capabilities of the database management systems (DBMS) being administered and including disaster recovery (backups and testing of backups), performance analysis and tuning, and database design or assistance thereof. Hardware preventive maintenance and troubleshooting, software installation and collaborated with IT personnel with every issues, process or procedures.
Collaboration with the fellow DBA(s) and SENIOR DBA(s) in terms of assistance and job delegation. Creating work plan process and procedures and training the newly hired DBA(s) in ORACLE familiarization and DBA activity. ORACLE Dataguard Monitoring / Rebuilding. Focuses on database design and the ongoing support and administration of databases for a specific application or subset of applications. Collaboration with the fellow DBA(s) and SENIOR DBA(s) in terms of assistance and job delegation
Provides technical support to application development teams. This is usually in the form of a help desk. The DBA is usually the point of contact for Oracle Corporation. Enforces and maintains database constraints to ensure integrity of the database. 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. Evaluates releases of Oracle and its tools, and third party products to ensure that the site is running the products that are most appropriate. Planning is also performed by the DBA, along with the application developers and System administrators, to ensure that any new product usage or release upgrade takes place with minimal impact.
Installing and configuring computer hardware operating systems and applications, monitoring and maintaining computer systems and networks.
Talking staff or clients through a series of actions, either face to face or over the telephone to help set up systems or resolve issues. Deliver service and support to end-users using and operating automated call distribution phone software, via remote connection or over the Internet
Interact with customers to provide and process information in response to inquiries, concerns, and requests about products and services
Troubleshooting system and network problems and diagnosing and solving hardware or software faults replacing parts as required. Diagnose and resolve technical hardware and software issues involving internet connectivity, email clients, IPTV, VOIP and more. Testing and evaluating new technology and conducting electrical safety checks on computer equipment.
Providing support, including procedural documentation and relevant reports following diagrams and written instructions to repair a fault or set up a system supporting the roll-out of new applications setting up new users' accounts and profiles and dealing with password issues. Gather customer’s information and determine the issue by evaluating and analysing the symptoms, research required information using available resources, follow standard processes and procedures
Responding within agreed time limits to call-outs and working continuously on a task until completion (or referral to third parties, if appropriate) prioritizing and managing many open cases at one time rapidly establishing a good working relationship with customers and other professionals, e.g., software developers
Identify and escalate priority issues
Improved a website from an existing company website, installing software applications to company client’s such as schools and institution, computer hardware maintenance/troubleshooting making as a preventive maintenance, providing technical assistance to the office personnel, company school clients and backup-teaching in schools and institution.
Installing and configuring computer hardware operating systems and applications, monitoring and maintaining computer systems and networks.
Talking staff or clients through a series of actions, either face to face or over the telephone to help set up systems or resolve issues. Deliver service and support to end-users using and operating automated call distribution phone software, via remote connection or over the Internet
Interact with customers to provide and process information in response to inquiries, concerns, and requests about products and services
Troubleshooting system and network problems and diagnosing and solving hardware or software faults replacing parts as required. Diagnose and resolve technical hardware and software issues involving internet connectivity, email clients, IPTV, VOIP and more. Testing and evaluating new technology and conducting electrical safety checks on computer equipment.
Desktop Publishing, Data Recording, Customer Relations, Programming, Computer Maintenance, Software Hardware Consultancy, Web Designing & Internet Tutorial.
Installing and configuring computer hardware operating systems and applications, monitoring and maintaining computer systems and networks.
Talking staff or clients through a series of actions, either face to face or over the telephone to help set up systems or resolve issues. Deliver service and support to end-users using and operating automated call distribution phone software, via remote connection or over the Internet
Interact with customers to provide and process information in response to inquiries, concerns, and requests about products and services
Troubleshooting system and network problems and diagnosing and solving hardware or software faults replacing parts as required. Diagnose and resolve technical hardware and software issues involving internet connectivity, email clients, IPTV, VOIP and more. Testing and evaluating new technology and conducting electrical safety checks on computer equipment
College Degree