Senior Database Engineer
| Company | Freedom Technology Solutions Group |
|---|---|
| Location | Annapolis Junction, MD, USA |
| Salary | $160000 – $210000 |
| Type | Full-Time |
| Degrees | Bachelor’s |
| Experience Level | Senior, Expert or higher |
Requirements
- TS/SCI with Polygraph
- A bachelor’s degree and ten (10) years of experience as a DBE in programs and contracts of similar scope, type, and complexity is required. Fifteen (15) years of software development experience may be substituted in lieu of a bachelor’s degree.
- Proficiency in SQL Server and Oracle databases
- Experience with MS Visual Studio and MS SQL Server Management Studio
- Ability to write triggers, functions, stored procedures, and packages
- In-depth knowledge of indexes and sequences
- Strong ability to analyze large datasets and develop optimal solutions for updating existing records
- Ensure data integrity when developing and implementing solutions
- Proficient in writing complex queries and views, including effective use of subqueries.
Responsibilities
- Monitor and maintain the health and performance of Oracle databases.
- Perform routine database backups, restores, and disaster recovery testing.
- Develop and optimize SQL queries, stored procedures, and triggers to enhance system performance.
- Create and modify database objects such as tables, indexes, and views to meet application requirements.
- Provide technical support for ARCHIBUS and Maximo, resolving database-related issues.
- Analyze and troubleshoot system errors, slow queries, and data inconsistencies.
- Assist with version upgrades and patch management for ARCHIBUS, Maximo, and Oracle databases.
- Perform pre- and post-upgrade testing to ensure seamless functionality.
- Collaborate with stakeholders and developers to understand and implement customer requirements.
- Design and develop database solutions that integrate with system user interfaces.
- Enforce data security policies and implement access controls.
- Ensure data integrity and consistency across applications.
- Document database configurations, procedures, and troubleshooting steps.
- Share knowledge with team members to improve overall system understanding.
- Use database monitoring tools to identify potential bottlenecks and optimize system performance.
- Recommend and implement improvements to enhance database efficiency.
Preferred Qualifications
- PL/SQL Experience (a plus): Proficient in creating and managing stored procedures, triggers, functions, and packages in Oracle databases.
- AWS Experience: Familiar with deploying, managing, and scaling databases in Amazon Web Services (AWS) cloud infrastructure.
- AWS Relational Database Service (RDS): Experience with managing SQL-based databases (MySQL, PostgreSQL, SQL Server, Oracle) in AWS RDS.
- Migrating Databases to AWS: Experience migrating databases to AWS, ensuring data integrity and minimal downtime during the transition process.