The SQL Server Database Administrator (DBA) is responsible for performing all aspects of Database Administration on Microsoft’s SQL Server database technologies in a Windows environment.
This may include system administration, troubleshooting, analysis, testing, research, training, general problem solving, technical support and testing/deployment of new systems. Designing and implementing back-up, recovery, archiving, conversion strategies, and performance tuning. The SQL Server Database Administrator is responsible to define and develop database standards, policies and procedures and optimizes database by providing solutions utilizing new database features and functionality along with varying levels of project management, as assigned.
Job Responsibilities:
- Partner with other Database Administrators in support of database services to ensure the highest standards of availability, resilience, integrity, security and performance required by our business systems.
- Maintain multiple Microsoft SQL Server environments.
- Set up new databases in Microsoft database and perform database maintenance.
- Partner with other Database Administrators during installation, configuration, software upgrade and updates to maintain client environments.
- Partner with other Database Administrators in development, setting up and managing automated backups.
- Set up and manage scheduled SQL Server Agent jobs.
- Performance tuning and database optimization.
- Set up centralized monitoring, executing scripts, patches, backup reports, status reports and performance monitoring.
- Perform appropriate Change Management duties to comply with IT policies and procedures.
- Perform appropriate Incident/Problem Management duties to comply with IT policies and procedures.
- Report progress on a weekly basis of status on all assigned work tasks in a written report.
- Ability to work during non-business hours including weekends and holidays, as needed.
Minimum Qualifications:
- Five years’ experience as a Database Administrator on SQL Server.
- Five years’ experience with SQL on SQL Server.
- Three years’ experience with SQL Server Management Studio (SSMS).
- Two years’ experience with SQL Server 2016 or higher.
- Two years’ experience with Windows Server 2016 or higher.
- Two years’ experience with C#, PowerShell, Python and/or .Net scripting
Preferred Qualifications:
- Experience with SQL Server Integration Services (SSIS).
- Microsoft Certifications a plus
- Experience with MySQL and/or Teradata.
- Experience with Excel, Outlook and Word.
- Experience with Local, State or Federal government.
Personal Qualities:
Be innovative, energetic, energizing, flexible and eager to learn. Excellent work ethic, attention to detail, ability to work in a highly collaborative, collegial, multidisciplinary fast paced team environment. Excellent analytical skills with the ability to manage multiple priorities and requests. Excellent communication and interpersonal skills. Ability to work independently and meet requested deadlines promptly.
- Experience as a Database Administrator on SQL Server.
- Experience with SQL on SQL Server.
- Experience with SQL Server Management Studio (SSMS).
- Experience with SQL Server 2016 or higher.
- Experience with Windows Server 2016 or higher.
- Experience with C#, PowerShell, Python and/or .NET scripting.
- Experience with Excel, Outlook and Word.
- Experience with SQL Server Integration Services (SSIS).
- Experience with Local, State or Federal government