SQL Server Administration
- Install, configure, and maintain SQL Server instances across development, test, and production environments.
- Perform regular database maintenance, including backups, restores, indexing, and patching.
- Monitor and optimize database performance and troubleshoot performance issues.
- Ensure database security, access controls, and compliance with internal policies.
Development Support
- Collaborate with development teams to support database-related requests, new feature development, and troubleshooting.
- Design, write, and optimize stored procedures, functions, views, and complex SQL queries.
- Assist with database design, schema changes, and data modeling activities.
- Provide guidance on SQL best practices and efficient data access patterns.
Reporting & Data Integration
- Build and maintain complex Power BI reports and datasets, incorporating data from multiple tables, systems, and applications.
- Create or optimize data models and dataflows to support reporting needs.
- Ensure accuracy, performance, and reliability of BI solutions.
- Collaborate with stakeholders to gather reporting requirements and translate them into technical solutions.
System Monitoring & Maintenance
- Implement monitoring tools and processes to ensure database health, uptime, and performance.
- Proactively identify and resolve database or data quality issues.
- Support disaster recovery planning, testing, and execution.
SOC2 Protocols:
- Assist with SOC2 protocols compliance by implementing and maintaining security controls.
- Conduct regular audits and assessments to verify adherence to SOC2 standards.
- Develop and enforce policies and procedures to safeguard sensitive data.
- Collaborate with the security team to address any vulnerabilities or risks identified during SOC2 audits.