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