What are the responsibilities and job description for the Database Architect position at IO Associates?
Job Details
Job Title: Database Engineer
Job Description: We are looking for an experienced Database Engineer to design, implement, and maintain robust database solutions that drive our software applications, analytics, and reporting functions. The ideal candidate will possess strong technical expertise in database architecture, performance optimization, security, and cloud-based solutions while collaborating with cross-functional teams to support business objectives.
Key Responsibilities:
Database Architecture & Modeling:
Develop and implement scalable database solutions aligned with software development and analytical needs.
Design logical and physical data models to ensure efficiency, integrity, and smooth data flow.
Construct and enhance database schemas, tables, views, indexes, and stored procedures to maximize system performance.
Lead database architecture initiatives within a Kubernetes-based microservices ecosystem.
Performance Enhancement & Optimization:
Diagnose and resolve database performance challenges, applying best practices for continuous improvement.
Monitor and fine-tune database operations to ensure efficiency, particularly in high-volume or large-scale environments.
Leverage optimization tools and methodologies to enhance query execution times and resource utilization.
Cloud-Based Database Management:
Oversee database deployment and administration on cloud platforms such as AWS, Azure, or Google Cloud.
Ensure seamless integration and efficient data management across cloud-based environments.
Data Security & Compliance:
Implement robust security protocols to protect sensitive data and maintain compliance with industry regulations.
Define and enforce access control policies to uphold data confidentiality, integrity, and availability.
Conduct security audits and collaborate with cybersecurity teams to ensure best practices in data protection.
Collaboration & Documentation:
Work closely with developers, analysts, and stakeholders to understand data requirements and usage patterns.
Provide guidance on database best practices and data governance.
Maintain comprehensive documentation of database architecture, configurations, and operational procedures.
Maintenance & Troubleshooting:
Manage backup, recovery, and failover processes to minimize downtime and data loss.
Diagnose and resolve database-related issues, implementing preventative measures to enhance system stability.
Stay up to date with database patches, emerging technologies, and new feature implementations.
Software Development Integration:
Apply object-oriented programming principles to database interactions.
Utilize Java and/or Python for database management within cloud environments.
Required Qualifications & Experience:
Bachelor's degree in Computer Science, Information Technology, or a related discipline (or equivalent work experience).
Minimum of 5 years of experience in database design, development, and administration.
Proficiency in SQL Server, Oracle, MySQL, PostgreSQL, or equivalent database systems.
Expertise in data modeling, normalization, and indexing techniques.
Strong command of SQL and database optimization strategies.
Familiarity with NoSQL databases (e.g., Percona, MongoDB).
Knowledge of database performance monitoring tools and data warehousing principles.
Strong analytical and problem-solving abilities.
Excellent communication skills to convey complex concepts to both technical and non-technical audiences.
Ability to work independently and collaboratively while quickly adapting to new technologies.
Preferred Qualifications:
Hands-on experience with cloud database solutions such as AWS RDS, Azure SQL, or Google Cloud BigQuery.
Object-oriented programming experience.
Proficiency in Python for scripting and database interaction.
