Database Architect

Omm IT Solutions

Gwynn Oak, MD

Job Description
PLEASE NOTE:

IT IS 100% ON-SITE POSITION IN WOODLAWN
The selected candidate must be able to obtain and maintain a public trust clearance
The selected candidate must be willing to work on-site in Woodlawn, MD, 5 days a week

Key Required Skills:

Database architecture experience with AWS, Snowflake, SQL, and automation and scripting.

DESCRIPTION:

Utilize the AWS database and data processing services, including Amazon RDS, AuroraDB, DynamoDB, Redshift, ElastiCache, EMR, and Neptune.
Configure, launch, and manage EMR clusters, optimizing for performance and cost, and integrating with various data sources.
Architect scalable, high-performance, and secure database solutions.
Integrate databases with other AWS services such as Lambda, S3, EC2, and Glue.
Utilize AWS security best practices (IAM, encryption, VPC, security groups) and compliance requirements for data storage.
Design backup, disaster recovery, high availability, and failover solutions (Multi-AZ, read replicas).
Troubleshoot AWS-related issues and incidents.
Design, implement, and manage virtual data warehouses in Snowflake.
Write complex SQL queries for data analysis, transformation, and reporting.
Optimize queries; manage caching, clustering, and leveraging auto-scaling to handle workloads.
Ensure compliance with SSA security, privacy, and data management policies.
Brief management, customer, team, or vendors using written or oral skills at appropriate technical level for the audience.
Provide guidance/support to other junior/mid-level developers.
All other duties as assigned or directed.

Requirements

Skills Requirements
BASIC QUALIFICATION

Bachelor's Degree in Computer Science, Mathematics, Engineering or a related field; Masters or Doctorate degree may substitute for required experience
7+ years as a Database Architect.
Experience in AWS database and data processing services, including Amazon RDS, AuroraDB, DynamoDB, Redshift, ElastiCache, EMR, and Neptune.
Knowledgeable in AWS security best practices (IAM, encryption, VPC, security groups) and compliance requirements for data storage.
Strong troubleshooting skills for AWS related issues and incidents.
Skilled in optimizing queries, managing caching, clustering, and leveraging auto-scaling to handle workloads.
Proficient in automation and scripting (CloudFormation, Terraform, AWS CLI, Python, Bash, PowerShell) for database and workflow management.

REQUIRED SKILLS

killed in both relational and NoSQL database management, data modeling, normalization, and schema design.
Experienced in configuring, launching, and managing EMR clusters, optimizing for performance and cost, and integrating with various data sources.
Skilled in designing backup, disaster recovery, high availability, and failover solutions (Multi-AZ, read replicas).
Advanced skills in writing complex SQL queries for data analysis, transformation, and reporting.

AWS Experience:

Proven ability to architect scalable, high-performance, and secure database solutions, with proficiency in query optimization, indexing, caching, and performance tuning using AWS tools.
Experienced in integrating databases with other AWS services such as Lambda, S3, EC2, and Glue.
Adept at securing AWS clusters, managing IAM roles, implementing encryption, and monitoring jobs using AWS tools (CloudWatch, CloudTrail).

Snowflake Experience:

Proficient in designing, implementing, and managing virtual data warehouses in Snowflake, with a strong understanding of micro-partitions.
Experienced in schema design, normalization, and building efficient data structures in Snowflake.
Familiar with data ingestion, transformation, and loading using Snowflake's features and integration tools.
Knowledgeable in Snowflake's role-based access control, data encryption, and security best practices.
Experienced in integrating Snowflake with BI tools (Tableau, Power BI) and using Python for data pipelines and machine learning applications

DESIRED SKILLS

Experience identifying requirements, researching options, designing, and implementing solutions at a leadership level on project work.
Experience scripting in a Linux environment to automate ETL solutions and data migration jobs.
Understand and apply quality techniques and practices (automated unit testing, Test Driven Design/Development, performance analysis, continuous integration)
Ability to assist with architectural tactical thinking, information solutions and road maps to drive architectural recommendations.
Detail oriented and committed to consistently completing repetitive production-like tasks on-time and error-free.
Prior experience working in a federal agency or public sector environment.
Effective communication skills for working with cross-functional teams, including data scientists, analysts, and business stakeholders.
Ability to translate technical concepts into non-technical terms for business stakeholders.
Ability to manage multiple projects, prioritize tasks, and deliver within deadlines

Apply

Vacancy posted 1 day ago

Similar jobs that could be interesting for youBased on the Database Architect in Gwynn Oak, MD vacancy

