Job Description
The Junior Database Administrator (Jr. DBA) is part of the team responsible for the operational support of business-critical database systems. The Jr. DBA, under the supervision of the Senior Database Administrator (Sr. DBA), performs tasks needed to administer Microsoft SQL Server. The Jr. DBA demonstrates strong communication skills, the ability to build functional relationships with team members and users, and excellent problem-solving and troubleshooting skills.
Duties and Responsibilities
- Monitor database server health and performance
- Install, patch, configure, and maintain SQL Server
- Analyze and resolve common issues/faults in SQL Server and related infrastructure, providing issue resolution end-to-end
- Query and understand data from SQL Server system dynamic management objects
- Write T-SQL queries and scripts to investigate issues and complete assigned tasks
- Maintain a high degree of security by implementing changes to access rights in SQL Server and Windows Server as directed by Sr. DBA
- Work with other IT teams to identify and understand technical needs and solutions
- Work with other IT teams to analyze and resolve issues
- Review relational database designs and T-SQL code for application development teams
- Help upgrade SQL Server to newer versions
- Help migrate databases between servers and platforms
- Research and recommend improvements to database system performance, integrity, and security, and compliance
- Follow database administration team standards and procedures
- Provide 24x7 on-call support on a rotating basis
- Flexible to work off-hours, including weekends and holidays, as required
- Perform other tasks and functions as required or assigned by Sr. DBA
Required Skills & Experience
- A minimum of 2 years of experience administering Microsoft SQL Server in production environments
- A minimum of 2 years of experience writing T-SQL
- A minimum of 1 year of experience working with relational databases concepts
- SQL Server administration experience including:
o SQL Server Management Studio (SSMS)
o SQL Agent
o Database auditing and control
o Database security
o Database design and code development
o Troubleshooting and resolving faults in SQL Server and related infrastructure
o SQL Server Reporting Services (SSRS)
- Knowledge of Microsoft Windows Server
- Knowledge of relational database concepts (e.g., tables, columns, rows, primary keys, foreign keys, indexes, normalization).
- Knowledge of security and permissions in SQL Server
- Proven troubleshooting skills
- Strong analysis and critical thinking skills
- Strong documentation skills
Nice to Have Skills & Experience
- Bachelor's degree in computer science, information science, information systems management, or equivalent
- Administering databases for in-house-built applications
- Knowledge of HIPAA compliance requirements as it related to database administration
- Microsoft Azure database administration experience
Benefit packages for this role will start on the 31st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.