ROLE OBJECTIVE :

The Database Administrator (DBA) is to ensure the performance, security, availability, and integrity of databases within an organization. The DBA is responsible for designing, implementing, maintaining, and optimizing database systems to store, manage, and retrieve data efficiently. This role also involves monitoring database performance, troubleshooting issues, implementing backups and disaster recovery plans, and ensuring data security and compliance with regulatory requirements. The DBA aims to provide reliable and scalable database environments that support business operations and enhance data driven decision-making

DUTIES & RESPONSIBILITIES:

The roles and responsibilities of a Database Administrator (DBA) for Microsoft SQL Server / ASP.NET / IIS-based ERP systems include managing not only the SQL databases but also overseeing the integrated components of the ERP system, including web applications hosted on IIS and built on ASP.NET. Here are the key responsibilities:

 SQL Server Database Management:

o Install, configure, and maintain SQL Server databases, ensuring proper setup of production, development, and test environments.

o Monitor database performance using SQL Server Management Studio (SSMS) and optimize queries, indexing, and storage to improve performance.

o Implement database security measures, including role-based access control, encryption, and auditing to protect sensitive data.

o Backup and restore databases regularly, testing disaster recovery plans to ensure data can be restored with minimal downtime.

o Manage database replication, mirroring, and clustering for high availability and disaster recovery.

o Optimize SQL queries and database structure to ensure ERP applications run efficiently, handling large volumes of transactions.

 ERP Application Integration

o Work closely with ASP.NET developers to ensure that the database layer of the ERP system is optimized for performance and scalability.

o Assist with database schema design and modifications as needed during ERP application updates or new feature development.

o Maintain database-driven processes and workflows that are critical to the ERP system's functionality.

 Application and Web Server Management (IIS):

o Manage and configure IIS servers hosting ASP.NET applications for the ERP system, ensuring availability and performance of the web-based interface.

o Monitor IIS logs and application performance, troubleshooting any web-related issues (e.g., slow loading times, connection problems).

o Apply patches and updates to IIS and ASP.NET components regularly to ensure the security and stability of the web server environment. o Optimize server configurations and load balancing to support high traffic volumes and ensure scalability.

 Performance Tuning and Optimization:

o Monitor and analyse SQL Server performance, identifying bottlenecks in query execution, indexing, or storage.

o Optimize SQL Server performance through query tuning, index maintenance, and partitioning large tables as needed.

o Tune IIS performance by configuring caching, connection limits, and resource allocation to handle ERP system load effectively.

 Security and Compliance:

o Implement security policies for SQL Server, IIS, and ERP systems, ensuring compliance with relevant regulations such as GDPR, HIPAA, or SOX.

o Manage user roles, permissions, and authentication for the ERP database and web applications, ensuring least privilege access.

o Conduct regular security audits and vulnerability assessments on both the database and web application layers.

 Backup and Disaster Recovery:

o Develop and implement comprehensive backup strategies for SQL databases and IIS servers, ensuring regular and reliable backups.

o Test and maintain disaster recovery procedures, ensuring minimal downtime and quick restoration of both the database and the ERP application in case of failure.

o Plan and implement failover strategies, including replication, mirroring, and clustering for SQL Server to ensure high availability.

ERP System Upgrades and Patches:

o Manage and execute database migrations, upgrades, and patches for SQL Server and ERP system components.

o Coordinate ERP system updates with developers and business stakeholders, ensuring minimal disruption to business operations during system changes.

o Test and apply updates to ASP.NET applications, IIS configurations, and SQL Server databases as part of scheduled maintenance.

 Troubleshooting and Support: o Provide technical support for SQL Server databases, IIS servers, and ASP.NET applications running the ERP system.

o Investigate and resolve issues related to database connectivity, slow query execution, or application performance.

o Work with the development and infrastructure teams to resolve any ERP-related issues impacting end-users.

 Documentation and Reporting:

o Maintain detailed documentation of the ERP systems database architecture, server configurations, and application setup.

o Generate reports on database performance, system uptime, security audits, and user activity for management review.

o Document backup strategies, disaster recovery plans, and key troubleshooting procedures for the ERP system.

 Collaboration with Development and IT Teams:

o Collaborate with software developers, IT support, and system administrators to ensure seamless integration and performance of the ERP system.

o Work with developers to design, test, and deploy database changes that support new ERP features or performance improvements.

o Liaise with infrastructure teams to ensure adequate resources (CPU, memory, storage) are allocated for SQL Server and IIS to maintain optimal performance. In this role, the DBA ensures that both the SQL Server databases and the ERP system (including ASP.NET/IIS components) are highly available, secure, and perform efficiently to meet business needs.

MINIMUM QUALIFICATION, EXPERIENCE & SKILLS

 Minimum Qualifications: o Bachelor's degree in Computer Science, Information Technology, or a related field.

In some cases, an Associate degree with relevant certifications (e.g., Oracle, Microsoft SQL Server) may be acceptable.

 Essential Skills:

 Technical Skills:

o Database Management Systems (DBMS): Expertise in relational database systems like Oracle, SQL Server, MySQL, PostgreSQL, or NoSQL databases like Mongo DB, Cassandra.

o SQL: Strong command of Structured Query Language (SQL) for database querying, management, and optimization.

o Performance Tuning: Knowledge of performance tuning, query optimization, and indexing to improve database efficiency.

o Backup and Recovery: Experience in setting up, configuring, and managing database backup and recovery processes.

o Security Management: Knowledge of database security best practices, including user roles, data encryption, and access controls.

o Database Design and Architecture: Understanding of database schema design, normalization, and indexing strategies.

o High Availability & Disaster Recovery (HA/DR): Experience with clustering, replication, and failover techniques for database systems.

 Soft Skills:

o Problem-solving: Ability to identify, diagnose, and resolve database-related issues effectively.

o Attention to Detail: Accuracy in database configuration and management to avoid data corruption or downtime.

o Communication: Good verbal and written communication skills to collaborate with development teams, management, and non-technical stakeholders.

o Time Management: Ability to prioritize tasks and manage multiple projects or database systems simultaneously.

o Adaptability: Willingness to learn new technologies and adapt to changing business needs.

 Certifications (Optional but Preferred):

o MySQL Database Administration Certifications

o PostgreSQL Certified Professional o Oracle Certified Professional (OCP) - Oracle Database o Microsoft Certified: Azure Database Administrator Associate

o Google Professional Data Engineer o AWS Certified Database – Specialty o Mongo DB Certified DBA Associate Having a combination of relevant education, certifications, and hands-on experience is key to excelling as a Database Administrator.