What are the responsibilities and job description for the SQL DBA position at ExecutivePlacements.com?
Job Description
This is a remote position.
Job Role: SQL DBA
Job Location: Remote
Job Duration: Long Term
Responsibilities
SQL
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 company's 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/DMV's 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
SQL