Job Opening
Senior Database Administrator
Permanent
Dublin
19-09-2023
80000
Realtime Recruitment has partnered with a global client that provides the best-in-class payment processing solutions to industry leaders!
This client is looking to bring in a Senior SQL Database Administrator that will work alongside the DBA Manager in maintaining the databases performance, integrity and security. You will also work alongside various production teams assisting in the building & deployment of solution upgrades.
This is a fully remote, full time position however, candidates are required to be located in Ireland.
Responsibilities and Duties
1. Collaborate closely with engineering teams to create and maintain logical/physical database designs in support of both new and existing application development efforts. Keep data models up-to-date.
2. Craft and implement schema designs, indexes, SQL queries, and stored procedures.
3. Manage database specifications, maintain a data dictionary, adhere to design and coding standards, and document your work thoroughly.
4. Tackle problem-solving and root cause analysis, offering recommendations and implementing preventive measures as needed.
5. Examine SQL query plans and utilize diagnostic tools to identify and address performance bottlenecks, taking corrective actions to enhance efficiency.
6. Assess the advantages of available system upgrades and enhancements and implement them when deemed beneficial.
7. Construct High Availability (HA) and Disaster Recovery (DR) systems using technologies such as Failover Clustered instances, Availability Groups, Multi-site clusters, and Replication across geographi