Key Responsibilities:
- Database Design and Development:
- Design and implement SQL Server databases and schemas based on business requirements.
- Develop efficient SQL queries, stored procedures, functions, and views to support application development and data analytics.
- Performance Optimization:
- Identify and resolve performance issues in SQL queries and database objects like procedures, functions, and views.
- Optimize database design for performance and scalability.
- Data Integration and Migration:
- Manage data migration, transformation, and scripting tasks.
- Integrate data from various sources into SQL Server databases.
- Database Security and Compliance:
- Implement database security best practices to protect sensitive data like Credit/Debit Cards, SSNs, etc.
- Compliance with data privacy regulations and guidelines. e.g. Compliance like CIS, DISA STIG, FERPA, GDPR, HIPAA, NERC, PCI DSS, and SOX (Good to Have)
- Monitoring and Maintenance:
- Monitor database performance, resource usage, and maintain database health (Good to Have).
- Perform routine maintenance tasks such as backups, restores, and disaster recovery procedures (Good to Have).
- Collaboration and Documentation:
- Collaborate with developers, analysts, and IT staff to ensure database solutions meet business requirements.
- Create and maintain technical documentation related to databases and data flows.
Qualifications:
- Possess 5+ years of experience as a core SQL Server Database developer.
- Proven experience as a SQL Server Database Developer or similar role.
- Proficiency in SQL programming (T-SQL) and database query optimization.
- Excellent analytical and problem-solving skills.
- Familiarity with data warehousing principles and ETL processes.
- Ability to work independently and as part of a team in a fast-paced environment.
- Good communication and interpersonal skills.