Job overview
senior azure & on prem ms sql database administrator will be responsible for the management of production and non
- production databases; database maintenance activities; troubleshooting database-related issues; monitoring of database capacity and performance; installation, administration, and configuration of database server/instances/databases; installation and configuration of ssrs; support release/code deployment activities (ssis packages, ssrs reports, sql objects etc)
*cv must be sent in english*
essential functions
- conduct the following for azure sql/azure sql mi/sql on azure vm, on prem sql server, ssrs, ssis, azure synapse and other related products as applicable and necessary
- install/configure/setup/administer and maintain production and non-production environments
- setup high-availability and disaster recovery
- plan and test high availability and disaster recovery
- create users and assign/manage permissions based on the level of access the user would need; ensure robust and full proof security of assets
- resolve database integrity, performance, blocking, connectivity, and replication issues.
- detect and resolve database-related cpu, memory, i/o, disk space and other contention issues.
- perform and manage database backup/recovery/restore and capacity monitoring
- synapse workload management and optimization
- setup sql agent jobs, elastic jobs and runbook automation
- identify and setup alerts and logging in azure
- maintain databases - statistics, indexes, fragmentation
- coordinate removal and/or archiving of data that is no longer required to be available in the production databases.
- deploy and configure ssis packages and ssrs reports. Troubleshoot issues with ssrs and ssis.
- support release/code deployment activities
- provide 24x7 support as necessary
- implement operational automation using scripts.
- conduct performance tuning and optimization (stored procedures, views, functions, queries, database) - in-depth sql database advanced performance tuning experience - stored procedures, views, functions; skilled in analyzing and assessing query execution plans and dmvs; expertise in assessing and implementing indexes and partitioning; tuning etl jobs - ssis & azure data factory
- design and create databases to support development initiatives
- synapse workload management and optimization
*qualifications*:
- bachelor's degree or related working experience
- experience in ha/failover technologies
- experience in log shipping and dr environments
- experience with datasync in azure and other technologies used in replicating data
- strong experience in performance tuning and optimization (pto)
- experience with sql server versions 2005 to 2019
- experience running and troubleshooting ssis packages
- experience troubleshooting performance issues in the sql server environment
- good verbal and written communication is a must have.
- advanced level of english.
Q² solutions is a leading clinical trial laboratory services organization with end-to-end laboratory services and secure, enterprise-wide biospecimen and consent management solutions.