Job Description :
new position 06/11 - SPA_SSD_540

Client: State of PA - Direct

Rate: $52/hr on C2C

Job Title: SQL Server DBA

Location: Harrisburg, PA

Duration: 12 Months

Position Type: Contract

Interview Type: In-Person


Required Skills:

· Data dictionary analysis and design and data model analysis design Required 7 Years

· 4 year college degree or equivalent technical study. Highly desired

· Experience supporting application system development life cycle Required 7 Years

· Business systems analysis and design experience Required 7 Years

· Administration and scripting experience Required 7 Years

· T-SQL Required 7 Years

· MS SQL Server Required 7 Years

· Physical and logical database design and modeling experience Required 5 Years

· SQL Server Integration Services Required 5 Years

· Dezign (or other ER tool) Required 5 Years

· SQL Server Reporting Services Highly desired 5 Years

· IDERA (or other monitoring tool) Desired 5 Years

Job Description:

DOC requires the services of a DBA staff augmentation consultant to assist with database design and implementation for the CAPTOR project and other DOC/PBPP systems as required.

DOC requires the services of a DBA staff augmentation consultant to assist with database design and implementation for the CAPTOR project and other DOC/PBPP systems as required. The resource is responsible for data analysis and database management. The resource will also be involved in maintenance, enhancement, relational database design, physical and logical database modeling, performance analysis and tuning. The resource should have a range of skills and knowledge of the utilities and production tools used for data storage management to support the Application Team, OLTP and OLAP design concepts, data warehousing, ETL skills, data integration and migration, MS SQL Server best practice, SQL server configuration, SQL server failover clustering, etc.

DOC IT utilizes both waterfall and agile project methodologies. As such, experience with both waterfall and agile project methodologies will be preferred. Resource must also have the following soft skills: Team Player, Communicator (Verbal and Written), Patient, Smart, Analytical, Good Problem solving capabilities, Logical Thinking.

Role Description:

- Physical and logical database modeling.

- Engages in ongoing process improvement

- Database design, installations and conversions.

- Business systems analysis and design experience.

- Logical data modeling techniques.

- Provides status of work to Project Team Lead.

- Knowledgeable in data analysis and database management techniques.

- Execution of all responsibilities with little direct supervision of Team Lead.

- Anticipate and resolve issues specific to the team.

- Determine time estimates and schedule for own work and resolve issues in a timely manner.

- Identify and track issues, risks and action items.

- Skilled data dictionary analysis and design and data model analysis design.

- Maintains central data repository.

- Experience and knowledge in supporting application system development life cycle.

- Responsible for data dictionary backup and recovery.

- Responsible for definition of standards of data dictionaries.

- Communicates accurate and useful status updates.

- Manages and reports time spent on all work activities.

- Follow quality standards.

- Able to work in a team environment.

- Complete assigned tasks.