- Good knowledge in SSIS (ETL)
- Good T-SQL Programming Knowledge
- Create complex query definitions that allow data to be extracted
- Admin of database: installation, Backup Strategy
- Performance tuning in SQL Server
- Manage users and groups
- Monitor performance counter
- Work with HA/DR solution in SQL server(Failover Cluster, Always on)
- Good knowledge about lock & latch in SQL server
Requirements
- At least 3 years of experience in SQL Server Position; priority in PSP/E-Commerce CO.
- Expertise in T-SQL programming and database design concepts and standards
- Proficient in Query Performance Tuning
- Ability to present a solution based on SQL Server
- Ability to check and evaluate potential blocking, deadlock and recommend a solution for avoiding blockages
- Familiar with Database administration concepts
- Familiar with Data Warehouse and BI concepts
- Strong communication and negotiation skills
