* SQL DBA AVAILABLE IMMEDIATELY* **
* REQUEST**: **please take a minute and add **[email protected] ** in
your mailing list for current and future requisitions.*
* Please scroll down to know for other available consultant
Technologies.*
*Consultant*
*Skills*
*Exp*
*Location*
*Availability*
Swagath
* SQL DBA*
7+ Years
NJ
Immediately
*Summary*
· *7+ years* of IT experience in *SQL SERVER Database
Administration, System Analysis, Design, and Development* & Support
*in Production,
QA, Replication and Cluster Server Environments*.
· Experience in *installation and configuration *of MS SQL Server *
2008/2005/2000* versions.
· Experience in *Migration from SQL Server 2000 to SQL Server
2005/2008* as well as *DTS Exchange tool for migrating DTS packages to SSIS
packages. ***
· Installed and created SQL Server software and databases *on UNIX/
NT servers*. **
· Strong knowledge *Database Design & Architecture principles*.**
· Exposure to *Oracle programming and Architecture*.**
· Knowledge in Setting up of *SharePoint *Database in SQL Server
2000.**
· Experience in *up gradation/Migration of MS SQL* Server 6.5/7.0
to MS SQL Server 2000 and now 2000 to 2005 and 2008 *by in place upgrade
process and Side by Side process***
· Experience in *migration of Data from Excel, Flat file, Oracle to
MS SQL Server by using BCP and DTS utility*. Extracting, Transforming and
loading of data using SQL Server DTS.
· Installing SQL Server in a *Cluster Environment*.
· Experience in *IIS, MTS, and Windows NT administration*.
· Experience with *upgrades and service pack installations Tuning
and normalization*.
· Expertise in planning and implementing *MS SQL server security
and database permissions*
· Experience in *Database Backup, Recovery and Disaster Recovery
procedures*.
· Extensive experience with *Storage Capacity planning, including
system storage allocation, on-going capacity analysis and planning future
storage requirements*.
· Hands on experience and outstanding knowledge in *high
availability solutions, including SQL Server clustering, replication, Log
shipping, and Mirroring.***
· Managed the multiple databases (DB) under *clustered
(active/active, active/passive) and **implementing RAID technology.*
· High level proficiency with various types of *Replication Models
such as Snapshot, Transactional and Merge Replication* (Planning,
Replication Tools, Implementing Replication).
· Extensive knowledge of *Relational Database Management Systems*.
· Experience in Extraction Transformations and Loading (ETL) tools
like Data Transformation Services (DTS), Bulk Insert, and *BCP for OLTP and
DSS* (Data Mart/Data Warehouse) environment.
· Extensive experience in *Capacity planning, Maintenance planning,
Performance Tuning*.
· Proficient in *monitoring SQL Server Performance* using *SQL
Profiler** (Dead Locks/Long running queries), Query Analyzer, Index Tuning
Wizard, Database Engine Tuning Wizard and Windows Performance Monitor. *
· Good experience in monitoring *Windows and SQL Server error logs*.
· Experiences in *Performance Tuning, Query Optimization,
Client/Server Connectivity, Database consistency checks using DBCC,
resolve Dead
Locks/Long running queries*.
· Design *entity relationship diagrams* and dimensional data
models.
· Involved in optimizing code and improving efficiency in databases
*including re-indexing, updating statistics*, recompiling stored procedures
and performing other maintenance tasks.
· Strong SQL Server Administration skills using various backup
strategies, Model *(simple, bulk and full),* database maintenance plan, user
(NT/SQL) security authorizations, database creation.
· Very good hands on experience with *DB Artisan admin tool and SQL
Assistant tool.*
· In depth knowledge of developing *complex stored procedures,
views, efficient triggers,* required functions, and *creating indexes and
indexed views* *using SSMS and SQLCMD. *
· * *Very strong knowledge in* HQL (*Hibernate query language*).*
· Proficiency in web-tier development using Struts/JSTL/HTML
-proficiency in middle-tier and back-end programming using SQL, HQL, JPA/QL*
.*
· created and managed *schema objects such as tables, views,
clusters, indexes, procedures and triggers through query analyzer*
· Experience in implementing *business logic using Triggers,
Viewsand Stored
procedures*.
· Experience with *ER-win data modeler for generating physical and
logical schemas. Generating DDLs scripts and Forward and Reverse Engineering
Databases.***
· Managed day-to-day User activities like *creating logins,
granting permissions, applying security for new users and creating user
Roles and Role Members to ensure Security.*
· Supported the *deployment of SQL Server 2005/2008, SSAS (Analysis
Service), SSRS (Reporting Service) and SSIS (Integration Service for ETL
activities).*
· Designing and building the *OLAP cubes using Star schema and Snow
Flake Schema* using native OLAP Service Manager.
· Expert in *Data Extraction, Transforming and Loading (ETL)* using
various tools such as *SQL Server Integration Services (SSIS), Log Shipping,
DTS, Bulk Insert and BCP.***
· Created *DTS and SSIS Package designs for Import/Export from
accesses, oracle and Sybase to SQL Server.*
· Experience in *Designing, Building the Dimensions**, cubes with
star schema using SQL Server Analysis Services (SSAS).*
· Knowledge of *business intelligence/data warehousing
practices*and tools using
*MS SQL Server 2005 Reporting Services (SSRS). *
· Experience *in SQL Server Reporting Services (SSRS)* Installation
and Configuration for *Scale-Up and Scale-Out topology*
· Self-motivated and Flexible to adapt to any new environment and
work on any project.
· Worked as a team member to *provide 24x7 on-call production
database support.*
* *
* *
*Skill Set*
Relational Databases
SQL Server 2008/2005 / 2000 / 7.0, MS-Access 2000/2003/2007, Oracle 9i &
10g, My SQL4/5.
Database Tools
SQL Server Enterprise Manager, Query Analyzer, SQL Profiler, SSIS, SSAS,
SSRS, DTS, BCP, ODBC,SQL OLEDB, DBCC, ADO, ADO.NET, Business Intelligence
Studio, Crystal Reports.
Languages
C, C++, C#, JAVA, VB.NET, ASP.NET, XML, PHP, UNIX Shell Scripts, T-SQL.
Operating Systems
Windows 2003, Windows 2000 server, Win ME/NT/XP, UNIX.
Web Servers
IIS 5.0/6.0, Apache, Tomcat.
Architecture
Relational DBMS, Client-Server Architecture, Clustering, Replication, OLAP,
OLTP.
ETL
SSIS, DTS, Informatica, Data Stage.
Other Tools
Erwin 4.0/3.5, Microsoft Visual Studio 2003/2005, Service Center, MS Visual
SourceSafe, Source Control, MS Visio, Windows System Monitor, Redgate
,sqlcompare, lite speed.
Regards,
Ritesh Doddle
SVK Systems, Inc |Microsoft & Oracle Certified Partner
Direct : 205-538-2350, Alt : 205-510-7424 x 530
Email:-*[email protected]*
11465, Johns Creek Parkway, Suite #180
Johns Creek,Georgia, 30097
Therefore, as God's chosen people, holy and dearly loved, clothe yourselves
with compassion, kindness, humility, gentleness and patience.
Colossians 3:12
--
You received this message because you are subscribed to the Google Groups
"KNOW.IT" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/know_it_az?hl=en.
