Database Administrator

Matrix Eastern Europe, the offshore division of Matrix IT, one of the leading global R&D services companies with more than 11,000 professionals, is looking for a Database Administrator to join one of our teams!

We are hiring a hands-on Database Administrator to own the reliability, performance, security and recoverability of client’s data estate across MongoDB, Microsoft SQL Server and AWS. You will report to the Chief Architect and work closely with engineering, DevOps and Security/Compliance.

Daily tasks

• MongoDB (Atlas and self-managed on-prem)
• •Administer MongoDB Atlas clusters: tiers, scaling, network peering/private endpoints, alerts, Atlas backups and the Performance Advisor.
• •Run self-managed replica sets on-prem: installation, upgrades, replica set and sharding configuration, OS and storage tuning.
• •Optimize schemas, indexes and aggregation pipelines with developers; profile and fix slow queries.
• •Plan and execute version upgrades on both Atlas and on-prem clusters with minimal downtime.
• Microsoft SQL Server
• •Administer production SQL Server instances: high availability (Always On AGs or equivalent), maintenance plans, index and statistics maintenance.
• •Diagnose performance using execution plans, Query Store, wait stats and DMVs.
• •Review T-SQL, stored procedures and schema changes before release.
• •Manage the SQL Server data warehouse: load jobs (SQL Agent / SSIS), partitioning, columnstore indexes, storage growth and reporting-query performance.
• AWS data services
• •Operate Amazon RDS instances: parameter groups, Multi-AZ, read replicas, snapshots, Performance Insights and minor/major version upgrades.
• •Manage S3 as a data and backup store: bucket policies, encryption (SSE-KMS), lifecycle rules, versioning, Object Lock and cross-region replication where required.
• •Support data pipelines that move operational data to S3 and downstream analytics.
• Backup, recovery and resilience
• •Own backup policies for every data store: schedules, retention, encryption, offsite/cross-region copies, and documented RPO/RTO per system.
• •Run scheduled restore tests and disaster-recovery drills, and record the evidence.
• •Write and maintain runbooks for failover, point-in-time recovery and incident response.
• Security, compliance and operations
• •Enforce least-privilege access, user and role management, encryption at rest and in transit, and audit logging.
• •Provide evidence and controls for audits (e.g. SOC 2, ISO 27001) and banking-partner due diligence.
• •Build monitoring and alertin

Requirements

•5+ years as a DBA supporting production systems. •3+ years administering MongoDB in production, covering both MongoDB Atlas and self-managed deployments (replica sets, upgrades, indexing, query tuning). •3+ years administering Microsoft SQL Server in production (HA, maintenance, performance tuning, T-SQL). •Hands-on experience with AWS RDS and S3 (snapshots, encryption, IAM policies, lifecycle and replication settings). •Proven experience designing backup and retention policies and performing real restores, including point-in-time recovery. •Scripting for automation in at least one of Python, Bash or PowerShell. •Working knowledge of database security: access control, encryption, auditing. •Fluent English, written and spoken.

Must have: MongoDB, Data base, SQL, AWS