Database related jobs
Download
1 / 50

Database Related Jobs - PowerPoint PPT Presentation


  • 146 Views
  • Uploaded on

Database Related Jobs. Gueorgui Gagov Karen Myers Shaoang Zhao Scott McQuistan. Today’s Road Map. Certifications and Benefits Examples Job Titles and Salary Statistics Local and Regional Career Examples. Agenda. Value and Benefits of the Database Certified Professional Credential

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Database Related Jobs' - stedman


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Database related jobs

Database Related Jobs

Gueorgui Gagov

Karen Myers

Shaoang Zhao

Scott McQuistan


Today s road map
Today’s Road Map

  • Certifications and Benefits

  • Examples

  • Job Titles and Salary Statistics

  • Local and Regional Career Examples


Agenda
Agenda

  • Value and Benefits of the Database Certified Professional Credential

  • Oracle Certified Professional Credential (OCP)

  • Microsoft Certified Database Administrator (MCDBA )

  • MySQL Certification

  • PostgreSQL Certification


Value of the database certification credential
Value of the Database Certification Credential

  • Competitive edge, differentiation & credibility = Job Opportunities

  • Improved Efficiencies

    • Certified professionals handle more support calls

    • Companies advocating certification report less downtime

    • Employer ROI Payback in only nine months because of savings due to increased internal effectiveness

      • IDC

  • Quicker adoption of technology

  • Improved customer service


  • What ocps oracle certified professional have said
    What OCPs(Oracle Certified Professional) Have Said

    • Three out of four OCPs feel their certification gives them greater confidence.

    • Three out of five OCPs feel they have a competitive edge over their non-certified counterparts.

    • 70% feel the OCP process has helped them maintain skills.

    • Two thirds of OCPs working as consultants have benefited through:

      • New contracts

      • Client retention

      • Greater access to new opportunities


    Benefits of the database certification credential
    Benefits of the Database Certification Credential

    • Use of Certificates for endorsement of your career by leveraging those established brand equity

    • Special event access

    • Ability to join the certification member community


    Certification programs overview
    Certification Programs Overview

    • Oracle Certified Professional Credential (OCP)

    • Microsoft Certified Database Administrator (MCDBA )

    • MySQL Certification

    • PostgreSQL Certification


    Oracle certification program
    Oracle Certification Program

    Achieved by the Top Oracle Professionals

    Three tiers

    OCM

    Oracle

    Certified Master

    Hiring Manager Approved Industry Benchmark

    Get Certified, Establish Credibility,

    Increase Opportunities

    OCP

    Oracle Certified

    Professional

    Answers the Demand for more Oracle Professionals

    Learn Online

    Test Online

    Get a Job Online

    OCA

    Oracle Certified Associate


    Why three certification tiers
    Why Three Certification Tiers?

    • Provides a tool for IT managers to use in making hiring decisions

    • More closely aligned with job roles and skill levels

    • OCA can be used as the first step in a professional career and development path

    • OCP demonstrates professional commitment

    • OCM provides a performance based benchmark for hiring experts


    Oracle certification paths
    Oracle Certification Paths

    • OCA:

      • Oracle9i DBA Certified Associate

      • Oracle9iAS Web Administrator Certified Associate

      • Oracle9i PL/SQL Developer Certified Associate

    • OCP:

      • Oracle8i DBA Certified Professional

      • Oracle9i DBA Certified Professional

      • Oracle6i Internet Application Developer Certified Professional

      • Oracle9i Forms Developer Certified Professional

    • OCM:

      • Oracle9i Database Administrator Certified Master


    Oracle Certified Associates (OCA) have foundational knowledge that will allow them to perform junior team member tasks working with database administrators and application developers.

    Oracle Certified Professionals (OCP) have proven skills in managing a large-scale database or in developing robust applications that are deployed enterprise-wide.


    Ocm candidate prerequisites
    OCM Candidate Prerequisites knowledge that will allow them to perform junior team member tasks working with database administrators and application developers.

    • Must have Oracle9i DBA Certified Professional credential

    • Minimum of 3 – 4 years of practical experience as an Oracle DBA

    • Knowledge of Oracle9i database technology and features


    Oracle9 i dba certified master content areas
    Oracle9 knowledge that will allow them to perform junior team member tasks working with database administrators and application developers.i DBA Certified Master Content Areas

    • Database Configuration

    • Oracle Network Configuration

    • Oracle Enterprise Manager

    • Data Management

    • Database Management

    • Performance Management

    • Database Availability

    • Standby Database and Data Guard


    Minimum required ocm participant skills
    Minimum Required OCM Participant Skills knowledge that will allow them to perform junior team member tasks working with database administrators and application developers.

    • Working knowledge of Linux:

      • Formatting and executing basic OS commands

      • Creating and navigating through directory structures

      • File management using copy, move, and remove

      • Linux environment text editors (Line Mode or GUI)

      • Setting environment variables


    Minimum required ocm participant skills1
    Minimum Required OCM Participant Skills knowledge that will allow them to perform junior team member tasks working with database administrators and application developers.

    • Ability to locate and launch Oracle9i executables:

      • Database Creation Assistant

      • Listener Utility

      • Oracle Net Manager

      • Oracle Net Configuration Assistant

      • OEM

      • OMS

      • Oracle Password Utility

      • RMAN Utility

      • SQLPLUS


    Minimum required ocm participant skills2
    Minimum Required OCM Participant Skills knowledge that will allow them to perform junior team member tasks working with database administrators and application developers.

    • Proficient with working in a command line environment

    • Proficient with using Oracle Enterprise Manager

    • Advanced knowledge and use of Oracle9i (9.0.2.2) features and functionality

    • Familiarity with navigating through non-searchable Oracle documentation

    • Familiarity with navigating through and the functions of Konqueror browser software

    • Ability to employ “BEST PRACTICES” when working in an Oracle9i database environment to solve complex technical problems


    Microsoft certified database administrator mcdba
    Microsoft Certified Database Administrator (MCDBA ) knowledge that will allow them to perform junior team member tasks working with database administrators and application developers.

    • Creation of the certification was fueled by the growing industry demand for skilled database administrators

    • and fueled by the availability of Microsoft SQL Server™ version 7.0.


    Mcdba test requirements
    MCDBA Test Requirements knowledge that will allow them to perform junior team member tasks working with database administrators and application developers.

    • Need to pass three core exams

    • One SQL Server administration exam

    • One SQL Server design exam

    • Either one Windows 2000 Server or one Windows Server 2003 exam to fulfill the networking systems core requirement.


    Sql server administration exam
    SQL Server administration exam knowledge that will allow them to perform junior team member tasks working with database administrators and application developers.

    • Planning

      -Develop a security strategy.

      -Develop a SQL Server capacity plan.

      -Develop a data availability solution.

      -Develop a migration plan.

      -Develop a replication strategy.


    Sql server administration exam1
    SQL Server administration exam knowledge that will allow them to perform junior team member tasks working with database administrators and application developers.

    • Installation and Configuration

    • Configuring and Managing Security

    • Managing and Maintaining Data

      -Create and manage databases.

      -Load data by using various methods. Methods include the INSERT statement, the SELECT INTO statement, the bcp utility, Data Transformation Services (DTS), and the BULK INSERT statement.


    Sql server administration exam2
    SQL Server administration exam knowledge that will allow them to perform junior team member tasks working with database administrators and application developers.

    • Restore system databases and user databases

    • Manage replication.

    • Automate administrative tasks.

    • Monitoring and Optimization

    • Troubleshooting


    Sql server design exam
    SQL Server design exam knowledge that will allow them to perform junior team member tasks working with database administrators and application developers.

    • Developing a Logical Data Model

      -Define entities. Considerations include entity composition and normalization.

      - Design entity keys. Considerations include FOREIGN KEY constraints, PRIMARY KEY constraints, and UNIQUE constraints.

      -Design attribute domain integrity. Considerations include CHECK constraints, data types, and null ability.


    Sql server design exam1
    SQL Server design exam knowledge that will allow them to perform junior team member tasks working with database administrators and application developers.

    • Implementing the Physical Database

      -Create and alter databases. Considerations include file groups, file placement, growth strategy, and space requirements.

      -Create and alter database objects. Objects include constraints, indexes, stored procedures, tables, triggers, user-defined functions, and views.

      -Alter database objects to support replication and partitioned views.


    Sql server design exam2
    SQL Server design exam knowledge that will allow them to perform junior team member tasks working with database administrators and application developers.

    • Retrieving and Modifying Data

      -Import and export data. Methods include the bulk copy program, the Bulk Insert task, and Data Transformation Services (DTS).

      -Manipulate heterogeneous data. Methods include linked servers, OPENQUERY, OPENROWSET, and OPENXML.

      -Retrieve, filter, group, summarize, and modify data by using Transact-SQL.

      -Manage result sets by using cursors and Transact-SQL. Considerations include locking models and appropriate usage.

      -Extract data in XML format. Considerations include output format and XML schema structure.


    Sql server design exam3
    SQL Server design exam knowledge that will allow them to perform junior team member tasks working with database administrators and application developers.

    • Programming Business Logic

      -Manage data manipulation by using stored procedures, transactions, triggers, user-defined functions, and views.

      -Enforce procedural business logic by using stored procedures, transactions, triggers, user-defined functions, and views.


    Sql server design exam4
    SQL Server design exam knowledge that will allow them to perform junior team member tasks working with database administrators and application developers.

    • Tuning and Optimizing Data Access

      -Analyze the query execution plan.

      -Capture, analyze, and replay SQL Profiler traces.

      -Create and implement indexing strategies.

      -Improve index use by using the Index Tuning Wizard.

    • Designing a Database Security Plan

      -Use programming logic and objects. Considerations include implementing row-level security and restricting direct access to tables.


    Exam on microsoft server product
    Exam on Microsoft server product knowledge that will allow them to perform junior team member tasks working with database administrators and application developers.

    • Creating User Services

      - Create ASP.NET pages.

      -Add Web server controls, HTML server controls, user controls, and HTML code to ASP.NET pages.

      -Instantiate and invoke Web services or components.

    • Creating and Managing Components and .NET Assemblies


    Exam on microsoft server product1
    Exam on Microsoft server product knowledge that will allow them to perform junior team member tasks working with database administrators and application developers.

    • Consuming and Manipulating Data

      -Access and manipulate data from a Microsoft SQL Server™ database by creating and using ad hoc queries and stored procedures.

      -Access and manipulate data from a data store. Data stores include relational databases, XML documents, and flat files. Methods include XML techniques and ADO.NET.

    • Testing and Debugging

    • Deploying, Maintaining and Supporting, Configuring and Securing a Web Application


    Mysql certification
    MySQL Certification knowledge that will allow them to perform junior team member tasks working with database administrators and application developers.

    • Two Tiers

    MySQL Professional Certification

    MySQL Core Certification


    Mysql core certification
    MySQL knowledge that will allow them to perform junior team member tasks working with database administrators and application developers.Core Certification

    • Capable of creating and using databases and tables, inserting, modifying, deleting, and retrieving data from a MySQL database .

    • The job role will typically be to maintain data in company databases, performing data analysis, importing and exporting data, and so forth.


    Mysql professional certification
    MySQL Professional Certification knowledge that will allow them to perform junior team member tasks working with database administrators and application developers.

    • Proof that you master more complex issues, such as installing a server from scratch, keeping the server running smoothly at all times, using the new table types, using more advanced SQL, and analyzing the trouble spots of other users' queries.

    • The typical job role of a MySQL-Prof is in setting up and managing one or more MySQL servers in an organization, often managing a team of one or more users and programmers of MySQL products.


    What s postgresql
    What’s PostgreSQL knowledge that will allow them to perform junior team member tasks working with database administrators and application developers.

    • PostgreSQL is an enhancement of the POSTGRES database management system, a next-generation DBMS research prototype.

    • While PostgreSQL retains the powerful data model and rich data types of POSTGRES, it replaces the PostQuel query language with an extended subset of SQL. PostgreSQL is free and the complete source is available.


    Postgresql certification
    PostgreSQL Certification knowledge that will allow them to perform junior team member tasks working with database administrators and application developers.

    • Three types of certification are provided: - "PostgreSQL Certified Administrator"- "PostgreSQL Certified Developer"- "PostgreSQL Certified Expert


    Advices
    Advices: knowledge that will allow them to perform junior team member tasks working with database administrators and application developers.

    • If you seek career in the DB field:

      • Get initial certification

      • Company can pay for the next levels

    • DB and programming:

      • Not only SQL

      • Web/Programming language


    Examples
    Examples: knowledge that will allow them to perform junior team member tasks working with database administrators and application developers.

    • Crashing a webpage demo:

      • The “apostrophe” bug

      • Wrong data/Wrong field type

      • Control users


    Last tip
    Last Tip: knowledge that will allow them to perform junior team member tasks working with database administrators and application developers.

    Look for the free stuff!


    Database administrator
    Database Administrator knowledge that will allow them to perform junior team member tasks working with database administrators and application developers.

    • Administers, maintains, develops and implements policies for ensuring security and integrity

    • Implements data models and database designs, data access and table maintenance codes

    • Resolves performance issues

    • Handles capacity and replication issues

    • Typically requires a bachelor’s degree

    • 2-4 years experience

    • Relies on limited experience and judgment

    • Works under supervision and typically reports to a manager

    • $68,591 – 79,126 – 91,657

    • For more prestigious positions, on average positions pay 44% higher salaries nationwide if the employee has an advanced degree


    Database analyst i
    Database Analyst I knowledge that will allow them to perform junior team member tasks working with database administrators and application developers.

    • Reviews, designs, evaluates, maintains and implements

    • Identifies data sources, constructs decomposition diagrams and provides data flow diagrams

    • Writes code for access, modifications, and construction

    • Bachelor’s degree

    • 0-2 years experience

    • Knowledge of commonly used concepts, practices, and procedures

    • Relies on instructions and pre-established guidelines

    • Works under immediate supervision directly under a project manager or projects leader

    • $40,860 – 46,087 – 53,088


    Database analyst ii
    Database Analyst II knowledge that will allow them to perform junior team member tasks working with database administrators and application developers.

    • Very similar job duties as Analyst I

    • Bachelor’s degree

    • 2-4 years experience

    • Relies on limited experience and judgment to plan tasks

    • Works under general supervision

    • $52,281 – 59,715 – 67,469


    Database analyst iii
    Database Analyst III knowledge that will allow them to perform junior team member tasks working with database administrators and application developers.

    • Similar duties to Analysts I and II

    • Bachelor’s degree

    • 4-6 years experience

    • Familiar with a variety of the fields concepts

    • Relies on experience and judgment to plan tasks

    • Performs a variety of complicated tasks

    • May lead and direct the work of others

    • $66,150 – 74,472 – 84,093


    Database analyst iv
    Database Analyst IV knowledge that will allow them to perform junior team member tasks working with database administrators and application developers.

    • Similar job duties to Analysts I, II, and III

    • Requires Bachelor’s degree in area of specialty

    • Typically has 6-8 years of experience

    • Relies on extensive experience to plan and accomplish goals

    • Leads and directs the work of others

    • Either reports to a manager or the department head

    • $71,753 – 80,045 – 89,400


    Database analyst v
    Database Analyst V knowledge that will allow them to perform junior team member tasks working with database administrators and application developers.

    • Similar duties as other Analysts

    • Requires a bachelor’s degree in area of specialty

    • At least 8-10 years of experience

    • Demonstrates expertise in a variety of the fields concepts, practices and procedures

    • Relies on extensive experience to accomplish goals

    • May provide consultation on complex projects

    • Considered a top level specialist

    • Reports to manager or head of department

    • $81,625 – 89,566 – 98,858


    Database librarian
    Database Librarian knowledge that will allow them to perform junior team member tasks working with database administrators and application developers.

    • Designs, enters, audits and maintains databases

    • Responsible for verifying all data meets standards

    • May require an Associates degree

    • 3-5 years experience

    • Familiar with a variety of the fields concepts and procedures

    • Performs a variety of complicated tasks

    • May lead and direct the work of others

    • Reports to manager

    • $38,966 – 44,829 – 56,046


    Top data warehousing executive
    Top Data Warehousing Executive knowledge that will allow them to perform junior team member tasks working with database administrators and application developers.

    • Oversees and coordinates the data warehouse / business intelligence group

    • Accountable for all data warehouse systems to ensure business objectives met

    • May require an advanced degree

    • At least 15 years experience

    • Familiar with a variety of concepts and relies on extensive experience

    • Leads and directs others

    • Reports to top management

    • $125,966 – 164,096 – 186,423


    Salary comparison des moines vs national average with bonuses

    Des Moines knowledge that will allow them to perform junior team member tasks working with database administrators and application developers.

    Admin – $91,657

    Analyst I – 53,088

    Analyst II – 67,469

    Analyst III – 84,093

    Analyst IV – 89,400

    Analyst V - 98,858

    Librarian – 56,046

    National Average

    $1400-3300 higher

    900-1400 higher

    900-1400 higher

    1400-3000 higher

    1400-3000 higher

    2300-5000 higher

    1000 higher

    Salary ComparisonDes Moines vs. National Average with bonuses


    Salary comparison cedar falls vs national average with bonuses

    Cedar Falls knowledge that will allow them to perform junior team member tasks working with database administrators and application developers.

    Admin - $85,614

    Analyst I - 49,588

    Analyst III - 78,550

    Analyst V - 92,341

    Librarian - 52,368

    National Average

    $1-3000 higher

    800-1000 higher

    1500-3000 higher

    2200-4500 higher

    1000 higher

    Salary ComparisonCedar Falls vs. National Average with bonuses


    Database administrator1
    Database Administrator knowledge that will allow them to perform junior team member tasks working with database administrators and application developers.

    • Thousands of Job Postings

    • Geographically Disperse

    • Full- time permanent positions and contract work

    • Good range of salaries, mainly $75,000 - $100,000/year, more for contract work.

    • Range of organizations, from non-profit, to retail, to research to casinos.

    • Central Iowa examples:

      • IFMC

      • Ruan Transportation

      • Modis

      • State of Iowa

      • IRG Researchers


    Database analysts
    Database Analysts knowledge that will allow them to perform junior team member tasks working with database administrators and application developers.

    • Thousands of Job Postings

    • Geographically Disperse

    • Full- time permanent positions and contract work

    • Good range of salaries, mainly $35,000 to $100,000/year, more for contract work.

    • Range of organizations, from non-profit, to retail, to research to casinos.

    • Central Iowa examples:

      • Wells Fargo

      • GeoLearning

      • ADP

      • Citi Cards


    Database librarian1
    Database Librarian knowledge that will allow them to perform junior team member tasks working with database administrators and application developers.

    • Limited Postings

    • Only a few locations

    • Mainly nonprofit – with this title

    • Functions encompassed within other IT Functions or Administrative Functions

    • No examples in central Iowa


    Top data warehousing executive1
    Top Data Warehousing Executive knowledge that will allow them to perform junior team member tasks working with database administrators and application developers.

    • Many postings, however, not many in central Iowa

    • Geographically disperse

    • Variety of industries

    • Wide variance in compensation packages, and structures

    • Examples:

      • Leukemia and Lymphoma Society

      • Global Executive Solutions

      • NetZero

      • The Regence Group


    ad