Description:
The SQL Developer and DBA will play a critical role in designing, developing, maintaining, and optimizing database solutions to support GIC's operational and analytical needs. This position combines hands-on database administration with SQL development to ensure high availability, performance, and security of data systems. Drawing from industry best practices and the profiles of top candidates, the role emphasizes proactive monitoring, stakeholder collaboration, and agile project execution to deliver reliable data infrastructure aligned with business goals. The ideal candidate is a self-motivated professional with a blend of technical expertise and soft skills, ready to contribute to a dynamic team environment.
Key Responsibilities
The role involves a mix of administrative, developmental, and collaborative tasks. Responsibilities are prioritized based on common themes from experienced professionals in similar roles:
Database Administration
Install, configure, and administer SQL Server environments (clustered and standalone, versions 2008-2022). Perform regular backups, restores, and integrity checks (e.g., DBCC) to ensure data recovery and compliance. Proactively monitor database performance, capacity, and security using tools like Performance Monitor; optimize queries and indexes for efficiency. Manage user access, roles, and permissions; implement security best practices for databases, SSIS packages, and SSRS reports. Troubleshoot and resolve database issues, including performance bottlenecks and failover scenarios.SQL Development
Design, develop, and maintain stored procedures, triggers, functions, and complex T-SQL queries for data extraction, manipulation, and reporting. Build and deploy SSIS packages for ETL processes, data integration, and migrations. Create and customize SSRS reports and dashboards; integrate with tools like Spotfire or QlikView for business intelligence. Support data warehousing initiatives, including normalization, integrity checks, and bulk data operations.Project and Release Management
Collaborate with cross-functional teams (e.g., developers, analysts, business stakeholders) on database-related projects using Agile methodologies.- Document changes, enhancements, and operational procedures; manage releases and deployments via tools like Jira.
- Assist in strategic decisions for new systems, software upgrades, and infrastructure scaling. Provide training to end-users on reports, dashboards, and database tools.
Maintenance and Support
Conduct quality assurance on imported/exported data; resolve bugs and implement fixes in production environments. Evaluate and test updates to source systems; support ad-hoc scripting and views for operational