BETSOL is a cloud-first digital transformation and data management company offering products and solutions to both enterprises and consumers. BETSOL’s Data Management product lines include Rebit (Rebitgo.com) and Zmanda (Zmanda.com). BETSOL Global IT Services (BETSOL.com) builds and supports end-to-end enterprise solutions, reducing time-to-market for our customers. Our engineering team, with its several patents, delivers award-winning products and solutions in over 40 countries. Our work locations are set against the vibrant backdrops of Broomfield, Colorado and Bangalore, India. We take pride in being an employee centric organization. Learn more at betsol.com
Job Description
Looking for a SQL Server DBA with 3-5 years of experience in SQL Server database administration and Azure database administration. Roles & Responsibilities:
Fulfil DBA daily activities:
Backups/Restore, User Access Management (creating users, privileges, roles, quotas, table, indexes etc.), space management, monitoring (alert log, memory, disk I/O, CPU, database network connectivity)
Work closely with developers, provide DBA support for multiple applications in development, Test, QA, UAT and production environments. The individual will also be required to work on scripting tools like Power Shell at an application level
Work on Application and DB deployments to all environments
Maintain SQL DB’s (On Prem and Azure), Azure DW and Reporting (SSRS/Power BI)
Primary Skills required:
Installing SQL server (DB, Integration Services, Report Services, Analysis Services, Data Tools, On Prem & Cloud) and client software, creating, upgrading and patching databases in different environments. Experience in Upgrade and Migration of SQL Server to higher version (SQL Server 2008 R2 to SQL Server 2016 or higher)
Working with the Development teams to fix the problems in Applications.
Performance Tuning of database which includes SQL optimization.
Proficiency in T-SQL, includes, creating database objects like tables, views, indexes, constraints, functions, procedures, triggers, partitioned tables, etc. Planning, scheduling and taking backups. Hands on experience in database backups and Recovery strategies.
Managing Clustered environments, load balancing, scripting using Power Shell
Azure database and Power BI administration
Database and Azure AD user, service accounts and role management
Desired Secondary Skills:
Executing deployments to different environments and automating them
Data warehouse/ETL and BI knowledge
PROD maintenance experience
Qualifications
B.E./ME (CS/EE) or equivalent higher-level degree Certifications:
SQL Server 2016 or higher versions Database Administrator Certified Professional
Azure Database Administrator Associate
Additional Information
Experience range: 3-5 years’ experience in SQL Database Administration, Azure & Power BI administration
We regret to inform you that this job opportunity is no longer available