Daniel Mellor Email & Phone Number

Sierra Vista, Az, Us

Redmond, Washington, Us

Us

Member of a DBA team also acting as System Administrators for over 150 Enterprise level SQL Servers utilizing Clustering, Mirroring, Always On, Log Shipping, Partitioning, Central Management Servers, and Policy Based Management. Responsible for building and decommissioning servers and maintaining high security. Developed PowerShell and TSQL scripts to automate processes resulting in significant reductions in man hours, such as patching scripts, automating installs, and maintaining server security. Limited use of SSRS and SSIS for reporting and monitoring.

Oklahoma City, Ok, Us

SQL Developer / Database Administrator. Responsible for general database maintenance including automated procedures, database objects, and performance tuning. Provide queries as needed. Mainly tune queries and implement best practices for the databases. Set up and maintain sql source control and testing environments. Review architecture of new database. Continue to provide as needed contract support.

Oklahoma City, Ok, Us

Maintain multiple mssql databases. Generate dynamic stored procedures and perform required database maintenance. Create and maintain excel rating engines for multiple lines of business. Meet with internal staff and external developers in a business analyst / project manager role. Develop solutions to most of my projects including debugging web applications written in C# and altering databases as necessary. Participate in discovery for new programs and products. Assist in database migration and testing. Provide data and actuarial analysis for senior officers.

Oklahoma City, Ok, Us

Processed submissions and policies servicing over 100 accounts with limited supervision in a paperless environment. Streamlined administration and worked on program development. Invoiced and ensured all accounts were current. Ran reports and performed correspondence with agents and carriers. Maintained rates, troubleshot formulas, and performed data analysis and ad-hoc reporting on unrelated lines of business for senior officers. Designed and maintained Excel rating engines for multiple lines of business.