Senior Database Administrator

AffinityX is a global provider of industry-leading digital marketing, advertising, creative, and print solutions, working to generate exceptional, measurable results for every client. Our adaptive, customer-first approach pairs the best talent with strategic solutions, working to streamline multiple processes, technologies, and platforms to help businesses develop efficiencies and achieve success.

Who you are

A database administrator (DBA) in digital web services is responsible for designing, implementing, and maintaining the databases. This position requires expertise in database management systems, database security knowledge, and database performance tuning experience. The DBA must work closely with developers, network administrators, and other IT staff to ensure that the databases are optimized for performance, highly available, and secure.

Note: please keep in mind that although this is a remote position, it is required to have Serbian citizenship.

Required Skills:

  • Expertise in administering MySQL 5.7 (or newer) Enterprise Edition.
  • Expertise in administering Oracle 11g
  • Oracle database systems; MySQL 8.0 experience a plus; MS SQL Server experience a plusExpertise in Structured Query Language (SQL)
  • Expertise in database design, ERDs, schema creation
  • Expertise in creating stored procedures, functions, views
  • Expertise in managing databases on AWS RDS, Google Cloud SQL, or Azure Database services
  • Configuring and maintaining replication, log shipping, etc.
  • Familiarity with database automation and scripting using languages like Python, PHP, PowerShell, or Bash

Position Responsibilities and Essential Duties:

  • Ability to work efficiently with MySQL and Oracle databases; any experience with SQL Server is a plus
  • Ensure data integrity and system performance for all of our databases
  • Create and maintain the database schemas based on business and project requirements –
  • Understand the intended use of the database structures & help educate development team members on them
  • Write efficient complex queries; assist developers to do the same Configure and maintain replication, log shipping, etc.
  • Create upgrade scripts to move changes from development to production
  • Support database management and provide help for upgrade and migration of databases to new releases
  • Maintain database documentation Advise and guide systems development team members on database/file design, performance monitoring and application/maintenance design and tuning
  • Troubleshoot the incidents and problems reported on database systems
  • Work with IT and Client Solution team members to ensure the database integrity, high availability and security
  • Help provide the root cause analysis on the major incidents/problem

Benefits

  • 100% remote
  • Private health insurance
  • Long-term engagement

If you wish to find out more about the Client, the position, the selection process and discuss the salary, please reach out to: milan.milosevic@bps-tech.io.

Please keep in mind that only shortlisted candidates will be contacted for an interview. Thank you.

Apply for this position

Allowed Type(s): .pdf, .doc, .docx