Database Administrator

PepperPointe Partnerships • Lexington, KY

18h • $70,000 - $80,000 • Onsite

About The Position

This role is based on site at our Lexington, KY headquarters. This is not a remote position We are looking for a Database Administrator with data warehousing experience comfortable working in a technology focused environment to join our data team. This position will be responsible for acquisition and integration of data sources into our Data Lake, management of databases and leading the design of the company's data strategy to solve the company’s business problems. The ideal candidate will have a high working knowledge of Database Structures, BASH, Linux, Python, SFTP, Microsoft SQL, Airflow, Docker Containers, API Programming, and ETLs. To be successful in this position, you should demonstrate excellent organizational skills and critical thinking skills. You should also have a propensity to be proactive in addressing issues and concerns to avoid crises, and constantly be looking to innovate old methods and processes for greater efficiency and effectiveness.

Requirements

• Production Deployment Insight: Deep understanding of the challenges and trade-offs involved in building and deploying systems to production, ensuring robust and reliable database operations.
• Performance Optimization: Highly skilled in identifying performance bottlenecks, detecting anomalous system behavior, and determining the root cause of incidents to maintain optimal database performance.
• Technical Proficiency: Extensive experience with cloud environments, Windows/SQL Server, PowerShell scripting, Airflow, Linux, and virtualization technologies.
• Database Expertise: Proficient in SQL, ETL processes, and database programming, with the ability to design, implement, index, and maintain efficient data solutions.
• Systems Knowledge: Knowledge of how Microsoft SQL, Airflow, ETLs, and Dockers all interact.
• Cloud Networking: Strong experience with cloud networking, including network connectivity, protocols, load balancing, and related technologies to ensure seamless data flow and access.
• Technical Knowledge: Comprehensive knowledge of computer systems, hardware, and software, enabling effective integration and troubleshooting.
• Customer Service Orientation: Strong commitment to providing exceptional customer service, ensuring user satisfaction and support.
• Organizational Skills: Excellent organizational abilities, ensuring efficient management of tasks and resources.
• Time Management: Strong multitasking and time-management skills, with the ability to prioritize tasks effectively to meet deadlines.
• Problem-Solving Skills: Proficient in identifying and solving problems, thinking in regards of systems, gathering and analyzing information skillfully, and developing alternative solutions.

Nice To Haves

• Educational Background: Bachelor’s degree in Data Science, CIS, Computer Science, Software Development, Mathematics or a related field. Relevant work experience can be considered in lieu of a degree.
• Certifications: Relevant certifications are highly desirable, including certifications focused on database management (e.g., Microsoft Certified: Azure Database Administrator Associate)
• Healthcare Experience: Experience working in a dental or healthcare-related organization is a plus, with familiarity in managing and securing health information systems.
• Technical Proficiency: Extensive experience with SQL Server, including SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS).
• Cloud Experience: Proficiency in cloud platforms such as AWS, Azure, with experience in cloud database services like Amazon RDS, Azure SQL Database.
• Scripting Skills: Strong scripting abilities, particularly in PowerShell, to automate routine database tasks and improve efficiency.
• ETL Processes: Proven expertise in designing and managing ETL (Extract, Transform, Load) processes to ensure accurate and efficient data integration.
• Database Design: Strong skills in database design, modeling, and optimization to ensure scalable and high-performance databases.
• Security Knowledge: Comprehensive knowledge of database security best practices, including data encryption, access control, and vulnerability assessment.
• Disaster Recovery: Experience in developing and implementing disaster recovery plans and backup procedures to ensure data integrity and availability.
• Regulatory Compliance: Understanding of regulatory requirements such as HIPAA, GDPR, or other data protection laws relevant to database management.

Responsibilities

• SQL and SSMS Development: Develop, support, and maintain SQL jobs and SSMS packages for data imports, exports, and transformations to ensure seamless data integration and workflow automation.
• Systems Monitoring: Monitor database systems and Airflow for performance and respond promptly to any system outages or disruptions, ensuring minimal downtime and quick recovery.
• Database Maintenance: Provide ongoing maintenance of database refreshes, including checking Docker Containers, backups, and performance tuning to ensure data integrity.
• Data Storage and Security: Design and implement standards for data storage, workflow, maintenance, access, and security administration to protect sensitive information and ensure compliance.
• Issue Resolution: Diagnose and resolve system errors and other database-related issues, utilizing a systematic approach to troubleshooting.
• Performance Reporting: Run and analyze reports to identify common issues, complaints, and areas for improvement, implementing logging solutions to track issues.
• Software Installation and Updates: Install or update database software to address issues, improve functionality, and ensure compatibility with other systems.
• Additional Responsibilities: Perform other duties as assigned, contributing to the overall efficiency and effectiveness of the Analytics department

Benefits

• Medical, dental, and vision benefits
• 401K with company match
• A company culture of promotions from within, with a start-up atmosphere allowing for varied and rapid career development

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Number of Employees: 1-10 employees