WHAT IS A SQL SERVER DATABASE ADMINISTRATOR ?
The SQL Server Database Administrator manages Microsoft SQL Server and Great Plains, optimizing system performance and ensuring compliance with corporate policies. They are responsible for developing, maintaining, and supporting system queries, reports, and security features. The role requires over four years of MS SQL Server administration experience, strong communication skills, and flexibility to address IT needs as they arise.
Need-to-Know Overview of a SQL Server Database Administrator
1. SQL Server Database Administrator Duties and Responsibilities
- Support and maintain the Microsoft SQL and Microsoft Dynamics GP environment, including Production and UAT including installation, configuration, backup, recovery, upgrades, schema changes, etc.
- Work with MS great plains consultant to manage MS great plains.
- Work with various teams for performance tuning and optimization, query optimization, index tuning, caching, buffer tuning, etc
- Serve as the MS SQL and great plains subject matter expert for daily support initiatives
- Develop, implement and maintain queries, dashboards and reports
- Plan manage and support required application upgrades within the financial system
- Administer security roles and tasks in compliance with corporate policies
- Proactively monitors application health
- Document and update procedures and processes experience a must
- Develop and maintain database backup & recovery, Disaster Recovery and Business Continuity procedures
- Expected to provide help-desk end-user support of Microsoft SQL and Microsoft Dynamics-GP for back-office users
- Assist in solving production problems promptly, including off-hours and weekend support when necessary
2. SQL Server Database Administrator Skills, Experience, Qualifications
- 4+ years MS SQL Server Administration experience supporting SQL environment
- Working knowledge of accounting principles and financial aspects would be a plus
- MS SQL Server Reporting Services (SSRS) development experience
- Management Reporter experience is a plus
- Microsoft SQL Server Database administration, maintenance, upgrades, backup and recovery
- Microsoft Office applications, especially Excel
- Ability to communicate ideas in both technical and user-friendly language
- Self-motivated and able to work in a team environment
- Willing and flexible to work in all areas of Information Technology as needed
- Experience with database performance tuning and optimization, using native monitoring and troubleshooting tools
- Experience with backup, restore and recovery models
Career Overview FAQs
What does a career overview explain?
A career overview explains what a profession involves, including the purpose of the role, the type of work professionals typically perform, and how the position contributes to organizations or industries. It helps readers understand the field before exploring more detailed resources such as job responsibilities, required skills, and career requirements.
What do professionals in this career typically do?
Professionals in this field usually manage projects or tasks, collaborate with teams, analyze information, and solve problems related to business or organizational objectives. Daily responsibilities may vary depending on experience level, specialization, and the organization where the role is performed.
What skills are commonly required for this career?
Most careers require a combination of technical skills related to the profession and professional skills such as communication, teamwork, problem solving, and analytical thinking. These abilities help professionals perform effectively in different work environments and across various organizational roles.
What is the typical career path in this field?
Many professionals begin in entry-level roles where they gain foundational knowledge and practical experience. Over time, they may progress to mid-level or senior positions that involve greater responsibility, specialization, or leadership within their organization or industry.
How can someone start a career in this field?
Starting a career in this field typically involves building relevant knowledge, gaining practical experience, and developing the key skills associated with the profession. Preparing strong application materials, such as a targeted resume and cover letter, can also help candidates pursue entry-level opportunities successfully.
Editorial Process
Lamwork content is developed through structured review of publicly available job postings and documented hiring trends.
Editorial operations are managed by Thanh Huyen, Managing Editor, with research direction and final oversight by Lam Nguyen, Founder & Editorial Lead. Content is periodically reviewed to reflect observable labor market changes.