SQL Development experience with SSRS/SSIS and OLTP


Pranay Mateti
2:28 PM (11 hours ago)
to bcc: me 

Hi,

 

This is Pranay from Reliable Software, please send me your updated resume to pranay.m@rsrit.com


Job title: SQL Developer/Database Engineer with SSRS/SSIS and OLTP

Location: Pasadena, CA

Duration: 6 months


Green card Holder/US Citizens /GC EAD/L2 EAD/H4 EAD

Looking for a Senior Database Engineer!!!! Candidate must have strong SQL Development experience with SSRS/SSIS and OLTP. Extensive OLTP experience is a MUST!!!!!


PLEASE NOTE: INTERVIEW OVER SKYPE IS ALLOWED BUT CANDIDATE MUST INTERVIEW FROM ONE OF THE VENDOR OFFICE LOCATIONS ANYWHERE IN THE US!!!!

 

CANDIDATE MUST INTERVIEW AT THE CLIENT SITE IF LOCAL

 

PRIMARY DUTIES/RESPONSIBILITIES/EXPECTATIONS:

Database Design and Development

•Reviews business requirements and technical design documents to develop effective database solutions

•Logical and Physical Data Modeling for the Client’s internal and external facing applications using database normalization and de-normalization methods.

•Developing, documenting and performance tuning of effective data access routines such as stored procedures, views, triggers and functions

•Developing effective heavy duty data solutions for Database Archiving, Data Conversion and Batch Data interface using SQL Server Integration Services (SSIS)

•Provide technical leadership for large-scale database projects

 

Database Management

•Installation and configuration of SQL Server in database servers in both stand alone and clustering environments.

•Monitoring and Managing System Performance, Security  and Capacity, taking Proactive actions to increase capacity to meet demand by upgrading hardware including disk, memory and processor

•Management of the database environment by defining database maintenance tasks, such as backup & restore, indexing, statistics, alerts and notification for database servers.

•Maintaining documentation related to database server configuration and database change management.

•Providing User and Develop support for data needs.

 

OTHER

•Works on project deliverables while supporting day-to-day production activities.

•Enforces established documentation guidelines and best practices.

•Maintains a high degree of business functional knowledge and current automated technologies and tools.

•Adheres to all policies and procedures concerning all confidential information including but not limited to internal use and restricted information, including Protected Consumer Information (PCI) and Protected Health Information (PHI).

•Adheres to all Company Health and Safety policies and procedures.

•Administers duties as defined by the Client’s performance review plan within the required deadlines.

•Other duties as assigned by supervisor.

 

QUALIFICATIONS:

REQUIRED

•A minimum of 7 years or more of hands-on experience with MS SQL Server Database design, development and administration

•A thorough understanding of relational databases and SQL

•Experience with MS SQL Server 2005 and 2000 environments with some emphasis in Database Administration, including management tools.

•Advanced knowledge of SQL query development using MS SQL-Server 2005

•Strong Experience in SQL Performance Tuning using various performance matrix gathering techniques.

•Strong Experience in SSIS and heavy duty SQL Development using SQL Server internal database metadata structures, XML and Encryption

•Experience with database communication mechanisms: .NET, ODBC and TCP/IP

•Experience in code migration, database change management and data management through the various stages of the development life cycle

•Understanding of logical and physical modeling concepts

•Experience with the MS SQL Clustering architecture

•Excellent communication, interpersonal and organizational skills

•Ability to prioritize, meet deadlines and to work well under pressure

•Must enjoy working in a fast-paced teamwork environment and dealing with a variety of people

•Will work with both minimal supervision and in a collaborative team environment

•BS degree in Information Technology/Computer Science or equivalent work experience

 

 

ADDITIONAL SKILLS DESIRED (all of these would be pluses, but none is absolutely required)

•Banking and/or credit card systems (stored value systems) experience.

•Knowledge of new database technologies a plus

•Experience in architecture and configuration of MS SQL database mirroring, partitioning, Service Broker and Notification Services

•Experience in Microsoft Operating System – Windows Server 2003

•Experience in SQL Server 2008

•Microsoft SQL Certification will be a plus.

 

 Pranay M

Technical Recruiter

(W) 312-448-6138

22260 Haggerty Rd, Suite # 285,Northville, MI 48167.

www.rsrit.com