Home/Find a Job/..
SQL DBA
SQL DBA
Unijobs on behalf of our public sector client have a requirement for a suitably skilled SQL DBA to join their team. The duration of this post is 12 months initially with possible extensions thereafter. This role will be Remote working- The successful candidate must be able to attend client sites as 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.70 per hour based on an annualised salary of €57,898. You will accrue 30 days annual leave per year and paid Bank Holidays.
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 |
Database Administrator Responsibilities:
- Support the clients Project 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 2yrs 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
- Applicants must be eligible to work in Ireland at the time of application.
*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