Remote (EST) II Azure SQL DBA II No h1B/CPT/OPT at Remote, Remote, USA |
Email: [email protected] |
Job Title: Azure SQL DBA Primary Skills: Microsoft Azure SQL Managed Instance (SQL MI), HA SQL databases, Azure Cloud environment Secondary Skills: SSIS, SSRS, MSSQL Server, Active Directory, IaaS, PaaS desirable Comments to Team: Description: Location: Remote (EST candidate preferred) Summary Times New Roman";mso-bidi-font-family:Calibri;mso-bidi-theme-font:minor-latin">The Azure SQL DBA will be responsible for designing, implementing, and optimizing complex, highly available (HA) SQL databases, as well as planning for and migrating such existing SQL databases from on-premise to Azure Cloud. Additional responsibilities include recommending improvements to best practices, defining repeatable procedures, as well as day-to-day database activities. Responsibilities: Plan for and safely migrate HA SQL databases from on-premise to Azure Cloud environments Times New Roman"; mso-hansi-theme-font:minor-latin;mso-bidi-theme-font:minor-latin">Work closely with other DBAs, application administrators, development teams, and test teams to define requirements and develop solutions to complex problems Times New Roman"; mso-hansi-theme-font:minor-latin;mso-bidi-theme-font:minor-latin">Lead the architecture and design of complex database systems, focusing on performance optimization and scalability. Times New Roman"; mso-hansi-theme-font:minor-latin;mso-bidi-theme-font:minor-latin">Collaborate with cross-functional teams to understand business requirements and translate them into efficient database solutions. Times New Roman"; mso-hansi-theme-font:minor-latin;mso-bidi-theme-font:minor-latin">Review and analyze database design and integration of systems, recommend enhancements and/or improvements. Times New Roman"; mso-hansi-theme-font:minor-latin;mso-bidi-theme-font:minor-latin">Recommend best practices for data modeling, indexing, and query optimization to ensure optimal performance and reliability. Times New Roman"; mso-hansi-theme-font:minor-latin;mso-bidi-theme-font:minor-latin">Design and implement data migration strategies to seamlessly transition to Azure cloud. Times New Roman"; mso-hansi-theme-font:minor-latin;mso-bidi-theme-font:minor-latin">Proactively monitor database health and performance, identifying and addressing bottlenecks and issues as they arise. Times New Roman"; mso-hansi-theme-font:minor-latin;mso-bidi-theme-font:minor-latin">Drive the adoption of cloud-based database solutions, particularly Microsoft Azure SQL Managed Instance (SQL MI), leveraging its capabilities for scalability and manageability. Times New Roman"; mso-hansi-theme-font:minor-latin;mso-bidi-theme-font:minor-latin">Collaborate with security and compliance teams to ensure data protection and regulatory compliance across database systems. Times New Roman"; mso-hansi-theme-font:minor-latin;mso-bidi-theme-font:minor-latin">Identify risks, perform risk analysis, effectively manage risks; proactively raise prioritization and scheduling tradeoff decisions, escalating and identifying alternate options as appropriate Times New Roman"; mso-hansi-theme-font:minor-latin;mso-bidi-theme-font:minor-latin">Participate in disaster recovery planning and testing, ensuring the resilience and availability of critical database systems. Symbol";mso-bidi-font-family:Symbol"> Symbol";mso-bidi-font-family:Symbol"> Symbol""> Times New Roman"; mso-hansi-theme-font:minor-latin;mso-bidi-theme-font:minor-latin">Maintain the strict confidentiality of sensitive information. Times New Roman";mso-bidi-font-family:Calibri;mso-bidi-theme-font:minor-latin"> Requirements: Minimum 5 years experience as a Microsoft SQL DBA, including design, builds, upgrades, migrations, support, and performance tuning database administrative experience Cloud migration project implementation and support experience Times New Roman"; mso-hansi-theme-font:minor-latin;mso-bidi-theme-font:minor-latin">Must have a complete understanding of underlying data and applications. Times New Roman"; mso-hansi-theme-font:minor-latin;mso-bidi-theme-font:minor-latin">Must possess the following, including but not limited to system knowledge of Windows server, WSFC, Always On, Disaster Recovery, thorough knowledge of SQL Server databases, architecture and software development methodologies and practices; strong database performance tuning skills; and strong database troubleshooting and problem resolution skills. Times New Roman"; mso-hansi-theme-font:minor-latin;mso-bidi-font-family:"Times New Roman"">Experience with SSIS and SSRS to meet various Business Intelligence requirements. Experience with Database Administration for MSSQL Server. Times New Roman"; mso-hansi-theme-font:minor-latin;mso-bidi-font-family:"Times New Roman"">Extensive experience in setting up and supporting SQL Server Mirroring, Log Shipping, Mirroring/Log Forwarding, Clustering, and other disaster recovery methods. Times New Roman"; mso-hansi-theme-font:minor-latin;mso-bidi-font-family:"Times New Roman"">Demonstrates comprehensive knowledge and hands-on experience with SQL High Availability features, SQL Structured Query Language, and SQL Clustered environments. Times New Roman"; mso-hansi-theme-font:minor-latin;mso-bidi-font-family:"Times New Roman"">Experience configuring multiple nodes (Active/Passive) in SQL Servers to establish Clustering Environments. Experience in troubleshooting and resolving database problems, and in using native monitoring and troubleshooting tools. Times New Roman"; mso-hansi-theme-font:minor-latin;mso-bidi-font-family:"Times New Roman"">Proficient in Performance Tuning, Query Optimization, Client/Server Connectivity, conducting Database Consistency Checks using DBCC Utilities. Times New Roman"; mso-hansi-theme-font:minor-latin;mso-bidi-font-family:"Times New Roman"">Experience with backups, restore and recovery models, and configuring failover clusters. Times New Roman"; mso-hansi-theme-font:minor-latin;mso-bidi-theme-font:minor-latin">Knowledge of High Availability (HA) and Disaster Recovery (DR) options for MSSQL Server - Always On , Clustering, Failover etc. Times New Roman"; mso-hansi-theme-font:minor-latin;mso-bidi-theme-font:minor-latin">Experience with Microsoft Azure and Cloud Solutions - IaaS, PaaS desirable Times New Roman"; mso-hansi-theme-font:minor-latin;mso-bidi-theme-font:minor-latin">Experience in implementing operational automation using scripts. Times New Roman"; mso-hansi-theme-font:minor-latin;mso-bidi-theme-font:minor-latin">Knowledge of indexes, index management, and statistics. Times New Roman"; mso-hansi-theme-font:minor-latin;mso-bidi-theme-font:minor-latin">Experience working with Windows server, including Active Directory and proper disk configurations. Times New Roman"; mso-hansi-theme-font:minor-latin;mso-bidi-theme-font:minor-latin">Good communication and documentation skills. Strong interpersonal, verbal, and written communication skills. Education Bachelor's degree in computer science or a related field or equivalent experience MCTS, MCITP, and/or MVP certifications a plus MCSE/MCSA certifications preferred Other Duties Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties, or responsibilities that are required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without notice. Equal Opportunity Employer Statement SDI Presence is an equal opportunity employer that is committed to diversity and inclusion in the workplace. We prohibit discrimination and harassment of any kind based on race, color, sex, religion, sexual orientation, national origin, disability, genetic information, pregnancy, or any other protected characteristic as outlined by federal, state, or local laws. This policy applies to all employment practices within our organization, including hiring, recruiting, promotion, termination, layoff, recall, leave of absence, compensation, benefits, training, and apprenticeship. SDI Presence makes hiring decisions based solely on qualifications, merit, and business needs at the time. This email is generated using CONREP software. A54505 Keywords: Michigan Remote (EST) II Azure SQL DBA II No h1B/CPT/OPT [email protected] |
[email protected] View all |
Thu Sep 12 20:02:00 UTC 2024 |