|
|
|
|
| Desired Industry: Computer Software/Programming |
SpiderID: 28594 |
| Desired Job Location: dallas, Texas |
Date Posted: 9/8/2009 |
| Type of Position: Contractor |
Availability Date: immediate |
| Desired Wage: |
|
|
U.S. Work Authorization: Yes |
| Job Level: Experienced with over 2 years experience |
Willing to Travel: |
| Highest Degree Attained: Bachelors |
Willing to Relocate: Yes |
Objective:
Role: SQL Developer/SSIS Developer/SSRS Developer
• Over 6 years of experience in IT Industry as a Developer and Administrator of MS SQL Servers 7.0 and 2000/2005/2008.
• Experience in Installation, Configuration, Maintenance and Administration of SQL Server and applying Patches and Service packs to keep the Database at current patch level.
• Creation of Data Marts for collective view by a group of users.
• Experience in Migration from SQL Server 2000 to SQL Server 2005
• Experience in Extracting, Transforming and Loading (ETL) data using SSIS which is latest in 2005 also implemented DTS Import/Export utility.
• Experience in creating Packages, Jobs, Sending Alerts using SQL Mail and DTS Packages.
• Experience in creating and managing Database objects like Triggers, Tables, Views, Stored Procedures, Indexes, Roles, Rules, Defaults, User defined Data Types and Functions using SQL and PL/SQL.
• Experience in Debugging Stored Procedures, Triggers and Functions.
• Experience in establishing Backup, Recovery, and Disaster Recovery.
• Experience in generating different Reports using MS SQL Server Reporting Services (SSRS) and Crystal Reports.
• Experience in troubleshooting SQL issues by using SQL Tools, Execution Plan, Trace, Statistics, index Tuning wizard.
• Good knowledge on OLTP and OLAP databases.
• Experience in Creating SQL Server Integration Services (SSIS) packages to integrate the data coming from various data sources.
• Knowledge in implementing Failover Support for SQL Server with Active/Active and Active/Passive Cluster configuration.
• Experience in SQL Server Analysis Services (SSAS) in SQL 2005 and SQL Server 2008
• Experience in developing web forms using C#.Net, .Net Framework 2.0.
• Defining Data warehouse (star and snow flake schema), fact table, cubes, dimensions, measures using SQL Server Analysis Services.
• Experience in using Performance Monitor and SQL Profiler.
• Excellent Analytical, Production Support, Problem Solving, Communication and Interpersonal skills, with ability to interact with individuals at all levels.
Experience:
PROFESSIONAL EXPERIENCE
Client: USPTO, Alexandria, VA July 2008 – Till Date
Role: SQL Developer/SSIS Developer/SSRS Developer
Responsibilities:
• Analyzed business requirements and build logical data models that describe all the data and relationships between the data.
• Assisted in production OLAP cubes, wrote queries to produce reports using SQL Server 2000/2005 Analysis Services (SSAS) and Reporting service (SSRS).
• Administering the MS SQL Server by creating User Logins with appropriate Roles, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Designed normalized database schemas for document repository project. Coordinated with business unit and development staff to design most efficient schema.
• Experience in developing web forms using C#.Net, .Net Framework 2.0 using agile methodology.
• Developed SSIS Templates which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Dev, Test and Production Environments.
• Developed complex T-SQL Programs, writing Stored Procedures (with proper Exception Handling), Triggers (DDL & DML), Cursors, Indexes and Views.
• Query performance optimization and troubleshooting. Identification and optimization of long running queries, poor indexing, parallelism issues, etc. and their effects on the database /application. Utilized performance tools including SQL Profiler, Performance Monitoring, Query Analyzer Execution Plans, Database Engine Tuning Advisor, Index Tuning Advisor etc.
• Involved in Analyzing, Designing, Building and testing of OLAP Cubes using SQL Server Analysis Services (SSAS) 2005.
• Used MDX for retrieving multi-dimensional data.
• Setup the performance counter by using Performance Monitor to identify the bottleneck of windows server such as CPU, memory, IO, paging and SQL Server and also bottleneck of SQL Server such as buffer cache hit, memory, transaction, procedure cache, paging etc.
• Migrated data from Heterogeneous Data Sources and legacy system (DB2, Access, Excel) to SQL Server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.
• Active part in building Star schema and Snow flake schema based on the business requirements.
• Experience in migration from SQL Server 2000 to SQL Server 2005 using SQL Upgrade Advisor.
• Created several Complex Reports (sub reports, graphical, multiple groupings, drilldowns, parameter driven, formulas, summarized and conditional formatting) using SSRS (SQL Server Reporting Services).
• Experience in migrating some of the DTS packages in to SSIS.
• Exposure to running online jobs and creating alerts, notifications and Emails on failure of jobs.
• Troubleshooting deadlock issues by setting Trace Flags and Analyzing Locks.
• Created additional File and File Groups and moving database objects between them to resolve performance and space issues.
• Created batch programs using T-SQL and scheduled them as jobs in order to run the reports more efficiently.
• Excellent understanding of multi tiered application environments. SQL Server interaction with client based desktops, application servers, and Microsoft Internet Information Server (IIS).
Environment: SQL Server 2000/2005, T-SQL, Windows XP, Enterprise Manager, SQL Server Management Studio, SQL Server Business Intelligence Studio, SQL Server Profiler, IIS, SSRS, SSAS, SSIS, Proclarity, XML, Visual Studio 2005, Visual Source Safe (VSS).
Client: AIG, Los Angeles, CA Feb 2007 - Jun 2008
Role: SQL Developer/SSIS Developer/SSRS Developer
Responsibilities:
• Responsible for providing 24x7 Production support, Database and Log Backups & restoration, Backup strategies and scheduling Backups. Backing up system and master databases and restoring them when ever necessary.
• Gathered functional requirements, analyzing and writing the technical specifications.
• Responsible for report generation using SQL Server Reporting Services (SSRS) and Crystal Reports based on business requirements.
• Extensive experience in designing, creating and deploying SSIS packages for transferring data from flat files, excels spreadsheets and heterogeneous data to and from SQL Server.
• Involved in Analyzing, Designing, Building and testing of OLAP Cubes using SQL Server Analysis Services (SSAS) 2005.
• Developed physical data models, data warehouse models and created DDL scripts to create database schema and database objects.
• Migrated the data from Oracle database to SQL server 2005 database using SSIS.
• Fine tuning Stored Procedures to improve performance that was achieved by removing unnecessary cursors.
• Experience in debugging Stored Procedures using Visual Studio Tool by setting break points.
• Regular responsibilities for updating staging and dimensional databases as well as rebuild the Dimensions and Cubes in Analysis Services.
• Excellent backend skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers (DDL & DML), User Defined Data types and Functions (UDF).
• Expertise in Troubleshooting Locking, Blocking, Deadlocking and performance issues with very good understanding in SDLC (Software Development Life Cycle).
• Work with App Teams on creating a productive Development, Test and Production environment for App Databases.
• Make recommendations for File group Creation and Placement, Right Data types for the Structures created.
• Monitor and tune SQL Scripts. Creating upgrade scripts for production environment. Responsible for installation of SQL Server Packs and Hot fixes.
• Developed SSIS Packages for Snapshot, Incremental, Historical Changes (SCD Type 2) Data Loads.
• Experience in query optimization & performance tuning using SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands.
• Responsible for report generation using SQL Server Reporting Services (SSRS) and Crystal Reports based on business requirements.
• Provided back-end support for performance testing and functional testing using use case testing methodologies.
Environment: SQL Server 2000/2005, T-SQL, Windows XP, Enterprise Manager, SQL Server Management Studio, SQL Server Business Intelligence Studio, SQL Server Profiler, IIS, SSAS, SSRS, SSIS, XML.
Client: Black and Decker, Hampstead, MD
Education:
EDUCATIONAL QUALIFICATIONS:
Bachelor of Technology
Jawaharlal Nehru Technological University.
Skills:
Relational Databases: MS SQL Server 2005, 2000, 2008, Microsoft Access,
Oracle 9i, 10g
ETL Tools : DTS (Data transformation services), SQL Server Integration Services (SSIS)
Database Tools : SQL Profiler, SQL Query Analyzer, Index Analyzer, DTS Import/Export, Backup Server, Replication server, SQL Agents, SQL Alerts, SQL Jobs, SQL Mail, SQL Client Configuration utility, Replication Tools
Reporting Tools : MS SQL Server Reporting Services (SSRS), Crystal Reports
Web Servers : IIS 5.0, IIS 6.0
Candidate Contact Information:
TheJobSpider.com has chosen not to make contact information available on this page.
Click "Contact Candidate" to send this candidate a response. |
|
|
|
|
|