Vacancy expired!
We’re searching for a Sr. SQL DBA. We need someone that can work remote 4 days a week and onsite one day a week. Our client offers amazing benefits and a super stable employee focused environment. Sr SQL DBA role oversees all the databases and database servers in production and test environments to make sure they’re running efficiently on optimum performance. In addition, this role takes ownership of all dba related tasks and provides direction to the rest of the dba team when needed.
- Collaborating with other teams on future projects and associated db activities and plan accordingly.
- Oversee monitoring activities on the website database and other DBs and establish performance baseline.
- Oversee future expectations based on new projects and upcoming events and plan accordingly to meet those expectations.
- Maintain and monitor SQL Server Databases while maximizing availability of critical business data.
- Ensure proper DR and HA policies are in place and they’re practiced properly.
- Oversee required actions to make sure all servers are patched, and the latest service pack has been applied to all the servers while maintaining an effective communication on Server Maintenance and build activities and issues.
- Manage cloud databases including Azure SQL and AWS Redshift.
- Study dba activities over time and propose how such activities can be automated, plan for their automation and monitor moving forward.
- Strong communication skills and willing to work in a team-oriented structure.
- Strong knowledge in relational data management, SQL Server 2008 thru 2019 as well as Azure SQL. Other DB platforms like Redshift, Postgres, cosmos db and Oracle is a plus.
- Strong experience and knowledge over TSQL and TSQL based objects.
- Ability to identify slow running queries in and performance tune those queries.
- Familiar with e-commerce UX performance monitoring tools and techniques.
- Identify server’s hardware bottlenecks that could affect SQL Server’s performance.
- Good working knowledge over SSIS and SSIS performance.
- Work with the rest of dba team to provide around the clock support.
- Willing to learn new technologies and new tools to better monitor/manage the environments.
- Manage security on SQL Server database servers.
- database design and architecture knowledge and experience.
- SQL Replication between on prem SQL Servers and Azure.
- SSRS knowledge is a plus.