Parsippany
Job Description About Agadia We specialize in healthcare management technology and offer a suite of utilization management software solutions for our clients. Our mission is to improve the quality of care and expedite the delivery of health care services by advancing and automating utilization management processes. We are based in Parsippany, NJ, with clients across the United States. As we grow, we are looking for a detail-oriented, self-motivated, independent SQL DBA. Job Overview As the DBA, you will be responsible for coordinating changes to computer databases, including testing and implementing database changes, while applying best practices for database management systems. This is a “hands-on” position requiring solid technical skills, as well as excellent interpersonal and communication skills. The successful candidate will be responsible for the development and sustainment of the SQL Servers, ensuring their operational readiness (security, health, and performance), executing data loads, and performing data modeling in support of multiple development teams. Must be capable of working independently and collaboratively. • Architect and administer SQL Server environments across production and non-prod systems., • Implement and maintain Always On Availability Groups (AOAG), Transactional Replication, and Mirroring., • Design and execute data archival/removal strategies aligned with compliance and business needs., • Performance Optimization & Monitoring, • Tune T-SQL queries, indexing, and schema structures., • Manage database performance using tools like:, • SQL Sentry, • SolarWinds DPA, • Redgate Monitor, • Develop proactive monitoring scripts and automation routines., • Data Security & Compliance, • Implement TDE, column-level encryption, row-level security, auditing, and access control., • Ensure compliance with HIPAA, HITECH, SOC 2, and GDPR standards., • Maintain secure backup, archival, and data retention practices., • Disaster Recovery Planning, • Design and execute DR strategies, including:, • Offsite replication, • Cross-region backups, • Disaster recovery drills and simulation exercises, • Document RTO/RPO expectations and validate failover procedures., • Offshore Collaboration, • Partner with offshore DBA and engineering teams for:, • Code reviews, • Standard enforcement, • Best practice alignment, • Training and mentoring, • Establish asynchronous communication and documentation processes., • Generative AI & Data Readiness, • Support AI/ML initiatives by:, • Structuring SQL datasets for prompt generation, training, and embedding models, • Working with RAG pipelines, vector databases, and real-time AI access requirements, • Collaborate with AI/data scientists on ingestion, performance, and tokenization strategies., • Cross-Platform Database Environments, • Support integration or data migration across:, • PostgreSQL, • MySQL/MariaDB, • Oracle DB, • Azure SQL / AWS RDS / Managed Instances, • Participate in cross-database ETL, reporting, and conversion efforts., • Leadership & Strategy, • Lead and mentor DBAs and developers across global teams., • Establish documentation, training, and review protocols., • Collaborate with DevOps, BI, Security, and Application teams on architecture and delivery., • Qualifications:Required:, • Bachelor’s degree in Computer Science, Information Systems, or a related field., • 7+ years of SQL Server DBA experience (2019 or later) with production and HA environments., • Expertise with AOAG, replication, mirroring, and performance tuning., • Hands-on experience with monitoring tools (SQL Sentry, DPA, Redgate)., • Strong skills in data protection and security compliance (HIPAA, GDPR, etc.)., • Experience working with offshore teams on structured collaboration., • Preferred:, • Experience supporting AI data pipelines, RAG, embedding models, or vector databases., • Familiarity with PostgreSQL, MySQL, or Oracle in enterprise workloads., • Cloud experience with Azure SQL, AWS RDS, or hybrid deployments., • Certifications: Microsoft Certified: Azure DBA, Security+, Certified Data Management Professional (CDMP). Please note: The Salary range is based on our market pay structure & includes benefits (Medical, Dental, Vision, life Insurance, 401 & PTO, etc.). Key Competencies Communicates effectively– Attentively listens to others, provides timely and helpful information, and is effective in a range of professional settings. Gives and receives feedback in a productive, professional manner. Demonstrates excellent oral and written communication skills. Manages Ambiguity - Operates effectively even when things are not certain, or the way forward is unclear. Is flexible in approach and able to adapt to meet changing business needs. Manages complexity -Makes sense of complex, high quantity, and sometimes contradictory information to effectively solve problems. Has strong organizational skills and can manage multiple activities simultaneously. Has close attention to detail. Ensures Accountability -Follows through on commitments and makes sure others do the same. Able to work independently as part of a small team.