Search jobs > Lafayette, LA > Database administrator

Database Administrator

Acadian Ambulance
Lafayette, LA, US
Full-time

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).

30+ days ago
Related jobs
Acadian Ambulance
Lafayette, Louisiana

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 ...

Global Data Systems
Lafayette, Louisiana

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. ...

Highmark Health
LA, Working at Home, Louisiana

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...

HR Professional Consulting
LA, US

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...

Confie
Lafayette, Louisiana

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...

CGI
Lafayette, Louisiana

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...

Promoted
Blake Johnson - State Farm Agent
Carencro, Louisiana

Join Our Dynamic Team at State Farm!.Are you ready to embark on a rewarding career where you can unleash your outgoing personality and passion for helping others? Look no further! We are seeking enthusiastic individuals to join our vibrant office culture as Agent Team Members with a State Farm indep...

Promoted
Luxury Bath Technologies
Lafayette, Louisiana

Luxury Bath is one of the fastest growing brands in the acrylic bath remodeling industry.We are looking for quality people to join our winning team.Our goal is simple, to beautify bathrooms across North America by manufacturing and installing attractive, durable, and maintenance-free bathrooms....

Promoted
Pizza Hut
Fort Johnson, LA, United States

Working at Pizza Hut is about making hungry people happy.It's about being independent and having fun, making new friends and earning extra cash.As a Pizza Hut team member, you can be the smiling face that greets and serves the customers or a cook who make things happen in the kitchen.Working with us...

Promoted
Pilot Company
Breaux Bridge, Louisiana

Pay Rates Starting between: $11.Are you passionate about team building, customer service, and meeting new people? Pilot Company offers a dynamic environment where no two days are the same.Team members have the opportunity to build an inclusive atmosphere with their co-workers and make a better day f...