Solutions Engineer/Database Management

DC
Full Time
Mid Level
Company Overview:
Subsidium, Inc. is a global provider of engineering, systems integration, technical, and programmatic services to both Government and Commercial entities. Subsidium provides mission critical services to Department of Defense (DoD) customers in CONUS, OCONUS, and forward deployed environments. Our customers demand the innovative, flexible, and mission focused approach that we deliver. Subsidium is dedicated to helping our customers overcome challenges through innovative solutions; particularly the continuing and evolving challenges presented in the transformation of the U.S. military and in the global war on terror. Subsidium and its employees are committed to mission accomplishment and organizational excellence. 

Location: 601 Pennsylvania Ave. NW (North and South Buildings), Washington, D.C.

Job Summary:
The National Gallery of Art is an art museum in Washington, D.C.  The Gallery serves the nation by welcoming all people to explore and experience art, creativity, and our shared humanity. The Gallery develops the understanding of art through collecting and exhibiting in ways that reflect our nation and its histories; preserving its collections for future generations; and delivering compelling public programs and events, engaging digital experiences, and groundbreaking scholarship.
The National Gallery uses Information Technology (IT) in the execution of its mission. The information technology services are managed by Treasurer’s office of Digital Solutions (TDS). These services are delivered through various departments within TDS.
This position is to support database management responsibilities across commercial and opensource database platforms, in heterogeneous computing environment (on-premise, cloud-hosted and SaaS).
The position involves Administration and support, troubleshooting, and performing break fix including emergency after hours onsite support for critical Tier1 business services.
The technical focal point is to administer and maintain database security, integrity, and optimization and resolve any database issues relating to Microsoft/Oracle/MySQL/Postgres/ MariaDB /AWS/Azure Database Management Systems (DBMS) and Azure Synapse Data Analytics Platform in coordination with other technicians. 

Responsibilities/Duties:
  •  Troubleshoot and perform break fix including emergency after hours onsite support as needed (especially for Tier1 business services) and provide root cause analysis.
  • The technical focal point is to administer and maintain database security, integrity, and optimization and resolve any database issues relating to Microsoft/Oracle/MySQL/Postgres/MariaDB/AWS/Azure Database Management Systems (DBMS) and Azure Synapse Data Analytics Platform in coordination with other technicians. 
  • Capture, analyze and report on problem areas and help resolve issues associated with database integrations within PaaS, IaaS, and COTS applications / systems / services.  
  • Support service deployments (operation architect/systems administrations) and escalation and restoration (24x7 on-call) efforts.
  • Install, configure, provision, operate and administer database management systems and their related software as well as backend storage server and hardware platforms.
  • Perform capacity and performance trending, conduct predictive analysis, and provide capacity reports to Capacity Manager monthly.
  • Design, install, monitor, maintain and performance tuning production databases while ensuring high levels of data availability.  
  • Security management by setting up user accounts and proper access, and auditing user activities.
  • Coordinating and perform database system upgrade, regular maintenance, patching, and compliance.
  • Provide support to the development team and implementation of database policies and procedures to ensure the integrity and availability of databases.
  • Identify common database commands and find ways to automate or simplify tasks. Create data pipeline or generate a certain type of data set when users perform a specific action.
  • Provide technical expertise in support of the design of complex physical/logical data models. Document and describe the structure for data storage, data indexing, data manipulation, and data retrieval applications.
  • Work with system owners and project managers to develop and implement complex querying and report solutions.  Share concepts and techniques as well as foster and encourage sharing of knowledge for database best practices. 
  • Design and develop architecture for data warehouse including source data ETL/ELT strategy, data movement and aggregation as well as data quality strategy. Serve as principal technical authority and lead specialist responsible for ensuring effective, economical, and advanced technical management of database and storage solutions.
  • Communicate regularly with the development team, business, and operations teams to ensure the security and confidentiality of data. Responsible for the availability, reliability and integrity of business data stored in production databases.
Qualifications:
  • 5+ years of experience working as a hands-on MS SQL Server Database Administrator, 
  • Advanced experience in database monitoring, troubleshooting, performance tuning, and high availability strategies for SQL Server, MySQL for on-premises (physical as well as VMWare platform) and cloud installations (such as Microsoft Azure / Amazon Web Services (AWS)).
  • Advanced knowledge of SQL Server backup and recovery strategies.
  • Advanced experience in database server specification, performance tuning, analysis, and optimization
  • Solid experience in TSQL and PL/SQL for troubleshooting and administration.
  • Experience defining hardware requirements and storage capacity planning for development, testing, QA and production for capacity planning and performance.
  • Advanced knowledge of SQL Server High Availability (HA) and Disaster Recovery (DR) options for SQL Server
  • Demonstrated ability to perform problem identification, analysis, and resolution on various DBMS (Oracle, MS SQL, MySQL). Experience in managing 24/7 high availability production DBMS.
  • Solid experience in design and implementation ETL process with SSIS/PDI.
  • PowerShell for automation server monitoring
  • Ability to design, develop, and document technical solutions, standard operating procedures and change requests. 
  • Ability to administer Linux/Windows server based operating systems and CLI w/ scripting.
  • Experience with capacity planning, utilization, and performance monitoring (Index, Table, Queries and Stored procedures). Data modeling skills for enterprise data warehouses and data marts.
