Job Description
Company: H-E-B
Location: Austin, TX
Workplace Type: On-site
Employment Type: Full-time
Responsibilities
- H-E-B is a leading innovator in technology, and our Digital Technology Partners collaborate to design, construct, implement, and support technology solutions.
- As a Staff Database Administrator, you’ll lead in the team effort to administer, design, develop, implement, and maintain database applications to accommodate complex user needs.
- Once you’re eligible, you’ll become an Owner in the company, so we’re looking for commitment, hard work, and focus on quality and Customer service.
- “Partner-owned” means our most important resources—People—drive the innovation, growth, and success that makes H-E-B The Greatest Omnichannel Retailing Company.
- Do You Have a HEART FOR PEOPLE… willingness and ability to supervise others?
- HEAD FOR BUSINESS… skills to assist in administering, designing, developing, implementing, and maintaining database applications?
- PASSION FOR RESULTS… possesses a relentless drive for excellence that leads to continuous improvement in how we administer our databases and related IT systems with a strong focus on delivering cost efficiencies and a drive to recommend database management and productivity software?
- We Are Looking For A related degree or comparable work experience and formal training / certification.
- 7+ years of rich work experience.
- Strong work experience in PostgreSQL database administration.
- Work experience in Oracle database administration is preferred.
- Work experience with GCP BigQuery administration is preferred.
- 2+ years of experience using Google Cloud Platform (GCP) in general and with managing databases in particular.
- 2+ years of Java (Spring) programming experience is preferred.
- Strong Linux operating system internals knowledge.
- Work experience in migrating databases from one RDBMS to another, such as Oracle to PostgreSQL, and to public clouds like GCP.
- What is the work?
- Administration / Design & Development Consults / collaborates with multiple teams in database administration / design / development to accommodate business and user needs of medium to large scope and complexity.
Performs Database Administration
- (DBA) / design / development; manage physical structures of databases, improve databases and database servers compute resource optimization, perform analysis and resolution of complex problems, improve database security, control database access.
- Implements Backup and Recovery and High Availability for databases.
- Creates development, test, and production database environments with configuration management and change control procedures.
- Takes ownership of database platforms and related technologies and independently supports and maintains multiple databases with advanced features.
- Sets standards / creates strategies, drive efficiencies in space utilization, database objects management ( High Availability for databases.
- Creates development, test, and production database environments with configuration management and change control procedures.
- Takes ownership of database platforms and related technologies and independently supports and maintains multiple databases with advanced features.
- Sets standards / creates strategies, drive efficiencies in space utilization, database objects management (indexes, tables etc.) and overall throughput.
- Works with cross-functional team members belonging to IT Infrastructure, Information Security, Network, Storage etc. in articulating and convincing technical requirements.
- Participates in on-call rotation and provides after-hours support to production databases (not frequently, only when required).
- Prioritizes resolving database and database server related security vulnerability findings in a timely fashion.
- Monitors database alert notifications, transaction volumes, server and database space utilization, backup jobs and take timely/preventive action before production issues are caused.
- Supports application development teams in their production deployments.
- Takes responsibility and ownership for tasks and projects assigned and delegated by the team manager (or) director.
- Independently starts and completes large size DBA projects.
- Takes primary ownership of multiple key systems and processes managed by the DBA team.
- Works with a sense of urgency and completes assigned tasks and projects within the given due dates.
- Assists with root cause analysis (RCA) of production database issues and work towards long-term solutions.
- Takes a lead role in developing best practices standards for data access and database administration (DBA) and create rich documentation of technical procedures in DBA.
- Performs version control (software configuration management) of DBA programs/scripts using source control systems such as Gitlab.com, Atlassian Bitbucket server etc..
- Follows IT change management processes set in H-E-B.
- Serves as expert to assist with fine-tuning application programs / processes.
- Provides support for application development teams in problem determination, especially on database issues.
- Evaluates / recommends DB management and productivity software.
- Performs database replication between on-premises systems and between on-premises systems and public clouds.
- Performs migration of database systems from on-premises to public clouds, with a focus on GCP for cloud initiatives.
- Specific PostgreSQL Responsibilities Expert knowledge and proficiency in all aspects of PostgreSQL database administration including installation, architecture, internals, SQL tuning, backup and recovery and all other related administrative tasks.
- Designs, creates, and administers PostgreSQL database clusters configured with transparent data encryption and replication for high availability.
- Securely sets up and manages database accounts.
- Installs, uses, and researches PostgreSQL database extensions.
- Coaches and teaches how to Identify and tune poorly performing SQL statements.
- Maintains and creates database monitoring and automation scripts written in Python or BASH.
- Training Educates other team members and application developers on database best practices, SQL tuning, and platform optimization configurations.
- Provides mentorship and training to other team members across the globe.
- Creates succession planning in the team for supporting key systems and processes so that there is no single point of failure.
- Presents and represents the team in company-wide IT meetings and external industry conferences.
- Can you…
- Function in a fast-paced, retail, office environment.
- Travel by car or plane with overnight stays.
- Regularly lift up to 20 lbs.
- Work extended hours and / or rotating schedules.