PostgreSQL Database Administratror
- Eazy Erp Technologies
- 2 - 8 years
- Noida, Gurugram
- 2 months ago
- Email to a friend
- Report this job
Job Description
ere is a comprehensive job description for a PostgreSQL Database Administrator:
Key Responsibilities
1. *Database Design and Implementation*: Design, implement, and maintain databases to meet organizational needs.
2. *Database Administration*: Manage and administer databases, including data modeling, normalization, and optimization.
3. *Data Security and Backup*: Ensure data security, integrity, and availability by implementing backup and recovery procedures.
4. *Performance Monitoring and Optimization*: Monitor database performance, identify bottlenecks, and optimize database configuration for improved performance.
5. *Troubleshooting and Support*: Troubleshoot database issues, provide technical support, and resolve database-related problems.
6. *Data Migration and Integration*: Plan, coordinate, and execute data migrations and integrations with other systems.
7. *Database Upgrades and Patches*: Apply database upgrades, patches, and fixes to ensure database stability and security.
8. *Documentation and Reporting*: Maintain accurate documentation, reports, and metrics on database performance, security, and usage.
Requirements
1. *Technical Skills*: Proficiency in database management systems (DBMS) such as Oracle, Microsoft SQL Server, MySQL, or PostgreSQL.
2. *Database Design and Development*: Knowledge of database design principles, data modeling, and normalization.
3. *SQL and Query Optimization*: Strong understanding of SQL, query optimization, and performance tuning.
4. *Data Security and Backup*: Knowledge of data security best practices, backup and recovery procedures, and disaster recovery planning.
5. *Problem-Solving and Troubleshooting*: Excellent problem-solving and troubleshooting skills, with the ability to analyze complex database issues.
6. *Communication and Collaboration*: Effective communication and collaboration skills, with the ability to work with technical and non-technical stakeholders.
Nice to Have
1. *Certifications*: Database certifications such as Oracle Certified Professional (OCP), Microsoft Certified Database Administrator (MCDA), or Certified Data Administrator (CDA).
2. *Cloud Experience*: Experience with cloud-based databases such as Amazon RDS, Google Cloud SQL, or Microsoft Azure Database Services.
3. *Data Warehousing and Business Intelligence*: Knowledge of data warehousing and business intelligence concepts, including data modeling, ETL, and data visualization.
Job Classification
Industry: IT Services & ConsultingFunctional Area / Department: Engineering - Software & QA
Role Category: DBA / Data warehousing
Role: Database Administrator
Employement Type: Full time
Contact Details:
Company: Eazy Erp TechnologiesLocation(s): Noida, Gurugram
+ View Contact
Keyskills: Performance tuning Data migration Data modeling Database design MySQL Database administration Oracle Business intelligence Technical support SQL
Fraud Alert to job seekers!
₹ Not Disclosed
Similar positions
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in