This is a remote position.
Job Role : SQL DBA
Job Location : Remote
Job Duration : Long Term
Responsibilities
- Responsible for designing building installing maintaining and tuning the databases that support the companys day-to-day operations.
- Min 10 years experience in SQL server 2012 or later in an administrative role.
- Must possess high-level of proficiency in SQL and T-SQL.
- Must possess 3 years of experience building deploying and maintaining ETL packages using SSIS.
- Must possess experience installing configuring and upgrading database software including HADR configurations.
- 5 years experience creating / updating / optimizing / troubleshooting - Stored procedures / functions tables views triggers indexes and constraints.
- Experience with database object migrations across multiple database environments and keeping various environments in sync.
- Must possess experience in troubleshooting and resolving job failures performance issues blocking / deadlocking issues connectivity and security issues.
- Proficient in optimizing database workloads using Profiler / Extended Events / DMVs or other database monitoring tools. Experience with Solarwinds DPA is preferable.
- Possess Good working knowledge of windows server operating systems (2012 / 2016)
- Possess strong knowledge of backups restores and recovery models.
- Possess solid understanding of various Amazon Web Services especially AWS RDS EC2 and S3. Familiarity with other SQL / NoSQL databases such as Oracle MySQL PostgreSQL MongoDB etc. is a plus
Required Skills : SQL
Key Skills
Databases,SQL Server Management Studio,SQL,.NET,Microsoft SQL Server,ssrs,TFS,Database Design,Performance Tuning,SSIS,T Sql,Data Warehouse
Employment Type : Full Time
Experience : years
Vacancy : 1
Monthly Salary Salary : 2 - 56