What are the responsibilities and job description for the Database Administrator position at Crystal Management?
Who We Are.
At CMIT, we do more than provide real-world solutions. We deliver transformative results. Through cutting-edge technology and process innovations, we are changing how federal and commercial clients worldwide deliver their mission. A service-disabled veteran-owned small business, we take pride in serving our nation through exemplary support for our clients and employees alike.
DATABASE ADMINISTRATOR
CMIT is looking for a highly skilled Database Administrator to design, optimize, and manage our FAST FAMS database systems. The ideal candidate will have strong expertise in PostgreSQL and a passion for performance tuning and scalability. Experience with AWS RDS and AWS DMS is highly desirable, while familiarity with AWS data processing services like Kinesis, EventBridge, Athena, Glue, and Firehose is a plus. This role is perfect for someone who enjoys solving complex problems, taking initiative in undefined spaces, and working with a collaborative, high-performing team.
Responsibilities
- Design, implement, and maintain PostgreSQL databases ensuring high availability, reliability, and security.
- Perform query optimization, indexing strategies, and performance tuning to enhance database efficiency.
- Manage database monitoring, troubleshooting, and capacity planning to ensure optimal performance.
- Work with AWS RDS for database deployment, maintenance, and automation.
- Utilize AWS Database Migration Service (DMS) for database migration and replication.
- Collaborate with development teams to implement best practices for data modeling, schema design, and ETL processes.
- (Nice to have) Work with AWS data services such as Kinesis, EventBridge, Athena, Glue, and Firehose to support data processing and analytics.
- Develop and maintain backup strategies and disaster recovery plans for mission-critical systems.
- Ensure database security, compliance, and governance following industry standards.
- Other duties as assigned
Qualifications Required
- 5 years of experience with PostgreSQL, including advanced query optimization and performance tuning
- Strong knowledge of indexing strategies, query execution plans, and database internals.
- Experience managing AWS RDS for PostgreSQL in production environments.
- Hands-on experience with AWS DMS for data migration and replication.
- Proficiency in SQL, PL/pgSQL, and scripting (Python, Bash, etc.) for automation.
- Strong experience with database backup, restore, and disaster recovery strategies.
- Ability to troubleshoot and optimize database performance under real-world constraints.
Preferred Skills
- Experience with AWS data services (Kinesis, EventBridge, Athena, Glue, Firehose).
- Familiarity with NoSQL databases (DynamoDB, Redis, etc.) in AWS environments.
- Understanding of data warehousing concepts and ETL pipelines.
- Experience with Infrastructure-as-Code (Terraform, CloudFormation).
- Exposure to CI/CD pipelines and DevOps best practices for database deployments
Clearance Required
- Active or ability to obtain a TSA Clearance is required
Who Makes It Happen.
At CMIT, we firmly believe that our innovative solutions are only as powerful as the teams harnessing them. Our people are more than just contributors - they are at the heart of everything we do and every success that we earn. Our employees are offered ample options to design a personalized benefits package that best meets their needs. Options include:
- Medical / Rx
- HSA / FSA
- Dental & Vision
- Life / AD&D
- Long & Short Disability
- Disability Insurance
- Accident Insurance
- Critical Illness
- Hospital Insurance
- Pet Benefits
- Education/Training Program
- 401k Retirement
- Generous Paid Time Off
- Flexible Parental Leave
- Volunteer Time Off
- Flexible Work Locations
- Alternative Work Schedules
CMIT provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, or any other characteristic protected by federal, state, or local laws. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training.