Enterprise Database Administrator - Tulsa, OK bei BlackHawk Industrial
BlackHawk Industrial · Tulsa, Vereinigte Staaten Von Amerika · Onsite
- Senior
- Optionales Büro in Tulsa
WHO ARE WE: BlackHawk Industrial provides you the highest quality industrial products and equipment, offering manufacturing services while creating innovative engineered supply solutions. We truly believe in the importance of the local relationships with the customers we service. Our employees have fun every day exceeding the expectations of our customers, suppliers, and shareholders. We distinguish ourselves as the #1 choice of industrial manufacturers who are in need of Technical Service and Production Savings.
We are BIG ENOUGH TO SERVE, and SMALL ENOUGH TO CARE.
***This position is located onsite in Tulsa, OK***
SUMMARY: The Database Administrator (DBA) is responsible for the performance, integrity, and security of BlackHawk Industrial Inc.'s databases. This role involves managing database structures, monitoring system performance, planning for future growth, and ensuring data availability and security. The DBA will work closely with other IT team members and business units to support and optimize the company's database systems.
ESSENTIAL DUTIES AND RESPONSIBILITIES
- **Database Management:**
- Administer and support Epicor Prophet 21 solution, SQL databases, and data infrastructure onsite and across cloud-hosted environments.
- Install, configure, and upgrade database server software and related products.
- Perform database tuning and performance monitoring.
- Plan growth and changes (capacity planning).
- **Data Integrity and Security:**
- Coordinate with the Infrastructure Manager to ensure data integrity and availability by implementing appropriate security measures.
- Work with the Infrastructure Manager to develop, manage, and test backup and recovery plans.
- Collaborate with the Infrastructure Manager to ensure that storage, archiving, backup, and recovery procedures are functioning correctly.
- **Support and Maintenance:**
- Perform full DBA functions including database provisioning and changes, patching, upgrades, backups, restores, replication, high availability, and disaster recovery.
- Provide 24/7 support for critical production systems.
- Perform regular maintenance, including applying patches and updates.
- Troubleshoot and resolve database issues.
- Coordinate with vendors for support and maintenance of database systems.
- **Collaboration and Documentation:**
- Collaborate with application teams on development, test, and production support for software implementations, migrations, and data initiatives.
- Document database configurations, procedures, and policies.
- Provide training and support to users on database-related topics.
- **Performance Monitoring and Optimization:**
- Monitor database performance and implement changes to optimize efficiency.
- Analyze, design, and implement changes to improve database performance.
- Develop and implement strategies for database tuning and performance enhancements.
- Conduct performance troubleshooting and tuning to resolve issues and improve slow-running queries.
- Develop automated maintenance plans, jobs, alerts, and monitoring of the data environment.
- **Compliance and Standards:**
- Utilize monitoring tools and develop standards to ensure databases meet uptime, reliability, security, and compliance objectives.
- Ensure databases comply with industry standards and regulatory requirements.
- Develop and enforce database standards, guidelines, and best practices.
- Conduct regular audits to ensure compliance with company policies and procedures.
- **Development and Reporting:**
- Create schemas, indexes, stored procedures, functions, and optimize database code for maximum throughput.
- Generate reports and data analysis to provide business insights to users and leadership.
QUALIFICATIONS
- Proven analytical and problem-solving abilities.
- Ability to effectively prioritize and execute tasks in a high-pressure environment.
- Can conform to shifting priorities, demands and timeliness through analytical and problem-solving capabilities.
- Keen attention to detail.
- Technology Savvy.
- Strong interpersonal and oral communication skills.
- Adept at reading, writing, and interpreting technical documentation and procedure manuals.
- Ability to present ideas and solutions in user-friendly language.
- Unquestionable ethics and morals.
- Highly self-motivated and directed.
- Strong customer service orientation.
- Skilled at working within a team-oriented, collaborative environment.
EDUCATION and/or EXPERIENCE
**Required:**
- Bachelor’s degree in Computer Science or a related technical field.
- 5+ years of DBA experience with enterprise-level solutions and SQL Server 2019 and higher.
- Knowledge of T-SQL, SSIS, and SQL Server optimization and configuration best practices.
- Proven experience with high availability, replication, clustering, AlwaysOn availability groups.
- Expert troubleshooting, analysis, and performance tuning abilities.
- Hands-on experience with software upgrades, patching, and system maintenance.
**Preferred:**
- Epicor Prophet 21 knowledge.
- Experience with Windows Server 2019 administration.
- ERP or manufacturing systems DBA experience.
- Familiarity with SQL Server 2019 containers and DevOps procedures.
CERTIFICATES, LICENSES, REGISTRATIONS
- None required.
WORK ENVIRONMENT
- Occasional evening and weekend work to meet deadlines.
- Occasional overnight travel to meet with internal and external customers.
- Sitting for extended periods of time.
- Employee is regularly required to speak and understand English, stand, walk, sit, use hand to finger, handle or feel objects, tools or controls; reach with hands and arms.
- Employee is required to use computer and other equipment.
- Lifting and transporting of moderately heavy objects up to 50 pounds, such as computers and peripherals.
- Specific vision abilities include close vision and the ability to clearly focus vision.
PPE REQUIRED:
Eye protection, ear protection, and as required by customer, steel-toed shoes and head protection.BENEFITS:
- Health Insurance BCBS of OK HDHP
- HSA with Employer match (must meet criteria)
- Dental and Vision Insurance
- 401K Plan and Company Match
- FSA (Full FSA, Limited FSA, and Dependent FSA)
- Company paid Long Term and Short-Term Disability
- Company paid basic Life Insurance and AD&D/
- Supplemental life and AD&D/Dependent life
- Ancillary Critical Illness Insurance (Wellness Rider Included)
- Ancillary Accident Insurance (Wellness Rider Included)
- Ancillary Hospital Indemnity
- Employee Assistance Program (EAP) – Includes concierge services and travel assistance.
- Paid Time Off
- Holiday Paid Time Off
- Gym Reimbursement
- Quarterly Wellness challenge with a chance to will money or prizes
- Tuition Reimbursement – after 1 year of employment
*BlackHawk Industrial is an Equal Opportunity Employer
**As part of our BHID policy, we require all potential employees to undergo pre-employment background and drug screening. This is a standard procedure we follow to ensure a safe and productive work environment.