Company Details

.

Assignment Details

Our client, a leading biopharmaceutical company, is looking for an independent consultant to work closely with Enterprise Architect and Project leaders across the organization supporting various DBA needs.

The primary Roles and responsibilities include-

- Serves as a SPOC for all database management related needs
- Manage installation and configuration of a new SQL Server, Azure SQL, Cosmos DB, etc. databases
- Migrate existing SQL Server instances to Azure SQL or provision a new Azure SQL database
- Handle the transfer of data from the existing system to the new platform
- Manage structured and unstructured data stored in Very Large Databases (VLDB)
- Create and maintain database standards and policies
- Support database design, creation, and testing activities
- Modernise existing applications with Azure SQL Managed Instance
- Manage database availability and performance, including incident and problem
management
- Administering database objects to achieve optimum utilization
- Defining and implementing event triggers that will alert on potential database performance or integrity issues
- Performing database housekeeping, such as tuning, indexing, etc. and Automate common
management tasks using PowerShell
- Monitoring usage, transaction volumes, response times, concurrency levels, etc.
- Identifying reporting, and managing database security issues, audit trails, and forensics
- Designing database backup, archiving, and storage strategy
- Developing and maintaining capacity plans

Year One Critical Success Factor
- Successfully own and manage all databases
- Successfully manage database configuration including installing and upgrading software and maintaining relevant documentation
- Successfully complete planned data migration to Azure cloud data lake

Skills Required

- Have an IT, computer science, or engineering educational background with at least 5 years of experience as DBA
- At least 2 years of experience as Azure DBA
- Need to be conversant with structured query language (SQL) and relevant database technologies (whether proprietary or open source)
- Experience implementing and managing databases in Azure cloud
- Hands-on experience working on cloud data warehouses
- Experience with Azure Infrastructure management is a plus
- Experience in working in an on-site & off-shore model, handling stakeholders from various locations
- Excellent problem-solving and analytical skills
- Excellent communication, teamwork, and negotiation skills
- Good organizational skills
- Flexibility and adaptability
- Excellent business relationship and user support skills
- Self-starter, with the ability to work and execute independently with minimal oversight