Responsible for the day-to-day administration and maintenance of transactional databases, ensuring that databases are available, performing properly, and secure. Design database architecture and processes, participate in database strategy and capacity planning.

Essential Job Duties :

- Perform installations, upgrades and patching, backup and recovery, performance tuning, security, monitoring, and configuration.

- Define standards for physical data storage, maintenance, access, and security administration.

- Configure database parameters and define data repository requirements, data dictionaries, and warehousing requirements.

- Design and implement approaches to improve database performance, capacity, and scalability.

- Design, develop, and implement the Extract, Transform, Load (ETL) processes using SQL Server Integration Services (SSIS). Create packages to import and export data from various sources and destinations.

- Monitor and optimize the performance of SSIS and SQL Server Reporting Services (SSRS) jobs and troubleshoot issues. Develop and maintain documentation of ETL processes, data flows, and data lineage.

- Identify and troubleshoot performance issues and implement optimization strategies to ensure optimal database performance.

- Develop and optimize complex Transact SQL (T-SQL) queries and stored procedures to extract, transform, and load data from multiple sources into SQL Server databases, while ensuring high performance, data accuracy, and data integrity.

- Consult with Solutions Architects, DBAs, Developers, Business Analysts, and other stakeholders as required to ensure databases meet business needs.

- Assume other duties as assigned.

Basic Qualifications :

Education & Experience (Level of education AND years of experience are required) :

- Bachelors degree or commensurate experience

- 5+ years of related experience.

Preferred Qualifications :

- Experience in working in Agile development environments, following Agile methodologies and best practices, and using tools such as Jira for project management and collaboration.

- Knowledgeable in SQL Server 2012, 2014, 2017, 2019+

- Knowledgeable in Windows Server 2012, 2016, 2019+

- Knowledgeable in SSIS, SSAS, SSRS, as well as the SQL Server Database Engine, and SQL Server Agent.

- Advanced Microsoft Office skills (specifically Word, Excel, and Visio).

- Experience with Oracle Database, Elasticsearch, Kafka, PostgreSQL a plus.

Knowledge/Skills/Abilities (Includes needed certifications, systems knowledge, job skills, characteristics, competencies, etc.) :

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

- Ability to utilize complex computer operations (intermediate/advance programming, relational databases, and operating systems) and advanced features of software packages.

- Frequently communicates complex information and interacts with management.

- Can present, resolve, and address delicate situations. Can motivate and persuade others.

- Decisions impact the management and operations within a department.

- May contribute to business and operational decisions that affect the department.

- Problems are varied and complex, requiring analysis or interpretation of the situation.

- Problems are solved using knowledge and skills, general precedents, and practices.

- Provides and sets goals and priorities for functional area.

- May make recommendations for department policies, practices, and programs.

- Makes decisions for and/or resolves problems for others.

- Ability to handle multiple projects simultaneously including task delegation, project oversight, and resource allocation.

Essential Physical Demands/Work Environment (i.e. lifting demands, travel requirements, etc.) :

- Work is primarily sedentary : must be able to sit for extended periods of time and use a computer, keyboard, and mouse, frequently. The employee must occasionally lift and/or move up to 25 pounds. Travel may be required periodically, including overnight stays (contingent on position requirements).

- Team Member : You have been assigned to the job title shown above. The duties shown are the generally accepted duties at LKQ Corporation for this role. Your duties may vary depending on your specific department /location, and your supervisor will discuss these variances with you. By your signature below, you acknowledge that you have discussed this role with your supervisor and understand your assigned duties