Database Analyst

Role: Database Administrator Architect Analyst

Work Location: Washington DC (5 days Onsite)

Role Description:

The Database Admin Architect Analyst is responsible for the design, implementation, automation, optimization and creation of database systems at the analyst level. This role combines database administration, architectural design, and analytical capabilities with knowledgeable coding and automation skills to support enterprise data infrastructure and operations.

Key Responsibilities

Database Administration & Configuration

- 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

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.