Senior database administrator

Roles and Responsibilities:
o Database Administration
? Oversee all data generated, monitor server transaction speeds, and look for any service degradation in speeds due to SQL fragmentation or lack on maintenance
? Oversee all SQL instances and databases
? Ensure all databases of the same platform is up to data and the same
? Ensure data is accurate and integrity is maintained with SQL backups and logs shipping
? Ensure the companies records are archived and secure and keep the companies database maintenance plan intact with the company records
? Ensure the Databases security is correct and accurate and only allow who is required to the required databases

o High Availability
? Implement and maintain a working high availability environment with SQL replication for failover on all SQL instances

o Database Reporting and dashboards
? Ensure all company reports are accurate and running
? Build and maintain the company dashboards
? Ensure all Business intelligence is reachable at all time
? Ensure all reconciliation take place and investigate any discrepancies found

o Database Solution Design
? Design databases for custom build solutions and be able to understand hight transaction flows and be able to build the databases, store procedure and functions as required to met demands

• Knowledge:
o Power BI or any third-party BI software
o SQL and SQL replication in advanced stage
o Data warehousing and transactional flows of data in systems
o Active Directory, DNS with working with SQL
o Virtual Server Experience, Azure or AWS experience a bonus with SQL
o Knowledge on all forms of internet connectivity
o SQL security Implementations and management
o Knowledge of SQL best practices for change control, implementations etc.