Solutions Engineer/Database Management

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). 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. #J-18808-Ljbffr