SQL Database Administrator

Database Administrator Unijobs on behalf of our public sector client have a requirement for a suitably skilled Database Administrator to join their team. The duration of this post is 12 months initially with possible extensions thereafter. This role will be remote working but the successful candidate must be available to attend client sites when required. Working 35 hours per week, the successful candidate will be employed as an agency employee and will be paid an hourly rate of €31.08 per hour based on an annualised salary of €56,757. You will accrue 30 days annual leave per year and paid Bank Holidays. The Database Administrator will join the Customer Service Experience (CSE) Database Services team working on the Application Modernisation Project (AMP). The successful candidate will provide: Database support for upgrades and assessments Advice and support to AMP project stakeholders regarding to all aspects of Database support. The DBAs will be required to support the delivery of services provided by DBA team. Service Types / Category Individual Service Names Troubleshooting/Support DBA Support DBA Alerts Daily Monitoring of Database Estate Security SQL Server Security Best Practice Installation and Maintenance New Builds Upgrades and Migrations Database Backup and Recovery Work closely with Senior DBA in deployment of DBATools to Database Estate Project Work Provide database support for AMP Project. Responsibilities: Support our clients Application Modernisation Programme - AMP in the management of the SQL database estate. Contribute and assist in the migration of databases from out of support servers. Manage database upgrades and consolidation projects Maintain and administer database security access Perform database Ad-hoc backups and restores Trouble shoot and resolve database connectivity issues SQL Server Installation, Upgrades, Migrations and Configuration Install database software service packs and cumulative updates as necessary Monitor and maintain database storage resources Monitor and maintain database maintenance plans for backups, index rebuild/defragment, and database statistics Deliverables for this position: Health check Assessments of SQL database estate in the regions: Identification of SQL Servers/Databases Documentation on configurations, version, dependencies, availability of backups Testing of Ability to restore from backups Analysis of Storage and configuration requirements Migration to new locations on National Data Centres: Configuration of new SQL Servers & SQL Server Instances Application of latest patches/update Transfer of Databases Rollback plans Post-Migration tasks: Continuous Monitoring of additional SQL database estate Updating of relevant documentation, Decommissioning of redundant SQL Servers Required Skills & Competencies: The successful candidate will be required to demonstrate the following skills: Proven expertise in the area of SQL DBA; min 2 years experience Proven experience of setting up, managing and monitoring replicated SQL databases Excellent knowledge of database security, backup and recovery and performance monitoring standards Ability to ensure business continuity in terms of database replication, backup and recovery PowerShell scripting skills would be advantageous Experience creating stored procedures, views and functions Personal Characteristics: Demonstrate good problem solving, analytical and decision making skills The ability to interact in a professional manner with key stakeholders The ability to produce against set timelines Self-starter with a willingness to take responsibility Excellent teamwork and interpersonal skills Excellent written and verbal communication skills Impeccable attention to detail *This position may be subject to Garda Vetting and Foreign Police Clearance, if applicable you will be required to obtain these prior to commencing in this role* Unijobs is an equal opportunities employer Skills: Database Administrator SQL DBA DBA Support DBA Alerts SQL Powershell Scripting Benefits: 30 days' annual leave