| 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:- Microsoft Certified Azure Database Administrator – Associate
- Oracle Certified Professional
- Amazon Web Services (AWS) Certified Database - Specialty
- 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: | - 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.
- Recruiters or Third parties will not be considered.
- 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.
- This is a W-2 position
- All interviews will be conducted on Microsoft Teams with your camera on; there will be no exceptions
- As part of our screening process, you will be requested to provide a link to your LinkedIn profile
|