Job Details
Experience Needed:
Career Level:
Education Level:
Salary:
Job Categories:
Skills And Tools:
Job Description
- Proactively manage and maintain security standards and controls
- Actively seek to optimize and simplify our architecture
- Take ownership of performance and capacity monitoring aspects of the DB
- Execution of data migration jobs and scripts as required
- Assist the infrastructure team in sizing hardware used for the DB
- Support and collaborate with product developers
- Contribute to the creation and maintenance of disaster recovery plans
- Create a reliable backup strategy
- Ensure database backups are appropriately executed and periodic restorations are exercised to ensure backup quality
- Determine and document DB policies, procedures and standards
- Performance testing and evaluation to ensure data security, privacy and integrity
- Identification of bottlenecks and deadlock issues
- Ensure SLA's & operational KPI’s are met, working as necessary with internal and external support functions when major incidents occur
Job Requirements
- Bachelor of Science major in Computer Science or Information Systems or any relative degree
- Experience in Microsoft SQL Server (2005, 2008, 2012, 2014, or 2016)
- Highly skilled at writing complex stored procedures & Scripts
- Highly experienced in Indexing and finetuning stored procedures for performance
- Experience in SQL Server Integration Services (SSIS) package development, SQL Server
- Reporting Services (SSRS)
- Microsoft SQL 2016 administration certified is a plus
- Using SQL Server, SQL Script (T-SQL)
- SQL Data architect SQL Schema design and normalization
- SQL Performance tuning