Are you ready to take the next step in your career and hit the ground running as a DBA here at Workplace Solutions.
As a Senior Database Administrator in our Workplace Solutions Database Management team, you will have extensive experience managing SQL Server, Azure, and PostgreSQL databases. You will be responsible for ensuring the performance, availability, and security of our databases. This role requires a strategic thinker with the ability to implement best practices, troubleshoot complex database issues, and mentor junior DBAs.
Job responsibilities
- Manage and maintain SQL Server, Azure SQL, and PostgreSQL databases.
- Perform database tuning, optimization, and maintenance to ensure high performance, as well as implement and oversee database backup, restore, and disaster recovery processes.
- Design and develop database architectures and models and write and optimize SQL queries, stored procedures, and functions.
- Implement database security measures to protect sensitive data and ensure compliance with industry standards and regulatory requirements.
- Conduct regular security audits and vulnerability assessments.
- Monitor database performance and proactively identify and resolve issues, as well as performing root cause analysis of database-related issues and implement corrective actions.
- Utilize monitoring tools to maintain database health and performance.
- Manage databases hosted on Azure, including Azure SQL Database and other cloud-based database services.
- Develop and implement strategies for database migration to and from the cloud and ensure efficient utilization of cloud resources and manage associated costs.
- Work closely with other IT teams, developers, and stakeholders to deliver robust database solutions and mentor and provide technical guidance to junior DBAs and other team members.
- Contribute to the development of database policies, standards, and procedures.
Required qualifications, capabilities, and skills
- Formal training or certification on system design concepts and proficient advanced experience with SQL Server, Azure and PostgreSQL.
- Experience in database design, implementation, and maintenance.
- Background in performance tuning and optimization of large-scale databases.
- Proficiency in SQL Server.
- Extensive experience with Azure SQL Database and other Azure cloud services.
- Solid knowledge of PostgreSQL and its various extensions and tools.
- Familiarity with database monitoring and management tools (e.g., SQL Profiler, Azure Monitor, pgAdmin).
- Understanding of data warehousing concepts and experience with ETL processes.
- Excellent problem-solving, analytical skills and strong communication and collaboration skills.
- Ability to work independently and as part of a team.
- Attention to detail and a commitment to data integrity and security.
Preferred qualifications, capabilities, and skills
- Certifications in SQL Server, Azure, or PostgreSQL.
- Experience with NoSQL databases and other modern data technologies.
- Knowledge of scripting languages such as PowerShell or Python.
- Experience with DevOps practices and tools (e.g., CI/CD pipelines).