Direct Hire, No Sponsorship or Corp to Corp
SQL SERVER DATABASE ADMINISTRATOR
: BE or BS Degree in one of the following subject areas: Computer Science, Business Administration, Information Technology or related field preferred
: 3-5 years Microsoft SQL 2005, 2008 experience
: Minimum of 3-6 years of experience building system solutions, working as a member of a multidiscipline team, utilizing formal development methodologies.
: Minimum of 3-6 years of experience in Data Analysis, Database Administration, or Database Replication in a high volume multi-platform transactional environment; experience with data warehousing technologies is desirable.
: Minimum of 3-6 years of development and enforcement of data management policies, standards, and procedures.
: Conceptual knowledge of project management techniques is required.
: Understanding of, and experience with, server-client computing and relational database environments
: Experience with data management and data processing flowcharting techniques
: Knowledge of reporting and query tools and practices
: Good understanding of the organizations goals and objectives
: Good interpersonal, written, and oral communication skills
: Technical documentation skills
: Ability to present ideas in user-friendly language
: Self motivated and directed, with keen attention to detail
: Able to prioritize and execute tasks in a high-pressure environment
: Experience working in a team-oriented, collaborative environment
: Good written and oral communication skills
Necessary Skills or Characteristics:
: Advanced knowledge of writing SQL scripts
: Experienced in data modeling.
: Exposure to UML or other associated object orientated design methodologies.
: Demonstrates a strong understanding of the database development life cycle including data modeling, database coding, testing, and implementation.
: Strong experience of relational databases, backup and restore operations, DB logins/permissions, stored procedures, schema, triggers, database maintenance activity, etc.
: MS SQL Server 2005 & 2008
: SSIS development
: N-tier Architecture
: Windows 2003/2008 Server
: Remote Procedure Calls (RPC), store procedures
: Works under close supervision from senior technical staff, on occasion working independently.
: Maintains system level entity relationship diagrams, translates business requirements into transactional database schema designs, assesses the appropriateness of replicated data, and verifies compatibility of database tool and application software packages with existing database architectures and standards.
: Maintains meta data, administers the development and staging environments data repository, determines data types, optimizes the physical database design for the specific DBMS, and approves schema changes, call patterns, and SQL code.
: Codes and installs changes to the database schema, stored procedures, and replication processes utilizing DBMS- or package-specific techniques as appropriate.
: Develops and executes procedures to validate changes to the database infrastructure.
: Prepares required documentation and participates in change control, works with production database administrators to migrate schema and stored procedure changes to Production and participates in the verification processes.
: Responsible for the modeling, definition, creation, and maintenance of the database resource.
: Works closely with a team of developers and is involved in design decisions.
: Provides developers consulting on performance and optimizing SQL scripts.
: Creates or reviews data models.
: Reviews and tests new technologies and architectures that support and are aligned with applications
: Enforces existing database standards and documents DBA processes.