• In my opinion, Development DBA is like Architect, but would do more detailed design, test, and review codes from Developers (if there is any), if there is no developers, Development DBA may end up in designing the database logical infrastructures and then writing scripts to implement the design. So development DBA should know the business very well and know what the data do in the database.

    Production DBA is more like maintening the existing running databases, keeping them up running without issue. Typical Tasks would be: installation SQL Server, backup/restore; engaging with app admins to resolve db-related application issues; disaster recovery strategies work for the business; performance tuning; security administration...etc. PROD DBA is like a housekeeper and firefighter, making sure the DBs are running with high efficieny, availability and redundancy while when there is emergency, should be able to resolve issues swiftly. Production DBA could function well without knowing the business processes/data well.

    --(Personally I am a Production DBA)