Database Administrator Ii
Current• Developing methodologies for the ongoing assessment of database performance and the identification of problem areas.• Providing leadership for the development and enhancement of production applications including working with applications, technical support and operations during the design, development and implementation of processing and reporting applications.• Work with the developers to design logical database structure, schemas, security.• Create and manage schema objects such as tables, views, indexes, and referential integrity depending on user requirements.• Create complex stored procedures, triggers, tables, views, and other SQL joins and statements for applications and data requirements.• Maintain the synchronization of data and software / hardware of both the production and development servers.• Create & implement and maintain backup / recovery strategies and schedules.• Improve performance of databases by analyzing indexes, fill factors, and fragmentation issues• Monitor critical server issues including response delay, locking and blocking and server downtime.• Perform all aspects of database administration including backups, recovery, reporting using SSRS, and working with SQL server Profiler to generate and read trace data.