 involved in requirements gathering technical design development by using agile or other software methodologies as needed on specific assignment write complex sql codes store procedures views ddl dml user defined functions to implement the business logic use execution plan sql profiler and database engine tuning advisor to optimize queries and enhance the performance of databases