Database Administrator

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 user’s 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 SME’s 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.