• Database Administrator

    Affordable CareMorrisville, NC 27560

    Job #1319039571

  • OverviewJOB PURPOSE:The Database Administrator will be responsible for the operation, configuration, maintenance, and development of multiple SQL Server environments including the Enterprise Data Warehouse, Microsoft Dynamics GP, and Dentrix Enterprise under the supervision of the Enterprise Data Warehouse Manager.Your Team - Who You'll Work With+ Work closely with the Enterprise Data Warehouse Manager to develop and execute goals+ Work with other IT members and business stakeholders to deliver database performance, stability, security, and recoverability.ResponsibilitiesGENERAL DUTIES & RESPONSIBILITIES:+ DBA+ Administermultiple SQL Server environments including the Enterprise Data Warehouse, Microsoft Dynamics GP, and Dentrix Enterprise+ Manage security+ Design and implement disaster recovery plans+ Participate in the development and deployment of product releases+ Install, upgrade, and manage database applications+ Analyze existing Enterprise Data Warehouse objects for performance issues+ Performance tuning and optimization of existing objects, SSIS packages, and ETL jobs living in the Enterprise Data Warehouse+ Create and maintain technical documentation for all SQL processes+ Diagnose and troubleshoot database errors+ Be available for on-call support as needed+ Inbound/Outbound data feeds+ Implement robust outbound data feeds utilizing SSIS, SQL, APIs, and industry best practices to support the enterprise.+ Perform all aspects of SDLC: requirements gathering, documentation, proof of concept, development, testing, implementation, etc.+ Augment Enterprise Data Warehouse+ Create tables, views, and stored procedures under the guidance of the Enterprise Data Warehouse Manager as needed.+ Assist with database and schema design planningQualificationsGENERAL KNOWLEDGE, SKILLS & ABILITIES:+ Bachelor's degree in Computer Science or related field+ 5+ years ETL development experience (SSIS, Informatica, Azure Data Factory)+ 5+ years SQL experience+ 5+ years Data Warehouse development (ETL, Data Architecting, Data Modeling)+ 5+ years of DBA (Database Administrator) Experience+ Proven experience with troubleshooting principles, methodologies, issue resolution and data governance techniques+ Strong customer service focus with proven ability to connect with customers, understand needs and deliver results+ Excellent communication and listening skills with the ability to document methodologies supporting design+ Strong problem solving and conceptual thinking skills+ Willing to be a positive mentor and guide to the team sharing knowledge and experience where needed+ Proven track record of consistency, accuracy, and accountability+ Proven ability to multi-task and effectively manage multiple projects, competing priorities and adeptly re-prioritize based on changing needs+ Demonstrated capability to be self-directed, and work without day to day direction+ Must be flexible and adapt well to change+ Ability to work a flexible schedule, including weekends and on-call as neededNeed help finding the right job?We can recommend jobs specifically for you!Job ID 2020-10307Category Information Technology