Job Description
Job Description
Job brief
We are seeking a seasoned Database Administrator with extensive experience managing SQL Server 2017 and newer environments . The ideal candidate will bring 8+ years of hands-on expertise in backup and recovery, performance tuning, user access control, and database integrity. Youll be responsible for developing SQL scripts and stored procedures, managing SQL Server Agent Jobs, and maintaining SSIS packages using Visual Studio. This role requires a proactive individual with a sharp eye for performance optimization and a solid foundation in SQL best practices.
Responsibilities
- Administer and maintain SQL Server 2017 and later database environments
- Perform database backups and restores regularly
- Enforce data integrity using primary / foreign keys, indexes, and unique constraints
- Manage user access and permissions across multiple databases and schemas
- Review execution plans and optimizes code for improved performance
- Plan for database growth and ensure proper capacity management
- Use Visual Studio to build, update, and maintain SSIS packages
- Develop and manage SQL scripts , stored procedures, views, and functions
- Configure and maintain SQL Server Agent Jobs
- Integrate email alerts and notifications into scheduled jobs and scripts
Requirements Technical Skills
Minimum 8 years of experience in SQL Server database administrationProficiency with SQL Server 2017 and aboveDeep knowledge of :Backup and restore strategiesSQL development (stored procedures, views, functions)Job scheduling and maintenance using SQL Server AgentUser and role management within databasesQuery optimization and execution plan analysisCapacity planning and database scalingTools & Integration
Familiarity with integrating email notifications into SQL workflowsSoft Skills
Excellent analytical and problem-solving abilitiesHigh attention to detail with a proactive approach to database healthStrong interpersonal skills and ability to work both independently and collaboratively