Senior DataBase Analyst

Luxoft; Dublin; On-site; EUR 110,000 - 150,000; Full time

Job summary

Luxoft is seeking a senior Database Administrator to join the Managed Services database team. You will manage and support cloud-based databases (Oracle 19c and Postgres 17) across production and client environments, ensuring stability, performance, and availability.

You will work with DevOps and developers to integrate DB changes into CI/CD, implement backup and DR plans, and optimize queries and schemas. Willingness to work shifts and occasional on-call is expected.

Qualifications

• 12+ years of experience as a DBA with emphasis on Oracle, Postgres, AWS, and performance tuning.
• Experience in both development and production environments.
• Willingness to work any shift and perform extended hours as needed.
• Excellent problem-solving skills and strong attention to detail.
• Good interpersonal skills and ability to operate in a dynamic environment.

Responsibilities

• Own the stability, performance, and availability of all production database environments.
• Manage and support managed services databases on the cloud (Oracle 19c, Postgres 17).
• Perform change management for database maintenance and deployments.
• Configure multi-AZ deployments, Read Replicas, and cross-region architectures on AWS.
• Perform database installations, patching, and upgrades on AWS infrastructure.
• Develop and test disaster recovery plans and automated backups.
• Monitor performance with CloudWatch, lambda, SNS; respond to alerts.
• Collaborate with developers, DevOps, and cloud architects to CI/CD.
• Drive automation of DBA tasks using PowerShell, Python, AWS CLI, GitHub Actions.

Skills

DBA experience

Oracle

PostgreSQL

AWS

Performance tuning

Development & production

Problem solving

Attention to detail

Interpersonal skills

Shift work

Tools

OEM

Foglight

SQL Developer

PGAdmin

Shell scripting

PowerShell

PL/SQL

PG/SQL

GitHub Actions

Terraform

Ansible

JIRA

ServiceNow

Confluence

AWS CLI

CloudWatch

Job description

Project description

The Database team is responsible for managing and supporting our Managed Services clients. The role involves being a member of the database team within Managed Services which is responsible for maintaining managed services databases on the cloud.

Responsibilities

• Responsibilities: The Database team is responsible for managing and supporting our Managed Services clients. The role involves being a member of the database team within Managed Services which is responsible for maintaining managed services databases on the cloud (oracle 19c, Postgres 17) including:Management of all managed services environments (internal and client-facing)Provide support for any database related issues to all clients, particularly managed services clientsManage high severity incidents via SPGI process and work with all stakeholders to resolve issues as soon as possible including attending client bridge callsEnsure Database requests are dealt with within defined SLA’sModelling and scripting database changes for all our productsEnsure client releases are packaged and made available in a timely mannerBe available for occasional on-call rotation or weekend deploymentsOur cloud is hosted on AWS, and includes Amazon RDS, Amazon EC2, and Amazon Aurora. The role requires expertise in database performance tuning, security, cloud-based best practices, and ensuring continuous availability. The DBA will collaborate closely with developers, system administrators, and DevOps teams to ensure efficient database integration with business applications.Production Stability and ReliabilityOwn the stability, performance, and availability of all production database environments.Work on incident resolution, root cause analysis, and prevention strategies.Define and enforce database operational standards, guardrails, and best practices.Perform Change Management Database Management & MaintenanceAdminister and maintain Oracle and PostgreSQL databases hosted on Amazon RDS, Amazon Aurora, and Amazon EC2.Perform database installations, patching, and upgrades on AWS infrastructure.Configure and manage multi-AZ deployments, Read Replicas, and cross region architecturesImplement database partitioning, compression, and indexing to optimize performance.Performance EngineeringConduct deep performance analysis at the system, query, and indexing levels.Recommend and implement architectural improvements for scalability.Guide application teams in schema and query optimization.Backup & RecoveryDesign and implement automated backup strategies using AWS Backup and RDS Automated Snapshots for RDS oracle and Aurora PostgresUse Oracle RMAN for Oracle database backups and recovery.Develop and test disaster recovery plans.Monitoring & AlertingConfigure proactive alerts for performance issues, storage limits, and availability risks using CloudWatch, lambda and AWS SNS.Collaboration & DocumentationCollaborate with developers, cloud architects, and DevOps teams to integrate database changes into CI/CD pipelines.document database architectures, configurations, backup strategies, and recovery plans.Automation & InnovationDrive automation of operational DBA tasks using PowerShell, Python, AWS CLI, GitHub Actions or similar tools.Evaluate and implement new database technologies, monitoring solutions, and optimization tools.Tools & TechnologiesOracle Enterprise Manager (OEM), FoglightSQL Developer, PGAdminShell scripting, PowerShell, PL/SQL, PG/SQLGitHub, Terraform, Ansible,JIRA, Service Now, ConfluenceAWS native services including AWS Backup

SKILLS

Must have

• 12+ years of experience as a DBA, with a strong emphasis on oracle, Postgres, AWS and performance tuning.Familiar with working in both development and production environmentsWillingness to work any shift and to perform additional hours as needed.Good interpersonal skills and ability to operate in a dynamic environmentExcellent Problem-Solving SkillsStrong attention to detail

Nice to have

Willingness to work late hours