COME BUILD YOUR FUTURE WITH PRESIDIO!We know technology is the key to success in a connected world. The innovative solutions we provide our clients can unlock possibilities that transform their business. While technology permits that connection, technology without imagination and ingenuity cannot be effective. At Presidio, we know that it's our people that make the connections happen.WHY YOU SHOULD JOIN US? You will set your career on track for outstanding achievement with a company that knows no limits. Presidio is a leading North American IT solutions provider focused on Digital Infrastructure, Business Analytics, Cloud, Security & Emerging solutions.THE ROLE: IT Administrator, Microsoft SQL DatabasePresidio is seeking an IT Administrator/Microsoft SQL Database Administrator to join our team in a 100% remote capacity who will be responsible for supporting and coordinating all database activities and leading and securing the SQL instances and databases. This includes supporting back-up, maintenance, restore, documentation, optimization, testing, tuning and administration of Presidio IT's SQL server database applications while maintaining a focus on availability and performance of all databases.Key Responsibilities:Perform MS SQL Database Administration, including but not limited to: database installs, patches, upgrades, clustering, configuration, custom scripting and security.Provide technical assistance to other members of the team and also assist other development teams.Perform problem isolation, definition, resolution and follow-up. Inform management and teams about issues and resolutions and follows escalation procedures.Perform proactive review of systems performance metrics and alerts to ensure 100% system uptime.Build guidelines standards and procedures to streamline the processes and coordinate with multiple groups for maintenance activities.Research and recommend tools and procedures for increased infrastructure performance.Act as SQL query expert to analyze and performance tune SQL queries and SQL Stored Procedures in order to achieve maximum performance.Additional duties as assigned.Data WarehouseMigrate to Azure SQL Database or provision a new SQL database.Backup and restore Azure SQL Databases.Implement high availability and disaster recovery.Monitor and optimize the performance of your cloud database.Automate common management tasks using PowerShell. Dynamics 365Daily tasks: Monitor DB server and database performance, troubleshoot DB related issues, implement and support DB related systems.Scheduled Tasks:Perform maintenance on D365 environments. Including code deployments and upgrades as needed to fill in for DevOps.Manage the D365 Data import / export process via data entities. Including setting up new entities, managing batch jobs, mapping changes and change tracking.Backup and Restore D365 data from Production to UAT and development environments, including data updates to ensure the environment can properly integrate with other environments.Required Skills:Efficiently lead multiple, significant, high-priority projects with varying deadlinesAble to effectively lead and motivate small project teamsAbility to achieve results under limited direction.General knowledge of D365 and LCSExperience with D365 Data EntitiesStrong knowledge with monitoring, performance tuning, SQL queries, Always On and SQL backups/restores Strong background with MS SQL Database along with Azure SQL DatabaseSelf-starter, will to look for solutions to problems along with automationWorks well in a team environmentAdditional Desired Skills:PluralsightChannel: Azure DWHMS certification paths and necessary training to achievehttps://docs.microsoft.com/en-us/learn/certifications/exams/az-303https://docs.microsoft.com/en-us/learn/certifications/exams/az-304AZ-303 "Microsoft Azure Architect Technologies"AZ-304 "Microsoft Azure Architect Design"Participate in one-to-one training with peersEducation and Experience:Bachelor's Degree or equivalent work experience and/or military experience.Minimum of 3-5 years of prior experience in a MS SQL DBA role. ABOUT PRESIDIOPresidio is committed to Diversity, Equity, and Inclusion at the highest levels and has strengthened its drive to build and drive systemic DE&I change process across all levels of the organization. Cultivating a culture of inclusion where the expression of all our differences are valued, celebrated, and add to our collective achievements.Presidio is a leading IT solutions provider assisting clients in harnessing technology innovation and simplifying IT complexity to digitally transform their businesses and drive return on IT investment. Our Digital Infrastructure, Business Analytics, Cloud, Security & Emerging solutions enable our almost 7,000 middle market, enterprise and government clients to take advantage of new digital revenue streams, omnichannel customer experience models, and the rich data insights generated by those interactions.Our mission is to enable our clients to capture economic value from the digital transformation of their businesses by developing, implementing and managing world class, cloud ready, secure and agile IT Infrastructure solutions. We deliver this technology expertise through a full life cycle model of professional, managed, and support services including strategy, consulting, implementation and design.By investing in the future of IT solutions we stay at the forefront of technology trends. And to ensure our clients have access to a wide range of technologies and best-of-breed solutions, we partner with over 500 OEMs including market leaders and emerging providers to bring our clients integrated, multi technology solutions.We serve as an extension of our clients' IT teams, providing deep expertise and letting them focus on their core business. Through 60+ US offices and 2,800 professionals, including 1,600 technical engineers, we are trusted advisors to our clients on a local level while also bringing our national scale and expertise to bear.Engage Presidio, where the digital future is built.Culture at PresidioDigital Infrastructure:Our Digital Infrastructure solutions help make existing IT infrastructure more efficient, while equipping our clients for a cloud-flexible, mobile-ready, highly secured, insight-driven future. Given the millions of potential configurations across these technologies, our clients rely on our expertise to simplify a highly complex IT landscape, helping to identify and deploy the solutions most appropriate for their business needs. Our Digital Infrastructure solutions scale from workgroup to the largest enterprise requirements.Cloud:We help our clients take cloud strategy and adoption to the next level. Through our advanced cloud solutions practice, combined with Presidio's IT infrastructure expertise, we provide private, hybrid, and multi cloud solutions. By closely aligning our services and solutions with our strategic partners Microsoft Azure (TM) , Amazon Web Services (TM) , Intel(R) and VMware (TM) Presidio offers cloud strategy, architecture and implementation services along with application rationalization and migration across the hybrid and multi-cloud data center environment. In addition, our new and innovative Presidio Cloud Concierge solution provides a foundation for Automation and Self-Services across Clouds to improve productivity and drive increased levels of governance and security.Rather than a "one size fits all" approach, or having to choose between public or private, Presidio tailors a hybrid cloud strategy to meet your unique business requirements. We help our clients accelerate and simplify cloud adoption across the entire IT lifecycle.Security:Our comprehensive security risk methodology gives customers the ability to safeguard their environments and critical business data. This includes continuous threat protection and risk mitigation through the Presidio Cyber Risk Management program, a next generation approach that integrates security strategy, assessments, architecture and remediation, and aligns all of these with organizational goals.Presidio Cyber Risk Management provides clients with a holistic approach for effective security policies and procedures, risk assessment and management, regulatory compliance, incident response, and education and awareness. We use an established risk management methodology and proprietary risk scoring process to provide the IT leader and board of directors with an ongoing view of their organization's risk exposure and remediation path.Emerging Technologies:Emerging technologies such as IoT, blockchain and artificial intelligence continue to disrupt current business models, and customers are faced with the task of transforming their organizations to achieve desired outcomes. Increased demand for operational efficiencies, better customer experience and improving safety and security has taken priority. This accelerated rate of change is prompting businesses to align their processes, applications and infrastructure to new consumption and service-based models. For our customers, it means enabling a seamless exchange of data within complex ecosystems to help advance digital transformation.At Presidio Emerging Technologies, we provide solutions for safety and security, mobile and wireless communications, data collection and analytics using purpose-built, ruggedized hardware and software. Presidio offers validated solutions for Industrial Insights, Connected Transportation, Smart Cities, and Safer Schools.For more information visit: www.presidio.com Presidio is an Equal Opportunity / Affirmative Action Employer / VEVRAA Federal Contractor. All qualified candidates will receive consideration for this position regardless of race, color, creed, religion, national origin, age, sex, citizenship, ethnicity, veteran status, marital status, disability, sexual orientation, gender identification or any other characteristic protected by applicable federal, state and local statutes, regulations and ordinances.To read more about discrimination protections under Federal Law, please visit: https://www1.eeoc.gov/employers/upload/eeoc_self_print_poster.pdf (Get Acrobat Reader)If you have any difficulty using our online system and need an accommodation in the job application process due to a disability, please send an email to recruitment@presidio.com for assistance.Presidio is a VEVRAA Federal Contractor requesting priority referrals of protected veterans for its openings. State Employment Services, please provide priority referrals to recruitment@presidio.com.RECRUITMENT AGENCIES PLEASE NOTE: Agencies Please Note: Agencies may not submit any unsolicited candidate information to any employee of Presidio. Any candidate information received by any employee of Presidio will be considered property of Presidio, unless the submitting agency is an Authorized Vendor who has received a written request to perform recruiting services from a member of Presidio's Talent Acquisition staff. No other Presidio staff member shall be authorized to engage an agency to perform recruiting services. Authorized Vendors have entered into written contracts with Presidio that have been reviewed and executed by the Vice President of Talent Acquisition. Payments will not be made to any agency who is not an Authorized Vendor (nor will they be made to any agency for performing unauthorized services).#LI-PH1#CB