We are looking for a SQL developer + Database Administrator who will be responsible for designing databases and ensuring their stability, reliability, and performance. You will also work with other developers optimizing in-application SQL statements as necessary and establishing best practices. You will help solve all database usage issues and come up with ideas and advice that can help avoid such problems in the future.
This is an internal client-facing role that requires strong data-driven decision-making, excellent communication skills, and the ability to work cross-functionally with different business units.
Key Responsibilities:
- SQL Developer:
- Design, develop, and maintain SQL databases.
- Write and optimize SQL queries, stored procedures, and functions.
- Ensure data integrity, security, and performance of databases.
- Troubleshoot and resolve database issues.
- Collaborate with other developers and stakeholders to understand requirements and implement solutions.
- Participate in database design and architecture.
- Document database schemas and procedures.
- Perform database backups, restores, and migrations.
- Database Administrator
- Installing, configuring, and maintaining database systems.
- Monitoring database performance and identifying areas for improvement.
- Optimizing database structures and queries for efficiency.
- Ensuring data integrity and consistency.
- Developing and implementing backup and recovery plans.
- Implementing and enforcing security measures to protect sensitive data.
- Managing user access and permissions.
- Monitoring security breaches and vulnerabilities.
- Working with developers to design and implement new database features.
- Collaborating with other IT professionals to ensure smooth database operations.
- Providing technical support to users.
Required Skills & Experience:
- 3-5+ years of experience as a SQL Developer + Database administrator.
- Excellent analytical and problem-solving skills.
- Good communication and collaboration skills.
- Proficiency in SQL (e.g., SQL Server, MySQL).
- Experience with database design and modeling.
- Knowledge of database performance tuning and optimization.
- Familiarity with database security best practices.
- Experience with data migration and ETL processes.