Database Administrator II

About the role

Reflexive Concepts is seeking a skilled Database Administrator II to join our team.

Responsibilities

• Build new environments using Oracle OEM Cloud Control and Data Guard
• Administer Oracle and cloud-native database technologies (AWS RDS, Aurora, DynamoDB), including installation, configuration, OEM management, and lifecycle maintenance
• Develop, maintain, and optimize PL/SQL procedures, queries, schema changes, and data structures to support efficient storage, retrieval, and application performance
• Implement and enforce database security policies, user account management, data at rest/in transit protections, and Oracle Label Security (OLS)
• Lead database migration efforts, including transitioning Oracle on-premises environments to AWS RDS, and design solutions for resilience and high availability
• Troubleshoot performance bottlenecks, locking issues, and system anomalies while directing performance optimization and structural redesign efforts
• Maintain the integrity, security, and availability of database(s)
• Establish and maintain database user accounts
• Administer, maintain, and implement policies and procedures for ensuring the security and integrity of the database(s)
• Organize and format data for efficient query and storage processes
• Evaluate requirements and recommend available DBMS products
• Provide server administration with a variety of database products that include Oracle, SQL Server, and SYBASE
• Perform disaster recovery, performance analysis and tuning, index maintenance, and monitoring of data
• Develop policies and procedures for ensuring the security and integrity of the database(s)
• Perform database and software life-cycle activities to ensure highest level of system performance and availability
• Support data modeling activities by way of prototype database implementation
• Coordinate database architecture changes with Database Engineers (DBEs)
• Direct the monitoring, administration, and implementation of performance on database systems as well as database performance optimization, developing/changing database indices, redesigning database structure, and reloading data into a database
• Direct the installation of database management systems, databases, tables, and views
• Direct the administration and use of current and emerging database tools, strategies, and technologies

Requirements

• Ten (10) years' experience as a DBA in programs and contracts of similar scope, type, and complexity is required
• Bachelor's degree in a technical discipline from an accredited college or university is required
• Four (4) years of additional DBA experience may be substituted for a bachelor's degree