Job Title :
Database Administrator I
Alternate Job Title(s) :
Junior DBA
Division / Department :
Information Technology
Status : Salary - Exempt
Salary - Exempt
Performance Appraisal Type :
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 :
AMOUNT OF TIME
None
Up to 1 / 3
1 / 3 to 2 / 3
Over 2 / 3
Stand
Walk
Talk or hear
Use hands to finger, handle or feel
Climb or balance
Stoop, kneel, crouch or crawl
Reach with hands and arms
Taste or smell
Weight lifting requirements and the amount of time spent lifting on this job :
AMOUNT OF TIME
None
Up to 1 / 3
1 / 3 to 2 / 3
Over 2 / 3
Up to 10 pounds
Up to 25 pounds
Up to 50 pounds
Up to 100 pounds
More than 100 pounds
Vision requirements :
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 :
AMOUNT OF TIME
None
Up to 1 / 3
1 / 3 to 2 / 3
Over 2 / 3
Wet, humid conditions (non-weather)
Work near moving mechanical parts
Work in high, precarious places
Fumes or air borne particles
Toxic or caustic chemicals
Outdoor weather conditions
Extreme cold (non-weather)
Extreme heat (non-weather)
Risk of electrical shock
Work with explosives
Risk of radiation
Vibration
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).
Analytic Data Engineer – Databricks
This role within the 'Data Engineering & Self-Service Products' team involves architecting and engineering analytic data solutions, including designing and developing data marts in Databricks using PySpark or Spark SQL, building interactive Power BI dashboards to visualize KPIs and trends, and creat...
Senior Database Developer
As Senior Database Developer, you will provide technical leadership and management of production and development servers for an Application Development Team that supports Confie’s MGA business (7+- developers, 10+ BA/ QA, and 10+ application systems). Expertise in Database development, advanced TSQL...
Data Engineer
Knowledge and/or experience in working with SQL on Hadoop tools and technologies including HIVE, Impala, Presto, others from an open source perspective and Hortonworks Data Flow (HDF), Dremio, Informatica, Talend, others from a commercial vendor perspective Experience in working with both open-sourc...
Database Administrator
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. The Junior DBA will work closely with developers, system administrators, and project managers to learn ...
Data Quality Engineer (Mid) - U.S. Citizenship Required
CGI Federal is hiring a Data Quality Engineer (Mid) to work with a skilled and motivated team of professionals on a high-visibility Department of Homeland Security (DHS) Cybersecurity and Infrastructure Security Agency (CISA) cyber security program. Support Requirement Engineers to determine qualita...
Networking Engineer- Lafayette, LA
Global Data Systems (GDS) is seeking professional Network Engineers. Networking Engineer . CCNP level certification in one or more specializations to include Enterprise routing / switching, Security , and Data Center or equivalent field experience. ...
Customs and Border Protection (CBP) Border Patrol Agent
Border Patrol (USBP) offers those interested in a career in law enforcement an exceptional opportunity to work with an elite team of highly trained professionals whose camaraderie, pride, and purpose are hallmarks of their daily mission protecting America.If you are looking for an exciting and rewar...
Remote Product Tester
Product Testers are wanted to work from home nationwide in the US to fulfill upcoming contracts with national and international companies.We guarantee 15-25 hours per week with an hourly pay of between $25/hr.There is no payment required in order to apply or to work as an In-Home Usage Tester.You do...
Border Patrol Agent
NATIONWIDE OPENINGS INCLUDING NORTHERN BORDER STATIONS – APPLY TODAY!.CURRENT OR PRIOR LAW ENFORCEMENT.Applicants with current or prior law enforcement experience can enter.EARN UP TO $30,000 IN RECRUITMENT INCENTIVES.Newly appointed Border Patrol Agents will be offered a $20,000 recruitment incenti...
Customer Service Rep(03012) - 8202 Maurice Ave
As the leaves begin to blow, let us help you earn some extra dough!.RPM Pizza has been one of the largest Domino’s franchises in the United States for over 40 years, is family-owned and operates over 175+ stores in five states, including Indiana, Michigan, Mississippi, Alabama, and Louisiana.W...