Senior Database Administrator

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 If you have previously applied to Syms Strategic Group (SSG), there is no need to reapply. Applications are still under review. 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 proceduresMonitor and maintain database objects such as tables, indexes, views, and stored proceduresMonitor and maintain database performance, including tuning and optimizationAnalyze and optimize database performance, including query optimization and index managementConduct regular performance assessments and implement improvements to ensure optimal system performanceDevelop and implement backup and recovery strategies to protect data integrity and availabilityPerform regular backups and recovery drills to ensure data can be restored in case of failures or disastersImplement and enforce database security policies and proceduresManage user access and permissions to ensure data security and compliance with organizational policiesMonitor database systems for performance, errors, and potential issues using monitoring toolsPerform regular maintenance tasks, including database patches and updatesProvide technical support and troubleshooting assistance for database-related issuesCollaborate with application developers, system administrators, and other Information Technology (IT) staff to resolve database problemsMaintain comprehensive documentation of database configurations, procedures, and processesCreate and update operational manuals and guidelines for database managementEnsure databases comply with industry standards, regulations, and best practicesStay 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) ServerExperience in database design and architectureProven experience in database performance tuning, backup and recovery, and security managementProficiency in deploying, managing, and configuring SQL Server and Oracle databasesExperience with database monitoring and maintenance toolsKnowledge of specific features like automated backups, snapshots, scaling, and read replicasStrong knowledge of Oracle and SQL Server database architecture, management, and optimizationProficiency in writing and optimizing complex SQL queries, stored procedures, and triggersExperience with Oracle and SQL Server backup, recovery, and disaster recovery planningProficiency in Oracle and SQL Server database architecture, administration, and performance tuningExpertise in Procedural Language for SQL (PL/SQL) programming and Oracle database optimizationExperience with query optimization and indexing strategies for both SQL Server and OracleProficiency in using performance monitoring tools to diagnose and resolve database performance issuesKnowledge of database backup and recovery techniques, including point-in-time recovery and disaster recovery strategiesExperience implementing and managing automated backup solutionsAn understanding of database security best practices for both SQL Server and OracleExperience with user authentication, authorization, encryption, and data maskingStrong analytical and problem-solving skills to troubleshoot complex database issuesExcellent verbal and written communication skills, with the ability to explain technical concepts to non-technical stakeholdersAn ability to prioritize tasks, manage time effectively, and meet deadlinesStrong attention to detail to ensure data integrity and system stabilityAn ability to work effectively as part of a team and collaborate with application developers and system administratorsStrong documentation skills for creating and maintaining database configurations, processes, and proceduresAn ability to manage and contribute to multiple projects simultaneously, ensuring timely completion and quality resultsA commitment to staying current with emerging technologies and industry trends in database management and cloud services Professional CertificationsNone required, but the following advanced certifications are preferred: Microsoft Certified Azure Database Administrator – AssociateOracle Certified ProfessionalAmazon Web Services (AWS) Certified Database - SpecialtyEdifecs certification Years of Professional Experience8+ years of professional experience 8+ years of experience in database administration, preferably with Oracle and SQL ServerDesired experienceDeep 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 transactions999 transactions Knowledge of HIPAA compliance requirements in cloud data architecture Experience with healthcare payer/PBM systems, clearinghouses, or pharmacy operations Experience with EdifecsFormal EducationBachelor’s degree in Computer Science, IT, or a related fieldCitizenship RequirementU.S. Citizenship required for this specific opportunitySecurity Clearance RequirementsMust possess or qualify for a Public Trust (MBI)CRITICAL NOTES: 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 consideredRecruiters or Third parties will not be consideredThis is a 100% U.S. based remote position. However, candidates from CA, CO, IL, MN, NJ, NY, OR, or WA will not be consideredThis is a W-2 position All interviews will be conducted on Microsoft Teams with your camera on; there will be no exceptionsAs 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. Powered by JazzHR pibB6rh1oi