Job Description:
Seeking a highly skilled and experienced Senior Database Administrator with a strong background in PostgreSQL and Oracle Database.
The ideal candidate should have 5 years of hands-on experience with PostgreSQL and 3 years with Oracle Database, demonstrating a deep understanding of database architecture, performance tuning, backup and recovery, and security management.
Key Responsibilities:
• Database Management:
• Install, configure, and maintain Aurora PostgreSQL databases.
• Implement and manage database backup and recovery strategies.
• Oracle installation, upgrade, ASM administration
• Performance Tuning:
• Monitor database performance and identify performance bottlenecks.
• Optimize database queries and indexes for maximum efficiency.
• Conduct regular performance reviews and provide recommendations for improvements.
• Security and Compliance
• Implement and maintain database security policies and procedures.
• Ensure compliance with data protection regulations and company policies.
• Conduct regular security audits and vulnerability assessments.
•Database Development:
• Collaborate with development teams to design and implement database schemas, stored procedures, and functions.
• Provide guidance on best practices for database development and optimization.
• Participate in code reviews and provide feedback to developers.
• Troubleshooting and Support:
• Provide expert-level support for database-related issues.
• Troubleshoot and resolve complex database problems in a timely manner.
• Maintain detailed documentation of issues and resolutions.
Requirements
• 7+ years of experience in Database Administration.
• Proven experience as a Database Administrator.
• In-depth knowledge of database management systems, primarily AWS PostgreSQL, Oracle Database and MySQL
• Familiarity with database design principles, data normalization, and indexing techniques.
• Understanding of data security and access control principles.
• Extensive experience in AWS RDS.
• Knowledge of cloud-based database services (e.g., AWS RDS, SCT, and DMS).
• Strong knowledge of PostgreSQL replication, high availability, and disaster recovery mechanisms in AWS Cloud environment.
• Experience with PostgreSQL monitoring and performance tuning tools.
• Proficiency in SQL and experience with writing complex queries and stored procedures.
• Automate database tasks using AWS services like AWS Lambda, AWS CloudFormation, and AWS RDS/Aurora.
• Strong analytical and problem-solving skills with an ability to troubleshoot database-related issues.
• Familiarity with Linux/Unix operating systems and shell scripting.
• Experience using and administering Oracle Enterprise Manager (OEM)/Cloud Control.
Never miss an opportunity! Create an alert based on the job you applied for.