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.