| Sr. Microsoft Azure SQL Server DBA at Remote, Remote, USA |
| Email: [email protected] |
| From: Krishna, orchids [email protected] Reply to: [email protected] Sr. Microsoft Azure SQL Server DBA Location:100% remote. The method of interview is virtually via Teams, with the candidate's participation with video-enabled This position will be 100% remote. There may be changes in the future in which work will be onsite in the office (Mechanicsburg, PA 17050).*** ***The individual in this position is required to pick up commonwealth-issued equipment and get their VPN set up their first day.*** Senior-level Azure SQL Server Database Administratorwith 10 years of relevant experienceand extensive knowledge in SQL Server administration in Microsoft Azure and on-premises environments in support of mission at Public Safety delivery center (PSDC). The candidate will manage all aspects of database administration in a single and clustering environment including but not limited to planning, installation, configuration, security configuration, backup and restore, optimization, and monitoring of SQL Server databases. The candidate should also possess T-SQL development skill to maintain and optimize SSIS ETL processes, and SQL scripts for enhancing and automating security lockdown process. They must demonstrate their technical expertise and experience by having personally performed these activities during their past projects and engagements rather than just participating on a team that was responsible for these activities. The candidate should understand IT and software development life cycle processes to provide support in the Microsoft Azure Government. Key Responsibilities: -Design and implement fault-tolerant SQL Server solutions using highly availability patterns for scalability and stability in on-premises and Microsoft Azure -Experience in performing data migrations upgrades/modernizations, performance tuning on IaaS and PaaS Managed Instance and SQL Azure -Design and deploy Microsoft SQL PaaS solutions in Microsoft Azure Government (MAG) -Monitor and maintain database storage, and database health, performance, sustainability and security -Monitor and maintain SQL server Mirroring, Log shipping, backups, ETL SSIS jobs, and encryption -Provide SQL Server administration in MS SQL Server 2016, 2017 and/or 2019 -Plan and implement database backup strategies and perform recovery in case of disaster -Respond to database and user problems, and provide guidance to junior level DBA -Analyze SQL query plans, suggest and implement solutions to support developers in the Software Development Life Cycle (SDLC) -Install, configure and upgrade database management systems and software including clustering environment -Refine and automate security lockdown processes using T-SQL and PowerShell DSC -Optimize Microsoft for ETL, Data visualization, and Business Intelligence data analysis -Should be proficient in Business Analysis, Architecture Knowledge and Technical Solution Design. -Supports the configuration, deployment and execution of CI/CD pipelines in alignment with SDLC methodologies. -Knowledge of networking engineering including DNS, Active Directory, Firewall, Load balancers, etc.. |
| [email protected] View all |
| Wed Oct 19 02:18:00 UTC 2022 |