Senior Database Administrator

Syms Strategic Group, LLC (SSG)•Melbourne, FL

3d•$74,263 - $81,970•Remote

About The Position

Syms Strategic Group (SSG) is seeking a talented Senior Database Administrator for a full-time, remote position within the Veterans Affairs (VA) department. This role requires a minimum of 8+ years of professional experience in database administration, with a focus on Oracle and SQL Server. The position involves installing, configuring, upgrading, and maintaining database management systems, creating and managing database objects, monitoring performance, and implementing backup and recovery strategies. Security is paramount, requiring the implementation and enforcement of database security policies and procedures, managing user access, and monitoring for potential issues. The role also includes providing technical support, collaborating with IT staff, maintaining documentation, and ensuring compliance with industry standards and best practices. Staying updated with the latest database technologies is essential.

Requirements

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
U.S. Citizenship required
Must possess or qualify for a Public Trust (MBI) security clearance

Nice To Haves

Microsoft Certified Azure Database Administrator – Associate
Oracle Certified Professional
Amazon Web Services (AWS) Certified Database - Specialty
Edifecs certification
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

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