Principal Database Engineer
REI Systems
2024-11-06 00:47:54
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.