Duties and Responsibilities:
Managerial Duties:
1. Preparation and development of monthly, quarterly, and annual work plans aligned with the general plan of the agency to achieve set goals.
2. Presentation of monthly, quarterly, annual, and ad hoc reports on relevant activities and achievements to inform leadership.
3. Execution of other duties assigned by competent authorities in accordance with laws, regulations, and agency objectives.
Coordination Duties:
4. Ensuring coordination between relevant directorates inside and outside the agency on related topics.
Key Responsibilities:
- Designing, creating, and managing new databases for various departments of the General Directorate of Treasury based on operational needs.
- Collecting, analyzing, and preparing technical reports on database performance, challenges, and issues for submission to the Database Development Management.
- Timely maintenance and protection of existing databases to prevent cyber-attacks, viruses, and any unauthorized access to stored data.
- Installing and configuring database management systems on servers and providing access links to users based on their privileges.
- Regular setup and implementation of backup and recovery systems for databases to secure critical information of the Directorate.
- Full proficiency in SQL Server and familiarity with other DBMS types to ensure better management and flexibility in systems.
- Evaluating and analyzing transaction processes to identify software and hardware upgrade requirements.
- Designing and implementing policies, procedures, and security controls to ensure the safety of databases and stored information.
- Analyzing database requirements and designing logical and physical structures based on modern database principles and organizational needs.
- Managing database access by defining users, roles, and privileges according to security standards.
- Developing and optimizing queries, indexes, and other database components to improve system speed and efficiency.
- Technical collaboration with software development teams in designing, testing, and implementing structural changes to databases.
- Utilizing monitoring tools for continuous oversight of the health, performance, and security of databases. Monitoring database software updates and analyzing their impact on security and performance.
- Accurate documentation of structures, changes, policies, procedures, and all database-related activities for future reference and knowledge transfer.
- Providing expert consultations to resolve complex database issues.
- Offering technical advice and recommendations based on data analysis to relevant officials to improve database and information systems operations.
- Training and guiding new employees or users in database usage and adherence to security principles.
- Responding to database incidents and issues, including recovery of deleted or lost data and resolution of system errors.
- Preparing and delivering complex reports related to budget, allocation, expenditure, and other reports requested by relevant authorities.
- Participating in technical meetings to analyze new solutions and offer professional opinions in database development.
- Remaining in the office beyond regular working hours when necessary to manage increased workloads.
- Performing other duties assigned by competent authorities in accordance with relevant laws, regulations, and the Ministry’s objectives.
Requirements for the Position:
This job description is prepared in accordance with Articles 7, 8, and 34 of the Civil Service Employees Law, and includes the following criteria:
1. Education:
- Bachelor’s degree (at minimum) in one of the following fields:
- Computer Science
- Information Technology
- Software Engineering
- Database Management
- Information Systems
- Or a related technical discipline
- Higher academic qualifications (e.g., Master’s) are preferred.
2. Work Experience:
- Minimum of 2 to 3 years relevant work experience in database administration, development, or related roles.
- Proven experience in:
- SQL Server administration and development
- Database security implementation
- Backup and recovery planning
- Performance tuning and query optimization
3. Technical Skills:
- Strong knowledge and hands-on experience with:
- SQL Server (required)
- Other DBMS like MySQL, PostgreSQL, or Oracle (preferred)
- Ability to:
- Design and normalize databases (logical & physical)
- Develop and optimize complex queries and indexes
- Configure and use database monitoring tools
- Apply security policies and manage roles/permissions
- Familiarity with:
- Backup and disaster recovery strategies
- Data migration and transformation processes
- Scripting languages (e.g., T-SQL, PowerShell)
4. Analytical and Reporting Skills:
- Ability to analyze data and performance metrics.
- Experience preparing technical and financial reports.
- Capacity to provide expert advice based on data insights.
5. Soft Skills:
- Strong problem-solving and troubleshooting abilities.
- Good communication and teamwork skills.
- Capacity to train and support users.
- Flexibility to work beyond regular hours when required.
6. Language Skills:
- Proficiency in one of the official languages (Pashto or Dari).
- Working knowledge of English (especially technical vocabulary).
7. Computer Literacy:
- Proficiency in MS Office (Word, Excel, PowerPoint).
- Knowledge of database design tools and monitoring software.