Database Administrator
C. Mack Solutions
full-time
Posted on:
Location Type: Office
Location: Ashburn • District of Columbia • Maryland • United States
Visit company websiteExplore more
Tech Stack
About the role
- Champion all aspects of data architecture, analytic methodology, and visualization functions including engineering standards, governance processes, and providing vision and context to explore and effectively utilize emerging technologies
- Work with database developers and administrators across multiple product teams
- Serve as a data and technology expert across a broad and diverse set of mission critical applications
- Actively participate in Agile Scrum sprint planning, artifact creation, sprint testing, regression testing, demonstrations, retrospectives and solution releases
- Analyze project-related problems and create innovative solutions involving technology, analytic methodologies, and advanced solution components
- Deliver deployable software in short sprints
- The ability to be adaptable and work constructively with a technically diverse and geographically separated team is crucial.
Requirements
- Must live within the DC, MD, VA area
- U.S. Citizenship is required
- Candidate must be able to obtain CBP Public Trust clearance
- College degree (B.S.) in Computer Science, Software Engineering, Information Management Systems or a related discipline
- Professional Experience: at least seven (7) years related technical experience, with databases, including designing, implementing, and optimizing database systems
- Experience with data modeling, tuning, scaling, security, backup, recovery, and integrity of RDBMS, specifically PostgreSQL in AWS
- Solid understanding of concepts such as data types, indexing, performance tuning, query plans
- Ability to take high level requirements and work with Product Architects to create a data model to store transactional data
- Understanding of Oracle, Microsoft SQL Server, or MySQL, as well as understanding of NoSQL databases like DynamoDB, MongoDB, Cassandra, or Couchbase
- Strong SQL skills for querying, analyzing, and managing data, as well as creating and maintaining stored procedures, triggers, and views
- Experience with CDC (change data capture) concepts and usage
- Knowledge of security best practices, including encryption, authentication, and access control, to ensure that sensitive data is protected and compliant with government regulations
- Experience with cloud-based database services such as Amazon Web Services (AWS) RDS, Google Cloud SQL, or Microsoft Azure SQL Database
- Experience with data integration tools and techniques, including ETL (Extract, Transform, Load) processes, and queue-based messaging systems to ensure seamless data flow between systems
- Familiarity with microservices based architecture and its impact to data storage
- Skills in analyzing and optimizing database performance, including indexing, partitioning, and query optimization
- Ability to work effectively with cross-functional teams, including developers, data analysts, and business stakeholders, to gather requirements and communicate complex database concepts
- Experience helping customers and mission users conceptualize and prioritize their data analysis and visualization needs.
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills & Tools
data architectureanalytic methodologydata modelingPostgreSQLSQLETLcloud-based database servicesCDCmicroservices architecturedatabase performance optimization
Soft Skills
adaptabilitycollaborationproblem-solvingcommunicationcross-functional teamworkinnovationvisioncontextual understandingleadershipagile methodology
Certifications
CBP Public Trust clearance