Apply for this Job
Database Administrator Education Requirements:
- Bachelor or Associate degree in Information Technology, Computer Science or related degree with an emphasis in database administration, system administration; or equivalent combinations of education and work experience required.
Experience:
- 3+ years of hands-on experience administrating the latest versions of Microsoft SQL Server and Azure SQL Databases.
- Knowledge of other industry databases such as Oracle, MySQL, PostgreSQL and Azure Cloud are important in this role.
Position Summary:
- The Database Administrator (DBA) is responsible for the deployment, administration, maintenance & technical support for all database environments.
- Investigate operational or systematic problems, provide resolution using advanced analytical skills and tools as well as be responsible for analyzing database performance issues & recommending tuning changes to improve performance.
- Works closely with development teams and senior architects to design and implement hybrid cloud and cloud native solutions using Azure infrastructure, platform and software as a service (IaaS, PaaS, SaaS) offerings as well as other cloud-based SaaS tools.
- Works with Identity & Access Team to provide access and maintain database security.
Essential Job Functions
- Involved in the design, implementation, security, scaling, and support of SQL Server & Azure SQL workloads.
- Assists with environment/database refreshes.
- Troubleshoot application database connectivity, SQL server issues, query performance, SQL HA/DR (i.e. SQL cluster, Always On, Log
- Shipping, DB replication) and other issues in production and development.
- Monitor and maintain database security & perform DB user/service account administration.
- Actively monitor overall SQL system health, database performance and schema review following best practices
- Database software and server installation, migrations, configuration and management
- Assists with Installing changes to database software, service packs and hot fixes as needed.
- Database backups, restores, consolidation and reorganization.
- Optimizes and tunes database systems to maximize their performance and operation.
- Defines and improves the overall release process for database systems.
- Monitor and support existing product and custom developed databases.
- Troubleshoot production support issues post-deployment and come up with solutions as required.
- Write T-SQL code and stored procedures to monitor, automate and support DBA tasks.
- Ability to provide code review and offer suggestions for improvements to T-SQL code and stored procedures.
Additional Job Functions
- Ensure all production changes follow the standard change request process.
- In order to minimize impact to users software installations and upgrades may need to be conducted outside of normal business hours, and occasionally on weekends.
- Supports & assists with disaster recovery planning and testing.
Follow industry security best practices.
- Occasional travel required to perform installations on project sites, onsite project support and training.
Knowledge, Skills and Abilities
- Demonstrates strong problem-solving skills.
- Experience with data analysis leveraging SQL.
- Knowledge of SQL Query Store
- Experience with Power BI, SSRS, and other reporting tools.
- Experience with MS Azure Cloud platform
- Ability to create and foster relationships within IT, department SMEs and end users.
- Hands on experience in SQL Server Integration Services (SSIS) package development and SQL Server Reporting Services (SSRS)
- Working knowledge of Idera or Redgate database tools
- Implementing and managing multi-node clusters
- Experience with Microsoft PowerShell
- Knowledge of Veeam SQL Backup/Recovery
- Ability to work with and handle sensitive and confidential information.
- Ability to prioritize, work independently and work within a deadline.
Date Posted: 12 April 2025
Apply for this Job