Microsoft Sql Server Dba Level Ii
CIBER, Inc. (Portland, Oregon)

This job posting has expired.

You may wish to try a search for Microsoft SQL Server DBA Level II

Or visit the FlipDog home page
 

Attachment A:  Contractor Employee Skills Description

Database Administrator

12.4  Microsoft SQL Server Database Designer

Level II

 

Field:

Computer Technology

Experience Level:     

5-9+ years

Education Level:

Undergraduate College Degree or equivalent experience

Certification Required:

 

Performance Period:

 

Estimated Hours During Performance Period:

 

Hourly Rate:

 

Vendor Name:

 

RFP Number:

1040

Contractor Employee:

 

Contract Number:

 

 

Overview:

A Database Administrator– Database Designer creates and maintains database objects within the database based upon physical data models and other specifications provided.  The Database Administrator - Database Designer migrates data from source RDBMS’s to databases on the MS SQL Server 2005 platform and has functional skills in Object/Relational mapping and web services, Simple Object Access Protocol (SOAP) and Web Services Description Language (WSDL).

The Level II Database Administrator- Database Designer is a position requiring from 5-9+ years of demonstrated database design experience using Microsoft SQL Server, structured query language (SQL), Microsoft SQL Server Reporting Services (SSRS),data migration tools (Microsoft Data Transformation Services (DTS) and SQL Server Integration Services (SSIS)). 

The Database Administrator – Database Designer is a supplemental labor position and the candidate is not an employee of BPA or of the United States Government. The candidate is subject to all federal laws, contract requirements, security policies and procedures while performing his or her work on site at BPA. The candidate will not have any supervisory authority over federal employees.

The Database Administrator - Database Designer must possess the skills required to perform the work assigned (i.e., the “know-how” when reporting to work).  Bonneville Power Administration (BPA) is not responsible for training or directing the candidate on how to perform the work, and the candidate is responsible for delivering the “know-how” within the workplace requirements, policies, rules, regulations, federal law and the timeline requested.

For security purposes, the Database Administrator - Database Designer may not bring his or her personal computer on site at BPA. In addition, he or she may not bring on site and transfer to any flash memory device or any other media any BPA data, files, or images.

 The Database Administrator - Database Designer carries out work requirements which may require advanced permissions allowing exposure and access to sensitive data and information so confidentiality is paramount.

Privileged Access

The Database Administrator/Database Designer contractor employee’s work will require privileged access to BPA Information Technology (IT) networked or desktop systems.  Such access contains data and information that may contain all or at least one of the following: For Official Use Only, Critical Infrastructure Information, Privacy Act, Personally Identifiable Information (PII), and/or sensitive unclassified information (SUI).  Contractor employees who require and are granted privileged access to BPA IT systems, the following conditions apply, and the contractor employee, as the user, acknowledges the following:

1.  Contractor employee will conform to all BP IT cyber security requirements and policies regarding privileged access with special emphasis on the Cyber Security Program Plan (CSPP) and the BPA Manual 1110;

2.  Access is only granted on the basis of need as established by the organizational supervisor and under the least privilege policy;

The Vendor acknowledges all risks and costs in providing to BPA the Database Administrator / Database Designer supplement labor.  The Vendor is responsible for reviewing BPAM requirements, discussing and/or developing procedures in controlling risks and ensuring conditions are met for the Database Administrator/Database Designer contractor employee.

Skill Requirements:

Knowledge of and skill in applying

·        Microsoft SQL Server 2000 and Microsoft SQL Server 2005.

·        Data migration tools such as Microsoft Data Transformation Services (DTS) and SQL Server Integration Services (SSIS).  Informatica tools a plus.

·        Microsoft SQL Server Reporting Services (SSRS).

·        Object/Relational mapping and web services, Simple Object Access Protocol (SOAP) and Web Services Description Language (WSDL)

·        Analysis, organization, categorization, assimilation, and integration of data, business rules for database objects for source to target data mappings from multiple RDBMS’s and other sources to a Microsoft SQL Server database.

·        Architecting and communicate source to target data mappings conversions.

