Ascentech Services Limited – Our client is a Technology Company providing Information Management Solutions and Services to African companies and businesses. They currently have an opening for the position below:
Job Title: Database Administrator
Location: Lagos
Employment Type: Full-time
Responsibilities
- Work with the Enterprise IT Unit to design and develop capacity planning of the database infrastructure.
- Application (Designing schema, access patterns, locking strategy, SQL development, and tuning, Modifying the database structure, Optimizing application and end-user queries (reactive tuning), Archiving Data, Generating needed ad hoc reports by querying from the database, Proactive performance tuning)
- Access (Enrolling users and maintaining system security, Controlling user access to the database)
- Database (Parameter configuration and tuning, Cache management, Job scheduling)
- Monitor, maintain database systems, and resolve problems that may arise.
- Maintain data integrity and security (manage roles and permissions of database users).
- Use industry-standard tools for database tuning.
- Generate traces, execution plans, identify performance issues,deadlocks/contention, and resolve them.
- Create and manage constraints and indexes.
- Automation of tasks, installations, updates, maintenance task configuration, etc.
- Database unit testing frameworks like TSQLT
- Familiar with Git, Talend, ReDSHIFT, PowerBI, and other data tools
- Proactive housekeeping/archiving and shrinking of databases.
- Manage production, QA, and development database environments for all company solutions.
- Create detailed documentation including diagrams of database infrastructure.
- Learn relevant business processes and understand the data flow, criticality and dependencies.
- Effectively coordinate and communicate with all the stakeholders(internal teams and clients).
Requirements
- Candidates should possess a Bachelor’s Degree
- The ideal candidate is required to have about 3 years of experience.
Core Skills:
- In-depth understanding of AWS and other cloud services
- Experience with cloud data security solutions
- Extensive experience writing T-SQL and stored procedures and query tuning on high transaction systems.
- Experienced in SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS).
- Experienced in ETL (Extract-Transform-Load) development / data integration.
- Sound knowledge of RDBMS concepts, database architecture, and SQL/T-SQL.
- Proficient with SQL server profiler for monitoring and troubleshooting database activity and performance.
- Experience in SQL Server Clustering and HA technologies including mirroring, log shipping, failover cluster, and various replication technologies would be an advantage.
- Knowledge of other databases like MySQL, No SQL databases, and In-memory databases and MCTIP certification will be an advantage.
- Ability to develop procedure documents and maintain detailed database-related documents.
- Working knowledge and experience with graph databases
- Good communication skills.
- Attention to detail.
Deadline: 7th December, 2021.
Method of Application
Interested and qualified candidates should send their CV to: princewill@ascentech.com.ng using the Job Title as the subject of the email.
Leave a Reply