Database Administrator

#Broadcasted

Database Administrator
Experience: 3 - 4yr

JD:
The job description of a Database Administrator (DBA) specializing in Microsoft SQL Server (MS SQL) typically includes the following responsibilities:

Database Design and Implementation: Designing and implementing MS SQL Server databases, including determining the schema, table structures, relationships, and indexing strategies. Ensuring the databases are optimized for performance, scalability, and security.

Database Performance Monitoring and Tuning: Monitoring database performance using various tools and techniques to identify and resolve performance bottlenecks. Optimizing queries, indexes, and database configurations to improve overall system performance.

Database Backup and Recovery: Developing and implementing backup and recovery strategies to protect the integrity and availability of MS SQL Server databases. Performing regular backups, verifying backups, and restoring databases in case of data loss or system failures.

Database Security and Access Control: Implementing and maintaining security measures to protect sensitive data stored in MS SQL Server databases. Configuring user access rights, roles, and permissions. Monitoring and auditing user activities to ensure compliance with security policies and regulations.

Database Maintenance and Upgrades: Performing routine maintenance tasks such as database reorganizations, index rebuilding, and statistics updates to optimize database performance. Planning and executing database upgrades and migrations to newer versions of MS SQL Server.

Database Troubleshooting and Issue Resolution: Investigating and resolving database-related issues, such as data corruption, performance degradation, and system errors. Troubleshooting and resolving database connectivity problems and working with application developers to address database-related issues.

Database Documentation and Reporting: Creating and maintaining documentation related to database design, configuration, and processes. Generating reports on database performance, availability, and security to provide insights and recommendations for improvements.

Collaboration and Support: Collaborating with cross-functional teams, including developers, system administrators, and business stakeholders, to understand and address database requirements. Providing technical support and guidance to application developers and end-users regarding database-related matters.

Database Capacity Planning: Assessing current and future database storage and processing requirements. Planning and implementing capacity expansion strategies to ensure the availability of adequate resources to support database growth.

Continuous Learning and Professional Development: Keeping up to date with the latest trends, technologies, and best practices in MS SQL Server database administration. Participating in training programs, attending conferences, and obtaining relevant certifications to enhance skills and expertise.

Working experience of 3+ year on Complex data structure ERP.
Having Experience to handle Overseas clients, Willing to work on night shifts.