Database Architect
Full Time
No Travel Required
On-site
Depends on Experience
Global CI
Fitment
Dice Job Match Score™
🔗 Matching skills to job...
Job Details
Skills
- Amazon S3
- Amazon DynamoDB
- Amazon RDS
- Clustering
- Amazon Web Services
- Database Administration
- Data Modeling
- Data Warehouse
- NoSQL
- Microsoft Power BI
- Python
Summary
Key Required Skills:
Database Architecture, experience with AWS, snowflake, SQL, and automation and scripting.
Position 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 for 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 audience.
- Provide guidance/support to other junior/mid-level developers.
- All other duties as assigned or directed.
(Basic Qualifications)
- 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)
- Skilled 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
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
- Dice Id: 10112157
- Position Id: 8911410
- Posted 1 day ago
Company Info
About Global CI
We were founded in 1992 on the principles of providing high quality, value-added technology consulting services. Over the years, we have remained dedicated to this ideal, and are proud to provide industry specific expertise with deep domain knowledge in Healthcare, Public, and Private Sectors. We currently provide a coast-to-coast footprint, with clients represented in more than 20 states.
Create job alert
Never miss an opportunity! Create an alert based on the job you applied for.Similar Jobs
It looks like there aren't any Similar Jobs for this job yet.
Search all similar jobs