Job Description

Serve as SQL Server DBA providing core database administrative, innovation, support, database infrastructure and architecture design. Position requires the ability to provide on-call, after-hours/weekend support, when necessary.

• Install, configure, monitor, upgrade and maintain MSSQL databases in production and nonproduction environments.
• Work closely with other Infrastructure operations and engineering, product development, business operations, and technical operations to ensure delivery of database services within the SLA's and performance target set.
• Implementation/Support of databases, storage structures, high-availability solutions, replication, encryption, and disaster recovery solutions.
• Database administration for applications, ensure continuous 24x7 operation and availability in support of mission critical business applications and participating in on-call.
• Regular database capacity planning and archival solution related to database growth and system utilization, trend analysis, predictive future database resource requirements, and the structured organized reporting of the same.
• Participate in the evaluation, selection and implementation of DBA tools to improve the effectiveness of tasks such as performance monitoring and tuning, recovery, and database change management processing.
• Proactive and reactive performance analysis, monitoring, troubleshooting and resolution of database issues.
• Write/maintain PowerShell scripts for DB automation and application maintenance.
• Advance experience with automation of managerial and repetitive DBA task

Job Requirements

• Bachelors/Degree in Computer Science or other technology field is a must.
• Minimum of 4 years of DBA experience with Microsoft SQL Server.
• 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 (Always-On) and strong architectural/engineering skills to design systems that meet applications High Availability and Disaster Recovery requirements.
• Solid knowledge in Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools. (knowledge of indexes, index management, and statistics)
• Demonstrate ability to write complex SQL queries with MS SQL related technologies including T-SQL, stored procedures and database design
• Demonstrate ability to solve complex systems and database environment issues.
• A good team player, leader, flexible, share knowledge, help others, collaborate well within and outside the team.

Skills