We are looking for senior-level database administrator with advanced expertise in both Oracle and PostgreSQL, along with a deep understanding of database architectures, security principles, and performance tuning methodologies. The candidate should also have strong problem-solving skills, attention to detail, and the ability to work under pressure while managing multiple complex database systems.
The candidate must also be willing to participate in a rotational 24x7 on-call Production Support.
- Database Installation and Configuration
- Install, configure, and maintain Oracle Multi-Tenant Architecture and PostgreSQL database servers.
- Set up instances, database parameters, and schema objects.
- Perform upgrades and patch management to ensure databases are up-to-date with the latest features and security patches.
- Experience Red Hat Linux Operating Systems.
- Database Architecture and Design
- Collaborate with development teams to design and implement efficient, scalable database solutions.
- Create database structures, including tables, views, indexes, and constraints.
- Define data storage, indexing strategies, and partitioning schemes for optimal performance.
- Database Performance Monitoring and Tuning
- Monitor database performance and system resource utilization to ensure high availability.
- Identify bottlenecks, analyze slow queries, and tune databases for optimal performance.
- Utilize tools like Oracle AWR, PostgreSQL pg_stat_statements, and other performance analysis tools.
- Implement performance improvements such as indexing, query optimization, and caching mechanisms.
- Backup and Recovery
- Implement and manage backup and disaster recovery strategies (e.g., RMAN for Oracle, pg_dump for PostgreSQL).
- Ensure data integrity and availability through regular backups and replication.
- Perform recovery tasks in the event of database corruption or failure.
- Security Management
- Configure and maintain database security, ensuring appropriate user permissions and roles are in place.
- Encrypt sensitive data, ensure secure connections, and apply security best practices.
- Monitor for potential security threats and resolve vulnerabilities in both Oracle and PostgreSQL environments.
- Capacity Planning and Scalability
- Analyze and forecast future database storage requirements.
- Plan for scalability, ensuring the databases can handle increasing workloads and data growth.
- Optimize database storage and processing capabilities, balancing performance with cost.
- Data Migration and Integration
- Perform data migrations between Oracle, PostgreSQL, and other databases.
- Develop and manage ETL (Extract, Transform, Load) processes for data movement and transformation.
- Ensure data consistency and integrity during migration and integration efforts.
- High Availability and Clustering
- Implement and manage high availability solutions such as Oracle Data Guard Replication, RAC and PostgreSQL streaming replication or clustering.
- Configure failover mechanisms to minimize downtime in case of hardware or software failure.
- Database Troubleshooting and Issue Resolution
- Resolve database-related incidents such as connectivity issues, slow performance, and data corruption.
- Provide technical support to development and operations teams for database-related problems.
- Perform root cause analysis and implement preventive measures.
- Automation and Scripting
- Automate routine database administration tasks using scripts (e.g., Bash, PowerShell, PL/SQL for Oracle, PL/pgSQL for PostgreSQL).
- Develop automation tools for monitoring, backups, and performance tuning.
- Collaboration and Documentation
- Work closely with development, DevOps, and infrastructure teams to support application and system requirements.
- Document database configurations, processes, and procedures.
- Provide training and mentoring to junior DBAs or development teams on database best practices.
- Compliance and Auditing
- Ensure databases comply with relevant regulatory standards (e.g., GDPR, SOX, HIPAA).
- Regularly audit database security, usage, and access logs.
- Manage and maintain database audit trails and security logs.
- Innovation and Continuous Improvement
- Stay current with new database technologies, tools, and techniques.
- Propose and implement improvements to database systems, increasing efficiency, performance, and security.
Requirements
Qualifications
Type
Category
Qualification
Description
Competency
Required
Skills
Database
Oracle
Advanced (7-9 Years)
Yes
Skills
Database
Oracle 12c
Advanced (7-9 Years)
No
Skills
Database
Oracle 8i/9i/10g
Advanced (7-9 Years)
No
Skills
Database
Oracle Exadata
Advanced (7-9 Years)
No
Skills
Database
PostgreSQL
Proficient (4-6 Years)
No