Required for a leading Logistics Company
Experience required : 3-6 years
Location : Hyderabad
Skill set and Job Responsibilities:
- Installation and configuration of MS SQL Server
- Outstanding knowledge of SQL Server and T-SQL in constructing Stored Procedures, triggers, tables, user functions, views, indexes.
- Working Experience in designing, implementing, maintaining, and documenting complex database applications.
- Monitoring the growth of the database size & available disk spaces in servers to ensure the smooth running of daily activities.
- Performing Index tuning and rebuilding the Indexes.
- Strong knowledge of backups, restores, recovery models, database shrink operations
- Monitoring and optimizing the performance of the database.
- Designing the structure of database as per the requirements of business and that of the development team
- Support development team for complex query tuning and schema refinement.
- Writing Stored Procedures, functions whenever necessary.
- Controlling and monitoring user access to the database.
- Providing day-to-day Production Support and Maintenance for SQL Server databases.
- Implement and maintain database security by creating the Users, Roles and assign privileges required.
- Creating and Implementing any schedule jobs and alerts.
- Perform schedule maintenance and support new releases and deployment activities
- Work closely with Hosting partners on resolution of any issues, provide necessary support during downtimes etc
- Should be a quick learner
- Should be able to work independently and guide other team members
- Good communication skills
Individuals who can join immediately would be preferred.