Database Administrator IT

LKQ Corporation; Antioch (TN); On-site; USD 90,000 - 130,000; Full time

Job summary

LKQ Corporation is seeking a Database Administrator to manage the day-to-day administration and maintenance of transactional databases. You will ensure availability, performance, backups, and secure execution of operations in a fast-paced environment.

Responsibilities include installations, upgrades, patching, monitoring, tuning, data storage standards, and documentation. A bachelor's degree and 3+ years of relevant experience are required; PostgreSQL, MS SQL Server and Elasticsearch experience

Qualifications

• Bachelor's degree required.
• 3+ years of related experience with relational databases.
• Agile development experience preferred.
• Ability to analyze data and troubleshoot database issues.

Responsibilities

• Perform installations, upgrades and patching, backups and recovery, performance tuning, security, monitoring and configuration.
• Define standards for data storage, access, security and warehousing.
• Create, maintain and troubleshoot automated database jobs and documentation.
• Monitor connectivity and resolve performance issues; respond to alerts.
• Design approaches to improve database performance, capacity and scalability.

Skills

Analytical thinking

Oral and written communication

Problem solving

Multi-tasking

Education

Bachelor's degree

Tools

PostgreSQL

MS SQL Server

Elasticsearch

Job description

Join the LKQ Family! We're looking for motivated individuals to join our team at LKQ Corporation. With opportunities for growth, competitive benefits, and a supportive work environment, LKQ is the place to be. Apply now and take the first step toward a rewarding career!Responsible for the day-to-day administration and maintenance of transactional databases, ensuring that the database in available, performing properly, and is safely executed.Essential Job DutiesPerform installations, upgrades and patching, backup and recovery, performance tuning, security, monitoring, and configuration.Define standards for physical data storage, maintenance, access, and security administration.Perform backup and recovery using Database Management Systems.Configure database parameters and define data repository requirements, data dictionaries, and warehousing requirements.Create, maintain, and troubleshoot automated database jobs.Troubleshoot and resolve database connectivity and performance issues.Monitor server and database metrics and respond to/resolve alerts.Administer and maintain database access.Design and implement approaches to improve database performance, capacity, and scalability.Confer with appropriate managers regarding problems with and capabilities of databases.Create and maintain database and server documentation.Assume other duties as assigned. Supervisory ResponsibilitiesNot responsible for supervising employees.Minimum RequirementsEducation & ExperienceBachelor's Degree.3+ years of related experience required with relational databases.Preferred Requirements4+ years of relevant experience.Experience with Postgres, MS SQL Server and/or Elasticsearch.Agile development experience.Knowledge/Skills/AbilitiesAbility to add, subtract, multiply, and divide in all units of measure, using whole numbers, common fractions, and decimals. Ability to compute rates, ratios, and percentages and to draw and interpret graphs.Demonstrate use of computer operations (programming, relational databases, and operating systems) and software packages.Regularly uses moderately complex oral and written skills. May train others in functional areas, interact with others, and make presentations to departments or middle management.Problems encountered are routine, somewhat repetitive, and generally solved by following clear directions and procedures.Decisions generally affect own job or assigned functional area.Results are defined; sets personal own goals and determines how to achieve results with few or no guidelines to follow; supervisor/manager provides broad guidance and overall direction.Handle multiple tasks or projects simultaneously with moderate complexity.Essential Physical Demands/Work EnvironmentWork is primarily sedentary: must be able to sit for extended periods of time and use a computer, keyboard, and mouse, frequently.Travel may be required periodically, including overnight stays (contingent on position requirements).Must be able to lift up to 25 pounds.Join us for an exciting career journey with positive, driven individuals.