Database Engineer

No 3rd Party or C2C Resumes will be accepted for this role**

Apex Systems is seeking an experienced Database Engineer with strong experience supporting SQL Server databases. The Database Engineer will oversee the performance, integrity, and security of our firm’s databases. This individual will play a crucial role in the management and maintenance of both on-premises and cloud-based database systems. The Database Engineer will be instrumental in building our enterprise data lake house and warehouse, establishing robust data connections, and creating data gateways across multiple sources to support the firm’s data-driven initiatives. As a key player in our IT department, you will collaborate closely with system engineers, data analysts, and project managers to ensure seamless data integration and sustained data accessibility across the firm.
No 3rd Party or C2C Resumes will be accepted for this role*** Title: Database Engineer Industry/Vertical: Legal/Law Location: 100% Remote (EST)

Essential Job Duties
Database Maintenance and Operations: Ensure all database servers are up and running smoothly, providing a seamless flow of information throughout the company, minimizing downtime, and managing parameters to provide fast query responses

Data Security and Backup : Implement and oversee robust security measures, data integrity, backup, and disaster recovery plans

Performance Tuning: Monitor database performance, implement changes and apply new patches and versions when required to ensure optimal performance

Troubleshoot Database Issues: Rapidly troubleshoot any database issues that arise as part of the day-to-day operations of the firm, ensuring data accuracy and availability

Data Warehouse Development and Maintenance : Design, develop and maintain ETL processes related to importing and exporting data from source systems, transforming and cleansing data, and providing data to the data lake and warehouse

Business Intelligence Support: Develop and maintain Power BI datasets, dashboards, and reports, assisting in the creation of visualizations that help translate complex datasets into actionable insights

Minimum Requirements: 
Bachelor’s degree in computer science, information technology, or a related field, and at least 7-10 years of related work experience

Proven experience in database administration, with a strong background in data warehouse management and data integration

Expertise in Microsoft SQL Server including Integration Services (SSIS), Reporting Services (SSRS), and Analysis Services (SSAS)

Strong understanding of ETL processes, performance tuning, and SQL query optimization

Skills and Qualities Desired: 
Excellent analytical and creative problem-solving skills

High-level understanding of the organization’s goals and objectives

Superior listening, interpersonal, written, and oral communication skills

Logical and efficient, with keen attention to detail

Knowledgeable in web-related technologies such as HTML, XML and web services