• support the application development lifecycle
  • focuses on tasks related to building an effective, usable database environment to support the creation and maintenance of applications
  • lend assistance and support as programs and systems are being built
  • model and normalize the data
  • assists programmers in building and editing test data
  • provide and build tools to facilitate database testing and data refresh
  • ensure that proper methods are used to embed data access and modification logic into application programs
  • ensure that appropriate and efficient SQL is being coded and tested
  • create and maintain effective database-coupled application logic – stored procedures, triggers, and user-defined functions (UDFs)