Database Administrator (DBA)

April 3

StarCompliance

WebsiteLinkedInAll Job Openings

We are Reputation Guardians, on a mission to make compliance simple and easy.

Insider Trading • Political Activity • Gifts & Entertainment • Outside Activity • Reporting

201 - 500

💰 Venture Round on 2020-12

Description

• Day-to-day operational support to administer and maintain databases. • Performing database tuning, performance monitoring, and troubleshooting database errors. • Installation, configuration, patching, and upgrading of database server software and related products. • Establishing and maintaining backup and recovery policies and procedures. • Implementing and maintaining database security. • Setting up and maintaining documentation and standards. • Planning growth and changes (capacity planning). • Creating and maintaining SQL queries and scripts. • Finding and debugging malfunctioning programs affecting database integrity. • Setting and maintaining database standards. • Managing database access. • Recommending and implementing emerging database technologies. • Creating and managing database reports. • Being available for on-call support as needed. • Evaluating new database features and making recommendations. • Sharing knowledge and mentoring other IT staff as needed. • Performing disaster recovery operations and data backups when required. • Suggesting improvements to database capacity, performance, and scalability. • Database cloud management with Azure, utilizing Terraform, Ansible, and other tools. • Experience with critical operations in a client data hosted environment. • Experience with web-based applications DB interactions. • Strong experience as a Database Administrator and with database related utilities and tools. • Experience and understanding of database technologies (MySQL, MS SQL, NO-SQL) • Advanced knowledge of database security, backup and recovery, and performance monitoring tools and standards. • Experience and understanding database design, implementation, troubleshooting, and maintenance. • Ability to perform both database and operating system performance tuning and monitoring.

Requirements

• Azure or Microsoft SQL Server certifications are a plus. • At least five years of current database administration experience. • Proven experience as a Database Administrator focusing on SQL Server (PaaS and IaaS), with additional experience in MongoDB, PostgreSQL, Azure SQL Server Elastic Pools, and Azure CosmosDB. • In-depth experience with database installation, configuration, and upgrade. • Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc. • In-depth knowledge of Database backup and recovery of databases in a Cloud environment. • Strong Experience in High availability(Replication, Log shipping, Always On, Cluster environment) • In-depth knowledge of database performance tuning, optimization, and troubleshooting. • SQL Development ability to write and troubleshoot SQL Code and design (stored procedures, functions, tables, views, triggers, indexes, constraints) • In-depth knowledge of tuning and optimizing complex SQL statements for the best possible performance. • Knowledge of data replication & data modeling • Good knowledge ofAzure cloud services. • Ability to automate DBA tasks with strong scripting skills (e.g., PowerShell, Bash, Python, Ansible). • Strong problem solvingskills. • Experience with database security best practices, encryption, and compliance standards. • Administering SSIS, SSRS and SSAS • Excellent communication and collaboration skills.

Benefits

• Experience with critical operations in a client data hosted environment. • Experience with web-based applications DB interactions. • Strong experience as a Database Administrator and with database related utilities and tools. • Experience and understanding of database technologies (MySQL, MS SQL, NO-SQL). • Advanced knowledge of database security, backup and recovery, and performance monitoring tools and standards. • Experience and understanding of database design, implementation, troubleshooting, and maintenance. • Ability to perform both database and operating system performance tuning and monitoring. • Database cloud management with Azure, utilizing Terraform, Ansible, and other tools.