Overview
We are seeking a highly skilled and detail-oriented Data Warehouse Engineer to join our team. The ideal candidate will possess a strong IT foundation in database structure, configuration, installation, and management. This role demands expertise in major relational database technologies, including Microsoft SQL Server, PostgreSQL, and Oracle. You will work to ensure high availability, performance, and security of our databases, while also supporting database design, maintenance, and optimization efforts. A customer-focused mindset and a collaborative approach to teamwork are essential.
Key Responsibilities
- Data Management: Extract and load data, ensuring seamless data transfer and integrity across systems.
- Cybersecurity: Implement and maintain cybersecurity measures to safeguard data and prevent unauthorized access.
- System Updates: Regularly update hardware and software systems to ensure optimal performance and security.
- Data Authentication: Ensure the authenticity of data by performing verification and validation tasks.
- Performance Monitoring: Continuously monitor hardware and software performance, addressing any performance issues as they arise.
- Server and Database Configuration: Set up and configure servers and databases to ensure optimal performance and security.
- Data Integrity: Preserve data integrity by implementing best practices for database maintenance and troubleshooting.
- Database Standards & Policies: Create and maintain database standards, policies, and procedures for consistent and secure management.
- Database Design & Testing: Support database design, creation, and testing activities to improve overall system functionality.
- Availability & Incident Management: Manage database availability, including performance monitoring and incident/problem management.
- Database Optimization: Administer database objects for optimal resource utilization and ensure performance optimization.
- Event Triggers & Alerts: Define and implement event triggers to identify and alert on database performance or integrity issues.
- Database Housekeeping: Perform routine maintenance tasks such as database tuning, indexing, and optimizing query performance.
- Security Compliance: Implement database security measures and frameworks, ensuring compliance with industry standards.
- Backup & Archiving: Design and implement database backup, archiving, and storage strategies to ensure data recovery and long-term storage.
- Software Upgrades: Install and manage upgrades and patches for database-related applications.
- Automation & Tools Adoption: Identify, evaluate, and implement database administration tools and automation processes.
- Documentation: Develop and maintain comprehensive documentation for all database administration tasks, standards, and procedures.
- System Configuration Management: Oversee the installation, upgrading, and maintenance of database-related software and systems.
- Performance Forecasting: Monitor and plan for resource needs based on database activity and projected growth.
Education and Experience Requirements
Education:
- Bachelor’s degree in computer science, Information Technology, or a related field.
Experience:
- 1 to 3 years of experience in database administration, database architecture, or a related IT field.
- 6+ years of experience in database administration or systems development, with at least 2 years of Microsoft SQL Server administration experience.
Certifications:
- MCSE/MCSA certifications are preferred. Other relevant certifications (Microsoft, Oracle, etc.) are a plus.
Technical Skills:
- Expertise in relational database management systems such as Microsoft SQL Server, PostgreSQL, Oracle, and MySQL.
- Proficiency in Structured Query Language (SQL), Extract Transform Load (ETL) processes, stored procedures, and functions.
- Experience with database technologies such as NoSQL, MongoDB, and Big Data solutions.
- Familiarity with PowerShell and other scripting languages.
- Strong knowledge of SQL Server Integration Services (SSIS).
- Experience with Linux and Windows Server environments.
- In-depth understanding of relational database security, physical database design, and network topologies.
- Strong knowledge of server hardware, data storage solutions (SAN, RAID), and operating systems (Windows, Linux/UNIX).
- Strong understanding of performance optimization techniques, including indexing, query plans, and buffer/cache management.
- Expertise in database backup, archiving, and disaster recovery planning.
Communication Skills:
- Excellent verbal and written communication skills, with the ability to explain complex technical concepts to non-technical stakeholders.
Problem-Solving:
- Proven track record of successfully resolving complex database management issues.
Compliance Knowledge:
- Understanding of database security principles, licensing models (particularly Microsoft licensing), and regulatory compliance.
Key Competencies
- Detail-oriented and organized.
- Strong customer service orientation with the ability to manage stakeholder expectations.
- Excellent teamwork and collaboration skills.
- Ability to handle pressure and manage multiple priorities.
- Proactive approach to identifying and solving database-related issues.
Job Type: Full-time
Pay: $100,000.00 - $110,000.00 per year
Benefits:
- 401(k)
- 401(k) matching
- Dental insurance
- Employee assistance program
- Flexible spending account
- Health insurance
- Health savings account
- Life insurance
- Paid time off
- Vision insurance
Schedule:
Application Question(s):
- What are your thoughts regarding our mission statement? Mission Statement
At Restoration of America, we know the timeless foundation of America’s peace and prosperity is turning to God and the enforcement of just laws. We defend our nation by electing like-minded leaders and by creating organizations and campaigns that promote fully transparent elections, economic freedom, limited government, military superiority, secure borders, rule of law, and the sanctity of life. We do this through an experienced and passionate leadership team that values truth above all else. We apply best in class business practices yielding efficient, effective, and innovative products and results. And we partner with like-minded organizations to create force multiplication, extending both our reach and the return-on-investment for our donors.
- Have you ever set up your own SQL Server? Can you walk through the basic steps you used to do so.
- Do you have experience with datawarehousing or transforming data? Can you please cite an example?
Ability to Commute:
- Ponte Vedra, FL 32081 (Required)
Ability to Relocate:
- Ponte Vedra, FL 32081: Relocate before starting work (Required)
Work Location: In person