Oracle Database Admin

Job ID: NC-1118)

Hybrid/Local Govt Oracle DBA (15+) with SQL Server, MySQL, PostgreSQL, backup/recovery, security, APIs, Azure SQL, AWS RDS, Cloud SQL, Agile/Scrum experience

Location: Raleigh, NC (NCDHHS)
Duration: 12 Months

Skills:
Hands-on experience with database management systems (e.g., Oracle, SQL Server, MySQL, PostgreSQL).   Required    7     Years
Strong knowledge of SQL, database architecture, backup/recovery, and security best practices.   Required    7     Years
Experience with performance tuning, query optimization, and capacity planning.      Required    7     Years
Knowledge of modern database technologies and strategies for migrating and modernizing database systems     Required    7     Years
Familiarity with programming languages, APIs, and database design principles. Required    5     Years
Experience with cloud database technologies (Azure SQL, AWS RDS, Cloud SQL).  Required    3     Years
Experience with Agile/Scrum Framework environments.   Required    5     Years
Strong communication and collaboration skills to work with cross-functional teams, including developers, business analysts, and stakeholders.   Required    7     Years
State Government experience   Nice to have      2     Years

Job Description:
DHHS is seeking a Database Administrator (DBA) who will be responsible for installing, configuring, maintaining, and securing an organization’s database systems. This role ensures high availability, performance, integrity, and security of data across production, test, and development environments.

Key Responsibilities
Install, configure, upgrade, and maintain database servers and application tools.
Establish system storage requirements and modify database structures as needed.
Perform regular maintenance (debugging, patching, performance tuning, reporting).
Monitor database performance, identify bottlenecks, and implement optimization strategies.
Tune SQL queries, indexing strategy, and database parameters to improve efficiency.
Set up cybersecurity measures, authentication controls, and enforce security policies.
Manage user permissions, privileges, and audit activities to protect sensitive data.
Ensure compliance with regulatory and organizational data governance requirements.
Design and implement backup and disaster recovery strategies.
Ensure availability and integrity of backed-up data and support recovery operations.
Support database design, schema creation, and testing activities.
Consult with developers and stakeholders to ensure optimal database usage.
Implement event triggers, stored procedures, and performance alerts.
Monitor transaction volumes, concurrency, response times, and other performance indicators.
Perform housekeeping tasks such as tuning, indexing, and data cleanup.
Required Skills & Qualifications

Hands-on experience with database management systems (e.g., Oracle, SQL Server, MySQL, PostgreSQL).
Strong knowledge of SQL, database architecture, backup/recovery, and security best practices.
Experience with cloud database technologies (Azure SQL, AWS RDS, Cloud SQL).
Experience with performance tuning, query optimization, and capacity planning.
Familiarity with programming languages, APIs, and database design principles.
Problem-solving and analytical thinking with attention to detail.
Knowledge of compliance-heavy environments (healthcare, finance, government).