The team is looking to solve reliability engineering and operational support issues for Microsoft SQL Server database technologies, both on-premise and in cloud environments (AWS, GCP). This involves ensuring the efficient and cost-effective design, development, deployment, and management of these database environments, while maintaining high availability and performance for mission-critical applications.
Requirements
- 6-8 years of DBA experience with Microsoft SQL Server databases.
- 2+ years of Cloud experience working on GCP or AWS or Azure
- Strong technical skills in TSQL and PowerShell programming to automate SQL Server operational repetitive tasks.
- Strong knowledge and extensive experience with Microsoft SQL server technologies (all core areas: SSMS, SQL clustering, Data Synchronization, Encryption, Partitioning, Performance, Security, SSAS, SSIS and SSRS configuration) is mandatory.
- Sound knowledge of all windows and SQL utilities, strong PowerShell knowledge and experience is a plus.
- Solid understanding of network, storage, tiered application environments and security.
- Solid knowledge in database replication technologies including Always-on, Goldengate, etc. and strong architectural engineering skills to design systems that meet various applications High Availability and Disaster Recovery requirements.
Responsibilities
- Primarily Database reliability engineering, deployment, and support of Microsoft SQL Server database technology which include both on premise and cloud environments such as AWS and GCP.
- Support Database Administration and Engineering in the design, development and deployment, and management of Microsoft SQL database environments.
- Install, configure, monitor, upgrade and maintain MSSQL databases in production and non-production environments.
- Write, Develop, and maintain PowerShell and TSQL scripts for DB automation and application maintenance tasks.
- Advance experience with automation of managerial and repetitive DBA tasks.
- Provide technical expertise and hands-on support in consolidation and migration of databases to new hardware and platforms.
- Implementation and Support of databases, storage structures, high-availability solutions, replication, encryption, and disaster recovery solutions.
Other
- Ability to work well as a team and as an individual with minimal supervision.
- Good interpersonal skills along with effective communication (both written and verbal) skills.
- Demonstrate ability to solve complex systems and database environment issues.
- Demonstrate ability to work in a complex organization to determine business and customer needs, providing the best solution to meet those needs.
- A good team player, leader, flexible, share knowledge, help others, collaborate well within and outside the team.
