Description
Job responsabilities
The DBA position will be responsible for maintaining the company’s database systems (currently MS SQL Server) including back-up, performance tuning, capacity planning, monitoring critical events and documentation
Key Areas of Responsibility
- Create and manage multiple databases and assist with capacity planning.
- Monitor and maintain database systems and troubleshoot any issues that may arise.
- Maintain data integrity and security (manage database user roles and permissions).
- Use tools such as SQL Profiler to optimize your database.
- Generate traces and execution plans to identify and resolve performance issues, deadlocks/contentions.
- Develop strategies and implement solutions to manage backup, recovery, and replication.
- Create and manage constraints and indexes. Assists software developers with database operations such as developing complex SQL, optimizing DML, and creating stored procedures.
- Proactively manage/archive and shrink your database. Manage production, QA, and development database environments.
- Create detailed documentation including database infrastructure diagrams.
- Know the business processes involved and understand data flows, importance, and dependencies.
- Effective coordination and communication with all stakeholders (internal teams and customers).
- Establish and maintain database infrastructure for the company’s BI needs.
Requirements
Mandatory requirements for the job
- Create and manage multiple databases and assist with capacity planning.
- Monitor and maintain database systems and troubleshoot any issues that may arise.
- Maintain data integrity and security (manage database user roles and permissions).
- Use tools such as SQL Profiler to optimize your database.
- Generate traces and execution plans to identify and resolve performance issues, deadlocks/contentions.
- Develop strategies and implement solutions to manage backup, recovery, and replication.
- Create and manage constraints and indexes.
- Assists software developers with database operations such as developing complex SQL, optimizing DML, and creating stored procedures.
- Proactively manage/archive and shrink your database. Manage production, QA, and development database environments.
- Create detailed documentation including database infrastructure diagrams.
- Know the business processes involved and understand data flows, importance, and dependencies.
- Effective coordination and communication with all stakeholders (internal teams and customers).
- Establish and maintain database infrastructure for the company’s BI needs.
If interested, please send your application?
Pour postuler, veuillez cliquer sur ce lien : www.openjob.sn.
