Responsibilities:
- Collaborate with stakeholders, including software developers, system analysts, and business users, to understand database requirements and translate them into technical specifications.
- Design, develop, and implement database schemas, tables, views, stored procedures, and functions using SQL and database management systems (DBMS) such as MySQL, PostgreSQL, Oracle, or SQL Server.
- Develop and maintain ETL processes to extract, transform, and load data from various sources into databases, ensuring accuracy, consistency, and timeliness.
- Optimize database performance by fine-tuning queries, indexes, and database configurations, and implementing best practices for data storage, retrieval, and caching.
- Monitor database systems for performance, availability, and security vulnerabilities, and implement proactive measures to maintain reliability and uptime.
- Ensure data integrity, consistency, and security by implementing appropriate access controls, encryption mechanisms, and backup/recovery strategies.
- Troubleshoot database-related issues, diagnose problems, and implement solutions in a timely manner to minimize downtime and impact on business operations.
- Document database designs, configurations, and procedures, and provide technical support and guidance to other team members as needed.
- Stay updated with the latest trends, technologies, and best practices in database development and administration, and assess their potential impact on our organization's database strategy and roadmap.
- Collaborate with IT teams, vendors, and external partners to integrate databases with other systems and applications, and ensure seamless data flow and interoperability.
Must Have:
- Bachelor's degree in Computer Science, Information Systems, or a related field. (Master's degree preferred)
- Proven experience as a Database Developer, Database Administrator, or similar role, with expertise in designing, implementing, and managing relational databases.
- Strong proficiency in SQL programming and database management systems (DBMS) such as MySQL, PostgreSQL, Oracle, or SQL Server.
- Experience with database design, normalization, indexing, partitioning, and performance tuning techniques.
- Familiarity with ETL tools and processes, data modelling tools, and version control systems (e.g., Git).
- Knowledge of database security principles, access controls, encryption, and compliance requirements (e.g., GDPR, HIPAA).
- Excellent analytical and problem-solving skills, with the ability to understand complex data models, troubleshoot database issues, and implement effective solutions.
- Strong communication and interpersonal skills, with the ability to collaborate effectively with cross-functional teams and stakeholders at all levels of the organization.
- Ability to work independently and proactively, manage multiple tasks and priorities, and deliver high-quality results on time and within budget.
- Certifications in database technologies (e.g., Oracle Certified Professional, Microsoft Certified: Azure Database Administrator Associate) are a plus.
Job Types: Full-time, Contract
Pay: From $50.00 per hour
Work Location: In person