global-village-worker-ltd
Database Administrator
Job description
Position Advertised: Database administrator
Job specification
Your r esponsibility 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
