Database Administrator Architect

Database Administrator Architect

Location: Remote

Need active security clearance

This role is ideal for a technical professional who enjoys working at the intersection of database administration, architecture, and automation, with a developing proficiency in writing efficient code and optimizing database systems.

Key Responsibilities:

• Standing up new databases and Configure, maintain, and optimize new and existing database systems (Oracle, PostgreSQL, Redshift, MySQL, etc.)
• Implement and maintain backup and recovery strategies
• Troubleshoot database performance issues and perform root cause analysis
• Design high-availability and disaster recovery architectures
• Optimize database structures for performance and scalability
• Develop, test, and optimize stored procedures, functions, and packages
• Help with SQL queries troubleshoot
• Generate DDL scripts for database objects and schema management
• Automation & Scripting (knowledge of one coding language is required, university last year project is counted)

• Develop Python scripts for database automation, monitoring, and reporting
• Create shell scripts for database maintenance, backups, and operational tasks
• Build automation workflows using Ansible or similar tools
• Automate data extraction, transformation, and loading processes
• Develop monitoring and alerting solutions for database environments
• Create reusable code modules for common database tasks

Required Skills & Qualifications/ Core Competencies

• Understand database architecture, design principles, and normalization
• Knowledgeable in Python and shell scripting for automation
• Analytical mindset with problem-solving capabilities

Education & Experience

• Bachelor's degree in Computer Science, Information Technology, or related field (or equivalent experience)
• 1-3 years of experience in database administration and development

Work Environment

• Collaborative team environment with cross-functional interaction
• On-call rotation for production support may be required

Dynamic environment with opportunities for skill development and growth