SQL Developer

Overview

On Site
Full Time
Part Time
Accepts corp to corp applications
Contract - W2
Contract - Independent

Skills

Employment Authorization
Backup
Data Analysis
Data Migration
Stored Procedures
Communication
Estimating
Microsoft Azure
DevOps
Version Control
Documentation
Reporting
Management
Supervision
Database Administration
Microsoft SQL Server
Microsoft SSIS
Windows PowerShell
Scripting
SQL
Software Analysis
Database
Technical Direction

Job Details

Hiring: W2 Candidates Only



Visa: Open to any visa type with valid work authorization in the USA

They will also serve as a backup for the chief of the database administration section when required.

Responsibilities:

  • Perform database management activities using Microsoft SQL Server 2016/2019
  • Install database software
  • Analyze, design, and review logical and physical data models
  • Support the application system development life cycle.
  • Perform data analysis and correction activities
  • Load data tables and perform data migration sfrom one database structure to another
  • Review and migrate stored procedures;recommend improvements to enhance performance
  • Write and Use SSIS (SQL Server Integration Services) and PowerShell Scripts
  • Follow and help enforce established PDE database standards.
  • Monitor database performance and space requirements and give recommendations to improve
  • Analyze and resolve database performance issues
  • Assist with conversions from older SQL versions to current version
  • Maintain database access security and database integrity
  • Help ensure databases are backed up appropriately and can be restored if necessary
  • Assist with database server infrastructure and software analysis and recommendations
  • Conduct work in a team environment
  • Use strong communication skills; both written and spoken
  • Determine time estimates and schedule for own work
  • Use Azure DevOps for source control, manage work items, for documentation versioning, and to report time spent on all assigned work item activities
  • Complete assigned work activities; Anticipate and resolve issues in a timely manner
  • Communicate accurate and useful status updates to the Database Administration Section Chief, and to each Application Lead analysts/project managers
  • Execute all assigned responsibilities with little direct supervision from the Database Administration Section Chief
  • Represent DBA staff at status meetings and other meetings as requested
  • Keep current with the features of new database releases and related database products and make recommendations as to their use
  • Make recommendations on best practices and improvements surrounding database administration practices


Skill

Required / Desired

Perform database management activities using Microsoft SQL Server 2016/2019

Required

Write and Use SSIS (SQL Server Integration Services) and PowerShell Scripts

Required

Assist with conversions from older SQL versions to current version

Required

Assist with database server infrastructure and software analysis and recommendations

Required

Help ensure databases are backed up appropriately and can be restored if necessary

Required

Maintain database access security and database integrity

Required

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.