Employment type – Contract
Job Title – Senior Database Administrator
Job Location – Remote
Duration – 6+ months
Experience level – 10+
Mandatory Skills – Senior Database Administrator
Job Description –
The Senior Database Administrator supports the secure, reliable, and scalable data platforms integrated risk adjustment, quality, and value-based care solutions. This role owns production database operations across Azure SQL, Amazon RDS, and Percona MySQL environments, with particular emphasis on healthcare-data security, high availability, performance, disaster recovery, automation, and support for platform integration.
Responsibilities
• Maintains, modifies, and creates database structures with little or no supervision across on-premises and cloud-based database environments. Codes, tests, implements, and supports databases by applying knowledge of database design standards, database management systems, cloud database architectures, and enterprise data management practices.
• Administers and supports Azure SQL and related Microsoft Azure database services, Percona MySQL, and Amazon RDS database platforms in high-availability, high-volume, and high-transaction environments.
• Administers, monitors, tests, and improves high-availability and disaster-recovery solutions. Implements and maintains database configurations, security controls, maintenance procedures, backup and recovery solutions, and monitoring standards. Implements and improves procedures for archival, disaster recovery, business continuity, migration, replication, and database lifecycle management.
• Configures database parameters, routines, stored procedures, functions, triggers, and other database objects. Reviews database access patterns and application SQL code and provides recommendations to improve performance, scalability, reliability, and maintainability.
• Provides database performance tuning and troubleshooting across database engines, operating systems, cloud infrastructure, storage, networking, and application layers. Analyzes execution plans, wait statistics, blocking, deadlocks, resource utilization, query performance, indexing, statistics, and other
database performance characteristics.
• Administers cloud database services in Microsoft Azure and Amazon Web Services. Supports Amazon RDS deployments, including provisioning, configuration, monitoring, backup/recovery, replication, failover, scaling, security, and operational maintenance.
• Administers Percona MySQL environments, including high-volume and highly transactional production databases. Supports replication, backup/recovery, performance tuning, configuration management, monitoring, upgrades, migrations, and troubleshooting.
• Develops and maintains standards, procedures, automation, and guidelines for database management systems and supporting software. Identifies opportunities to automate routine DBA activities using scripting, database tooling, cloud services, and infrastructure automation.
• Participates in database migrations and modernization initiatives, including migrations between onpremises and cloud environments and migrations between database platforms when required.
• Assists in the research, evaluation, and implementation of new database technologies, cloud services, monitoring platforms, and database management techniques.
• Serves as a technical resource to database administrators, developers, engineers, and other technical teams. Reviews schemas, database changes, and SQL for performance, reliability, security, and operational supportability.
• Supports application debugging by analyzing database behavior, SQL queries, execution plans, locking, blocking, deadlocks, and other database-related application issues.
• Coordinates disaster-recovery activities and participates in testing, maintaining, and improving established emergency procedures. Participates in disaster recovery exercises and validates recovery objectives, backup integrity, replication, and failover procedures.
• Participates in on-call responsibilities and performs or assists with production problem resolution. Evaluates alternatives and recommends appropriate solutions during production incidents.
• Creates and maintains accurate technical documentation of database environments, configurations, procedures, recovery processes, standards, and operational activities. Ensures written communication is accurate, timely, and thorough.
• Adheres to accepted security, compliance, database, cloud, and operational standards and procedures.
• Serves as a mentor and technical resource for DBA I, DBA II, database engineers, and other members of the technical organization.
Required Skills
• Bachelor’s degree and three or more years of relevant database administration experience OR six or more years of equivalent professional database administration experience.
• Strong written and oral communication skills.
• Experience protecting regulated healthcare or similarly sensitive data, including encryption, auditing, access controls, and security remediation.
• Experience operating and validating database environments against established RPO, RTO, availability, and data-retention requirements.
• Experience supporting 24×7 SaaS or mission-critical production platforms.
• Demonstrated experience maintaining data integrity across high-volume ingestion, replication, or integration processes.
• Experience administering Azure SQL and cloud-based SQL Server environments.
• Experience administering Amazon RDS, including production database environments.
• Experience administering Percona MySQL and/or MySQL in high-volume production environments.
• Strong knowledge of database design principles, configuration, implementation, and production administration.
• Experience writing, maintaining, troubleshooting, and debugging complex T-SQL and MySQL stored procedures.
• Experience with high-availability solutions for Azure SQL, Percona MySQL, and/or databases hosted on Amazon RDS.
• Experience with database replication, failover, backup/recovery, disaster recovery, and business continuity.
• Experience with performance tuning and troubleshooting of database and application workloads.
• Strong knowledge of execution plans, indexing, statistics, blocking, deadlocks, wait statistics, resource utilization, and query optimization.
• Experience supporting production applications and troubleshooting problems across the application/database boundary.
• Experience with cloud database administration, including monitoring, security, scaling, availability, backup/recovery, and cost considerations.
• Ability to manage multiple priorities, operate with little or no supervision, and demonstrate strong attention to detail.
• Ability to participate in an on-call rotation and respond effectively to production incidents.
• Ability to document technical solutions and communicate complex technical concepts to both technical and non-technical audiences.
Preferred Skills
• Experience with Microsoft Azure including Azure SQL Database, Azure SQL Managed Instance, Azure
Monitor, Azure networking, storage, security, and related services.
• Experience with Amazon Web Services, including Amazon RDS, EC2, CloudWatch, IAM, VPC, and related services.
• Experience with Percona Server for MySQL, Percona XtraBackup, and MySQL replication technologies.
• Experience with Azure SQL Managed Instance and cloud-based SQL Server migrations.
• Experience supporting AWS serverless and event-driven workloads using AWS Lambda, Amazon SQS, and Amazon EventBridge Scheduler, including monitoring, troubleshooting, security, and database connectivity.
• Experience with large-scale, high-volume, highly transactional database environments.
• Experience with database monitoring and observability platforms such as LogicMonitor, New Relic, Azure Monitor, CloudWatch, or similar technologies.
• Experience with automation and scripting using PowerShell, Python, Bash, or similar languages.
• Experience with Infrastructure as Code, DevOps, CI/CD, or automated database deployment practices.
• Experience with Azure Data Factory, Microsoft Fabric, Synapse Analytics, or similar data integration and analytics platforms.
• Experience with .NET, C#, VB.NET, XML, REST APIs, SOA, or object-oriented development.
• Experience with enterprise data governance, security, auditing, and compliance requirements.
• Degree in Computer Science, Information Systems, Electrical Engineering, or a related technical field.
Tekshapers is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.
