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 - Database Administrator (Postgres + Oracle)

  • Full Time
  •  On-Site - Chennai
  • 12 months
  • Project posted on: 22/10/2024

Consultant - Database Administrator (Postgres + Oracle)

  • Information Technology
  • DBA/datawarehousing
  • Technology Operations and Support

On-Site - Chennai

Full Time

12 months

 22/10/2024

Assignment Details

Key Responsibilities:
1. Database Management and Administration:
o Install, configure, and upgrade PostgreSQL and Oracle databases.
o Monitor and maintain the health, performance, and security of PostgreSQL and
Oracle databases.
o Implement and maintain database backup and recovery procedures.
o Perform database tuning, indexing, and optimization to ensure efficient
database performance.
o Plan and execute database upgrades and migrations.
2. Security and Compliance:
o Implement and manage database security policies, procedures, and standards.
o Ensure data integrity and privacy in compliance with relevant regulations and
policies.
o Perform regular security audits and vulnerability assessments.
3. Performance Tuning and Optimization:
o Monitor database performance and implement necessary tuning and
optimization measures.
o Diagnose and resolve performance bottlenecks in PostgreSQL and Oracle
databases.
o Develop and implement strategies for continuous improvement in database
performance.
4. Backup and Recovery:
o Develop, implement, and test backup and recovery strategies.
o Ensure regular backups are taken and securely stored.
o Manage disaster recovery planning and execution.
5. Database Design and Development Support:
o Collaborate with development teams to design and optimize database schemas
and queries.
o Provide support for database development, including stored procedures,
functions, and triggers.
o Assist in the design and implementation of data models and database
structures.
6. Maintenance and Support:
o Provide 24/7 support for critical database systems and ensure high availability.
o Perform routine maintenance tasks such as patching, cloning, and refreshing
databases.
o Troubleshoot database issues and provide timely resolutions.
7. Documentation and Reporting:
o Maintain comprehensive documentation of database configurations,
procedures, and standards.
o Generate regular reports on database performance, usage, and incidents.
o Provide training and guidance to junior DBAs and other team members.

Skills Required

Skills required:
- 4 to 7 years of experienced in database Administrator (DBA) with expertise in both PostgreSQL and Oracle databases.
- Bachelor’s degree in Computer Science, Information Technology, or Equivalent.
- Proven experience as a DBA with both PostgreSQL and Oracle databases.
- Strong knowledge of SQL and PL/pgSQL (for PostgreSQL) and PL/SQL (for Oracle).
- Experience with database performance tuning and optimization.
- Proficient in backup and recovery procedures.
- Familiarity with database security best practices.
- Excellent problem-solving skills and attention to detail.
- Ability to work in a fast-paced environment and manage multiple priorities.

About the Client

An Indian multinational healthcare group

Industry

IT Services & Consulting

Minimum Experience:

4+ years

Additional Skills:

  • Postgres
  • Security
  • Oracle
  • Compliance
  • SQL
  • Database

No of open positions:

2

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.