Data Architecture and Modeling
Collect business requirements and understand application architecture
Create conceptual, logical and physical data models with Sybase PowerDesigner, ERWin or Visio
Create and maintain data dictionary

Database Design and Development
Involve at different stages of the software development life cycle (SDLC) 
Develop database objects to support application and implement business logic
Create database unit tests to verify database code against requirement

Database Project Build and Deploy
Build database project with Visual Studio Team System - Database Edition
Source control with Team Foundation Server (TFS), Subversion
Continuous integration, build and deploy with FinalBuilder, TFS Build, CruiseControl.Net

Data Warehouse and Business Intelligence
Create relational data model for Operational Data Store(ODS) and dimensional data model for Data Warehouse
Design ETL processes to load data to ODS and Data Warehouse
Create OLAP Cubes to support Business Intelligence (BI) analysis
Create management reports to support critical business decisions

Database Operation
Select software vendor and licensing options
Install and upgrade database management system (DBMS) software
Create and monitor routine database maintain plans and tune database performance
Manage security and monitor audit logs to ensure compliance and detect intrusion
Establish disaster recovery plan and verify periodically to ensure data is safe