Senior Specialist SQL DBA

Senior SQL Server Database Administrator

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
• 8+ 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 Types: Full-time, Permanent

Pay: ₹800,000.00 - ₹1,500,000.00 per year

Benefits:

• Health insurance
• Provident Fund

Ability to commute/relocate:

• Vadodara, Gujarat: Reliably commute or planning to relocate before starting work (Required)

Application Question(s):

• What is your notice period in Days?
• What is your current annual CTC?
• What is your expected annual CTC?