Software Engineer II

The Software Engineer (AWS) is responsible for recommending, implementing and supporting current and new SQL Server DB and AWS technologies, as required, to support the technical capabilities of Cox Automotive Inc (CAI). To be successful in this role one must be able to work effectively in a fluid, fast-paced environment. This role requires good communication skills, both with team members and business contacts. In addition, the successful Software Engineer must be able to work with minimal supervision on multiple concurrent projects.
Responsibilities:
• Diagnose and Resolve problems around database performance, DataLake performance, capacity, replication.
• Proactively monitor AWS environments or databases for errors and respond quickly and effectively to troubleshoot and resolve DB on-going issues on all CAI environments DEV/QA/PROD.
• Coordinate and schedule DB downtimes to perform DB maintenance procedures. i.e. DB patching, upgrades, etc.
• Design and Implement Backup and Recovery strategies using technologies used at CAI: Backup/Recovery tools for DataLake or other AWS storage.
• Manage/Monitor/Utilize Cloud Technologies: Athena, Lambda, MySQL, AWS RDS, S3
• Assist with ETL solutions for Snowflake, Redshift or DMS.
• Perform advanced database administration activities including but not limited to: DB Performance Tuning, Backup and recovery and Disaster Recovery solutions.
• Communicate effectively with other CAI groups gathering requirements for developing, tuning or supporting existing applications.
• Analyze existing systems and make recommendations on which technology best suits the business requirement for high availability, disaster recovery or high performance, on prem or in the cloud.
• Work independently or with other CAI teams to design or participate in functional/performance tests.
• Create/update CAI's database documentation about standard processes, AWS/DataLake technology features, or production issue troubleshooting.
• Stay current with changes in the technical area of expertise.
• Work with development teams to deploy code in production when needed.
• Participate in on-call rotations.
Qualifications:
• Bachelor's degree in Computer Science or related field
• 2+ years' experience in AWS Administration, Microsoft Windows/ SQL Server Technologies, data migration development.
• Experience working on 24x7 environments oriented towards a zero downtime target.
• Working knowledge or previous administration of SQL 2016-SQL 2022 and Windows Server 2016+ preferred.
• Experience with ETL in AWS.
• Ability to work with minimal direction, in a team environment.
• Performance tuning for AWS/DataLake systems.
• Some Experience with SQL in virtual, physical and cloud-based environments.
• Experience with Athena and data modeling for cloud technologies.
• Proven ability to quickly learn and implement new technologies.
• Experience with Administration, Security/Identity Management and Terraforms in AWS.
• Experience with SentryOne, a plus.
• Ability to code Powershell commands and maintain code in GitHub, a plus.
• Some Experience with Metabase and Collibra, a plus.
About Cox Automotive
At Cox Automotive, people of every background are driven by their passion for mobility, innovation and community. We transform the way the world buys, sells, owns and uses cars, accelerating the industry with global powerhouse brands like Autotrader, Kelley Blue Book, Manheim and more. What's more, we do it all with an emphasis on employee growth and happiness. Drive your future forward and join Cox Automotive today!
About Cox
Cox empowers employees to build a better future and has been doing so for over 120 years. With exciting investments and innovations across transportation, communications, cleantech and healthcare, our family of businesses - which includes Cox Automotive and Cox Communications - is forging a better future for us all. Ready to make your mark? Join us today!
Benefits of working at Cox may include health care insurance (medical, dental, vision), retirement planning (401(k)), and paid days off (sick leave, parental leave, flexible vacation/wellness days, and/or PTO). For more details on what benefits you may be offered, visit our benefits page .
Cox is an Equal Employment Opportunity employer - All qualified applicants/employees will receive consideration for employment without regard to that individual's age, race, color, religion or creed, national origin or ancestry, sex (including pregnancy), sexual orientation, gender, gender identity, physical or mental disability, veteran status, genetic information, ethnicity, citizenship, or any other characteristic protected by law. Cox provides reasonable accommodations when requested by a qualified applicant or employee with disability, unless such accommodations would cause an undue hardship.
Statement to ALL Third-Party Agencies and Similar Organizations: Cox accepts resumes only from agencies with which we formally engage their services. Please do not forward resumes to our applicant tracking system, Cox employees, Cox hiring manager, or send to any Cox facility. Cox is not responsible for any fees or charges associated with unsolicited resumes.