Senior Sql Database Administrator (Immediate Joiner)

Job Description

We are seeking a Senior DBA to join our Data Platform Engineering team. The DBA will be responsible for the data platform environment including overseeing the development and maintenance of the databases, assessment, optimization for new as well as existing implementations. In this role, he/she will work with architecture, application development and operations to help achieve a state-of-the-art data platform that meets current and future business objectives. The ideal candidate has deep database administration experience and seeks to design/model highly performant databases and queries. Above all other factors, the successful candidate is smart, driven, and wants to be part of a culture of innovation and creativity as we develop and define our unique market. Problems You Will SolveData Infrastructure upkeep ensuring 99.99% availabilityCreate new database clusters and be responsible for HA/DR Solutions using AlwaysON, Replication, Log shipping, etc. for business continuity and data growthLiaise on installation, configuration & maintenance of SQL Server instances in a shared enterprise organizationResponsible for promoting application related objects/code (releases) and implement CI/CD for Database stackCreate and manage database schema objects including tables, indexes, views, stored procedures, and triggersAdminister security - user accounts & database roles, schema, data encryption, etc.Support application developers and BI/BizOps/Data-science teams with database architecture, query optimization, data loads etc.Troubleshoot performance issues and suggest/implement optimizationsWork with and educate our dev team to make good schema design choices and optimize queriesAutomate recurring DBA tasksBe part of data platform engineering team on-call rotationMonitor database environment for high availability and disaster recovery, and proactively identify and solve issuesDocument, develop and enforce standards for best database practicesCreate backups and maintain recovery policies and procedures Establish and \maintain database security structures, encryption, and SOX compliance proceduresPerform database tuning, coordinate application releases, and troubleshoot database issues including slowness and latenciesAutomation scripts using Bash/Python/PowerShell/Git for managing database infrastructureUnderstand the different wait types and reasons for query suspension and improve performance for application. About YouBS or MS degree in Computer Science or Equivalent experience12+ years DBA experience in developing, maintaining, and administering MS SQL Server 2017 and aboveExperience setting up SQL server on premises a plusExperience with SQL Server 2014-2019Experience managing high volume, high concurrency environments and multi-TB OLTP databasesExpert level SQL skillsExperience coding and maintaining complicated SSIS PackagesPenchant for automation with PowerShell, Python or other data scripting languages a strong plusExperience with other databases, including Postgres, MongoDB, Apache Cassandra, or Apache Hive is also a strong plusProven analytical and problem solving skillsA curious, self-motivated, resourceful, critical-thinkerStrong oral and written communication skillsCapable of meeting deadlines in a fast-paced, dynamic, environmentTrouble shooting, performance monitoring and tuning skills is a must.