Principal Sql Dba Talent500 10 Years T866 in Dubai
Principal SQL DBA
Affinitiv is looking for a Principal SQL DBA to join our team. You will be working closely with the Development team on a Cloud-hosted application and a number of SQL servers to ensure the environment is built, configured, managed, and monitored correctly to support the business. You will help drive decisions on right-sizing servers and storage, troubleshooting performance issues, ensuring the highest level of reliability for the platform, and tuning the environment for maximum scalability and security and help with azure cloud migration.
Responsibilities
- Administers, manages and monitors all systems, including databases, in development, test and production environments.- Level of administration- Need Basis.
- Design and implementation of Azure cloud databases, high-availability solutions, replication, encryption, and disaster recovery solutions.
- Data Partitioning, Purging and Archiving solutions in the Azure SQL ecosystem.
- Migration of on-premises database to the Azure Cloud using SQL on VM, SQL MI, Azure SQL Database.- AWS.
- Azure CLI and/or Power Shell- Power BI
- Writing T-SQL, including complex stored procedures, functions, views, and triggers.
- Query analysis and troubleshooting Leadership responsibilities.
- Provide technical leadership through example, develop innovation, strategies, processes, and best practices.
- Monitor database performance, implement changes and apply new patches and versions when required.
- Manage SQL Server databases through multiple product life cycle environments, from development to mission-critical production systems.
- Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.
- Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations.
- Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end.
- Perform scheduled maintenance and support release deployment activities after hours.
- Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members.
- 24X7 support for our SQL Server environment. No shift- Overlapping of Us time zone.
- Own and manage uptime and performance SLAs.
- Ability to work well with team globally specifically in India.
- Work with Development and QA team, guide developers on following best coding practices to write optimal and efficient code.- NO People management.
Requirements
- 10 + Years of DBA experience in a production environment.
- 3 + Years supporting Azure SQL cloud-based databases.
- Nice to have experience of managing SQL Servers in AWS.
- 5 + Years in database tuning and project support, database server upgrades and migrations, writing and troubleshooting database stored procedures.
- experience with Azure SQL Family specifically SQL MI and Azure SQL Database.
- Application Development experience (preferably using.NET) and writing database Scripts.
- Good understanding of Dev Ops and the role of database administration teams in Dev Ops.
- experience of doing database deployment using. Dacpac.
- Advanced knowledge of performance tuning and administration, query analysis, performance monitoring and tuning, and maintenance routines.
- Background in automating processes
- experience with creating and maintaining database infrastructure.
- experience with database clustering (FCI or Always On Availability Groups)
- experience with database monitoring tools like Sentry One and native tools like Perfmon, Profiler, PAL and SQL DMVs.