SQL Database Administrator

The Role:

We're seeking a skilled professional who thrives on optimizing and managing high-performance SQL Server environments. In this role, you’ll be responsible for designing, implementing, and maintaining robust SQL Server databases that are not only secure and reliable but also highly available. You will also be involved in designing enterprise-wide data architectures, managing hybrid or multi-cloud solutions, and mentoring teams to foster growth and innovation. If you're driven to deliver top-tier database performance, manage complex cloud environments, and want to make a real impact, this is the perfect opportunity to showcase your expertise and elevate your career with us!

What you'll do:

• Manage iA’s SQL databases to ensure efficient organization, secure accessibility, and reliable data storage by configuring and overseeing user roles, permissions, and access controls. 
• Install and update SQL database management systems to maintain optimal performance and ensure systems remain current and effective.
• Monitor database health and performance to proactively identify risks and maintain security, recoverability, and efficiency. 
• Resolve database issues using advanced tuning, indexing, and optimization techniques while performing routine maintenance tasks such as patching, tuning, and performance testing to sustain system reliability.
• Collaborate with iA’s IS and development teams to resolve database-related issues, enhance application performance, and align solutions with business goals. 
• Provide strategic guidance on database architectures to support scalability and integrate seamlessly with hybrid and multi-cloud environments.
• Develop and implement enterprise-wide data management strategies that align with the industry’s best practices and operational standards. 
• Lead database consolidation and integration projects, ensuring smooth transitions, minimal disruptions, and the preservation of data integrity. 
• Design scalable and secure database architectures to meet iA’s evolving business needs.
• Safeguard sensitive data by implementing robust database security measures, including encryption and role-based access controls, to protect information and ensure compliance with organizational policies and regulatory requirements.
• Design and manage comprehensive backup and disaster recovery solutions to ensure business continuity and safeguard against system failures, minimizing downtime and data loss.
• Research emerging technologies and recommend enhancements to data management practices, introducing innovative approaches to improve database performance and reliability. 
• Mentor junior team members to foster skill development, collaboration, and a culture of technical innovation.
• Maintain detailed documentation of database configurations, recovery plans, processes, and operational procedures, ensuring clarity and accessibility. 
• Regularly communicate updates, performance metrics, and strategic insights to leadership and stakeholders to support informed decision-making.

Who you are:

• 5+ years of experience in SQL Server administration, performance tuning, and enterprise-level database environments.
• Expertise in writing SQL queries, stored procedures, triggers, and advanced optimization techniques.
• Proven experience managing hybrid and multi-cloud environments, particularly with Azure SQL Server.
• Strong understanding of indexing strategies, partitioning, and database design best practices.
• Exceptional troubleshooting and problem-solving skills.
• Technical experience with Microsoft SQL Server, Azure SQL Database, SQL Server Management Studio (SSMS), SQL Server Profiler, DataDog, Redgate SQL Toolbelt, Veeam Backup & Replication, Azure Recovery Services, 

It would be great if you also have:

• Master’s degree in Computer Science or Information Technology preferred
• Advanced certifications such as Azure Database Administrator Associate.
• Experience with performance monitoring tools like Datadog or similar platforms.
• Strong communication skills and the ability to collaborate across teams.
• Demonstrated leadership and mentorship experience in technical environments.

Applicants must be authorized to work for ANY employer in the U.S. Employer will not sponsor applicants for work visas.

Compensation:

The estimated base annual salary range for this position is $96,546.40  to $130,622, though a candidate's base annual salary shall be determined on a range of factors, including, but not limited to, qualifications and experience. This position may additionally be eligible for an annual discretionary bonus.

What are the perks?

• Generous time off policy that allows you to put your family first
• Opportunity to work on the cutting edge of pharmacy automation in a high growth tech company
• Competitive benefits, salary, and talent development opportunities
• Commitment to professional development and working for a company where your voice is heard.

More about iA:    

iA® (Innovation Associates®) is a pharmacy fulfillment company that provides an integrated platform of capabilities to support Centralized and Community Pharmacy Fulfillment Solutions. With over 30 years of experience in the pharmacy fulfillment business, we have developed and implemented a suite of automation and software solutions that help deliver quick and sustainable business results. Our integrated Pharmacy Fulfillment Platform enables scalable solutions that helps run the prescription fulfillment process from prescription acceptance to delivery, supporting dynamic design flexibility to service pharmacies in a variety of volumes and settings. Our solutions improve workflow, and increase efficiency, while enabling more time for pharmacists to focus on their patients. iA works with pharmacy providers in the Commercial, Health Systems, Government, and Mail Order/eCommerce markets. iA can help customers transform their pharmacy. For more information, visit iARx.com.              

Our Mission: We partner with providers to transform pharmacy through our leading-edge software enabled fulfillment technology and partners to deepen the patient-pharmacist relationship, enhancing patient safety and choice while increasing operational efficiency. iA empowers pharmacists to focus on patient care. iA can run the prescription fulfillment process from start to finish, helping pharmacies manage fulfillment and inventory to help lower costs, improve efficiency, increase safety, and provide comprehensive Rx tracking and real-time support.

Our Products:

• Software
• Modular Hardware
• Sophisticated Counting and Collation Devices

Our Core Values:

• Solutions Driven
• Customer Centric
• Championing Diversity
• Empowering Ownership
• Trust Daringly

To learn more about iA’s product, people and culture visit us at iARx.com OR check us out on LinkedIn, Facebook or YouTube!

iA provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.

This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.