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 Solve Data Infrastructure upkeep ensuring 99.99% availability Create new database clusters and be responsible for HA/DR Solutions using AlwaysON, Replication, Log shipping, etc. for business continuity and data growth Liaise on installation, configuration & maintenance of SQL Server instances in a shared enterprise organization Responsible for promoting application related objects/code (releases) and implement CI/CD for Database stack Create and manage database schema objects including tables, indexes, views, stored procedures, and triggers Administer 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 optimizations Work with and educate our dev team to make good schema design choices and optimize queries Automate recurring DBA tasks Be part of data platform engineering team on-call rotation Monitor database environment for high availability and disaster recovery, and proactively identify and solve issues Document, develop and enforce standards for best database practices Create backups and maintain recovery policies and procedures Establish and \maintain database security structures, encryption, and SOX compliance procedures Perform database tuning, coordinate application releases, and troubleshoot database issues including slowness and latencies Automation scripts using Bash/Python/PowerShell/Git for managing database infrastructure Understand the different wait types and reasons for query suspension and improve performance for application. About You BS or MS degree in Computer Science or Equivalent experience 10+ years DBA experience in developing, maintaining, and administering MS SQL Server 2017 and above Experience setting up SQL server on premises a plus Experience with SQL Server 2014-2019 Experience managing high volume, high concurrency environments and multi-TB OLTP databases Expert level SQL skills Experience coding and maintaining complicated SSIS Packages Penchant for automation with PowerShell, Python or other data scripting languages a strong plus Experience with other databases, including Postgres, MongoDB, Apache Cassandra, or Apache Hive is also a strong plus Proven analytical and problem solving skills A curious, self-motivated, resourceful, critical-thinker Strong oral and written communication skills Capable of meeting deadlines in a fast-paced, dynamic, environment Trouble shooting, performance monitoring and tuning skills is a must. Job Type: Full-time Pay: ₹50,000.00 - ₹120,000.00 per month Benefits: Health insurance Provident Fund Schedule: Monday to Friday Application Question(s): Are you ready to relocate to Vadodara, Gujarat location> What is your notice period in days? what is your current annual CTC? what is your expected annual CTC? Work Location: In person
