Database Administrator Skill Level 2 [D.26.0164]

• Candidate would be expected to be “On call” to support system operations.
• 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 recommends 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 Engineer (DBE)s
• Direct the monitoring, administrating, and implementing 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

Directs the administration and use of current and emerging database tools, strategies and technologies

Position Responsibilities

• Maintain the integrity, security, availability, and performance of multiple databases, including disaster recovery, monitoring, tuning, and index/partition optimization.
• 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 prem 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.
• Evaluate DBMS products, recommend solutions, and guide the adoption of emerging database tools, technologies, and best practices.

Basic Qualifications: 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., * Oracle

• OEM Management
• Red Hat Linux 7/8
• Git
• Puppet
• VMware
• Docker
• Kubernetes
• AWS / AWS Managed Databases including NoSQL databases
• Schema design and optimization
• Data modeling
• AWS Database Migration Service (DMS)