|
12+ Years of experience MS SQL SERVER Database that includes DBA, Development, Data Modeler, Architect, Data warehousing, SSIS/ETL, SSRS/Reporting, DSS and OLTP in both Production and Development in Windows Server, SAN and Clustered Environment. This includes T-SQL, C#, PL/SQL, VB.NET, ASP.NET, VB Script/Macros, Share Point Portal, Business Object, SAS, Crystal Report, Cold fusion and UNIX.
SQL SERVER DBA
· Installation, Upgrade and Configuration of SQL Server, Performance Monitoring, Tuning, Profiler Trace.
· Backups, Mirroring and Database Restore
· Log Shipping, Replication Snapshot and Transactional, Fail over Cluster Solution
· Performance Tuning, Query Tuning, SQL Profiler and Performance Counters
· Automation and Monitoring Jobs, Alerts, SQL Mail, Pager and Notification Services
· Security and Grants, Managing Permissions for user/logins and assigning server/database roles
· SSIS/DTS, VB script, Import/Export, Bulk insert, BCP, OSQL, ISQL, DOS Batch Script, SQLCMD
· Link Server, Distributed Queries Access 2000 and Oracle 9i Database, Zip, Unzip, Moving Files, FTP.
ARCHITECT/DATA MODELER
· Data Modeling/Architect, OLTP Database, ERWIN, VISIO, DB Artisan and ER-Studio.
DATA WAREHOUSE/SSIS/ETL
· ETL Process, data conversion, consolidation, cleansing, scrubbing and loading and data transformation
· Analysis Services / OLAP, Data Warehouse Architect, Data Analysis, ETL, Reporting and Data Marts
· Reports, Reporting Services, Web and Crystal Reports for Decision Support System (DSS). Business Objects for DW Reports.
BUSINESS INTELLIGENCE/SSRS REPORTS AND CHARTS
· Reporting Services provides a complete, server-based platform designed to support a wide variety of reporting needs enabling organizations to deliver relevant information where needed across the entire enterprise.
· We can develope Reporting Solution using MS Business Intelligent Studio, Report Definition Language (RDL), Report Manager, Reporting Service Configuration, .Net Report/Application Integration and using T-SQL Store Procs/Functions.
SQL SERVER T-SQL PROGRAMMING/DEVELOPMENT
· T-SQL Development, creating scripts, store procedures, functions, indexes, constraints
· Dot NET Integration and Programming Assemblies using CLR Methods and techniques.
· XML, using Internet information services IIS Configuration, Bulk load XML/XSD/ASCII
· Web/GUI Application Programming using ASP.NET 1.1/2.0 and C#, VB.NET/VB6.0 and CFML, IIS 6.0 and Cold Fusion 4.5/5.0 Prof. Server and MS Share Point Portal, Web Tools like Cold Fusion Studio 4.5/5.0, MS Front Page 2003, and Macromedia Dream Viewer, Photoshop, Adobe Golive.
ORACLE DBA
· Database administration, monitoring, performance tuning, FTP data, file spooling, PL/SQL & stored procedures, creating instance and schema, regular backups jobs, extensive use of SQLLDR, bulk inserts.
|