Software Engineer (Database Administrator) - 302913

The Software Engineer (Database Administrator) plays a dual role, combining expertise in software engineering and database administration to deliver technical solutions for business-critical enterprise systems and cloud environments. As a key contributor to both software and database projects, this individual works on planning, designing, implementing, and optimizing software solutions while ensuring seamless database management and accessibility. This is a government contract position supporting the Department of Energy (DOE) Savannah River Site (SRS) in Aiken, SC.

• Perform software engineering and database tasks as assigned

• Create and update stored procedures
• Create and update databases and tables
• Configure table indexes and relationships
• Deploy database change scripts
• Create automation for repeatable database tasks
• Create, update, and manage reports, visualizations, and dashboards
• Install, upgrade, and manage database applications (SSRS, SSIS, SSAS)
• Create and maintain documentation (Security baselines, Metadata Standards, Entity Relationship Diagram (ERD))
• Perform database migrations and upgrades

• Manage database security roles
• Expert who is aware of all organization data sources
• Install, configure, and maintain SQL instances and security baselines
• Diagnose and troubleshoot database errors, including after hours and weekends
• Configure and maintain SQL Server monitoring utilities
• Monitor and tune performance of database systems
• Perform backup and restore operations
• Testing backups on a monthly/quarterly basis
• Create and maintain a data dictionary
• Conduct annual database needs assessment
• Other responsibilities as assigned
• Reports to the Program Manager

 Knowledge:

1. Understanding of programming languages such as ASP.NET, C#, JavaScript, SQL, HTML, LINQ, and PowerShell.
2. Hands-on knowledge of the MVC framework for scalable application design and development.
3. Familiarity with Azure DevOps, Git version control, or other source control software.
4. In-depth knowledge of SharePoint O365, PowerApps, and Power Automate for workflow automation and collaboration.
5. Understanding of the principles and advancements in Artificial Intelligence (AI).
6. In-depth knowledge of  SQL Server and Oracle database systems.
7. Developing and implementing high availability, disaster recovery, and server tuning strategies, including parameters, resources, and contention management.
8. Cross-platform database migrations for mission-critical environments.

 Skills:

1. Proficiency in shell scripting languages such as Shell, Perl, and Python for automation and process efficiency.
2. Version control and collaboration skills using tools like Git or similar.
3. Ability to design, implement, and migrate enterprise-level IT systems and solutions.
4. Advanced problem-solving skills in optimizing system performance and ensuring data integrity.
5. Capability to work effectively across a variety of development platforms and environments.

 Abilities:

1. Ability to lead client-specific strategic engagements and collaborate effectively with customer or partner teams.
2. Strong ability to guide C-Level/Director-level IT/business stakeholders in crafting tailored Enterprise Architecture and IT strategy solutions.
3. Ability to migrate mission-critical database environments across platforms.
4. Able to manage and optimize database operations, ensuring high availability and robust disaster recovery solutions.
5. Leadership in fostering collaboration within cross-functional teams to achieve business and technical goals.

 Clearance:

• Must possess (or be able to obtain) a “Q” level security clearance. 

Education:

• High School Diploma or GED with 12 years of experience or BS/BA with 8 years

 Experience:

• Three years of experience with multiple programing languages to include ASP.net, C#, JavaScript, SQL, HTML, LINQ, PowerShell

• Three years of experience with MVC framework
• Familiarity with Azure DevOps, Git version control and/or other source control software
• Familiarity with SharePoint O365, PowerApps and Power Automate

• Experience adhering to a software development life cycle (SDLC)
• Experience in SQL Server and Oracle
• Experience with C-Level/Director level customers in IT/Business to craft their Enterprise Architecture and IT Strategies
• Experience with migrating mission critical database environments from one platform to another
• Experience working with high availability, disaster recovery and server tuning strategies including parameters, resources, contention, etc.

• Covers 100% of employee benefit premiums, including Medical (PPO or HDHP Option), Vision, Dental

• Matching 401K
• Short- and Long-Term Disability
• Pet Insurance
• Professional Development/Education Reimbursement
• Parking and Transit Benefits for NY, NJ, ATL, and DC Metro areas

Other Duties:

Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities and activities may change at any time with or without notice.