Sql Server Dba Resume Profile
4.00/5 (Submit Your Rating)
IA
SUMMARY OF QUALIFICATIONS
Fourteen years of experience in Information Technology.
Areas of expertise include:
- SQL Server Confidential
- Database Design, TSQL, Maintenance.
- SQL Server Analysis Services Confidential
- . Dimension, Hierarchy, Fact design. MDX.
- SQL Server Integration Services Confidential
- Extract, Transfer, Load ETL
- SharePoint 2010 Performance Point Reporting
- Development in Visual Studio Confidential
- , TFS, C .
- Extensive Project Management Experience including Requirements Gathering, Analysis, Design, Development, and Implementation.
PROFESSIONAL EXPERIENCE
Confidential
Business Intelligence DBA
- Design, build, deploy, maintain, and administer SQL Server 2008 R2 Analysis Services SSAS OLAP databases. Lead recurring meetings with stakeholders and analysts to review progress, clarify requirements, and plan work to be done. Monitor cube processing jobs, Analysis Services databases, and reporting components.
- Responsible for the migration from a legacy server 2005 SQL Server to a new replicated SQL Server 2008 R2. Identified unnecessary components, ensured compatibility of legacy code, and implemented any required changes. Redesigned Data Transformation Services DTS packages to use Integration Services. Lead recurring meetings with DBA's to review changes and discuss plans.
- Monitor SQL Server database processes, respond to issues, and ensure system availability. Perform on-call duties as required for 24/7 operations.
- Create and modify SQL Server T-SQL code for both new development and maintenance. Utilize formal change requests, peer reviews, testing plans, and post-deployment testing. Identified modifications to indexes which substantially improve performance and follow best practices. Assist fellow DBAs with peer reviews, adherence to best practices, and recommendations.
Confidential
Microsoft Solutions Developer/Analyst
- Designed an OLAP database using Microsoft SQL Server Analysis Services SSAS 2008 R2. Created dimensions, hierarchies, KPI's, drill-through actions, and measures related to Brownells sales. Worked with our Microsoft Partner to create Performance Point reports utilizing filters, charts, drill-through actions, and the decomposition tree.
- Designed a Data Warehouse in SQL Server 2008 R2, with data loaded from the COBOL source system in near real-time. Developed and implemented the Extract, Transfer, and Load ETL process using Integration Services. Used T-SQL queries, views, and functions to re-create calculations from the source system.
- Installed, Configured, and Deployed a SharePoint 2010 portal with our Microsoft Partner. Implemented SharePoint Sites, Document Libraries, MySites, Wikis, and Blogs. Incorporated SQL Server Reporting Services 2008 R2 reports, charts, and custom ASP.NET web applications.
- Implement solutions as required using C . Automate data collection from government web sites on restricted customers. Create ASP.Net application providing negotiated package rates using UPS web services. Combine multiple calendars on an interactive ASP.NET web page. Automate data gathering from a SQL Server database running on remote point of sale systems.
Confidential
Systems Integrator
- Developed C programs to integrate Progress databases to Maximo, a MRO application which uses a Microsoft SQL Server database. Created stored procedures which are called from C programs.
- Developed ASP.NET solutions for a SharePoint Portal. Integrated applications with Active Directory and Progress databases.
- Maintained and developed intranet web pages using MySQL and PHP.
- Maintained and customized Progress 4GL programs. Generated ad-hoc reporting.
Confidential
Programmer Analyst
- Produced Web applications that provide interactive reports, order retrieval, and drill down functionality to clients and internal users.
- Generated 70,000 in annual cost savings through an automated voice mail system. Designed a service oriented architecture that separates the Progress database programs from the IVR programs, facilitating team-based development and scalability. Improved daily throughput by 400 .
- Developed Web Services for a Service Oriented Architecture corporate initiative, providing order and status information to .NET web applications using XML parameters.
- Awarded Impact Performer of the Year for outstanding performance.
Confidential
Programmer
- Generated 75,000 annual cost savings by developing and implementing an Access database to rate lumber suppliers.
- Developed Visual Basic programs to optimize veneer usage for a new manufacturing cell.
- Developed a Microsoft Access scheduling application for a manufacturing production line, generating 60,000 annual cost saving
Cost Center Manager
- Managed a manufacturing cost center. Supervised 20 employees.
- Participated on Kaizen continuous improvement teams to reduce cost, improve ergonomics and safety, reduce work-in-process, and improve on-time performance