SQL Database Administrator III
Location
Pune | India
Job description
WHO WE ARE:
Zinnia Open Insurance is advanced data-driven technology that accelerates innovation, enables unrivaled speed-to-market, deepens relationships with policyholders, and empowers better risk-based outcomes. Open transforms the end-to-end experience to make everything faster, more transparent, and more collaborative for consumers, carriers, and advisors. Zinnia is a new tech company, but we're not new to insurance. We're L&A experts and technology innovators building Open Insurance to power exceptional experiences that evolve ahead of the marketplace. We're Zinnia. And we're Open. Join us, and experience Life, More Open.
WHO YOU ARE: Sr. Microsoft SQL Server Database Systems is responsible for the stability, security, monitoring and performance of a Database Platform. End-to-end systems management and technology governance of Zinnia platforms, including administration, security and audit. We are looking for people with the talent, drive and positive attitude, as well as experience with Microsoft SQL Database Administration.
WHAT YOU'LL DO: - Serve as a senior administrator of a database platform, working closely with application teams to support their needs both on projects and in ongoing run support.
- Collaboratively foster development between multi-functional IT teams.
- Coordinate with offshore DBA support personnel with direction from the Lead DBA.
- Ensure adequate run support for DBA environments.
- Serve as Subject Matter Lead for Microsoft SQL.
- Consult with Lead DBA regarding department standards and processes and create controls to enforce them.
- Assist IT and Business teams on new system implementation.
- Ensure appropriate backup and restore processes are conducted and available to meet business requirements and SLAs.
- Participate in disaster recovery configuration and testing
WHAT YOU'LL NEED: - Bachelor's degree or foreign equivalent in Computer Science, Engineering (any), or a related field.
- Minimum 5-8 years of experience as a relational database administrator with experience/expertise in:
- Microsoft SQL Server (all versions)
- Availability group configuration and administration
- RMAN - PL/SQL
- Database cloning
- Solaris Unix and/or Linux or Microsoft Windows (for Microsoft SQL)
- Shell Scripting
- OEM 13c Enterprise Manager
- Microsoft SQL performance tuning
- Progressively responsible experience in Microsoft SQL, basic DBA systems management, security concepts (authentication, authorization, encryption and digital signature), SSL, firewalls, storage and networking integration.
- Experience planning, testing, monitoring, troubleshooting.
BONUS POINTS: - NetApp Snap Center for Oracle/Microsoft SQL
- Solaris/UNIX/Linux administration
- Amazon Web Services RDS
- Postgres knowledge
- Document DB knowledge
- NetApp SAN
- VMWare ESX
- UC4 Job Scheduling Systems
- Active Directory
- Accenture Life Insurance Platform v5 or v9
WHAT'S IN IT FOR YOU We're looking for the best and brightest innovators in the industry to join our team. At Zinnia, you collaborate with smart, creative professionals who are dedicated to delivering cutting-edge technologies, deeper data insights, and enhanced services to transform how insurance is done. Visit our website at for more information. Apply by completing the online application on the careers section of our website. We are an Equal Opportunity employer committed to a diverse workforce. We do not discriminate based on race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability.
Job tags
Salary
