Social network you want to login/join with:
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 hire a Senior SQL Database Administrator who will work alongside the DBA Manager to maintain database performance, integrity, and security. The role involves collaborating with various production teams to assist in building and deploying solution upgrades.
This is a fully remote, full-time position; however, candidates must be located in Ireland.
Responsibilities and Duties
1. Collaborate with engineering teams to create and maintain logical and physical database designs supporting application development. Keep data models up-to-date.
2. Design and implement schemas, indexes, SQL queries, and stored procedures.
3. Manage database specifications, maintain a data dictionary, adhere to design and coding standards, and document work thoroughly.
4. Perform problem-solving and root cause analysis, providing recommendations and implementing preventive measures.
5. Analyze SQL query plans and use diagnostic tools to identify and resolve performance issues, taking corrective actions to improve efficiency.
6. Evaluate and implement system upgrades and enhancements when 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 geographical locations.
#J-18808-Ljbffr