Senior Database Administrator

SSG Official Website; Richmond (VA); Remote; USD 76,000 - 81,000; Full time

Job summary

Syms Strategic Group (SSG) is seeking a Senior Database Administrator for a fully remote role serving the Veterans Affairs department. Requires 8+ years of database experience, Oracle and SQL Server expertise, and a Public Trust (MBI) clearance. U.S.

citizenship is required. Salary range opens at $76,217 to $81,000 with W-2 employment and national remote eligibility. Candidate will lead DB design, performance tuning, backup/recovery, security, and DR planning while collaborating with IT staff.

Qualifications

• Proven expertise managing and maintaining Oracle databases and SQL Server.
• Experience in database design and architecture.
• Proven experience in performance tuning, backup/recovery, and security management.
• Proficiency deploying, managing, and configuring SQL Server and Oracle databases.
• Experience with database monitoring and maintenance tools.
• Knowledge of features like automated backups, snapshots, scaling, and read replicas.
• Strong knowledge of Oracle/SQL Server architecture, management, and optimization.
• Proficiency writing/optimizing complex SQL, stored procedures, and triggers.
• Experience with backup, recovery planning, and disaster recovery strategies.
• Proficiency in database architecture, administration, and performance tuning.
• PL/SQL programming and Oracle optimization expertise.
• Experience with query optimization and indexing for SQL Server/Oracle.
• Use of performance monitoring tools to diagnose issues.
• Understanding recovery techniques including point-in-time recovery.
• Experience implementing automated backup solutions.
• Knowledge of database security best practices for SQL Server and Oracle.
• Experience with user authentication, authorization, encryption, and masking.
• Strong analytical and communication skills to explain tech concepts.

Responsibilities

• Install, configure, and upgrade DBMS.
• Create and manage database objects (tables, indexes, views, procedures).
• Monitor and maintain database objects and performance.
• Conduct tuning and optimization for queries and indexes.
• Develop backup and recovery strategies and drills.
• Implement and enforce database security policies and access controls.
• Collaborate with developers and admins to resolve DB problems.
• Maintain documentation of configurations, procedures, and processes.
• Ensure compliance with industry standards and best practices.
• Stay updated on database technologies and cloud services.

Skills

Oracle DB

SQL Server

Performance tuning

Backup and recovery

Security management

PL/SQL

Query optimization

Database architecture

Monitoring tools

Data security/compliance

Education

Bachelor’s degree in Computer Science / IT

Microsoft Certified Azure Database Administrator – Associate

Oracle Certified Professional

AWS Certified Database - Specialty

Edifecs certification (preferred)

Job description

Syms Strategic Group (SSG) is seeking a talented Senior Database Administrator
Location: Remote
Department: Veterans Affairs (VA)
Type: Full Time
Min. Experience: Experienced
Security Clearance Level: Public Trust (MBI)
Salary Range: $76,217- $81,000
Military Veterans are highly encouraged to apply!

Essential Duties and Responsibilities

• Install, configure, and upgrade database management systems (DBMS)
• Create and manage database objects such as tables, indexes, views, and stored procedures
• Monitor and maintain database objects such as tables, indexes, views, and stored procedures
• Monitor and maintain database performance, including tuning and optimization
• Analyze and optimize database performance, including query optimization and index management
• Conduct regular performance assessments and implement improvements to ensure optimal system performance
• Develop and implement backup and recovery strategies to protect data integrity and availability
• Perform regular backups and recovery drills to ensure data can be restored in case of failures or disasters
• Implement and enforce database security policies and procedures
• Manage user access and permissions to ensure data security and compliance with organizational policies
• Monitor database systems for performance, errors, and potential issues using monitoring tools
• Perform regular maintenance tasks, including database patches and updates
• Provide technical support and troubleshooting assistance for database-related issues
• Collaborate with application developers, system administrators, and other Information Technology (IT) staff to resolve database problems
• Maintain comprehensive documentation of database configurations, procedures, and processes
• Create and update operational manuals and guidelines for database management
• Ensure databases comply with industry standards, regulations, and best practices
• Stay updated with the latest developments and trends in database technologies and implement relevant improvements

