Database Administrator

Key Responsibilities

• Manage, maintain, and monitor SQL Server databases to ensure availability, performance, and reliability.
• Perform database installation, configuration, maintenance, backup, and recovery activities.
• Monitor database performance and identify and resolve performance-related issues.
• Write, review, and optimize SQL queries, stored procedures, views, and other database objects.
• Perform database backup and restore operations and support disaster recovery activities.
• Manage database security, user accounts, roles, and access permissions.
• Troubleshoot database errors, connectivity issues, and data integrity problems.
• Support database upgrades, migrations, and maintenance activities.
• Maintain appropriate database documentation and technical specifications.
• Understand and work with SQL Server 2012 in production/support environments.
• Have working knowledge of SQL Server 2019 and its features and capabilities.
• Design and maintain Entity Relationship (ER) diagrams and Data Flow Diagrams (DFD) as required.
• Collaborate with developers, system administrators, and other IT teams to resolve database-related issues.
• Follow organizational standards for database security, backup, recovery, and data integrity.

Required Skills & Qualifications

• Minimum 3 years of professional experience as a Database Administrator or in a similar database-focused role.
• Graduate or Postgraduate degree in IT, Computer Science, Information Technology, or a related discipline.
• Strong hands-on experience with Microsoft SQL Server 2012.
• Good knowledge of SQL Server 2019.
• Strong understanding of database administration and management concepts.
• Good knowledge of SQL, database objects, stored procedures, views, functions, and indexing.
• Knowledge of database backup, restore, recovery, and performance tuning.
• Ability to design and interpret ER diagrams and DFDs.
• Good analytical and problem-solving skills.
• Ability to work independently as well as collaboratively with technical teams.

Preferred Skills

• Experience with database migration or SQL Server upgrades.
• Knowledge of database security and access management.
• Familiarity with high availability and disaster recovery concepts.
• Knowledge of database monitoring and performance optimization tools.
• Good documentation and communication skills.

Key Competencies

• Database Administration
• SQL Server Management
• SQL Query Optimization
• Database Performance Tuning
• Backup & Recovery
• Database Security
• ER & DFD Diagram Design
• Troubleshooting & Problem Solving
• Documentation and Team Collaboration