Position Overview
We are seeking a highly skilled Database Expert to join our data team as a Senior Data Solutions Architect. This role requires a comprehensive understanding of database architecture, cloud infrastructure, and advanced analytics to drive data-driven decision making across the organization. The ideal candidate will have extensive experience with AWS cloud services, ETL pipeline development, and business intelligence solutions.
Key Responsibilities
Database Architecture & Administration
- Design, implement, and maintain scalable database architectures across multiple environments
- Optimize database performance, security, and reliability for high-volume transactional and analytical workloads
- Establish and enforce database standards, policies, and best practices
- Monitor database health, perform capacity planning, and implement disaster recovery strategies
- Manage database security, access controls, and compliance requirements
Cloud Infrastructure Management
- Architect and deploy database solutions using AWS RDS, including MySQL, PostgreSQL, Oracle, and SQL Server instances
- Configure and optimize RDS parameter groups, security groups, and backup strategies
- Implement multi-AZ deployments, read replicas, and automated failover mechanisms
- Manage database migrations to cloud environments and version upgrades
- Utilize AWS services including VPC, IAM, CloudWatch, and AWS Backup for comprehensive data management
ETL Pipeline Development
- Design, develop, and maintain robust ETL pipelines to integrate data from multiple sources
- Create automated data ingestion processes for batch and real-time data streams
- Implement data validation, cleansing, and transformation logic
- Optimize pipeline performance and ensure data quality throughout the process
- Schedule and monitor ETL jobs, implementing error handling and alerting mechanisms
Business Intelligence & Analytics
- Develop and maintain business intelligence solutions using AWS QuickSight
- Create interactive dashboards, reports, and data visualizations for stakeholders
- Design and implement data models optimized for analytical queries
- Collaborate with business users to understand reporting requirements and translate them into technical solutions
- Establish KPIs and metrics to measure business performance
Data Science Support
- Prepare and structure large, complex datasets for machine learning and statistical analysis
- Collaborate with data scientists to optimize data access patterns and query performance
- Implement feature stores and data pipelines supporting ML model training and inference
- Ensure data governance and lineage tracking for analytical workloads
Required Qualifications
Technical Skills
- Database Expertise: 5+ years of experience in database administration and architecture with MySQL, PostgreSQL, Oracle, or SQL Server
- AWS Cloud Services: Proven experience with AWS RDS, including configuration, optimization, and management
- ETL Development: Strong background in designing and implementing ETL pipelines using tools such as AWS Glue, Apache Airflow, or similar platforms
- Business Intelligence: Hands-on experience with AWS QuickSight for dashboard and report development
- Programming: Proficiency in SQL, Python, and/or R for data manipulation and analysis
- Data Modeling: Experience with dimensional modeling, star/snowflake schemas, and data warehouse design
Analytical Skills
- Demonstrated ability to analyze large, complex datasets and extract meaningful insights
- Experience with statistical analysis and data mining techniques
- Strong problem-solving skills and attention to detail
- Ability to translate business requirements into technical solutions
Professional Experience
- Bachelor’s degree in Computer Science, Information Systems, Mathematics, or related field
- 7+ years of experience in database management and data engineering roles
- Experience working with enterprise-scale data environments
- Previous experience in cloud migration projects preferred
Preferred Qualifications
- AWS certifications (Database Specialty, Solutions Architect, or Data Analytics)
- Experience with additional AWS services such as Redshift, Athena, EMR, or Kinesis
- Knowledge of data governance frameworks and regulatory compliance (GDPR, HIPAA, SOX)
- Experience with Infrastructure as Code tools (CloudFormation, Terraform)
- Familiarity with containerization technologies (Docker, Kubernetes)
- Background in Agile/DevOps methodologies
What We Offer
- Competitive salary and comprehensive benefits package
- Opportunity to work with cutting-edge cloud technologies and large-scale data systems
- Professional development and AWS certification support
- Collaborative environment with cross-functional teams
- Flexible work arrangements and career growth opportunities
We are an equal opportunity employer committed to diversity and inclusion in the workplace.