This website uses cookies to ensure you get the best experience on our website. By continuing to use this site, you agree to our cookie  & privacy policy.Accept

checked This is a sample alert

Consultant : IT DBA (Azure)

  • Full Time
  •  On-Site - Bangalore
  • 12 months
  • Project posted on: 16/08/2023

Consultant : IT DBA (Azure)

  • Information Technology
  • DBA/datawarehousing

On-Site - Bangalore

Full Time

12 months

 16/08/2023

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

About the Client

.

Industry

Pharmaceuticals

Minimum Experience:

7+ years

Additional Skills:

  • Cloud data warehouse
  • database management
  • SQL
  • database design
  • DBA
  • testing
  • Data migration
  • powershell
  • azure
  • Agile Implementation and transitioning
  • Cosmos DB
  • Very Large Databases

No of open positions:

1

How it works

  • 1

    Build your
    skill profile

  • 2

    Strengthen it
    with feedback

  • 3

    Determine your
    optimal fee level

  • 4

    Apply for matching
    projects

  • 5

    Get finalized

  • 6

    Stay Engaged

Build your skill prodile

Project
step1
shape_step

Request feedback from prior projects and/or work stints

shape_step

Determine your optimal fee level

  • starFeeBee helps consultants understand how to price their services.
  • starEnter your skill & location to get ranges for what similar professionals have charged on projects.
  • starUnlock more details e.g., best paying sub-skills, ranges by projects durations, by simply adding a benchmark from a orior projects.
graph_step2
shape_step

Apply for matching projects

shape_step

Get finalized!

Project
step5
shape_step

Stay Engaged!

Project
step6
shape_step

Similar Freelance Projects you can apply to.

View More Projects btn btn

More than 3000 clients rely on Flexing It today

Frequently asked questions.

We host both full-time & part-time projects from top clients for 100+ skill categories. We also help connect experts like you with clients for short consultation calls called Flexperts

You just need to create a ‘boutique firm’ account during the registration process. The rest of the application process remains the same.

Our freelancers fee benchmarking tool, FeeBee helps our freelancers and consultants find out what their peers charged for similar projects. Built on 600K+ verified benchmarks, registered users get unlimited access to it.

As a freelancing platform, we do not provide permanent positions or full-time job to our consultant network.

Flexing It will be involved end to end right from contracts to invoicing. Once you are finalized, your payment details are transparently laid out in your contract terms with your client and our team actively liaises with the client finance team to ensure timely payments.

We do not charge any fee or commission from you. Your fee quote will be paid out to you in full as per your project contract.