·        Data modeling with an emphasis on the design and development of physical data models using named industry standard tools such as Computer Associate’s AllFusion Database Designer (ERwin).

·        Sound understanding of database administration principles with regard to database performance, configuration and the appropriate level of denormalization.

·        Data management standards and guidelines.

·        Database security

·        Intra-team and Inter-team communication and collaboration.

·        Microsoft Office Suite including Word, Outlook, Excel.

 

Sufficient to:

·           Create and maintain database objects (tables, indexes, views, triggers, stored procedures, database users, roles, etc.) in MS SQL Server.  Knowledge of other RDBMS platforms (e.g. Oracle and Sybase) is a plus.

·           Use Microsoft Data Transformation Services (DTS) and/or SQL Server Integration Services (SSIS) and other data conversion, data loading solutions.

·           Utilize Object/Relational mapping.

·           Utilize web services, Simple Object Access Protocol (SOAP) and Web Services Description Language (WSDL) using Visual Studio 2005 Team Edition.

·           Analyze source to target data needs to create database objects and provide data mapping for migration solutions in collaboration with application developers, other database administrators on simple to very complex migrations while ensuring that data and business rules are upheld and processing occurs efficiently and securely.

·           Architect, communicate, and implement data conversion and migration solutions from multiple RDBMS and sources to Microsoft SQL Server databases.

·           Perform physical data modeling including:

o       Design and modification of physical data model including appropriate use of normalization/denormalization, referential integrity; primary and foreign key assignments, and physical-only object definitions.

o       Update physical data model using the ERwin data modeling tool.

o       Able to forward engineer data model to create DDL and or database objects.

·           Apply sound database administration to enhance database performance, including changes to database configuration, the appropriate creation of indexes, denormalization, etc.

·           Understand the differences in data modeling and database performance optimizations between OLTP and OLAP databases.

·           Follow published standards, procedures, and guidelines for abbreviations, acronyms, class words and naming standards and data model reviews.  Ensures that the physical data model design includes standard database object names, referential integrity, appropriate constraints, foreign key assignments and consistent/appropriate use of surrogate keys and denormalization.  Ensure database security is administered in accordance to standards and guidelines established by the Cyber Security office, the Chief Technical Officer (CTO), and published data administration data layer standards and guidelines.

·           Communicates with business and technical staff:

o       Negotiate priorities and resolve requirement conflicts among various stakeholders

o       Communicate with a wide variety of technical and business experts in both individual and group settings using email and presentations.

o       Provides coordination between business clients, application development personnel and database administrators.

o       Works with developers to troubleshoot Transact-SQL and DBMS performance problems.

o       Responsible for the communication and coordination during the migration of database objects from development to test and from test to production environment.

o       Communicate with a wide variety of technical and business experts in both individual and group settings using email, self-generated documentation and presentations.

o       Works with developers to mitigate data insufficiencies while educating for future improvement.

o       Maintain documentation using Microsoft Word, Excel, etc.

Additional Skills Desired:

Knowledge of and skill in applying

Knowledge of SQL Server 2008 features is a plus.Microsoft .NET is a plus.

·        Significant data modeling experience

·        Extract Transformation and Load (ETL) tools.

 

Sufficient to:

·        Create and modify data models:

o       With experience doing data modeling with Computer Associate’s AllFusion Database Designer (ERwin) version 4.1.4.

o       By deriving physical data models from a logical data model.

o       By reverse engineering a physical data model from a physical database.

o       Information Engineering (IE) modeling notation.

·        Develop migrations with Informatica.

 

Performance Requirements:

Carry out assigned tasks with a professional demeanor reflected in excellent written and oral communication skills, listening skills, patience, analytical reasoning and problem solving abilitiesAbility to meet timelines, milestones, deliverables and provide timely (weekly) status updatesCommunicate technical information verbally and in writing to technical and non-technical usersProvide a sustainable IT infrastructure by supplying cross training and functional documentationProvide on-call and backup support for existing systems and functions.  Location for on-call and backup support may be at BPA facilities or off-site.  Required to carry a BPA supplied cell phone/pager and work non-core hours when requested.Understand and follow established processes and procedures including Change Management, Work Tracking and Time Management.