Note: The job is a remote job and is open to candidates in USA. Syms Strategic Group, LLC is hiring a Senior Database Administrator to manage and maintain Oracle and SQL Server databases for a Veterans Affairs department. The role focuses on database performance, security, backup and recovery, troubleshooting, documentation, and collaboration with IT teams.

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

Skills

• 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
• 8+ years of professional experience
• Bachelor's degree in Computer Science, IT, or a related field
• U.S. Citizenship required for this specific opportunity
• Must possess or qualify for a Public Trust (MBI)
• U.S Citizenship is required for this specific opportunity
• Must meet eligibility requirements for access to classified information and be able to obtain a government-granted security clearance
• Microsoft Certified Azure Database Administrator – Associate
• Oracle Certified Professional
• Amazon Web Services (AWS) Certified Database - Specialty
• Edifecs certification
• 8+ years of experience in database administration, preferably with Oracle and SQL Server
• 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

Benefits

• 100% U.S.-based remote position; candidates from CA, CO, IL, MN, NJ, NY, OR, or WA will not be considered.

Company Overview