SQL DBA

Description

POSITION SUMMARY PRINCIPAL DUTIES Technical
Manage SQL Server 2012 and 2014 environment based on industry best practice for database administration
Lead problem resolution of critical applications issues regarding availability, performance and security to identify, recommend, and implement issue resolution and/or process improvements
Develop and maintain SQL backup procedures and restore SQL databases monthly for testing purposes and ondemand for production environment. Maintain and document SQL stored procedures triggers; views; and services.
Create and monitor testing procedures for SQL and application software updates and upgrades.
Develop and maintain separate test and development environments for all critical database applications.
Lead SSIS package and SSRS reporting development, including technical requirements collection and documentation.
Develop complex Crystal, SQL and SSRS reports from critical application database sources.
Lead adhoc data analytics development, including technical requirements collection and documentation.
Document database architecture and customizations/modifications to all critical applications.
Develop and implement a strategy for creating highavailability environment for all critical database applications
Develop and implement a strategy for replicating databases to DR site.
Apply standard operating procedures to applicable Application Services processes
Collaborate with Manager of Network Services for testing and applying monthly maintenance updates on critical databases
Coordinate with Manager of Network Services on provisioning resources for critical databases, including backup requirements.
Provide input into the disaster recovery plan, especially RTO and RPO objectives; maintain current DR documentation for all critical application components Participate once every four to six weeks in oncall rotation as the primary point of contact for issues with the infrastructure after business hours and on weekends.
Management
Direct operational efforts by providing handson technical leadership to Application Services team in administering and supporting the availability, performance and security of CAO business application stack, including but not limited to CMS, CRM, ERP, Financial, Case Management and Advertising Sales business solutions.
Supervise application services staff including developing position description, recruitment, professional development and evaluation process.
Ensure Helpdesk trouble tickets are addressed timely and in accordance to established timeframes from SOP
Guide, review and approve design and build of custom interfaces, and the configuration and implementation of COTS integration components. Ensuring testing for system interoperability and documentation
Oversee the creation and maintenance of documentation content to satisfy SOP, DR and internal business and system documentation requirements.
Provide input and technical information in preparation of the application services strategic plan.
Assist Director with preparing the Application Services portion of the annual IT budget.
Provide technical information for the annual IT Security Audit submission regarding critical application version, SQL platform and security permissions of all financial applications.
Develop and maintain strategies and best practices around data integrity.
Other duties as assigned