Current Statistics
1,753,405 Total Jobs 373,820 Jobs Today 17,913 Cities 222,695 Job Seekers 146,729 Resumes |
|
|
|
|
|
|
Database Sr Administrator - Ellenwood Georgia
Company: Cox Automotive Location: Ellenwood, Georgia
Posted On: 05/03/2024
Responsibilities - Design, Build, and Operate large, complex Datalakes that meet functional / non-functional business requirements.
- Design, Build and Operate the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using Upsolver, AWS Glue, and AWS Athena.
- Interact effectively with other CAI groups gathering requirements for new initiatives, coordinate tasks across delivery teams and solve customer support requests.
- Facilitate the design and deployment of Datalake solutions by developing templates, playbooks, and managing infrastructure as code.
- Optimize the use of various data types considering storage (S3) benefits, processing, and retrieval from near real-time events, and unstructured data.
- Diagnose and Resolve Upsolver data ingestion workflows.
- Proactively monitor SDL AWS environments for errors, responding and troubleshooting issues on all CAI environments Non-prod/Prod on a timely manner.
- Coordinate and schedule downtimes to perform maintenance procedures.
- Use AWS best practices to keep SDL infrastructure secure.
- Leverage AWS services to efficiently monitor services (CloudWatch) or process data: Athena, Glue , Lambda, AWS RDS, S3.
- Leverage IAM roles to manage access to SDL resources.
- Manage access to Metabase, Create/Maintain Metabase Dashboards, and queries.
- Perform occasional database administration activities involving the AWS RDS instances supporting Metabase.
- Analyze existing infrastructure and make recommendations for improvements.
- Create/update CAI's database documentation about standard processes, and AWS/DataLake technology/infrastructure features.
- 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:
|
|
|
|
|
|
|