MS Azure SQL Server DBA || Austin, TX at Austin, Texas, USA |
Email: [email protected] |
From: Kaveri, Tek Pyramids [email protected] Reply to: [email protected] MS Azure SQL Server DBA Location: Austin, TX 100% REMOTE Need Locals Duration: Long Term Interview: Video Visa: NO H1Bs Prefer candidates with Active LinkedIn. Job Description Provide Database maintenance and Infrastructure support of application databases in all Azure platform-based (including Azure DevOps & CI/CD Pipelines) environment (development, testing, training, and production). experience in setting up Azure DevOps repos, pipelines, boards to help development and migration teams. Defining customer DevSecOps frameworks for secure CI/CD (Continuous Integration/Continuous Delivery) of Infrastructure as Code (IaC) templates and scripts and enabling automations using Scripts. Minimum Requirements: Years Required/Preferred Experience 7 Required Network support for Azure, Application performance / health monitoring, Azure Capacity planning, Azure VPN Configuration / troubleshooting, Azure VM maintenance and troubleshooting, Azure OS security patching and software updates 7 Required Azure automation management and improvements, IAM (Azure access management, and AD group Management) , AD Administration 7 Required Experience performing Database Administration functions for MS SQL Server 2016 and later 7 Required Understanding of complex SQL queries 7 Required Experience in database, logical, and physical design 7 Required Experience with Power scripting on MS Windows 7 Required Experience performing database backup, restore and recovery 7 Required Experience with each of the following: Configuring and maintaining database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security, while minimizing false alarms 7 Required Experience with each of the following: Troubleshooting and resolving database problems, Data modeling techniques to ensure consistency across teams and to meet integration and performance expectations 7 Required Experience with each of the following: Performance tuning and optimization at the physical server level (e.g., table and index partitioning), the database level (e.g., database settings and options), and query tuning 7 Required Experience with: Installation and configuration of SQL Server including AlwaysON, and as well as other forms of replication, Expertise in Failover clustering, SAN replication, and other High Availability (HA) and Disaster Recovery (DR) technologies 7 Required Experience with: Working with SQL Server Integration Services, SQL Server Reporting Services and Power BI 5 Required Experience with Salesforce Systems 5 Required Administration, building and deployment of agency MS Windows application server software 4 Required Bachelors degree from an accredited four-year college or university, with major coursework in Computer Science, Information Systems or a related field. Education and experience may substitute for each other on a year for year basis. 5 Preferred Experience in multi-dimensional data models that are an extension of Star schema - where dimension tables are broken down into subdimension tables 5 Preferred Knowledge of MuleSoft (version 4) 5 Preferred Experience with Informatica Power Exchange Change Data Capture (CDC) 5 Preferred Experience integrating SQL Server with Azure Active Directory 5 Preferred Experience working with Microsoft DevOps (previously called Team Foundation Server (TFS)) 5 Preferred Experience with Data Lakes; SnowFlake; or other Data Warehouse platforms 5 Preferred Working knowledge in one or more technology areas: Cloud technologies, Cloud Storage, Cloud Networking, IaaS, PaaS, Observability, IAM, Infrastructure as Cloud (IaC), 1 Preferred Certification is a plus: Azure Database Administrator; Certified Microsoft Database Administrator; MCTS; MCITP; MVP Keywords: continuous integration continuous deployment business intelligence active directory microsoft Texas |
[email protected] View All |
07:30 PM 10-Oct-23 |