Database Administrator

Yakshna Solutions, Inc.; Herndon (VA); Hybrid; USD 110,000 - 150,000; Full time

Benefits offered by this job

401(k)

Health insurance

Dental insurance

Vision insurance

Life insurance

Disability insurance

Paid time off

Training & development

Job summary

Yakshna Solutions, Inc. is seeking a Mid-Level SQL DBA to administer and optimize SQL Server databases (including 2022 Datacenter) with SSIS, ETL, replication, clustering, and patching.

You will design database structures, create stored procedures, and support developers with SQL tasks. The role covers maintaining performance, reliability, and security across MS SQL, MariaDB, PostgreSQL, Oracle, and MySQL platforms, ensuring robust data management.

Qualifications

• 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.).
• Minimum 5 years experience in database management.

Responsibilities

• Administer, configure, and maintain SQL Server databases including 2022 Datacenter environments with SSIS, ETL, replication, clustering, and patching.
• Design and manage database structures, develop stored procedures, and support developers with SQL creation and analysis.
• Ensure database performance, reliability, and security while performing maintenance, upgrades, and troubleshooting.
• Support multiple database platforms such as MariaDB, PostgreSQL, Oracle, and MySQL.

Skills

SQL Server

MariaDB

PostgreSQL

Oracle

SSMS

High Availability

Backup & Recovery

Performance Tuning

Education

Bachelor's degree

Tools

SSIS

ETL

Job description

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