 Using Agile or other software methodologies as needed on specific assignments. Write complex SQL codes. Store procedures. Use DDL, DML. User-defined functions to implement the business logic. Use execution plans. SQL profiler and database engine tuning advisor to optimize queries and enhance the performance of databases.