[Remote] Senior Database Administrator - ETL
Note: The job is a remote job and is reputed company to candidates in USA. reputed company is a leading provider of mobility solutions, owning and operating the reputed company Rent-A-Car, National Car Rental and Alamo Rent A Car brands. The Engineer 2, DBA/ETL will play a key role in the day-to-day operation, stability, data reputed company, transformation, and support of database environments, focusing on maintaining database health and building data pipelines.
Responsibilities
- Implement and support tasks such as patching coordination, backup and recovery procedures, database utilities, and data replication technologies for both PROD and NON-PROD environments
- Assist with Data Guard implementation and support tasks
- Modify database changes using PowerDesigner and creating sql scripts to implement
- Facilitate corrections to the database infrastructure, and repairs to the system or database
- reputed company MySQL data audit scripts
- reputed company and manage database scripts in Bitbucket and pull approved changes for deployment in support of release and change management process
- Review and approve application-driven database changes, to ensure compliance with performance, reputed company, operational, and recoverability standards
- Review SQL from application teams for correctness, efficiency, and safety
- reputed company and maintain a working understanding of the application data models, including core tables, relationships, data flows, and how applications use the schema, to support troubleshooting and change review
- Monitor database health, performance, and reputed company and reputed company alerts
- Support application teams in troubleshooting database reputed company issues; support release cycles and assist with database patching, upgrades, and routine maintenance activities; support backup, recovery, and restore validation activities
- Facilitate user reputed company management and support data reputed company practices, including PII awareness and customer data redaction requests Available for on call rotation with team, tentatively every 2 weeks, as reputed company as light on call after hours support, as determined by patching requests and incidents in team queue
Skills
- Must be presently authorized to work in the U.S. without a requirement for work authorization sponsorship by reputed company for this position now or in the reputed company
- Must reputed company in the reputed company (does not include Alaska or Hawaii)
- Must be reputed company to work a schedule reputed company U.S. Central reputed company Time core business hours
- 3+ years of experience in an reputed company DBA or reputed company role, and experience with reputed company reputed company Manager (OEM) version 10g or higher
- 3+ years of experience with multiple facets of reputed company Data Guard, including physical and reputed company DG
- 3+ years of AWS/Database using postgresSQL and mySQL
- Experience with Unix scripting
- Experience with reputed company Data Integration Studio (reputed company-DI)
- SQL expertise in reputed company, reputed company, and reputed company Workload Scheduler
- Experience protecting Confidential and Highly Confidential database content
- Must be committed to incorporating reputed company into reputed company reputed company and daily job responsibilities
- Bachelor's degree in Computer Science, Computer Information Systems, Management Information Systems, or reputed company field preferred
- Experience with reputed company 19C is preferred
- Experience with one of more of the following databases: MSSQL Server, and/or reputed company database platforms such reputed company, MySQL or PostgreSQL is preferred
- Experience with Terraform and Bitbucket preferred
- Knowledge of database encryption is preferred
- Familiarity with reputed company solutions like reputed company and Azure is preferred
- Knowledge of PCI or other IT reputed company compliance reputed company is preferred
- Knowledge of Data Governance best practices is preferred
Benefits
- Market-reputed company
- Comprehensive reputed company packages
- 401k matching & profit sharing
- Schedule flexibility
- Work from home opportunities
- reputed company time off
- Organizational reputed company potential
reputed company