IO Datasphere, Inc. has been providing project management, software development and IT staff augmentation services to our clients in the Midwest and throughout the U.S. since 1996. We are an approved vendor on contract to provide software development and IT staff augmentation services for the States of Illinois, Michigan, Minnesota, Iowa, and Wisconsin. We also provide these services to businesses, as well as local and county governments, in the Midwest and nationwide.

Our client is undergoing several technical and process/operational procedures modernization efforts. These modernization efforts include moving applications and infrastructure as code from on premise SQL servers to Microsoft Azure cloud hosting and web services. This process will include re-engineering web applications (.NET, JAVA) and SQL databases to take advantage of the Azure cloud infrastructure and native web services.

Modernization efforts also include refinement, streamlining, automation, and improving dev ops procedures (building a CI/CD pipeline, automating dev ops procedures, migrating from subversion to GitHub enterprise, and improving and adopting industry best practices for modern web application coding and design patterns and practices), automation of QA and test processes and procedures, writing test cases, scenarios, and scripts, test execution, test results, and adoption of new QA tools to increase QA process improvements and efficiencies including automation of testing suites (regression, etc.).

Tasks:

• Ensure the IT Data strategy and planning is aligned with the organization s business mission, strategy, and processes and document this using multiple design and data models that show how the current and future technology needs of the organization will be met in an efficient, sustainable, agile, and adaptable manner.
• Contribute to cutting-edge projects in a remote work environment.
• Work with a talented and collaborative team
• Lead data migration efforts and develop database management processes.
• Conduct performance testing for scalability and security enhancement
• Provide knowledge transfer and support to internal teams and stakeholders.

Location: St Paul, MN (Hybrid)

Contract: 1+ years

Skills Required:

• Experience in a DBA role with cloud implementation and administration experience
• Experience with database performance optimization techniques
• Proficiency in SQL Server, Oracle, Postgres, or other relational database management systems
• Experience managing SQL Server databases in VMWare and a cloud environment.
• Setup, configuration, management, and optimization of Azure SQL Database and Azure SQL Managed Instance.
• Setup, configuration, management, and optimization of Azure data management systems including Azure Data Factory, Azure Synapse Analytics, Azure Fabric, and Microsoft Purview.
• Knowledge of database security best practices
• Experience implementing access controls, encryption, and auditing
• Proficiency in performance-tuning techniques
• Supporting SQL Server components, including SSIS and SSRS
• Maintaining and troubleshooting ETL (Extract, Transform and Load) processes
• Performing SQL backups and Disaster Recovery
• Performing database migrations & upgrades
• Working with Azure SQL technologies
• Ability to optimize queries, indexes, and database configurations
• Comprehensive knowledge of hardware, database design, and implementation
• Systems thinking the ability to see how parts interact with the whole ( big picture thinking)
• Knowledge of IT data governance and operations
• Knowledge of data modeling as it pertains to IT data maintenance and retention.
• Excellent communication, leadership, and interpersonal skills.

***Rate depends on experience

*** Candidates authorized to work in the US are encouraged to apply. We are not sponsoring H1B candidates at this time.

*** Companies submitting candidates should only submit direct W2 employees for this position.

Please submit your resume by using the "URL" below

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.