Position Advertised: Database administrator

Job specification:

Your responsibility as a database administrator (DBA) will be the performance, integrity and security of a database. You'll be involved in the planning and development of the database, as well as in troubleshooting any issues on behalf of the users. You'll ensure that: data remains consistent across the database.

Duties and responsibilities

• Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high-levels of performance, availability, and security

• Manage, create and Maintain SQL Reporting Service Reports and ad-hoc reports as requested by the business

• Create and maintain documentation, procedures and best practices for database deployment and maintenance

• Create stored procedures for application programming interfaces (APIs)

• Respond to user reported errors in a timely manner

• Assist developers with complex query tuning and schema refinement

• Monitor systems performance and identifying problems that may arise

• Perform scheduled maintenance and support release deployment activities after hours

• Protect the database from threats and unauthorized access

• Provide technical mentorship and cross-training to other peers and team members

Qualifications and skills required:

• Bachelor’s degree in Computer Science or other relevant discipline or 10 Years IT experience

• Advanced T-SQL and Power Shell Scripting skills

• Advanced in Microsoft SQL query optimization and index management

• Advanced knowledge of Microsoft SQL Reporting Server Reports and Integration Service Packages

• Advanced hands expertise with replication, log shipping, High Availability and Backup/Recovery

• Advanced SQL Server maintenance/patching mechanics

• Advanced understanding of back end, server, and API development, including application and database/data development and architectures

• Expert in performance tuning and DB optimization using native monitoring and troubleshooting tools

• Experience with the following (one or all) NOSQL databases - Elastic, MongoDB, Neo4j

• Understanding and experience of Microsoft Azure and related SQL services including Azure SQL Managed Instances & Azure SQL Database

• Knowledge with Microsoft Power BI is desirable

• Understanding of Scrum/Agile methodologies is preferred

• Knowledge of ViewPoint Software for Business is desirable

Experience needed:

• Advanced T-SQL and Power Shell Scripting skills

• Advanced in Microsoft SQL query optimization and index management

• Advanced knowledge of Microsoft SQL Reporting Server Reports and Integration Service Packages

• Advanced hands expertise with replication, log shipping, High Availability and Backup/Recovery

• Advanced SQL Server maintenance/patching mechanics

• Advanced understanding of back end, server, and API development, including application and database/data development and architectures

• Expert in performance tuning and DB optimization using native monitoring and troubleshooting tools

• Experience with the following (one or all) NOSQL databases - Elastic, MongoDB, Neo4j

• Understanding and experience of Microsoft Azure and related SQL services including Azure SQL Managed Instances & Azure SQL Database

• Knowledge with Microsoft Power BI is desirable

Minimum requirements

• 10 Years IT experience

• . Experience with the following (one or all) NOSQL databases - Elastic, MongoDB, Neo4j

• Understanding and experience of Microsoft Azure and related SQL services including Azure SQL Managed Instances & Azure SQL Database

• Knowledge with Microsoft Power BI is desirable