Database Developer Trenton, NJ

Title : Database Developer* (Power Designer/Erwin) Location : W, Trenton, NJ Type : Contract Interview*: F2F (Mandatory) ONLY GC and Citizen can apply. REQUIRED TECHNICAL SKILLS AND EXPERIENCE: A minimum of 5 years of prior experience demonstrating the following  knowledge and skills: Understands RDBMS principals such as Table Design, Normalization, ACID  properties, Relationships, Referential Integrity and how these apply to SQL ...

Title : Database Developer* (Power Designer/Erwin)

Location : W, Trenton, NJ

Type : Contract

Interview*: F2F (Mandatory)

ONLY GC and Citizen can apply.

REQUIRED TECHNICAL SKILLS AND EXPERIENCE:

A minimum of 5 years of prior experience demonstrating the following  knowledge and skills:

Understands RDBMS principals such as Table Design, Normalization, ACID  properties, Relationships, Referential Integrity and how these apply to SQL  Server.

· Understands Data warehousing principals and is familiar with  Inmon and Kimball Methodology.

· Knows how to optimize physical structures and data processing in  SQL Server and T-SQL for OLTP vs. OLAP.

· Knowledge of Tracing, Monitoring, and Auditing facilities and  methods for SQL Server.

- Create and schedule Batch Jobs to run on SQL Server.
- Work closely with application developers and business users to design  databases.
- Design databases using PowerDesigner/Erwin, logical and physical level.
- Develop database objects including tables, indexes, triggers, views, stored procedures and functions.
- Create DTS packages and jobs to monitor, backup, import/export data  and data warehouse extracts.
- Review peer database design and code.
- modifications to the CCWIS Application/Project and other SQL Serer  environments meet the operational mission of the application as well as  conform to the expected technical standards of the application.

Responsibilities include, but are not limited to: 

- Provides technical support over a team of mainframe developers to  ensure the technical appropriateness of proposed modifications supporting  the CCWIS Application and other SQL Server related applications. 

- Assists the Application Manager in coordinating activities related to  each quarter's software development lifecycle. 

- Acts as the applications' database administrator (DBA) for the  purposes of maintaining the physical structure of the agency's SQL Server  environments, basic performance tuning, consulting with the development  staff on changes to the structure of the database and troubleshooting. 

- Serves as a liaison between the agency and DOIT to coordinate support  activities related to the mainframe or SQL Server environments 

- Coordinates DCF IS mainframe change control.
- Work on conversion of structured and non structured data.
- Participate in the definition, documentation and application of our  Coding and Naming Standards.

- Provide support to developers and/or testers to resolve technical  problems with data and/or databases. 

- Experience in supporting SQL Server-based NET applications. 

- Experience in assisting business analysts our business consumers in  the modeling their data needs.





Thanks and Regards,

Steve

Technical Recruiter.

Global Systems LLC

Office: 240-319-8578 | Email: steve@globalsyst.com, Web: www.globalsyst.com

Yahoo IM - steve20723