SQL Server DBA

SQL Server database management through multiple product lifecycles environments

• Configuring and maintaining SQL database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.

• Applying data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations

• analyzing, solving, and correcting issues in real time, providing problem resolution end-to-end.

• Refine and automate regular processes, track issues, and document changes

• Provides 24×7 support for critical production systems.

• Perform scheduled maintenance and support release deployment activities after hours.

• Candidate will work with Systems and Development teams on designs, SQL performance optimization, and perform on-call support by providing responses to high priority requests for assistance by Operations

• The candidate will work with application developers to evolve the database architecture and design and will participate in the creation and refinement of staging & production database instances.

• Candidate will be serving as a POC for advanced level troubleshooting issues, and perform hands-on Database/Systems administration as required.

• Candidate will automate regular Database/OS administrative work with other support teams and ensure they are functioning correctly.

• Candidate will plan and executes tests of fault tolerance capabilities, including backup/recovery, replication, failover, and disaster recovery.

• The candidate should have experience in tuning database server configurations, queries, and indexes. He/she will also be required to run such queries as requested by the development teams.

• Maintain documentation of backup and recovery procedures of the physical data storage and logical data design for assigned databases.

• 3+ years EDW/DWH DBA experience required

• 6+ months RedShift experience a plus

Job Type: Contract

Salary: $35.00 /hour

Required experience:

• EDW/DWH DBA: 3 years