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
search

Select a Skill

Talent

Join as Talent Post a project

checked This is a sample alert

logo

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:

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

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.

IT Expert in CRM: Keynote Speaker (Manufacturing/Healthcare/Tech)

FMCG

  • ERP/CRM
  • Technology Operations and Support
  • CIO/CTO functions
  • Technology Management
clock_icon less than 1 month(s)
exp_icon15+ years
location_icon Remote
SKILLS REQUIRED
  • #CIO / CTO
  • #Leadsquare CRM
  • #Speaker
Apply

Consultant Azure DevOps

IT Services & Consulting

  • Software Development - web technologies
  • Technology Operations and Support
  • Software Development - Python
clock_icon 3 month(s)
exp_icon7+ years
location_icon On-Site
SKILLS REQUIRED
  • #Kubernetes
  • #Azure DevOps
  • #Cluster deployment
  • #CI/CD tools
  • #Azure SQL
  • #Azure Blob storage
Apply

Consultant - Data Bricks

IT Services & Consulting

  • Software Development - web technologies
  • Technology Operations and Support
  • Technology Management
clock_icon 3 month(s)
exp_icon6+ years
location_icon On-Site
SKILLS REQUIRED
  • #data architectures
  • #Azure Blob Storage
  • #Kafka
  • #Azure Databricks
  • #Python
  • #SQL
Apply

Consultant—Test Engineer (API and Microservices)

IT Services & Consulting

  • Software Development - web technologies
  • Quality Assurance & Testing
  • Technology Operations and Support
  • Information Security
  • Software architect
clock_icon 4 month(s)
exp_icon4+ years
location_icon On-Site
SKILLS REQUIRED
  • #Microservices
  • # Test Management
  • #POSTMAN
  • #Azure DevOps
  • #Security Testing
  • #APIs
Apply

Consultant—Manual Tester (Windchill PLM Software)

IT Services & Consulting

  • Quality Assurance & Testing
  • Technology Operations and Support
  • Software architect
  • Technology Management
clock_icon 6 month(s)
exp_icon4+ years
location_icon On-Site
SKILLS REQUIRED
  • #CAD tools
  • #AutoCAD
  • #Software Quality
  • #ERP systems
  • #Test Management
  • #JIRAPTC
Apply

IT Expert in CRM: Keynote Speaker (BFSI)

Banking

  • ERP/CRM
  • Technology Operations and Support
  • CIO/CTO functions
  • Technology Management
clock_icon less than 1 month(s)
exp_icon15+ years
location_icon Remote
SKILLS REQUIRED
  • #CIO / CTO
  • #Leadsquare CRM
  • #BFSI
  • #Speaker
Apply

Consultant-Network Architect

IT Services & Consulting

  • Software Development - Mainframe
  • Software Development - web technologies
  • Technology Operations and Support
  • Hardware and Network administration
  • Software architect
clock_icon 12 month(s)
exp_icon10+ years
location_icon Hybrid
SKILLS REQUIRED
  • #CISCO
  • #VLAN
  • #NTP
  • #Juniper
  • #DNS
  • #DHCP
Apply

Consultant—AWS Serverless Developer (Node.js)

IT Services & Consulting

  • Software Development - web technologies
  • DBA/datawarehousing
  • Software architect
  • Technology Management
  • Software Development - Python
clock_icon 4 month(s)
exp_icon4+ years
location_icon Hybrid
SKILLS REQUIRED
  • #AWS Serverless
  • #Node.js
  • #Python
  • #Data Engineering
  • #Software Development
  • #AWS Lambda
Apply

Consultant—Windchill Developer

IT Services & Consulting

  • Software Development - web technologies
  • Quality Assurance & Testing
  • Technology Operations and Support
  • Software architect
  • Technology Management
clock_icon 3 month(s)
exp_icon5+ years
location_icon On-Site
SKILLS REQUIRED
  • #Windchill Customizations
  • #Windchill API
  • #PLM processes
  • #PTC Windchill
Apply

Consultant-Software Design Engineer

IT Services & Consulting

  • Software Development - C/C#/.NET
  • Software Development - Mainframe
  • Software Development - web technologies
  • Technology Operations and Support
  • Information Security
clock_icon 6 month(s)
exp_icon7+ years
location_icon On-Site
SKILLS REQUIRED
  • #Agile Implementation and transitioning
  • #C#
  • #Devops
  • #C
  • #AWS
  • #.NET
Apply

Consultant - Product Manager

IT Services & Consulting

  • Project/Program Management
  • Technology Operations and Support
  • Information Security
  • Software architect
  • Product Management
clock_icon 3 month(s)
exp_icon8+ years
location_icon On-Site
SKILLS REQUIRED
  • #P2P software
  • #B2B
  • #agile
  • #JIRA
  • #Atlassian tools
Apply

Data Engineer- AWS Red Shift

IT Services & Consulting

  • DBA/datawarehousing
clock_icon 6 month(s)
exp_icon6+ years
location_icon On-Site
SKILLS REQUIRED
  • #Data Modeling
  • #Informatica ETL
  • #AWS Redshift
  • #ETL Architecture
  • #Data Warehousing
  • #AWS
Apply
View More Projects btn btn

More than 3000 clients rely on Flexing It today

item_1
item_2
item_3
item_4
item_5
item_6
item_8
item_9

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.