Job Description

Database Administrator I

Junior DBA

Information Technology

Salary - Exempt

Professional

JOB SUMMARY: The Database Administrator I is responsible for assisting in the creation, optimization, and management of database systems that support the organization's applications and end-users. This role focuses on ensuring the security, availability, and performance of database services under the guidance of senior team members. The Junior DBA will work closely with developers, system administrators, and project managers to learn and support scalable database solutions, perform upgrades, implement backups, and help ensure compliance with data management standards.

REPORTS TO: IT Director

SUPERVISOR STATUS: This position does not have direct supervisory responsibilities, but is expected to serve as a mentor and technical leader within the database team.

EQUIPMENT: High-performance workstation, access to enterprise-grade database management tools.

DUTIES AND RESPONSIBILITIES

This job description is a general overview of the essential duties and requirements common to positions of this type and may be subject to change. Reasonable accommodations may be made to enable individuals with disabilities to perform essential functions.

Database Design and Maintenance

• Assist in designing and implementing database structures that support high availability and scalability.

• Help maintain database integrity, backup, recovery, and failover procedures.

• Install and maintain the performance of database servers.

• Diagnose and troubleshoot basic database errors.

• Assist with query tuning and optimization.

• Support performance tuning of database systems.

• Help create automation for repeating database tasks.

Security and Compliance

• Assist in implementing and maintaining database security strategies that comply with organizational policies and regulatory requirements.

• Support regular audits of database access and usage to ensure security compliance.

• Help manage database access and apply data encryption and data security standards.

Collaboration and Support

• Work closely with application development teams to integrate databases with business applications.

• Provide expert advice and support during database-related deployments and troubleshooting.

Documentation and Reporting

• Maintain detailed documentation for database architectures, configurations, and procedures.

• Generate regular reports on database health, performance metrics, and improvement plans.

• Ad-hoc reporting

Other Responsibilities

• Other Operations duties as assigned.

QUALIFICATIONS

Educational Background

• Bachelor's degree in Computer Science, MIS, Informatics, or a related field.

Experience

• 1+ years of experience in database administration or related field.

• Some experience with SQL database technologies is preferred.

Technical Proficiency

• Basic understanding of database design and architecture.

• Experience or coursework in database development using RDBMS or NoSQL data stores.

• Basic understanding of database structure, theories, principles, and practices.

• Some experience with database tuning and troubleshooting is a plus.

• Familiarity with data backup, recovery, security, and integrity.

• Basic understanding of SQL and Version Control Systems, such as Git.

Soft Skills and Other Requirements

• Excellent problem-solving and analytical skills.

• Strong communication and interpersonal skills.

• A proactive approach to learning and improvement.

• Ability to work under guidance and follow instructions.

• Commitment to detail and accuracy.

• Ability to meet deadlines and prioritize tasks effectively.

• Willingness to participate in on-call rotations and provide out-of-hours support as needed.

• Professional representation of the department and a willingness to continuously learn new skills.

TRAINING REQUIREMENTS

• Video Training: Brent Ozar

• How to Think Like the SQL Server Engine

• How I Use the First Responder Kit

• Fundamentals of Index Tuning

• Fundamentals of Query Tuning

• Fundamentals of Parameter Sniffing

• Fundamentals of TempDB

• Mastering Index Tuning

• Mastering Query Tuning

• Mastering Server Tuning

• Book

• SQL Server 2022 Administration Inside Out, and associated quizzes

TRAINING OPPORTUNITIES

Technical Skills Development

• Regular training on advanced database management systems and updates.

• Workshops on emerging data storage technologies and optimization techniques.

Security Best Practices

• Ongoing training in data security, risk management, and compliance with industry-specific regulations.

Leadership Development

• Leadership and management training tailored for senior technical staff.

• Courses on strategic decision-making and project management.

Personal Development

• Opportunities to attend industry-leading conferences and workshops.

• Support for certification in specialized areas such as data security or database management systems.

PHYSICAL DEMANDS

Physical activities and the amount of time spent performing each while on this job:

Weight lifting requirements and the amount of time spent lifting on this job:

Vision requirements:

X

Close Vision (clear vision at 20 inches or less)

Distance Vision (Clear vision at 20 feet or more.)

Color Vision (Able to identify and distinguish colors.)

Peripheral Vision (Able to observe areas that can be seen up and down or to the left and right while eyes are fixed on a given point).

Depth Perception (Able to judge distances and spatial relationships.)

Focusing (Able to adjust the eye to bring an object into sharp focus.)

WORK ENVIRONMENT

Specific situations that lead to environmental conditions can include: hazardous materials, electrical emergencies, vehicular accidents, outdoor emergency settings, hurricanes, tornadoes, industrial accidents, conditions affecting driving, settings where heavy equipment such as extrication tools are in use, etc.

Exposure to environmental conditions and the amount of time exposed to each on this job:

Noise level associated with this job:

_X__ Moderate Noise (Ex: business office with typewriters and/or computer printers, light traffic).

___ Loud Noise (Ex: metal can manufacturing, large earth-moving equipment).

___ Very Loud Noise (Ex: jackhammer work, front row at rock concert).

Job Tags

Similar Jobs