{"id":775,"date":"2023-06-01T13:32:12","date_gmt":"2023-06-01T13:32:12","guid":{"rendered":"https:\/\/hisolutionstech.com\/?post_type=awsm_job_openings&#038;p=775"},"modified":"2023-06-02T01:06:48","modified_gmt":"2023-06-02T01:06:48","slug":"sql-database-administrator-710978","status":"expired","type":"awsm_job_openings","link":"https:\/\/hisolutionstech.com\/?post_type=awsm_job_openings&p=775","title":{"rendered":"SQL Database Administrator (710978)"},"content":{"rendered":"\n<p>Role: SQL Database Administrator (710978)<\/p>\n\n\n\n<p>Client: State of Georgia<\/p>\n\n\n\n<p>Location: 1562 Twin Towers, 205 Jesse Hill Jr. Dr Atlanta GA 30334<\/p>\n\n\n\n<p>Hybrid<\/p>\n\n\n\n<p><strong>Only GC or US Citizens can apply for this position<\/strong><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>JD<\/p>\n\n\n\n<p>Under broad supervision, designs and secures computer databases to store, track, and maintain a large volume of critical business information. Develops database models and coordinates projects.<\/p>\n\n\n\n<p>Conduct the following for Azure SQL\/Azure SQL MI\/SQL on Azure VM, On Prem SQL Server, SSRS, SSIS, Azure Synapse and other related products as applicable and necessary<\/p>\n\n\n\n<ul>\n<li>As a SQL DBA, you\u2019ll need to have hands-on experience with databases. Create databases with efficient structures. Maintain high standards of data quality and integrity.<\/li>\n\n\n\n<li>Understand issues related to network performance and security.<\/li>\n\n\n\n<li>Experience in software development using Microsoft SQL Server 2019, Azure SQL, T-SQL and T-SQL language (queries, views, procedures), SQL Server database design, stored procedure design and implementation.<\/li>\n\n\n\n<li>Experience coding stored procedures (using T-SQL). Proven analytical problem solving and debugging skills.<\/li>\n\n\n\n<li>Knowledge of Data Warehousing models<\/li>\n\n\n\n<li>Working knowledge of Azure services<\/li>\n\n\n\n<li>Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, etc.<\/li>\n\n\n\n<li>Experience with performance tuning, query optimization, using Performance Monitor, SQL.<\/li>\n\n\n\n<li>Profiler and other related monitoring and troubleshooting tools. Knowledge of standard concepts, practices and procedures related to database management.<\/li>\n<\/ul>\n\n\n\n<p>. Knowledge of capacity planning and infrastructure provisioning.<\/p>\n\n\n\n<ul>\n<li>Design and create database objects for SaaS web applications<\/li>\n\n\n\n<li>Analyze and tune existing queries and schema<\/li>\n\n\n\n<li>Provide database expertise to teams of software developers<\/li>\n\n\n\n<li>Perform database administration tasks for production and non-production databases as needed<\/li>\n\n\n\n<li>Create and update documentation on database objects<\/li>\n<\/ul>\n\n\n\n<p>Required:<\/p>\n\n\n\n<ul>\n<li>Bachelors or Masters in relevant field.<\/li>\n\n\n\n<li>Strong written and verbal communication skills in English<\/li>\n\n\n\n<li>Real experience with Microsoft SQL Server in Azure Cloud Environment<\/li>\n<\/ul>\n\n\n\n<p>Preferred Skills:<\/p>\n\n\n\n<ul>\n<li>Knowledge of indexes, index management, and statistics.<\/li>\n\n\n\n<li>Experience in troubleshooting and resolving database problems.<\/li>\n\n\n\n<li>Experience in Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools.<\/li>\n\n\n\n<li>Experience with backups, restores and recovery models.<\/li>\n\n\n\n<li>Experience with data migration or ETL.<\/li>\n\n\n\n<li>Experience with cloud platforms, especially Azure.<\/li>\n\n\n\n<li>Experience with cloud-based databases, especially Azure SQL.<\/li>\n<\/ul>\n\n\n\n<p>Skill<\/p>\n\n\n\n<p>Required \/ Desired<\/p>\n\n\n\n<p>Amount<\/p>\n\n\n\n<p>of Experience<\/p>\n\n\n\n<p>SQL Server DBA<\/p>\n\n\n\n<p>Required<\/p>\n\n\n\n<p>8Years<\/p>\n\n\n\n<p>Microsoft SQL Server in a Azure Cloud Environment<\/p>\n\n\n\n<p>Required<\/p>\n\n\n\n<p>5Years<\/p>\n\n\n\n<p>Performance Tuning and Optimization (PTO)<\/p>\n\n\n\n<p>Required<\/p>\n\n\n\n<p>3Years<\/p>\n\n\n\n<p>Data Migration<\/p>\n\n\n\n<p>Required<\/p>\n\n\n\n<p>5Years<\/p>\n\n\n\n<p>Azure SQL, SQL, T-SQL<\/p>\n\n\n\n<p>Required<\/p>\n\n\n\n<p>5Years<\/p>\n\n\n\n<p>SQL Database back-up, recovery and documentation<\/p>\n\n\n\n<p>Required<\/p>\n\n\n\n<p>5Years<\/p>\n\n\n\n<p>Microsoft PowerShell<\/p>\n\n\n\n<p>Required<\/p>\n\n\n\n<p>3Years<\/p>\n\n\n\n<p>Capacity planning and Infrastructure provisioning<\/p>\n\n\n\n<p>Required<\/p>\n\n\n\n<p>5Years<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Role: SQL Database Administrator (710978) Client: State of Georgia Location: 1562 Twin Towers, 205 Jesse Hill Jr. Dr Atlanta GA 30334 Hybrid Only GC or US Citizens can apply for this position JD Under broad supervision, designs and secures computer databases to store, track, and maintain a large volume of critical business information. Develops database &hellip;<\/p>\n<p class=\"read-more\"> <a class=\"\" href=\"https:\/\/hisolutionstech.com\/?post_type=awsm_job_openings&#038;p=775\"> <span class=\"screen-reader-text\">SQL Database Administrator (710978)<\/span> Read More &raquo;<\/a><\/p>\n","protected":false},"author":1,"template":"","meta":{"site-sidebar-layout":"default","site-content-layout":"default","ast-global-header-display":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":""},"_links":{"self":[{"href":"https:\/\/hisolutionstech.com\/index.php\/wp-json\/wp\/v2\/awsm_job_openings\/775"}],"collection":[{"href":"https:\/\/hisolutionstech.com\/index.php\/wp-json\/wp\/v2\/awsm_job_openings"}],"about":[{"href":"https:\/\/hisolutionstech.com\/index.php\/wp-json\/wp\/v2\/types\/awsm_job_openings"}],"author":[{"embeddable":true,"href":"https:\/\/hisolutionstech.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"wp:attachment":[{"href":"https:\/\/hisolutionstech.com\/index.php\/wp-json\/wp\/v2\/media?parent=775"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}