Description

About You – Experience, education, skills, and accomplishments  

  • 8 years minimum of experience managing MSSQL, as well as Windows operating systems.
  • 8 years of experience of physical and logical MSSQL Server and database design knowledge
  • At least 8 years of experience with strong SQL DB architecture logical and physical understanding.
  • At least 8 years of experience in database performance tuning and capacity planning.
  • At least 8 years of experience with strong SQL Administration and MSSQL roles and features.
  • At least 7 years of experience in cloud-based database services, such as AWS RDS, MS Azure.

 

It would be great if you also had...

  • Ability to perform both MSSQL and operating system performance monitoring and the necessary adjustments.
  • Other DB engines like Oracle Server, MySQL and Postgres databases are a plus.
  • A good knowledge of the operating systems
  • Experience working in AWS or any other cloud like Azure would be great. 
  • Experience/Understanding with DevOps and automation tools and basic knowledge about CloudOps processes 
  • Monitoring tools and alerting like Data Dog and Pager Duty
  • Excellent knowledge of MSSQL backup and recovery scenarios.
  • Excellent skills in all Microsoft tools: SSMS, SSRS, SSIS
  • Excellent knowledge of MSSQL security management.
  • Experience and knowledge in Database migrating and upgrade.
  • Excellent knowledge business continuity and data integrity.

 

What will you be doing in this role? 

  • Creates and maintains all databases required for development, testing, education, and production usage.
  • Performs the capacity planning required to create and maintain the databases. The DBA works closely with system administration.
  • Formulate and execute remediation plans where existing Database deployments fall short of industry and company standards.
  • Assist in troubleshooting efforts when data integrity or database performance is suspected is a possible cause of service issues.
  • Performs ongoing tuning of the database instances.
  • Install new versions of the MSSQL and its tools and any other tools that access the SQL database.
  • Plans and implements backup and recovery of the MSSQL database.
  • Advise development teams on appropriate database server deployment and configuration. Implements and enforces security for all the SQL Databases.
  • Performs database re-organizations as required to assist performance and ensure maximum uptime of the database.
  • Support service delivery and development teams by refreshing non-production database environments.
  • Test patches to ensure compatibility with the database environment and participate in regular patching cycle.
  • Enforces and maintains database constraints to ensure integrity of the database.
  • Administers all database objects, including tables, clusters, indexes, views, sequences, packages, and procedures.
  • Assists with impact analysis of any changes made to the database objects.
  • Monitor Database alerts and respond to issues and errors.
  • Assess, develop, and improve database High Availability\Disaster Recovery strategy Implement maintenance plans and monitoring to ensure Database instances are running optimally and making best use of computing resources.
  • Contribute to the overall strategy for the Enterprise Solutions SQL Server estate supporting internal applications.
  • Supporting developers to ensure their applications query the DBs in the most efficient, possible way. 
  • Assisting with your expertise to new projects in order to define the best technologies and approaches to use from the DBA perspective. 
  • Assisting to resolve day to day incidents with our assets. 

Education

Any Graduate