Database Administrator

About AgadiaWe 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 OverviewAs 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.Key Responsibilities: Core Database AdministrationArchitect 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 & MonitoringTune T-SQL queries, indexing, and schema structures.Manage database performance using tools like:SQL SentrySolarWinds DPARedgate MonitorDevelop proactive monitoring scripts and automation routines.Data Security & ComplianceImplement 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 PlanningDesign and execute DR strategies, including:Offsite replicationCross-region backupsDisaster recovery drills and simulation exercisesDocument RTO/RPO expectations and validate failover procedures.Offshore CollaborationPartner with offshore DBA and engineering teams for:Code reviewsStandard enforcementBest practice alignmentTraining and mentoringEstablish asynchronous communication and documentation processes.Generative AI & Data ReadinessSupport AI/ML initiatives by:Structuring SQL datasets for prompt generation, training, and embedding modelsWorking with RAG pipelines, vector databases, and real-time AI access requirementsCollaborate with AI/data scientists on ingestion, performance, and tokenization strategies.Cross-Platform Database EnvironmentsSupport integration or data migration across:PostgreSQLMySQL/MariaDBOracle DBAzure SQL / AWS RDS / Managed InstancesParticipate in cross-database ETL, reporting, and conversion efforts.Leadership & StrategyLead 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:RequiredBachelor’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 CompetenciesCommunicates 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.