Senior AWS Database Administrator

Global Business Ser. 4u; Peoria (IL); On-site; USD 110,000 - 140,000; Full time

Job summary

Global Business Ser. 4u seeks a Senior AWS Database Administrator in Peoria, IL to manage and optimize production databases, systems and data pipelines across Snowflake environments. The role emphasizes AWS/Linux server administration, cost control, and data integrity, with collaboration with Data Managers and Product Owners.

Onsite role with a 12-month duration and cross-functional teamwork. The incumbent will lead database design and auditing, and contribute to IT roadmaps while thriving in a

Qualifications

• Bachelor’s degree in Information Technology, Computer Science/Technology or relevant field.
• 9+ years of relevant work experience as Database Administrator.
• Proficient knowledge of AWS Server Administration.

Responsibilities

• Provide expert support for production application databases with respect to availability, reliability, and integrity.
• Responsible for AWS and Linux Server Administration.
• Responsible for database/schema creation, role creation/maintenance and security.
• Monitor and manage database cost through usage reviews, query optimization and provide cost reduction recommendations.
• Manage database replication between different Snowflake environments.
• Monitor and troubleshoot database issues, configure system automation alerts, and implement corrective actions as needed.
• Escalate and resolve database issues that the team encounters that may prohibit their success.
• Work as part of a team to design and develop code, scripts, and data pipelines that leverage structured and unstructured data integrated from multiple sources.
• Provide technical leadership to Application engineers in database capabilities and features, build efficient queries, database design, and the use of database utilities.
• Performs audit support by providing documentation for data use approvals from data sources
• Participate in the development and alignment of the IT roadmaps.
• Ability to work in a fast paced, complex, and dynamic environment.

Skills

SQL

Python

Snowflake

Apache Airflow

Linux

AWS

Azure DevOps

GitHub

ETL

Education

Bachelor's degree in Information Technology/Computer Science/Technology

Job description

Title: Senior AWS Database Administrator - (18950-1)

Location: Peoria, IL

Duration: 12 Months

Onsite Role w2 candidates only

Position’s Contributions To Work Group

The Digital Analytics Database Administrator will have responsibility to support multiple Aftermarket part Digital Products. This responsibility includes managing servers and data repositories, resolving data conflicts, optimizing cost efficiencies, and maintaining the highest quality. Day to day tasks will vary between attending meetings, investigating customer inquiries, server maintenance, role creation and maintenance to working with team members to investigate and solve technical product issues. Typical customers include internal employees within multiple business products. In addition, this person may have direct relationships with Data Managers, Product Managers and Owners, and, in some cases, Sr Managers.

Typical Task Breakdown

Typical Job Responsibilities include:

• Provide expert support for production application databases with respect to availability, reliability, and integrity.


• Responsible for AWS and Linux Server Administration.


• Responsible for database/schema creation, role creation/maintenance and security.


• Monitor and manage database cost through usage reviews, query optimization and provide cost reduction recommendations.


• Manage database replication between different snowflake environments.


• Monitor and troubleshoot database issues, configure system automation alerts, and implement corrective actions as needed.


• Escalate and resolve database issues that the team encounters that may prohibit their success.


• Work as part of a team to design and develop code, scripts, and data pipelines that leverage structured and unstructured data integrated from multiple sources.


• Provide technical leadership to Application engineers in database capabilities and features, build efficient queries, database design, and the use of database utilities.


• Performs audit support by providing documentation for data use approvals from data sources


• Participate in the development and alignment of the IT roadmaps.


• Ability to work in a fast paced, complex, and dynamic environment.

Interaction With Team

Typical customers include internal employees within multiple business products. In addition, this person may have direct relationships with Data Managers, Product Managers and Owners, and, in some cases, Sr Managers.

Work Environment

• Mostly remote, working with a worldwide team. Team meets in either US or Geneva about once a quarter.

Education & Experience Required

• Bachelor’s degree in Information Technology, Computer Science/Technology or relevant field.

Technical Skills

Required

9+ years of relevant work experience as Database Administrator

• Excellent knowledge of SQL, Python, Snowflake, Apache Airflow, Linux, Amazon Web Services and Cloud applications


• Proficient knowledge of AWS Server Administration


• Strong knowledge of Azure DevOps and Github experience


• Understanding of ETL processes and tools

Desired

• Minimum 5+ years of experience of database administration, performance tuning, and design


• Working knowledge of one or more programming languages (Python preferred)


• Create innovative solutions to solve technical problems.


• Knowledge of Aftermarket data.

Soft Skills

• Excellent oral, written and interpersonal skills with the ability to influence and work effectively with diverse groups of peers and business partners.


• Self-starter and driven while working well in team environment.


• Detail oriented with a demonstrated ability to work on multiple tasks simultaneously with strong organizational and prioritization skills.