SQL Database Developer- Little Rock, AR

Peer Solutions Group - Little Rock, AR (30+ days ago)


We are hiring a SQL Server DB Developer who will be responsible for performing up front profiling and source target mapping that comprehensively documents data lineage, data flow and transformation solution design. Including the migration of DTS and SSIS packages.

Location: Little Rock, AR

Duration: 11+ months

Candidate Type: W2 or Corp-to-Corp (NO OPT/CPT CANDIDATES PLEASE)

Qualifications:

  • Bachelor’s Degree in Computer Science or related technical field
  • The right candidate will have strong SQL Server experience with specific DTS and SSIS upgrade knowledge.
  • Must have at least 10 years experience SQL 2012, 2008, R2,& 2005
  • Must have 6 years experience SQL Server Integration Services
  • Experience upgrading SQL 2008R2 or SQL2005 DTS/SSIS packages to SQL 2012 - 2017
  • Ability to modify existing packages to support ongoing system and business changes
  • Ability to participate in code review, analysis, and execution of packages and stored procedures to re-factor
  • inefficient code
  • Ability to troubleshoot problems with existing packages running on SQL 2008R2 and SQL 2012
  • Document all aspects of migrated and new SSIS packages and security required for future maintainability
  • * Follow data standards and architectural patterns to resolve data issues
  • * Experience writing reports in Reporting Services
  • * Experience with clustered servers
  • * Experience in data backup and recovery procedures
  • * Ability to detect and troubleshoot SQL Server related CPU, memory, I/O, disk space and other resource
  • contention
  • * As performance issues arise, determine the most effective way to increase performance including server
  • configuration changes or index/query changes
  • * Knowledge of SQL Server tools (profiler, SSMS, Perfmon, DMVs, System procs)
  • * Ability to prioritize and manage concurrent projects, demonstrate initiative, work with DBA team and
  • independently with minimal supervision
  • * Strong written and verbal communication skills

About Peer Solutions Group, Inc.

Peer Solutions Group, a full-service, Minority Certified (MBE) IT Services company founded by professionals with hands on experience in Staffing, Recruiting, Project Management, Technology and Consulting. Since the past 10+ years, we have helped our customers strengthen their competitive advantage, reduce operational costs, and improve efficiency by providing our P*ersonalized Effective Efficient R*eliable services with integrity, intellectual growth, quality, respect and positive thinking. Our core capabilities include but are not limited to:

  • Robotic Process Automation (RPA)
  • Business Process Analysis, Re-engineering and Automation
  • Cyber Security Consulting
  • Project Management Consulting
  • Custom Application Development/Programming
  • IT Staffing - Contract & Permanent

Peer Solutions Group is an Equal Opportunity Employer and is committed to providing the right opportunities for the right people. We have a culture of entrepreneurship and innovation where our employees can make a difference. We are looking for like-minded, dynamic individuals to come and join our rapidly expanding team.

Job Type: Contract