Database Administrator Architect
Location: Washington, DC/Remote/20% Onsite
Required Clearance: Public Trust
Since 1999, ITEC has delivered mission-critical support to the DoD and Intelligence Community. Now part of ManpowerGroup Public Sector (MGPS), we continue that work with expanded capabilities. Employees hired through this process will join MGPS and receive a comprehensive benefits package and competitive pay.
U.S. Citizenship Mandatory: Due to our US federal government contract, candidates for this position are required to be a US Citizen and will be subject to a background investigation.
Job 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.
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.
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.
Job 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:
- 1-3 years of experience in database administration and development
- Understand database architecture, design principles, and normalization.
- Knowledgeable in Python and shell scripting for automation.
- Analytical mindset with problem-solving capabilities.
Education:
- Bachelor's degree in Computer Science, Information Technology, or related field (or equivalent experience)
