Please scroll down, To apply

Principal Database Engineer

hiring now

REI Systems

2024-11-06 00:47:54

Job location Sterling, Virginia, United States

Job type: fulltime

Job industry: Education

Job description

Overview:
REI Systems' mission is to deliver reliable, innovative technology solutions that advance Federal clients' missions and exceed their expectations. Our technologists and consultants are passionate about solving complex challenges that impact millions of lives. We take a Mindful Modernization approach in delivering our services, including application modernization, grants management, case management systems, government data analytics, and advisory services. This approach, the REI Way, ensures mission impact by aligning our clients' strategic objectives with measurable outcomes through people, processes, and technology.

We offer the same commitment to our employees by providing professional development, meaningful projects, and flexibility to spend time with family and friends. We believe employees are at their best when fulfilled in both their professional careers and their personal lives. Learn more at .

Employees voted REI Systems a Washington Post Top Workplace in 2015, 2016, 2018, 2020, 2021, 2022, 2023 and 2024!

Responsibilities:
Project Overview:
The role focuses on managing and optimizing large-scale database systems, potentially across cloud platforms. Key tasks include database performance tuning, migration to the cloud, ensuring security, and supporting critical business applications. Collaboration with development and DevOps teams is essential to meet project goals in industries like healthcare, finance, or government services.

Position Overview:
The Principal Database Engineer is responsible for designing, implementing, and maintaining complex databases, ensuring performance, security, and scalability. Key responsibilities include optimizing queries, leading cloud migrations, developing disaster recovery plans, and ensuring data integrity. Expertise in SQL, NoSQL, and cloud databases is essential.

Maintain, monitor, and support application-required functionality and validity of back-end DB components and scheduled jobs

Support continuous performance of Production instances of applications by troubleshooting and solving issues from production tickets

Work with project leads to design new database tables, objects, and schemas; create backup and recovery processes; and manage the archiving and purging of data

Support any Data Migration related activities and use cases

Monitor scheduled jobs, identify inter-dependencies and issues, and troubleshoot and find appropriate fixes, as needed.

Conceptualize viable technical solutions that meet customer objectives and project requirements within the cost and schedule constraints

Provide thought leadership for innovative data solutions to address complex business problems

Work with team leaders and data analysts in resolving complex technical and operational issues

Work with and through both functional and technical project team members to deliver products in an agile manner

Qualifications:
Required Qualifications:

10+ years of experience architecting, designing, developing, and managing enterprise-level databases using relational databases like Oracle, MySQL, PL/SQL and SQL Server

5+ years of experience with ETL tools like Informatica and Pentaho Kettle

Experince with CARS metadata, stored procedures, and triggers

Excellent programming skills using PL/SQL and Linux Shell scripting.

Strong communication and teamwork abilities

Experience delivering solutions using Agile delivery practices

Solid understanding of CI/CD and Agile DevOps pipelines

Data Architecture and Governance Adherence

Logical to Physical model conversion in forward engineering

Suggesting optimum parameters for the database

Creating and altering DDL scripts for application schema creation

Installing and configuring application in a multi-schema, multi-database environment

Database performance tuning in conjunction with distributed application components enhancement

Supporting and resolving ongoing database and application issues

Refreshing databases for lower level environment from higher environment.

Educational Qualifications:

BS in Engineering, Computer Science, Information Systems or equivalent

Clearance: Eligible to obtain a public trust clearance.

Location: Hybrid (One day per week or as needed in the REI Sterling Office)

EEO Statement: REI Systems is an Equal Opportunity Employer. In our workplace, we seek, we welcome, and respect diversity in all of its forms.

Inform a friend!

<!– job description page –>
Top