1 / 21

CISB 314 –Database 2

CISB 314 –Database 2. Data and database administration. Database administrator. Here are the monthly salaries for DBA. DBA salary. Tan Chong & Sons Motor Co. Sdn Bhd. DBA Assistant Kuala Lumpur - Jalan Ipoh Responsibilities:

lapis
Download Presentation

CISB 314 –Database 2

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. CISB 314 –Database 2 Data and database administration

  2. Database administrator

  3. Here are the monthly salaries for DBA

  4. DBA salary

  5. Tan Chong & Sons Motor Co. SdnBhd • DBA AssistantKuala Lumpur - Jalan Ipoh • Responsibilities: • Manage – Both Oracle DB and SQL Server - support in the area in supporting to DB Administrator and also Tan Chong Database requirement. • Systems Delivery – Responsible for change management, administrator for SQL Server and Oracle, timely patch management, deployment of business systems. Conduct post-implementation reviews and recommend continual improvements. • IT Governance – Ensuring, enforcing and Compliance to IT policy and procedures. • User Management – Ensuring and maintenance of the users access to the Database system. • Requirements: • Candidate must possess at least a Degree in Computer Science / IT or equivalent. • A minimum of 2 years working experience in process definition, analysis, design and implementation. • In-depth domain knowledge in operations, planning, services and customer support preferably in the automotive industry. • Ability to work under time pressure, manage multiple groups of users while maintaining a positive and patient attitude. • Excellent command of both written and spoken English. • Self motivated with attention to detail. • Organizes own workload, sets priorities and works within deadlines. • Excellent organization, communication and interpersonal skills. • Ability to process assignments in an efficient, accurate and timely manner. • Able to work with minimum supervision, as well as able to contribute to team development. • People and results oriented and committed with a strong sense of urgency. • Professional certification in IT or customer service will be an added advantage.

  6. T-Systems Malaysia SdnBhd • Oracle DBA (Data Administrator) • Kuala Lumpur – Cyberjaya • Responsibilities: • Working on a team of 5 professional Oracle DBAs (database administrators), you participate in the support and development of the nearly 120 Oracle based applications within the organization and globally as well. Oracle based applications are mostly downstream with some corporate systems. Oracle has been the strategic DB toolset, and there are some non-critical implementations of SQL Server. • Key activities as part of this role on the team include:Administration, tuning, installation, upgrading, data management and security of the Oracle databases. • Consulting functions, working with a variety of IT teams implementing Oracle based applications (Group developed, in-house developed and vendor purchased). • Participate in pager rotating Oracle support team (5 members), which includes 7x24 for currently 3 database instances supporting highly critical business functions. • Rotate with other members on Support or Projects. • Skills: UNIX, Oracle, SQL

  7. AmBank • Database Administrator (Technical Services) • Responsibilities: • The Database Administrator is responsible to support and maintain databases on open system platform of AmBank Group. The incumbent will also manage the IT implementation / maintenance of the bank’s key and strategic business initiatives and projects • Provide database administration services to users, operation support and projects • Maintains an efficient of database system as to ensure maximum uptime of application system as expected in service level agreement • Key person in troubleshooting, maintaining and ensuring that the technical components of the system are integrated to provide maximum efficiency • Perform variety of tasks, which include feasibility studies, system reviews, security assessments and long-term planning • Provide technical consultancy to application developers and users • Develop technical enhancement and documentation on database aspect for project deployment and operation • Requirements: • Candidate must possess at least a Bachelor's Degree or Professional Degree in Computer Science/Information Technology or equivalent (CGPA at least 3.00) • Possess at least 2 years extensive hands-on experience in Oracle, DB2 (LUW) or Sybase RDMS. Certified with Oracle (OCP), DB2 or Adaptive Server Enterprise Administrator is an advantage • Knowledge in other RDMS such as MS SQL, MY SQL and PostgreSQL would be an added advantage • Comprehensive knowledge of the database programming environments, including optimization, tuning and application interfaces • Candidate must possess good communication skills, negotiation skills, problem-solving, analytical skills and ability to work under pressure (tight deadlines) • Able to work independently with minimum supervision

  8. Other job advertisements • Ventyx • Database Administrator • Requirements: • 3 - 5 years experience in SQL Server Database Administration. • 1 - 2 years experience in Oracle Database Administration. • Skilled in a scripting language (ie. UNIX shell, Perl, etc). • NT Administration skills. • Formal training in database theory, (ie. IT degree or diploma from a recognised institution) • Industry certifications. • Experience in one or more of the following an advantage: DB2 database administration, PostgreSQL database administration, UNIX administration, Zenoss administration. • GenesisHInfotech (M) SdnBhd • Database Administrator • Skill & Requirement Sets: • Needs SQL, MYSQL, Oracle 9i and 10g, Access, Tomcat and Appache experience. • At least 5 year(s) of working experience in the related field is required for this position. • Full-Time position available.

  9. Data Quality

  10. Learning Outcomes • At the end of this lecture, you should be able to: • Define terms • Describe importance and goals of data governance • Describe importance and measures of data quality • Define characteristics of quality data • Describe reasons for poor data quality in organizations • Describe a program for improving data quality

  11. Data Governance • Data governance • A set of processes and procedures aimed at managing the data within organization. • To achieve high-level objectives such as availability, integrity and compliance with regulations. • Data steward • A person responsible for ensuring that organizational applications properly support the organization’s goals for data quality.

  12. Requirements for Data Governance • Sponsorship from both senior management and business units • A data steward manager to coordinate data stewards • Data stewards for different business units, subjects, and/or source systems • A governance committee to provide data management guidelines and standards

  13. Importance of Data Quality • Minimize IT project risk • Make timely business decisions • Ensure regulatory compliance • Expand customer base

  14. Characteristics of Quality Data Uniqueness Accuracy Consistency Completeness • Timeliness • Currency • Conformance • Referential integrity

  15. Causes of poor data quality • External data sources • Lack of control over data quality • Redundant data storage and inconsistent metadata • Proliferation of databases with uncontrolled redundancy and metadata • Data entry • Poor data capture controls • Lack of organizational commitment • Not recognizing poor data quality as an organizational issue

  16. Data quality improvement • Get business buy-in • Perform data quality audit • Establish data stewardship program • Improve data capture processes • Apply modern data management principles and technology • Apply total quality management (TQM) practices

  17. Business Buy-in • Executive sponsorship • Building a business case • Prove a return on investment (ROI) • Avoidance of cost • Avoidance of opportunity loss

  18. Data Quality Audit • Statistically profile all data files • Document the set of values for all fields • Analyze data patterns (distribution, outliers, frequencies) • Verify whether controls and business rules are enforced • Use specialized data profiling tools

  19. Data Stewardship Program • Roles: • Oversight of data stewardship program • Manage data subject area • Oversee data definitions • Oversee production of data • Oversee use of data • Report to: business unit vs. IT organization?

  20. Improving Data Capture Processes • Automate data entry as much as possible • Manual data entry should be selected from preset options • Use trained operators when possible • Follow good user interface design principles • Immediate data validation for entered data

  21. TQM Principles and Practices • TQM – Total Quality Management • TQM Principles: • Defect prevention • Continuous improvement • Use of enterprise data standards • Balanced focus • Customer • Product/Service

More Related