• Own database architecture, performance, reliability, security, and scalability for core platform systems. • Use AI tools responsibly to accelerate database analysis, documentation, query tuning, troubleshooting, and workflow improvement. • Design database approaches for both single-tenant and multi-tenant SaaS environments, including migration strategies between tenancy models. • Improve tenant isolation, customer-specific data separation, scalability, and compliance-ready data architecture. • Review and improve schemas, indexes, queries, migrations, and data access patterns. • Optimize SQL performance, indexing strategies, execution plans, and database bottlenecks. • Partner with Engineering and Data Engineering on schema design, data modeling, migrations, pipelines, and performance-sensitive application changes. • Help define database strategies across OLTP systems, OLAP workloads, reporting layers, and data pipelines. • Strengthen database security practices, including encryption at rest, field-level encryption, column-level encryption, key management, access controls, and auditability. • Establish practical standards for database migrations, rollback planning, production readiness, monitoring, backups, and disaster recovery. • Support load testing, capacity planning, and performance benchmarking for critical workflows. • Collaborate with DevOps on AWS-hosted database infrastructure, environment strategy, access controls, and cost optimization.

Role Description We are a dynamic and dedicated group of individuals, working remotely across the US, and are looking for talented, passionate, and curious people to expand our team. Payentry offers human capital management services and solutions to employers across the US. Our mission is Delivering Success Together! We aim to provide the best systems and service for helping our clients grow their businesses. If you're ready to join in our mission, advance your career, and have fun while doing so - apply today! - Perform database management activities using Microsoft SQL Server. - Analyze, design, and review logical and physical data models. - Support the application system development life cycle. - Perform data analysis and correction activities. - Review stored procedures and recommend improvements to enhance performance. - Monitor database performance and space requirements and give recommendations to improve. - Help maintain database access security and database integrity. - Ensure databases are backed up appropriately and can be restored if necessary. - Assist with database server infrastructure and software analysis and recommendations. - Create and maintain documentation related to database design, configuration, and operations. - Keep current with the features of new database releases and related database products and make recommendations as to their use. - Make recommendations on best practices and improvements surrounding database administration practices. - Use strong communication skills; both written and spoken. Qualifications - Bachelor's degree in information technology or other relevant field OR equivalent work experience. - At least 6 years of experience in a DBA role, or similar. - Strong knowledge of database management using Microsoft SQL Server. - Experience working in cloud environments (Azure preferred). - Proven expertise in optimizing database queries in SQL. - Track record of successful troubleshooting and resolving database issues, such as performance bottlenecks, data issues, and connectivity problems. Location - This will be a remote position. Company Description - Payentry is an EEO Employer - M/F/Disability/Protected Veteran Status.

• Design and implement secure, scalable, multi-tenant database architectures for healthcare SaaS applications • Develop data models and storage solutions for sensitive healthcare data (PHI, PII/PPI) • Ensure compliance with HIPAA, HITECH, GDPR, and other relevant regulations • Implement data encryption (at rest and in transit), masking, and access controls • Architect systems for high availability, disaster recovery, and auditability • Define and enforce data governance, retention, and audit logging policies • Optimize database performance for large-scale healthcare datasets and real-time access • Collaborate with security, compliance, and engineering teams to meet regulatory requirements • Lead data migration and integration with EHR/EMR systems and third-party healthcare platforms • Comply best practices for secure CI/CD pipelines involving database changes • Monitor systems for data integrity, breaches, and anomalous access patterns

Role Description Security-cleared Professional: A DOD Secret Clearance or a Top Secret Clearance is required to be considered for this position. You have a Bachelor's Degree in a related field with 3+ years of experience as a Database Engineer using PostgresSQL. Can accept experience in lieu of degree. Additional requirements for the Mid-Level Database Developer position include: - Database experience of working in different OS platforms like Linux and/or RHEL. - Database performance tuning, upgrades, and patching to all COTS database products. - Database script writing (PL/SQL & PL/pgSQL) experience to manage ETL procedures. - Database storage management, database interfaces, external application database interfaces, and other systems database interfacing. - Performance tuning, hardware replacement, firmware upgrades, and patching to all COTS software products, including operating systems. - Experience in shell scripting to enhance and update daily monitoring tasks. - Working experience of AWS Cloud Services (Aurora & Postgres RDS) (Cloud Watch, Cloud Trail, EC2). - Strong understanding of postgres schema, user roles, access control, and security model. - Postgres script writing (PL/pgSQL) with loops, conditions, and variables. - Experience with Oracle development and administration is desired but not required. What you'll do: - Administer and maintain PostgreSQL databases across Linux environments, ensuring reliability and availability. - Perform database installations, configurations, upgrades, and routine maintenance activities with minimal supervision. - Write, optimize, and troubleshoot SQL queries, applying best practices in normalization and indexing to support application performance. - Execute and monitor backup and recovery processes, including pg_dump, pg_basebackup, and point-in-time recovery (PITR). - Analyze and improve database performance using explain plans and monitoring tools, resolving performance issues as they arise. - Support AWS-based infrastructure and database services, including EC2, CloudWatch, CloudTrail, and RDS (Aurora, PostgreSQL). - Manage PostgreSQL schemas, roles, and access controls, ensuring adherence to security and compliance standards. - Develop and maintain PL/pgSQL scripts to support database functionality and automation needs. - Perform system and software maintenance, including patching, upgrades, and coordination of hardware-related changes when required. - Create and enhance shell scripts to automate monitoring, alerting, and routine operational tasks. Qualifications - Bachelor's Degree in a related field. - 3+ years of experience as a Database Engineer using PostgresSQL. Requirements - DOD Secret Clearance or Top Secret Clearance. - Experience with different OS platforms like Linux and/or RHEL. - Database performance tuning and upgrades. - Experience with PL/SQL & PL/pgSQL. - Experience in shell scripting. - Working experience of AWS Cloud Services. - Strong understanding of postgres schema and security model. Benefits - Best-in-class matching 401K program. - Comprehensive healthcare plan through Cigna. - Competitive employer contribution to a health savings account. - Vision and dental plans. - Life insurance. - Short- and long-term disability. - Personal leave. - Paid certifications and training.