We are looking for a Database Administrator to join our clients team.
Salary and Benefits:
Responsibilities:
- Database monitoring administration upgrades backup and disaster recovery planning & testing and development including stored procedures views etc.
- Maintain multiple environments (development testing and production) including patching and troubleshooting.
- Manage database active directory integration user accounts roles and access restrictions under the guidance and direction of the Infosec team.
- Microsoft PowerBI SSRS and SSIS development administration support and security management.
- Work with cross functional teams to accommodate the database design and administrative needs.
- Participate in the development of long-term planning for new projects including the architecture design planning installation and commissioning of new RDBMS environments.
- Ensuring that external and internal regulations and policies governing data management and infosec compliance are met including regulations concerning security audit ability and privacy.
- Review service-related reports (database backups maintenance monitoring) daily to ensure issues are identified and resolved within established SLAs. Respond to database related alerts and escalations and come up with strategic solutions to recurring problems.
- Develop ongoing assessments of database performance and identify problem areas.
- Evaluate database storage requirements for current systems and future growth perform space and performance monitoring analysis tuning and forecasting.
- Manage RDBMS data assets including facilitating organisation wide system integration data sharing archival/migration of data to data lakes or warehouses and data pruning
- Provide ad hoc reports to clients operations and administration.
Key Skills:
- A minimum of 2 years experience working as a SQL DBA.
- Deep working knowledge of general SQL queries and commands.
- Experience of recent and current editions of Microsoft SQL Server ().
- Experience of recent editions of PostgreSQL (9.6 Current).
- Linux and Windows CLI and scripting (Bash Powershell Python).
- Applied experience/knowledge of High Availability MSSQL PostgreSQL architectures such as hands-on experience with Microsoft AlwaysOn Availability Groups PgPool II general database replication and mirroring techniques.
Qualifications:
- Certifications and formal training in Microsoft SQL Curriculum or PostgreSQL an advantage.