Key Responsibilities:
- Database Management:
- Install, configure, and maintain PostgreSQL, Oracle, and MySQL databases.
- Monitor database performance and ensure high levels of performance, availability, and security.
- Implement and maintain database security (roles, privileges, etc.).
- Perform database tuning and optimization.
- Plan and implement backup and recovery strategies.
- Ensure data integrity and manage database replication.
- Database Design and Architecture:
- Design and implement database schemas, tables, and objects to support business requirements.
- Collaborate with development teams to design and optimize database queries, stored procedures, and indexing.
- Provide guidance on database design to ensure scalability, performance, and reliability.
- Performance Monitoring and Tuning:
- Monitor and optimize database performance using tools like pgAdmin, Oracle Enterprise Manager, and MySQL Workbench.
- Identify and resolve bottlenecks in database operations.
- Analyze and resolve complex database issues (locking, deadlocking, replication conflicts, etc.).
- Database Security and Compliance:
- Implement security measures to protect sensitive data and ensure compliance with industry regulations.
- Monitor and audit database activity to ensure compliance with security policies.
- Develop and maintain database documentation and standard operating procedures.
- Automation and Scripting:
- Automate routine database tasks using scripts (e.g., Bash, Python, PowerShell).
- Develop and maintain automation tools for database provisioning, backup, and monitoring.
- Disaster Recovery Planning:
- Develop and implement disaster recovery plans to ensure data availability and integrity in the event of a failure.
- Test and validate backup and recovery procedures regularly.
- Collaboration and Support:
- Work closely with the development and operations teams to support application deployment and performance tuning.
- Provide database support and troubleshooting to ensure minimal downtime and quick resolution of issues.
- Mentor junior DBAs and provide technical leadership within the team.
Key Responsibilities:Database Management:Install, configure, and manage PostgreSQL databases.Assist in the management and maintenance of Oracle databases.Monitor database performance and perform necessary tuning and optimizations.Ensure data integrity, availability, and security.Implement backup, recovery, and disaster recovery procedures.Database Design and Development:Work with development teams to design database schemas, indexes, and optimize queries.Develop and maintain database scripts for automating tasks like backups, monitoring, and alerts.Performance Monitoring and Tuning:Monitor database systems regularly to identify performance issues.Optimize queries, indexes, and database configurations to improve performance.Security and Compliance:Implement and enforce database security policies.Perform regular audits of database systems to ensure compliance with security standards.Support and Troubleshooting:Provide support for database-related issues, including troubleshooting and resolving incidents.Work closely with application developers to resolve database-related issues.Documentation:Maintain and update documentation related to database configurations, procedures, and standards.Document and report database performance metrics and incidents.Required Skills:Technical Expertise:Proficient in PostgreSQL database administration.Basic to intermediate knowledge of Oracle database administration.Strong SQL skills and experience with database scripting languages.Understanding of database security, backup, and recovery strategies.Familiarity with performance tuning and query optimization.Experience and Education:Bachelor’s degree in Computer Science, Information Technology, or a related field.A minimum of 3-5 years of experience in database administration, primarily in PostgreSQL, with exposure to Oracle.