Copart is seeking an experienced Sr. Database Administrator (DBA) to manage PostgreSQL & MariaDB/MySQL Database environments running on Linux OS platform, including support of DB software and maintaining DB instances and databases. The DBA collaborates with Application Development, DevOps and Infrastructure teams to maintain high uptime and stability of database systems in all production and non-production environments.
Responsibilities will include:
Postgres database administration experience is required. MUST
- Ensure integrity, high availability, and optimum performance of Production database systems by providing technical support and maintenance.
- Proactively monitor and improve database and system performance.
- Oversee database backup strategy and recovery procedures.
- Install periodic software patches and new product releases.
- Implement and oversee database security strategy and best practices.
- Perform troubleshooting and maintenance of multiple global databases.
- Monitor databases regularly to check for problems such as locking issues and failed queries.
- Assist team with troubleshooting critical issues, implementing new ideas and solutions.
- Assist Development teams with application performance load testing, capacity planning, space management and data maintenance activities for database system.
- Handle daily Database deployments, Infrastructure changes and modifications in conjunction with change management team.
- Assist Developers with Database requirements, recommendations & design reviews.
- Coordinate problem resolution with MariaDB support as needed.
Preferred Skills:
- Eight plus years of hands-on experience as a database administrator.
- Five plus years of experience working as administrator on PostgreSQL Database.
- Three years of experience working on MySQL/MariaDB Administration.
- Would be good to have few years of experience working with Microsoft SQL Server and IBM DB2
- Experience working with Postgres HA/DR solutions like pgCluster, Patroni, streming replication.
- Experience working with MariaDB/MySQL HA solutions such as Galera Cluster, master-master replication, multi-master Replication.
- Experience with MariaDB/MySQL, with detailed understanding of internals such as memory management, storage engines like, InnoDB, Aria, MyRocks, etc.,
- Experience with backup solutions such as pg-dump, pgbackuprest, mysqldump, xtrabackup, mariabackup.
- Experience working with HAProxy and/or MariaDB MaxScale as software load balancer for Galera Cluster.
- Expertise in database object design including tables, indexes, views, triggers, stored procedures, functions, events and other user-defined objects.
- Experience in performing database performance optimization tasks with DB, like query tunning involving query rewrite or creation of indexes.
- Experience working with database features and tools such as partitioning, compression, constraints, admin views, event monitors, data encryption, etc.,
- Good experience working with scripting, like SQL Scripting, Shell scripting, Python, etc.,
- Strong presentation and interpersonal skills.
- Able to prioritize and execute tasks and projects in a fast paced and mission critical environment.
- Strong desire to learn new technologies and other database platforms.
Experience working in a team-oriented, collaborative environment
