Title: SQL DBA (Mid- Level)
Location: Washington, DC (Hybrid)
Status: Full Time
Clearance: Public Trust
Yakshna Solutions, Inc., (YSI) is a CMMI Level 3 assessed, ISO 9001, 20000:1, 27001 certified, woman-owned small business enterprises, headquartered in Herndon, Virginia, USA. YSI provides professional IT solutions and services to business corporations and government organizations. YSI is committed to serve its business communities as a leading IT vendor providing innovative, quality and cost-effective IT business solutions and services.
YSI offers a competitive benefits package that includes the following: 401(k), health, dental, and vision insurance, Life insurance, short-term and long-term disability insurance, paid time off, training and professional development assistance.
As a SQL DBA, the candidate will be responsible for administering, configuring, and maintaining SQL Server databases, including 2022 Datacenter environments with SSIS, ETL, replication, clustering, and patching. The role involves designing and managing database structures, developing stored procedures, and supporting developers with SQL creation and analysis. The DBA ensures database performance, reliability, and security while performing maintenance, upgrades, and troubleshooting. Additionally, the position supports multiple database platforms such as MariaDB, PostgreSQL, Oracle, and MySQL to ensure optimal data management across systems.
Required Skills:
- Bachelor's degree in computer science, information systems, or a related field. Equivalent work experience may be considered.
- 5+ years of experience across a wide range of database technologies (SQL Server, MariaDB, PostgreSQL, Oracle, etc.).
- Required to have a minimum of 5 years experience in database management.
- Extensive SQL experience and knowledge with developing data structures and stored procedures, and to support/install new databases.
- Provide SQL creation and analysis support for developers.
- SQL Server Management Studios (SSMS)
- SQL Server 2022 Datacenter (SSIS, ETL, HA, Replication, Clustering, STIG/patching) ~25 Databases
- Proficiency in the following database disciplines: MS SQL, SQL Server, SQL Cluster Environments, Maria DB, MySQL, PostgreSQL, Oracle, and MS Access.
- The SMEs must be proficient in creating and managing standalone SQL and Oracle databases.
- SMEs must be able to identify issues, perform server maintenance, install software patches, etc.
- Database administration, configuration, and maintenance
- Troubleshooting and issue resolution
- Backup and recovery
- Patching and upgrades
- Performance monitoring and tuning
- High Availability / Disaster Recovery
- Capacity planning and system health monitoring
- Change, incident, and request management
- Scripting and automation