Job Description:
The Database Administrator is vital in managing and optimizing our database infrastructure across various SaaS platforms. This position is responsible for the implementation, maintenance, development, and performance of databases with a primary focus on Microsoft SQL Server, Azure SQL, MongoDB, and PostgreSQL. The qualified candidate will have excellent problem solving, analytical, communication, coordination, and task management skills. Additionally, experience with Azure will be essential for success in this role.
The ideal candidate will bring a strong blend of technical expertise, problem-solving skills, and the ability to thrive in a fast-paced, collaborative environment.
Key Responsibilities:
- 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.
Qualifications:
- 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 of Azure cloud services.
- Ability to automate DBA tasks with strong scripting skills (e.g., PowerShell, Bash, Python, Ansible).
- Strong problem-solving skills.
- Experience with database security best practices, encryption, and compliance standards.
- Administering SSIS, SSRS and SSAS
- Excellent communication and collaboration skills.
StarCompliance Background Checks
All positions require pre-employment screening due to employees potentially having access to highly sensitive and confidential information involving finance and compliance; candidates must be trustworthy and have a heightened sensitivity to protecting confidential financial, professional information. To be eligible for employment with StarCompliance, candidates must undergo a rigorous background investigation with checks including, but not limited to, criminal record history, consumer credit, employment history, qualifications, and education checks.
Equal Opportunity Employer Statement
We prohibit discrimination and harassment of any kind based on race, sex, religion, sexual orientation, national origin, disability, genetic information, pregnancy, gender identity or expression, marital/civil union/domestic partnership status, veteran status or any other protected characteristic as outlined by country, state, or local laws.This policy applies to all employment practices within our organisation, including hiring, recruiting, promotion, termination, layoff, recall, leave of absence, compensation, benefits, training, and apprenticeship.
StarCompliance makes hiring decisions based solely on qualifications, merit, and business needs at the time. For more information, please request a copy of our Equal Opportunities Policy.Apply for this job
