SQL Developer

Position: SQL Developer

Duration: 1 year with possible Extension

Location: Montgomery, AL (On-site from day1)

Project Description

Mid-level SQL Developer / DBA working in a team environment that will operate in all aspects of database design, security, monitoring, and administration of SQL Server versions 2012+ and Azure DB. This position will have a heavy focus on building and maintaining SSIS packages, SQL queries, and stored procedures.

Skills Required

• SQL Server DBA * Advanced SQL query development
• Strong SSIS development skillset
• Strong communication and organizational skills.
• Ability to use problem-solving and analytical skills to take on challenging tasks
• Desire and ability to learn and hone new skills
• Able to work both independently and as part of a team.

Skills Preferred

• SSRS
• Azure DevOps
• Familiarity with the Agile Process
• Azure DB
• Data Modeling

Experience Required

• 3+ years of SQL Server Database Administration focusing on
• Developing, maintaining, and deploying SSIS packages
• Relational database modeling and design
• Installing SQL Server
• Writing and analyzing complex queries in T-SQL
• Troubleshooting and problem solving of performance and other issues related to locking and blocking
• Routine database maintenance such as backups, reorgs, and database recovery
• SQL Server security and encryption methods
• Developing T-SQL stored procedures, functions, views and triggers
• Working in a VSTS (Azure DevOps) and Agile environment.

Responsibilities:

• Meet with business partners to understand requirements.
• Communicate with technical, applications and operational teams to ensure database integrity and security.
• Create design documents, develop and unit test code changes, and participate with users in UAT testing.
• Understand new and existing processes and come up with methods to resolve issues.
• Manage database access across various user groups (internal and external).
• Assist in Database Design and Development.
• Create and maintain SSIS packages to import / export data and automate processes.
• Participate in the creation of development, staging, and production database instances, and the migration from one environment to another.
• Recommend and implement emerging database technologies.
• Recommend optimizations to existing application queries.
• Data security monitoring.
• Support production databases after hours as needed.

Education Required

Bachelor's Degree in Computer Science, Information Systems, or other related field; Or equivalent work experience.