IT - Database and Analytics Specialist | Waukesha County Technical College

Skills & Competencies

Skills developed through this program

Auto-populatedfrom O*NET via SOC 15-1242.00

Skills

Critical ThinkingComplex Problem SolvingReading ComprehensionActive ListeningJudgment and Decision MakingActive LearningProgrammingSpeaking

Knowledge

Computers and ElectronicsEnglish LanguageCustomer and Personal ServiceMathematicsTelecommunications

Abilities

Deductive ReasoningOral ComprehensionWritten ComprehensionProblem SensitivityInductive ReasoningInformation OrderingNear VisionOral ExpressionWritten ExpressionCategory Flexibility

Tasks

Modify existing databases and database management systems or direct programmers and analysts to make
Plan, coordinate, and implement security measures to safeguard information in computer files against
Plan and install upgrades of database management system software to enhance database performance.

Technology

Enterprise resource planning ERP softwareAccess softwareBackup or archival softwareData base management system softwareWeb page creation and editing software

Tools

Desktop computersHard disk drivesMainframe computersNotebook computersRedundant array of independent disks RAID systemsTape libraries

Work Values

Working ConditionsSupportAchievementRecognitionRelationshipsIndependence

Career Pathways

Occupations this program prepares you for

Auto-populatedfrom O*NET + BLS

Occupations matched to this program, with median wage, top wage, growth, and openings
SOC	Occupation	Method	Wage	Growth	Openings
Match confidence: medium15-1242.00	Database Administrators	title_inference	$104,620 median$160,890 top	-0.64%	-50

Program Pathways

Credentials this program stacks toward

No program pathways.

What You'll Learn

Key competencies developed through this program

Auto-populatedfrom NSX Competency Framework

Mastery: developing (Level 2)(based on Associate's Degree)

Existing databases and DBMS configurations — modify with reduced oversight to improve performance or accommodate changing business requirements.
Database security measures — plan and implement access controls and encryption settings to safeguard information against unauthorized disclosure.
DBMS software upgrades — coordinate installation and testing in staging environments to validate performance improvements before production deployment.
User accounts and access-level specifications — define and assign permissions for each database segment based on organizational role requirements.
Database application changes — design and execute test plans, correct identified errors, and apply necessary modifications in a team environment.
Storage networking software and backup systems — configure and maintain data recovery procedures to meet defined recovery time objectives.
Junior staff and end users — answer technical questions and deliver structured training sessions on database tools and query interfaces.
ERP and enterprise data platforms — administer routine operations and troubleshoot integration issues with adjacent business systems.
Database performance metrics — monitor using platform dashboards and generate reports identifying trends and potential bottlenecks.
Object-oriented and web platform development tools — collaborate with programmers to review code changes affecting database interactions.

Program Details

Detailed information about this program

No detailed information available.

Requirements

What you need to earn this credential

No requirements listed.

Financial Aid

Eligible funding programs

No funding information available.

Scholarships

No scholarships listed.