**** ******* ***, #*, ******* 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 ResumesSql Server Manager
Los Angeles, CA - dba, developer, c#, db2, turbine, programs,...Manufacturing Manager Supply Chain Time Control
Johnson City, TN - jerry, cnc, aviation, steel, tennessee, aerospace,...Instrument Engineer
Australia, WA - instrumentation, instrument, indonesia, engineer,...Management Sales Project Business Service Customer
Canada, Toronto, ON - bpo, offshore, canada, united kingdom, kingdom,...Administrative Assistant Executive Customer Service
Canada, Toronto, ON - toronto, sharepoint, vp, canada, instrument,...Engineer Entry Level Engineering Business Process
River Forest, IL - chennai, entry level, process engineer, wind,...Graphic Designer/ Wilcom/Photoshop
India, Surat - sample, programmer, buyer, surat, textile,...SAP Project Manager
Buffalo, NY - sample, sap, truck, six sigma, thermal, mumbai,...Construction Manager, Superintendent, Project Manager
United States - superintendent, construction manager, construction,...Engineer Electrical Project Power Plant Maintenance
Philippines, Manila, Northern Mindanao - philippines, turbine, power plant, inspector,...