Database Administrator Architect

Database Administrator Architect
Location: Washington, D.C. - supporting federal data infrastructure operations

Blue Rose Consulting Group, Inc. (Blue Rose) is seeking a skilled Database Administrator Architect to support a federal client in designing, maintaining, and optimizing secure database systems in a mission-critical environment.

In this role, you will contribute to the development and management of enterprise data infrastructure at the analyst level by supporting database administration, automation, and architectural design. Utilizing analytical capabilities and coding skills, you will work within a collaborative environment to ensure high availability, performance, scalability, and reliability of database systems supporting federal operations.

Responsibilities

As a Database Administrator Architect, you will:

• Configure, maintain, and optimize new and existing database systems including Oracle, PostgreSQL, MySQL, and Redshift
• Design and implement database architectures that support scalability, performance, and high availability
• Develop and maintain backup and recovery strategies and architectures to ensure data integrity
• Troubleshoot database performance issues and conduct root cause analysis
• Write, test, and optimize SQL queries, stored procedures, packages, and database functions
• Troubleshoot SQL queries
• Generate DDL scripts for database objects and schema management
• Develop automation scripts using Python and shell scripting for database operations, automation, maintenance, monitoring, and reporting
• Build automation workflows using tools such as Ansible
• Automate ETL processes and data integration workflows
• Develop monitoring and alerting solutions for database environments
• Create reusable code modules for common database tasks
• Collaborate with cross-functional teams in an Agile environment to support data operations

Schedule & Shift Details

• Full-time (40 hours/week)
• On-site support in Washington, DC
• Participation in on-call rotation for production support may be required

Requirements

• U.S. Citizenship or Dual Citizenship required
• Ability to obtain and maintain a Public Trust clearance
• Bachelor's degree in Computer Science, Information Technology, or related field (or equivalent experience)
• Minimum of 1-3 years experience in database administration, development, or related technical roles
• Minimum of 0-2 years experience in Python software development and shell scripting for automation
• Minimum of 0-2 years experience in database automation
• Minimum of 0-2 years experience in Agile methodology
• Minimum of 0-2 years experience in SQL query writing
• Knowledge of one coding language required (academic project experience acceptable)
• Demonstrated understanding of database architecture, design principles, and normalization
• Strong analytical mindset with problem-solving capabilities

Why Join Blue Rose?

• Support mission-critical federal data infrastructure and database operations
• Work with modern database technologies and automation tools
• Collaborate with experienced technical teams in a secure government environment
• Opportunity to grow technical expertise in database engineering and cloud data systems

Apply Today

Email: bluerosestaffing@bluerose-consulting.com
Website: www.bluerose-consulting.com/careers
LinkedIn: https://www.linkedin.com/company/blue-rose-consulting-group-inc/