Design, architect, and build databases based application systems from business requirements to planning and deploying test and production systems that are completely available and highly scalable
Automate and perfect operational DBA duties which will include installation, database upgrades, patching, environment cloning, implementing backup/recovery and monitoring procedures, capacity planning and site failover/switchover.
Interface with clients, network, hardware and system operations teams to resolve problems with application/database systems in a timely manner.
Follow change management process and participate in related meetings.
Responsible for managing Development, Test, QA and Production databases and implementing future SQL Server enhancements to meet the business needs of the end users.
Monitor database health - availability, reliability, performance, capacity planning, server clustering, replication, re-indexing. Tune system to ensure maximum system efficiency and 100% system availability. Resolve any problems that arise with the database
Develop, manage and test back-up and recovery plans and procedures during bi-annual Disaster Recovery exercise
Responsible for implementation and release of database changes as requested by the application team
Create and maintain database/application architecture and standards following Microsoft Best practices for physical structures, logical databases, user management.
Act as a database project leader for critical, time driven, visible projects, if needed.
Integrate/collaborate with application development and support teams on various IT projects.
Provide thought leadership and assist in setting strategic direction for Database, infrastructure and technology
Provide off hours support and maintenance as required, part of the 24x7 operations support on call rotations as needed.