Plans computerized databases, including base definition, structure, documentation, long-range requirements, operational guidelines and protection. Implementation, oversight, and coordination of application release management tasks. May be responsible for reporting-related activities, migrations, upgrades, new builds, code deployments and project delivery. Ensures accuracy and completeness of data in master files and various support tools, such as base dictionaries. Establishes and maintains security and integrity controls. Formulates and monitors policies, procedures and standards relating to database management. Proposes and implements enhancements that will improve the performance and reliability of the system. May be internal or client-focused, working in conjunction with Professional Services and outsourcing functions. As a seasoned, experienced professional with a full understanding of area of specialization, she resolves a wide range of issues in creative ways. Works on problems of diverse scope where analysis of data requires evaluation of identifiable factors. Demonstrates good judgment in selecting methods and techniques for obtaining solutions. Networks with senior internal and external personnel in own area of expertise.

Administer, maintain, and monitor over 100 Production databases using SQL Server 2008-2012 in a distributed architecture. Manage Production with over 25 servers and a footprint of 1.5 TB. Manage lower environments with a footprint over 2 TB with databases ranging from 5 GB to 800 GB. Administer, maintain, and monitor over 55 development databases on physical and virtual servers.   Create, automate, and troubleshoot SSRS reports and subscriptions. Manage and monitor database security using Active Directory to assign permissions, and use Windows Authentication logins and users to manage user and application access to the database. Resolve issues as a member of 24x7 on-call support.  * Migrate SQL Server 2005 instances to SQL Server 2012 on new physical hardware * Upgrade SQL Server 2005 instances to SQL Server 2012 on the same server * Develop and implement SQL standards for code review and best practices * Add databases to source control in TFS and implement deployment process

* Migrate centralized SQL Server instance to a new data center provider  * Develop and implement SQL standards for code review and best practices * Implement daily monitoring for new database objects and setup alert notification

Administer, maintain, and monitor over 150 Production databases using MS SQL Server 2008-2012 in a high transaction environment with a global footprint of 13 TB and over 500 development databases with a global footprint of 80 TB. Support Production databases ranging from 500 GB to 1.2 TB across 20 servers including several high-availability clusters. Support environments including 528 servers with 28 physical hosts.  Create SSIS packages using Business Intelligence Development Studio. Automate SSIS packages and stored procedures with jobs using credentials and proxies. Create and automate SSRS reports with stored procedures and subscriptions. Resolve issues on  rotational 24x7 on-call support.  * Optimize and debug stored procedures used for daily client reporting * Modify ad hoc requests to decrease the use of cursors and train employees on alternatives to cursors * Create complex reports with multiple data sources including drill through to sub reports * Coordinate and communicate requirements between operations and data servicesAnalyze ad hoc queries and stored procedures for bugs and submit tickets to correct issues found. Create ad hoc queries and scripts to streamline daily billing operations. Test client tickets and report bugs found. Provide standardized WIKI documentation. * Reduce daily billing time by 4 hours/day by streamlining ad hoc queries * Improve query performance by reducing execution time from over 5 min to less than 10 seconds