Education/Certifications:
  • Bachelor’s degree in computer science/engineering and a minimum of 8 years related technical experience required.
  • Microsoft Certifications will be preferred, however, the hands-on experience and size/complexity of SQL Server environments supported by the contractor may be considered to substitute the certification. 
Benefits and Perks:
  • Medical / Vision and Dental Plans
  • Holiday and Personal Time Off Pay
  • 401K 
  • Life Insurance
  • Education and Training Assistance Program (discussed during the onboarding process)
  • Incentive Plans and Referral Bonuses
  • Employee Assistance Programs
Subsidium, Inc is an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status, or any other characteristic protected by law. 
 
Share

Apply for this position

Required*
Apply with Indeed
We've received your resume. Click here to update it.
Attach resume or Paste resume
Attach resume as .pdf, .doc, .docx, .odt, .txt, or .rtf (limit 5MB) or Paste resume

Paste your resume here or Attach resume file

To comply with government Equal Employment Opportunity and/or Affirmative Action reporting regulations, we are requesting (but NOT requiring) that you enter this personal data. This information will not be used in connection with any employment decisions, and will be used solely as permitted by state and federal law. Your voluntary cooperation would be appreciated. Learn more.
Invitation for Job Applicants to Self-Identify as a U.S. Veteran
  • A “disabled veteran” is one of the following:
    • a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or
    • a person who was discharged or released from active duty because of a service-connected disability.
  • A “recently separated veteran” means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service.
  • An “active duty wartime or campaign badge veteran” means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.
  • An “Armed forces service medal veteran” means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985.
Veteran status


Voluntary Self-Identification of Disability
Voluntary Self-Identification of Disability Form CC-305
OMB Control Number 1250-0005
Expires 04/30/2026
Why are you being asked to complete this form?

We are a federal contractor or subcontractor. The law requires us to provide equal employment opportunity to qualified people with disabilities. We have a goal of having at least 7% of our workers as people with disabilities. The law says we must measure our progress towards this goal. To do this, we must ask applicants and employees if they have a disability or have ever had one. People can become disabled, so we need to ask this question at least every five years.

Completing this form is voluntary, and we hope that you will choose to do so. Your answer is confidential. No one who makes hiring decisions will see it. Your decision to complete the form and your answer will not harm you in any way. If you want to learn more about the law or this form, visit the U.S. Department of Labor’s Office of Federal Contract Compliance Programs (OFCCP) website at www.dol.gov/ofccp.

How do you know if you have a disability?

A disability is a condition that substantially limits one or more of your “major life activities.” If you have or have ever had such a condition, you are a person with a disability. Disabilities include, but are not limited to:

  • Alcohol or other substance use disorder (not currently using drugs illegally)
  • Autoimmune disorder, for example, lupus, fibromyalgia, rheumatoid arthritis, HIV/AIDS
  • Blind or low vision
  • Cancer (past or present)
  • Cardiovascular or heart disease
  • Celiac disease
  • Cerebral palsy
  • Deaf or serious difficulty hearing
  • Diabetes
  • Disfigurement, for example, disfigurement caused by burns, wounds, accidents, or congenital disorders
  • Epilepsy or other seizure disorder
  • Gastrointestinal disorders, for example, Crohn's Disease, irritable bowel syndrome
  • Intellectual or developmental disability
  • Mental health conditions, for example, depression, bipolar disorder, anxiety disorder, schizophrenia, PTSD
  • Missing limbs or partially missing limbs
  • Mobility impairment, benefiting from the use of a wheelchair, scooter, walker, leg brace(s) and/or other supports
  • Nervous system condition, for example, migraine headaches, Parkinson’s disease, multiple sclerosis (MS)
  • Neurodivergence, for example, attention-deficit/hyperactivity disorder (ADHD), autism spectrum disorder, dyslexia, dyspraxia, other learning disabilities
  • Partial or complete paralysis (any cause)
  • Pulmonary or respiratory conditions, for example, tuberculosis, asthma, emphysema
  • Short stature (dwarfism)
  • Traumatic brain injury
Please check one of the boxes below:

PUBLIC BURDEN STATEMENT: According to the Paperwork Reduction Act of 1995 no persons are required to respond to a collection of information unless such collection displays a valid OMB control number. This survey should take about 5 minutes to complete.

You must enter your name and date
Human Check*