Data Modeler/Data Architect
Company DescriptionSonSoft is an IT Staffing and consulting firm and duly organized under the laws of the Commonwealth of Georgia. We are growing at a steady pace specializing in the fields of Software Development, Software Consultancy and Information Technology Enabled...
Suggested
Permanent employment
Full time
H1b
Sonsoft
Baltimore, MD
2 days ago
Data Engineering & Analytics
$150k - $190k
...extend the lives of patients battling some of the most aggressive cancers. Every role here contributes to that mission - and as a Data Architect, you'll help shape the future of how data powers our business, drives innovation, and ultimately impacts patient outcomes. This is...
Suggested
Novocure
Baltimore, MD
5 days ago
Data Architect
...card, GC EAD and H1B are encouraged to apply. We are unable to sponsor at this time.At least fifteen (15) years of experience in architecting on-prem/cloud based multi user environments with expertise in planning, designing, building, and implementing IT application...
Suggested
H1b
Georgia IT Inc
Baltimore, MD
3 days ago
Data Architect
...Data ArchitectThis is a Sr. Data Architect role Enterprise Data Architecture Team. This person will help us Modern Data Management - Architecture and Practices. Define new approach to Data Modeling - we are looking for different options that are close to development and...
Suggested
Samprasoft
Baltimore, MD
3 days ago
Data Architect
...or other related scientific or technical discipline is required.General Experience:At least Fifteen (15) years of experience in architecting on-prem/cloud based multi user environments with expertise in planning, designing, building, and implementing IT application modernization...
Suggested
Work from home
Staffing the Universe
Baltimore, MD
3 days ago
Data Architect
...This role focuses on establishing strong data interfaces and interconnectivity of our integrated JOMIS product ecosystem. The data architect will help to build a strong data foundation that supports operational medicine, reporting, analytics, and future AI capabilities....
Full time
Mulu
Baltimore, MD
3 days ago
Big Data Hadoop Architect
...Flume, Sqoop, Hbase etc. to complete POCs, review code and guide the team.Should have had experience in playing the role of a lead architect for at least 2-3 Big Data implementations.Should have in-depth experience in implementing Big data platforms on one of the leading...
Permanent employment
Full time
Work experience placement
H1b
Sonsoft
Baltimore, MD
2 days ago
Lead Data Analyst- Investment Data Strategy (Washington DC or Baltimore, MD)
$122k - $209k
...investment management, data strategy, architecture, and technology delivery.The successful candidate will partner with Data Engineers, Architects, Front Office Stakeholders (Portfolio Managers, Traders, Research Analysts, Quants), and Technology Leaders to define and deliver...
Full time
Local area
Remote work
Work from home
3 days per week
T. Rowe Price
Baltimore, MD
12 hours ago
Remote Senior Data Architect
..., Python, C#, C, and .NET. Must be familiar with various databases, including Microsoft Access, Postgres, MySQL, Sybase, Firebird... ...analysis tools and processes. What you'll do: The Data Architect shall develop, build, and maintain utilities and scripts for...
Temporary work
Work at office
Remote work
GrabJobs
Baltimore, MD
2 days ago
Big Data Hadoop Technology Architect
...Flume, Sqoop, HBase etc. to complete POCs, review code and guide the team.Should have had experience in playing the role of a lead architect for at least 2-3 Big Data implementations.Should have in-depth experience in implementing Big data platforms on one of the leading...
Permanent employment
Full time
Work experience placement
H1b
Sonsoft
Baltimore, MD
4 days ago
Sr. Enterprise AI Data Architect
$121k - $206k
...responsible for enterprise capabilities including vendor solutions as product owners. Role SummaryAs a Senior Enterprise AI Data Architect, you will lead the design, governance, and evolution of enterprise data and AI architecture capabilities across the firm. This role...
Full time
Local area
Remote work
Work from home
3 days per week
T. Rowe Price
Baltimore, MD
4 days ago
Lead Data Analyst
...analysis. Demonstrates expertise in statistical applications such as SPSS, SAS, R, STATA, and Excel. Use statistical, reporting, database, and visualization tools such as SAS, SPSS, R, STATA, SQL, Power BI, Excel, and Banner or similar systems to extract, analyze, summarize...
Work at office
Immediate start
Flexible hours
Association for Institutional Research
Baltimore, MD
1 day ago
Power BI Reporting Analyst
$45 - $50 per hour
Power BI Reporting Analyst100% Remote | Monday-Friday | 8:00 AM-5:00 PMCompetitive Pay + Career Growth OpportunityAre you passionate about turning data into actionable business insights? We're partnering with a growing organization seeking a Power BI Reporting Analyst to...
Contract work
Temporary work
Remote work
Monday to Friday
TEKsystems
Baltimore, MD
4 days ago
Senior Analyst, Data Analytics - Data Enablement Team
$96.5k - $164k
At T. Rowe Price, we identify and actively invest in opportunities to help people thrive in an evolving world. As a premier global asset management organization with more than 85 years of experience, we provide investment solutions and a broad range of equity, fixed income...
Full time
Work experience placement
Local area
Remote work
Work from home
1 day per week
T. Rowe Price
Baltimore, MD
2 days ago
Senior Analytical Reporting Analyst - ALM & Power BI Development (Hybrid)
$97k - $110k
Job FamilyTreasury, Capital Management and Asset Liability ManagementAbout Us At Transamerica, hard work, innovative thinking, and personal accountability are qualities we honor and reward. We understand the potential of leveraging the talents of a diverse workforce. We...
Full time
Contract work
Work at office
Remote work
Worldwide
Visa sponsorship
Transamerica
Baltimore, MD
1 day ago
Information Technology Analyst
$55k - $70k
Get AI-powered advice on this job and more exclusive features. This range is provided by Franklin Fitch. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more. Base pay range $55,000.00/yr - $70,000.00/yr Direct message the...
Full time
Work at office
Remote work
Franklin Fitch
Baltimore, MD
2 days ago
Information Technology Analyst
Insight Global is seeking a Tier 2 Information Systems (IS) Analyst to provide advanced technical support for employees and business applications across the enterprise. This role serves as the escalation point for complex technical issues that cannot be resolved by the...
Permanent employment
Insight Global
Baltimore, MD
5 days ago
Enterprise Data Architect
$102.41k - $212.71k
...DevSecOps Experience with enterprise data strategy Knowledge of DoDAF Preferred Active Top Secret/SCI eligibility TOGAF Azure Solutions Architect Cloud certifications Experience supporting cyber operations organizations Additional Information Normal office conditions with...
Contract work
Work at office
Monday to Friday
Weekend work
Afternoon shift
SOSi
Baltimore, MD
3 days ago
Jr. Data Analyst
Junior Data AnalystThe Junior Data Analyst is responsible for designing, developing, and maintaining multifamily analytics and reporting to support informed decision-making across the organization. This role focuses on building and maintaining Power BI and SQL-based reports...
Full time
Sage Ventures LLC
Pikesville, MD
2 days ago
Data Analyst
...analysis, reporting, and decision-support outputs.Collect, validate, organize, and analyze data from multiple sources, including client databases, web-based sources, reporting platforms, and other program resources.Use analytical tools, SQL, Python, Excel, BI/reporting...
Index Analytics LLC
Baltimore, MD
5 days ago
Junior Data Analyst
$100k
...interested please email them or ask them to take you off their distribution list and make you unavailable as they share the same database with the client servicing team who only connect with candidates who are matching client requirements.No phone calls please. Shortlisted...
Full time
H1b
SynergisticIT
Baltimore, MD
3 days ago
Data Analyst
$100k
...interested please email them or ask them to take you off their distribution list and make you unavailable as they share the same database with the client servicing team who only connect with candidates who are matching client requirements. No phone calls please. Shortlisted...
Full time
H1b
SynergisticIT
Baltimore, MD
3 days ago
Data Analyst
...program team please email them or ask them to take you off their distribution list and make you unavailable as they share the same database with the client servicing team.We regularly interact with the top tech companies to give our candidates a competitive advantage-...
Full time
H1b
SynergisticIT
Baltimore, MD
3 days ago
Senior Data Analyst
State of Maryland's Department of Labor seeks a Data Analyst for the Family and Medical Leave Insurance (FAMLI) program. You will collect, validate, and analyze operational data from multiple sources to produce actionable insights, informing decisions and monitoring division...
State of Maryland
Baltimore, MD
1 day ago
Big Data Consultant
Company DescriptionSonsoft , Inc. is a USA based corporation duly organized under the laws of the Commonwealth of Georgia. Sonsoft Inc. is growing at a steady pace specializing in the fields of Software Development, Software Consultancy and Information Technology Enabled...
Contract work
Work experience placement
H1b
Sonsoft
Baltimore, MD
4 days ago
Data Analyst Supporting the FBI
$26 per hour
...sources. Ensures completeness of received information and reconciles inconsistencies. Accurately enters required data into one or more databases, documents, or spreadsheets. Establishes and maintains physical files. Keeps track of case file status in order to ensure...
Hourly pay
Full time
Temporary work
Work at office
Local area
Remote work
Flexible hours
FSA Federal
Baltimore, MD
3 days ago
Data Analyst
Data Analyst - SNOW APM X2100% Remote1 year +Government ConsultingTwo Data Analysts needed to participate in clients data migration from Planview to ServiceNow Application Portfolio Management (APM).Strong experience and knowledge of ServiceNow APMUnderstanding of how ...
Software Technology Inc
Gwynn Oak, MD
3 days ago
Remote Data Analyst
...that combines advanced software, radio-frequency identification (RFID) technology, a dedicated customer-support team, and a secure database to track and trace cannabis from growth, harvest, and processing to testing, transport, and sale. As Data Analyst, you will have...
Full time
Remote work
GrabJobs
Baltimore, MD
3 days ago
Data Analyst
Index Analytics LLC seeks a Senior Data Analyst / Researcher to transform complex federal healthcare data into actionable insights. You will apply advanced analytics across Medicaid/CHIP datasets and engage with stakeholders to support policy and program decisions. Lead...
Index Analytics LLC
Windsor Mill, MD
1 day ago
Senior Data Analyst
$145k - $175k
Luxury Presence is building the AI growth platform for real estate. Backed by Bessemer Venture Partners and other top investors, we're a Series C company that has hit $100M in annual recurring revenue. More than 90,000 real estate professionals, including over 30% of the...
Live in
Shift work
GrabJobs
Baltimore, MD
4 days ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to Database Architect. Be the first to apply!