Required Skills and Experience

• Proven expertise managing and maintaining Oracle databases and Structured Query Language (SQL) Server
• Experience in database design and architecture
• Proven experience in database performance tuning, backup and recovery, and security management
• Proficiency in deploying, managing, and configuring SQL Server and Oracle databases
• Experience with database monitoring and maintenance tools
• Knowledge of specific features like automated backups, snapshots, scaling, and read replicas
• Strong knowledge of Oracle and SQL Server database architecture, management, and optimization
• Proficiency in writing and optimizing complex SQL queries, stored procedures, and triggers
• Experience with Oracle and SQL Server backup, recovery, and disaster recovery planning
• Proficiency in Oracle and SQL Server database architecture, administration, and performance tuning
• Expertise in Procedural Language for SQL (PL/SQL) programming and Oracle database optimization
• Experience with query optimization and indexing strategies for both SQL Server and Oracle
• Proficiency in using performance monitoring tools to diagnose and resolve database performance issues
• Knowledge of database backup and recovery techniques, including point-in-time recovery and disaster recovery strategies
• Experience implementing and managing automated backup solutions
• An understanding of database security best practices for both SQL Server and Oracle
• Experience with user authentication, authorization, encryption, and data masking
• Strong analytical and problem-solving skills to troubleshoot complex database issues
• Excellent verbal and written communication skills, with the ability to explain technical concepts to non-technical stakeholders
• An ability to prioritize tasks, manage time effectively, and meet deadlines
• Strong attention to detail to ensure data integrity and system stability
• An ability to work effectively as part of a team and collaborate with application developers and system administrators
• Strong documentation skills for creating and maintaining database configurations, processes, and procedures
• An ability to manage and contribute to multiple projects simultaneously, ensuring timely completion and quality results
• A commitment to staying current with emerging technologies and industry trends in database management and cloud services

Professional Certifications

None required, but the following advanced certifications are preferred:

1. Microsoft Certified Azure Database Administrator – Associate
2. Oracle Certified Professional
3. Amazon Web Services (AWS) Certified Database - Specialty
4. Edifecs certification

Years of Professional Experience

8+ years of professional experience
8+ years of experience in database administration, preferably with Oracle and SQL Server

Desired experience

Deep hands-on EDIFECS experience in Electronic Data Interchange X.12 (EDI) Transactions Standards involving key X12 workflows involving the following transactions:

• X.12 medical claims (837, 834, 835, 277, etc)
• 270/271 and 278 transactions
• 999 transactions

Knowledge of HIPAA compliance requirements in cloud data architecture
Experience with healthcare payer/PBM systems, clearinghouses, or pharmacy operations
Experience with Edifecs

Formal Education

Bachelor’s degree in Computer Science, IT, or a related field

Citizenship Requirement

U.S. Citizenship required for this specific opportunity

Security Clearance Requirements

Must possess or qualify for a Public Trust (MBI)

CRITICAL NOTES:

1. SSG will not make assumptions regarding your qualifications. Your answers to the mandatory screening questions must be supported by the information on your resume. Applications with inconsistencies will not be considered.
2. Recruiters or Third parties will not be considered.
3. This is a 100% U.S. based remote position. However, candidates from CA, CO, IL, MN, NJ, NY, OR, or WA will not be considered.
4. This is a W-2 position
5. All interviews will be conducted on Microsoft Teams with your camera on; there will be no exceptions
6. As part of our screening process, you will be requested to provide a link to your LinkedIn profile

U.S Citizenship is required for this specific opportunity. Applicants selected will be subject to a government security investigation and must meet eligibility requirements for access to classified information and be able to obtain a government-granted security clearance. Individuals may also be subject to a background investigation including, but not limited to criminal history, employment and education verification, drug testing, and creditworthiness.
Syms Strategic Group, LLC is an Equal Opportunity Employer. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, national origin, marital status, disability, veteran status, sexual orientation, or genetic information.