Primary Senior Production DBA, Senior Database Architect, Senior Database Developer, Senior ETL Developer, Primary Database Migration Contact. Rearchitected database structures leaving view abstraction layer intact. This project was critical for several tasks that were high visibility to upper management. Provide performance optimization and recommendations to resolve locking and blocking. Heavy use of source control application and continuous integration in several different environments. High security clearance (TS) required for this position.

Identified and implemented multiple areas for database modeling improvements. Addressed database tuning issues & parameter settings. Upgraded database versions. Managed database engineering staff.

Identified and implemented multiple areas for infrastructure improvements. Identified multiple areas of suboptimal code resulting in better performance. Advised and designed new infrastructure. Assisted with migration to AWS RDS.

Designed, built, and deployed new databases with stored procedures and other programmability. Updated existing stored procedures for better performance. Performance tuned existing code for use by existing applications. Provided capacity planning information to management. Managed VMware cloud infrastructure including firewall rules and user provisioning.

Design, Develop, Implement, Administer, and Support highly available and highly flexible business intelligence and decision support software for globally managed finance, operations, and supply chain functions across the HP Networking business utilizing all available infrastructures including but not limited to Microsoft SQL Server, Microsoft SharePoint, and Microsoft Office Web Apps.

Design and manage high availability OLTP and OLAP systems with a team of highly experienced database administrators. Performance tuning on existing systems. Migrate existing physical systems to a virtual environment. Maintain a Positive and Encouraging environment.

Provide support to the Global BI team with SharePoint, Reporting Services, and Excel Services PowerPivot using both Oracle and SQL Server as data sources.

Manage a 45 server, 70TB VLDB OLAP environment, Performance Tuning, Database Design.Project Highlights:* Work with one other DBA to manage environment without the benefit of any third party tools.* Work with clients of IMS Health to optimize table structure & data types for high performance.* Repair existing maintenance code correcting errors, improving performance, and integrating new technology.* Write Database Security Policy and documented client projects.* Write Database Development Lifecycle Policy and helped other departments write policies for SDLC.* Migrate data from non-partitioned database into a fully partitioned database.* Learn and provide SQL support for in house applications.* Use snapshot, mirroring, and replication to provide high availability to clients.* Installed and evaluated Oracle as a potential solution.

Managed 60 server 10TB customer data environment, Performance Tuning, Complex T-SQL authoring. Project Highlights: Worked autonomously as a remote member of a DBA team located; IT Project management for data structure reorganization and data scrubbing.Managed Production Hosted SQL Server 2005 EnvironmentWrote SOP's, test plans, and documented environments. Learned and provided SQL support for 3rd party applications, Attenex & Ringtail. Created reports for Business Intelligence using SQL Server Reporting Services. Built and configured 3 clustered and 9 standalone SQL Servers

Provide wide range of services including mail service and website hosting on a contract basis for diverse clients including home users, and non-profit, e-commerce, and retail businesses.Project Highlights: Managed internal network comprised of 3 servers and 3 desktops. Designed, built, hosted, and maintained web-based applications and websites. Built and designed databases from scratch for web-based applications. Evaluated, documented, and made recommendations for applying MSSQL Server.

Documented and maintained clustered MS SQL Server production database servers. Implemented product and application upgrades. Managed backup jobs and alerts using the SQL Agent, Exchange Server, and SNMP.Implemented security protocols and managed database access. Wrote triggers and stored procedures for in-house custom applications. Supported personnel in assembling reports using report-writing software.

Designed, built, and maintained 6 production database servers. Set up and maintained 4 clustered database servers. Managed product and application upgrades, security, and database access. Partnered with and trained Software Engineers to write triggers and stored procedures for applications.Implemented a tape backup solution and Helpdesk tracking system.

Designed, built, and maintained 9 production database servers. Managed backup jobs and alerts using SQL Agent, Exchange Server, and SNMP.Wrote and maintained stored procedures for web pages using ASP and ADO. Trained Sales Engineers in installation and maintenance of client database servers. Implemented SMS 2.0. and multiple 3rd-party software packages.

Provider of credit-scoring and other analytical risk assessments.Database AdministratorSetup and maintained SQL Server database servers and applications.Prioritized project tasks and assisted Project Managers with team coordination.Managed product and application upgrades; backup jobs and alerts; security; database access; and 3rd-party software implementations.