Sql Server Business Maintenance Data Services
**** ******* ***, #*, ******* Oaks, CA 91401
• Database Architect/DBA in Healthcare/Financial/ecommerce, and Client/Server applications using MS SQL Server 2012, 2008 R2, 2005, 2000 Administration, Oracle 8i, 9i Administration. Production 24/7 support and maintenance, DBA, Responsible for database designed, installation and setup in standalone, clustered, in physical server and VMware technologies environment, data access permissions and privileges, maintenance setup, storage allocations, Mirroring, performance tuning, Tables, Triggers, Stored Procedures, backup and recovery setup in standalone and clustered environment. Disaster recovery strategies and setup. MSSQL setup with SAN Infrastructure and NetAPP mount point experience. Perform data loads, database refreshes and general maintenance. Operating System Installation and support Windows Server 2008 R2, 2008, 2003, 2000. Standalone and Active/Passive Clustering. Active Directory, Group policy, Site Application, DNS, File Permissions, and User group permissions.
• Design and Implement Disaster Recovery strategies, using SQL Replication, Log Shipping, and Database Mirroring.
• Extensive IT experience in collecting/analyzing requirements, system design, and client/server applications.
Design and Implementation of MS Business Intelligence software applications under different environments.
Developed Maintenance plans such as backup/restores databases, check database integrity task and execute SQL Server Agent Job etc, on the Data Warehouses through the Development studio.
Designed and implement Data Warehouse using SQL Server Analysis Services.
Designed and implement Data Warehouse using SQL Server Integration Services.
Designed and implement on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services.
Used Report builder and provided multiple types of reports in SQL Server Reporting Services (SSRS)
Used Crystal Reports.
Used Cognos Reports.
ETL Tools SQL Server Integration Services (SSIS)
Database SQL Server 2008 R2/2008/2005/2000, Oracle 8i, MS-Access
BI Tools Business Intelligence Development Studio, SQL Server Analysis Services 2008/2005, SQL Server Reporting Services 2005/2008/2008 R2/2012, QlikView Reporting.
Data Modeling Star Schema Modeling, Snow-Flake Schema Modeling, FACT and Dimension tables, Logical and Physical Data Modeling, MS Visio
Operating Systems Windows Server 2008 R2/2003/2000, Windows 7, Vista & XP.
Similar ResumesYouth Organizer
Los Angeles, CA - speech, writer, chemistry, black, youth, press,...Electrical-Mechanical Maintenance Technician
Cedar Hill, TX - electrical, plc, technician,...Quality Assurance Clinical Customer Service Research
Pomona, CA - submit, fda, clinical research, clinical,...Customer Service Manager Business Marketing Quality Control
encino, CA - samples, production manager, graphic designer,...Sales representative
Thousand Oaks, CA - dental, sales representative, buyer, dermatology,...Sales Software Assistant Los Angeles Marketing
Reseda, CA - available upon request, available upon,...Engineer Electrical Engineering Experience Construction
Rancho Palos Verdes, CA - electrical engineer, drilling, electrical,...Manager Quality Engineer Curriculum Vitae Human Resources
New York, NY - vitae, curriculum vitae, rep, engineer, ehs,...Manager Production Sales Warehouse Experience
Buena Park, CA - jerry, offshore, production manager,...Customer Service Administrative Assistant Experience
Upland, CA - submit, airborne, dialysis, trailer, truck driver,...